Daily Archives: April 27, 2009

Prestashop “an error occurred while updating object cms”

A blank error could appear when you use the CMS editor in PrestaShop. It says “an error occurred while updating object cms ()”.


Apparently they filter certain words to prevent SQL injection, which is a good idea, but what I don’t understand is why it needs to be in the  of Prestashop. I can understand if it were a comments box or something on the front end, which really doesn’t need to be a rich text editor, but on the back end? I suppose if somebody got into the  of your store this would help, but either way they’d be doing a lot of damage by just pointing and clicking.

If you get this error, check your content for the following words and replace them with something different: union, load_file, outfile, dumpfile, escaped, terminated, cascade, infile, x509, trigger, revoke