Welcome Guest! You need to login or register to make posts.

Notification

Icon
Error

Options
Go to last post Go to first unread
claudio  
#1 Posted : Thursday, July 15, 2010 7:26:52 PM(UTC)
claudio

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.it

thanks for aid
Dmitry.Obukhov  
#2 Posted : Sunday, July 18, 2010 7:36:02 PM(UTC)
Dmitry.Obukhov

Rank: Advanced Member

Groups: Member
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.
claudio  
#3 Posted : Monday, July 19, 2010 9:13:37 PM(UTC)
claudio

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.it

thanks for the help
andreym  
#4 Posted : Tuesday, July 20, 2010 5:38:05 PM(UTC)
andreym

Rank: Advanced Member

Groups: Member
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

camfam  
#5 Posted : Wednesday, August 4, 2010 12:34:18 PM(UTC)
camfam

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
Dmitry.Obukhov  
#6 Posted : Wednesday, August 4, 2010 4:39:22 PM(UTC)
Dmitry.Obukhov

Rank: Advanced Member

Groups: Member
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.
File Attachment(s):
install.zip (1kb) downloaded 14 time(s).
Best regards,
Dmitry Obukhov
Technical Support. Aurigma, Inc.
RichardH  
#7 Posted : Friday, October 8, 2010 5:54:41 AM(UTC)
RichardH

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
Dmitry.Obukhov  
#8 Posted : Sunday, October 10, 2010 3:23:27 PM(UTC)
Dmitry.Obukhov

Rank: Advanced Member

Groups: Member
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.
Users browsing this topic
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.