Unknown column in 'field list' error on MySQL Update query
28,135
Problem is solved. Thank you a lot everyone for their help.
Right Query for solution is:
UPDATE `holidaycholic`.`otelbilgi` SET `otelbilgi`.`isim_tr`='test2', `otelbilgi`.`aciklama_tr`='<p>test2</p>', `otelbilgi`.`uyari_tr`='test2', `otelbilgi`.`tag_tr`='test2' WHERE `otelbilgi`.`id`=1
No idea why but that worked for me.
Author by
Mustafa
python, php, mysql, js, css, jquery, ajax, facebook api and a bit of gaming :)
Updated on September 24, 2020Comments
-
Mustafa over 3 years
i echoed the query below: (query is safe)
UPDATE otelozellik SET isim_tr='test', aciklama_tr='<p>test1</p>', uyari_tr='test', tag_tr='test' WHERE id='1'
Database Error: Unknown column 'aciklama_tr' in 'field list'
I changed the order of columns, the one after
isim_tr
keeps giving error. When I moveisim_tr
to the last then the one afterid
giving the same error. But moving them to the last position is not a solution for me because table will be dynamic to add new columns when necessary. need an absolute solution.UPDATE: LATEST SCREENSHOT: http://img5.imageshack.us/img5/7215/mysqlerror.jpg
Solved. Solution is answered below. Thanks everyone.