ERROR 1193: Unknown system variable 'products_model'

[morty]

I am getting the above error when I try to enter this statement into mysqlcc. I get similar message trying to enter it using phpmyadmin.. I KNOW the statement is correct and that "products_model" exists EXACTLY how it is spelled.

Anyone have any ideas? Is this a configuration problem? It has always worked before in the past. Secondarily, I did try another update staement which uses the same table, though it does not affect the products_model field, and it works fine.

UPDATE products
set products_model = 'XYZZ' where products_model = 'XYZ';
set products_model = 'ABCD' where products_model = 'ABC';

BTW, Jaguar- while your monitoring seems to have improved some, you still have a ways to go before I'll be happy again. My site performance is half of what it was when I started with you. - and that's when it is working.

[JPC-Stefan]

Please open a ticket in support department and techs will check into your issues, or provide the ticket ID if you have already opened.

[Ron]

My silly guess of the day-- the update statement wasn't seen for some reason, and the query being seen is just "set product_name = "whatever".

See if there's an error before the 1193!

[Gwaihir]

Statement ends at that first ;. It then sees an invalid second statement. Try:

UPDATE products set products_model = 'XYZZ' where products_model = 'XYZ';
UPDATE products set products_model = 'ABCD' where products_model = 'ABC';

[morty]

Statement ends at that first ;. It then sees an invalid second statement. Try:

UPDATE products set products_model = 'XYZZ' where products_model = 'XYZ';
UPDATE products set products_model = 'ABCD' where products_model = 'ABC';

Well, such a stupid mistake. Haven't tried your suggestion yet, but I believe you are absolutely right. Not sure how I missed that one!!

Thanks Gwahir. Really appreciate it!

[morty]

Statement ends at that first ;. It then sees an invalid second statement. Try:

UPDATE products set products_model = 'XYZZ' where products_model = 'XYZ';
UPDATE products set products_model = 'ABCD' where products_model = 'ABC';

Yep, that was the ticket! Good catch Gwahir.

Thanks again.

[morty]

My silly guess of the day-- the update statement wasn't seen for some reason, and the query being seen is just "set product_name = "whatever".

See if there's an error before the 1193!

Thanks to you too Ron - looks like you also figured this out...