1064 mysql error

[m4rtyj]

Hi all,

I have uploaded the ltest version of zencart through fantastico loader, which installed without problems.

I am trying to modify my site so that customers can upload their photos for me to modify/ enlarge etc.

I need the customer to click on the size that they require and then upload their photo and then order the photo enlargement.

I have installed photoorder 1 which can be found here forums.aurigma.com/yaf_postst3943_HOWTO-Integrate-Image-Uploader-into-Zen-Cart.aspx i think is created by aurigma, but when i come to install the sql patch in the admin area of zencart, I get the following error.

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 'WHERE products_options_name='Photo'' at line 1
in:
[DELETE FROM zen_ products_options WHERE products_options_name='Photo';]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Can someone please explain what this means and how i can install the sql patch, ive been trying for days now and still get the same problems.

I have even tried installing the zencart files manually via filezilla and the problem still remains although it is worded slightly.

Thanks in advance.

[DrByte]

The problem is that you have a space between the table-prefix ("zen_") and the table name.
That suggests that the addon's SQL patch is written badly.

I suggest you talk to the addon's author. And, if the addon isn't hosted in the Free Addons area of the Zen Cart site then support for it isn't offered on this site. You'll need to deal with the author directly.