Zen Cart Logo
Forums / General Questions / 1064 Error after installing Time Zone Fix addon

1064 Error after installing Time Zone Fix addon

Views: 1,137

Results 1 to 4 of 4
6 Aug 2011, 8:12 AM
#1
hfprojekte avatar

hfprojekte

New Zenner

Join Date:
Aug 2011
Posts:
2
Plugin Contributions:
0

1064 Error after installing Time Zone Fix addon

have Error
installed Time Zone Fix

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 'SQL_SHOW_PRODUCT_INFO_MAIN' at line 1
in:
[SQL_SHOW_PRODUCT_INFO_MAIN]

6 Aug 2011, 8:25 AM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: 1064 Error after installing Time Zone Fix addon

Looks like you've damaged the files in the /includes/classes/db/mysql/ folder.
Put the original files back and that error should go away.

6 Aug 2011, 9:55 AM
#3
hfprojekte avatar

hfprojekte

New Zenner

Join Date:
Aug 2011
Posts:
2
Plugin Contributions:
0

Re: 1064 Error after installing Time Zone Fix addon

unfortunately, no

6 Aug 2011, 10:01 AM
#4
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: 1064 Error after installing Time Zone Fix addon

Okay, then you didn't restore the files properly.
Remove all the files you added with the addon, and put back the original version of all the files you replaced.

The SQL_SHOW_PRODUCT_INFO_MAIN constant is defined in the /includes/classes/db/mysql/define_queries.php file. So either you've deleted that file, or it's damaged, or you've done something very bizarre to other core system files that prevents that file from loading.

Restore from backup or do a fresh clean install again.