V3.52 bug with SQL not working

[pbwebguy]

I looked forward to updates with version 3.52 but had to revert back to an eariler version. It appears that webyog is mucking with the SQL statement before passing it to the database. It appears that webyog sees various column names as special words (i.e. status) and highlights them in the text editor. Here is a statement that never works in 3.52 but works perfectly fine everywhere else.

Quote:

UPDATE order SET status=200 WHERE order_id=5;

[Ritesh]

Try :

Quote:

UPDATE order SET `status`=200 WHERE order_id=5;

[Author]

Posts