I have a website that uses a database (www.eqtraders.com) It is run with PHP and MySQL
It seems that the host recently updated PHP and now 'yield' is a predefined keyword
in PHP.
So... I went everywhere and changed all field reference of yield to r_yield. I then change the database field names to r_yield
.
I am confident that the code is sending the following query:
INSERT INTO recipes (item_id, r_yield, tradeskill, restriction, triv_low, triv_high, date_added, triv_display) VALUES ("51998", "1", "Spell Research", NULL, "432", "432", "2015:11:04", "432")
And for this, I get the error:
Unknown column 'r_yield' in 'field list', in db: recipes
PHPMySQL
reports the field names are r_yield (There are two tables other than recipes that also needed to be changed)
Screenshot of PHPMyAdmin with the name change. Field 3
Does anyone have any advice on what I might need to do?