Rank: Newbie
Groups: Member
Joined: 7/15/2010(UTC)
Posts: 2
|
Hi, when I install the sql pach rivevo 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. and the site is not seen you can control: http://myprint.dimasoshop.itthanks for aid
|
|
|
|
|
|
Rank: Advanced Member
Groups:
Joined: 5/29/2010(UTC)
Posts: 1,310
Thanks: 8 times
Was thanked: 111 time(s) in 111 post(s)
|
Hello Claudio, Could you provide me with some additional details on your problem? Please let me know: - the used MySQL version number;
- the Zen Cart version number.
Looking forward to reply from you. |
Best regards,
Dmitry Obukhov
Technical Support. Aurigma, Inc.
|
|
|
|
|
|
Rank: Newbie
Groups: Member
Joined: 7/15/2010(UTC)
Posts: 2
|
Hi, the error in the data base are able to solve now only remains for me one of the template, it happens that if I choose the template from Aurigma public side there are errors. You can check http://www.stampasututto.itthanks for the help
|
|
|
|
|
|
Rank: Advanced Member
Groups:
Joined: 6/16/2009(UTC)
Posts: 134
Was thanked: 8 time(s) in 8 post(s)
|
Hello! The only tables we changed is the product_types and products_options tables from the patch. In the product_types table we add new product type - Product - Photo and add new Photo option in the products_options table. I'm not sure why it complains about ezpages table. Does the pages_title column exists in this table? We've tried to install Photo Order module on Zen-Cart 1.3.9d and it works. However, we have not tried it with any custom themes or any other modules. Can you please try to install on the clean Zen-Cart site with default theme and reply if the error still occurs? Edited by user Tuesday, July 20, 2010 5:40:35 PM(UTC)
| Reason: Not specified |
|
|
|
|
|
|
|
Rank: Newbie
Groups: Member
Joined: 8/4/2010(UTC)
Posts: 1
|
I am getting the same error on a fresh install:
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.
MySQL 5.0.45
Zen Cart 1.3.9d
Database Patch Level: 1.3.9d
Thanks for your help.
Regards,
Brian
|
|
|
|
|
|
Rank: Advanced Member
Groups:
Joined: 5/29/2010(UTC)
Posts: 1,310
Thanks: 8 times
Was thanked: 111 time(s) in 111 post(s)
|
Hello, I looked through your error message. I suppose this syntax error occurs because of the mistake in our SQL script– extra space between zen_ and products_options. I attached fixed install.sql file. Please try it and inform me about the results. Looking forward to your reply. |
Best regards,
Dmitry Obukhov
Technical Support. Aurigma, Inc.
|
|
|
|
|
|
Rank: Newbie
Groups: Member
Joined: 10/8/2010(UTC)
Posts: 1
|
hello
I'm having the same issue. I have tried the sql patch you put at the end of this. I'm using zen 1.3.9d.
this is the message I get
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 'products_options 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.
cheers
richard
|
|
|
|
|
|
Rank: Advanced Member
Groups:
Joined: 5/29/2010(UTC)
Posts: 1,310
Thanks: 8 times
Was thanked: 111 time(s) in 111 post(s)
|
Hello Richard, It seems that install.sql was not applied. I have checked this file once again and found no mistakes now. According to your message: Quote: [DELETE FROM zen_ products_options WHERE products_options_name='Photo';] the extra space stands between zen_ and products_options. Please check that you use new install.sql file from attachments of my previous post. |
Best regards,
Dmitry Obukhov
Technical Support. Aurigma, Inc.
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.