1064 Error at the product_info.php page

[davinciarte]

Inexplicably, for new products that I create in my store, I get the following error when I go to the product_info.php page for these products:

 

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Product X", "", "productx_image.jpg")' at line 1

 

I'm using "Product X" where the name of the product goes.

 

I don't get this error for products previously inserted in my store. Just for new ones that I've created as of today.

 

Any idea what is going on

[♥zelf]

I'm using "Product X" where the name of the product goes.

The actual error code without changes will be more helpful. Probably have an unescaped apostrophe in there somehow. Please include the exact error message.

[davinciarte]

I think I figured out the problem. I used the inches symbol (") in the product name which I am guessing is a no-no for mysql syntax. Is that the case? When I took out the quotes, the error code disappeared.

 

The actual error code without changes will be more helpful. Probably have an unescaped apostrophe in there somehow. Please include the exact error message.