I am currently getting the below error. This keeps on happening now and again (once every 2 weeks) and my website will be down for a few hours but will then correct itself and work ok! Any ideas?
e.g http://www.thefashionhut.co.uk/vans-...0a&filter_id=6
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 '-0, 0' at line 7
in:
[select p.products_quantity, p.products_rrp, p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status = 1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from zen_products p left join zen_specials s on p.products_id = s.products_id, zen_products_description pd, zen_manufacturers m where p.products_status = 1 and pd.products_id = p.products_id and pd.language_id = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '18' limit -0, 0]
Thread: 1064 Error in Syntax
Results 1 to 10 of 14
-
12 Apr 2008, 01:22 PM #1
New Zenner
- Join Date
- Oct 2007
- Location
- UK
- Posts
- 82
- Plugin Contributions
- 0
1064 Error in Syntax
-
12 Apr 2008, 02:32 PM #2
New Zenner
- Join Date
- Oct 2007
- Location
- UK
- Posts
- 82
- Plugin Contributions
- 0
Re: 1064 Error in Syntax
Upon further reading in this forum it seems my database cache is the problem.
Do I need to do this?: http://www.zen-cart.com/forum/showth...cache+turn+off
-
Re: 1064 Error in Syntax
What version of Zen Cart are you using?
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
-
12 Apr 2008, 06:25 PM #4
New Zenner
- Join Date
- Oct 2007
- Location
- UK
- Posts
- 82
- Plugin Contributions
- 0
Re: 1064 Error in Syntax
Version is 1.3.8a; Database Patch Level: 1.3.8
-
Re: 1064 Error in Syntax
What do you have in Admin->Config->Maximum Values for settings that are set to 0 ?
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
-
14 Apr 2008, 09:20 AM #6
New Zenner
- Join Date
- Oct 2007
- Location
- UK
- Posts
- 82
- Plugin Contributions
- 0
Re: 1064 Error in Syntax
Just Maximum Orders Detail Display on Admin Orders Listing
-
Re: 1064 Error in Syntax
Okay. What addons have you installed?
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
-
15 Apr 2008, 08:10 AM #8
New Zenner
- Join Date
- Oct 2007
- Location
- UK
- Posts
- 82
- Plugin Contributions
- 0
Re: 1064 Error in Syntax
Google Base Feeder and SEO URLs. SEO URLs was only installed a few weeks ago but this problem has been ongoing for over 2 months now.
Google Base Feeder was installed approx. 3 months ago.
-
17 Apr 2008, 11:12 AM #9
New Zenner
- Join Date
- Oct 2007
- Location
- UK
- Posts
- 82
- Plugin Contributions
- 0
Re: 1064 Error in Syntax
DrByte,
Any ideas? Website has just gone down again!
-
17 Apr 2008, 02:08 PM #10
Sensei
- Join Date
- Jan 2004
- Posts
- 66,419
- Blog Entries
- 7
- Plugin Contributions
- 81
Re: 1064 Error in Syntax
Which addon has added this products_rrp field to your products table?select p.products_quantity, p.products_rrp, p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, ....
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
Similar Threads
-
SQL Syntax error 1064 You have an error in your SQL syntax
By vxnut in forum General QuestionsReplies: 1Last Post: 25 Aug 2011, 05:58 AM -
1064 SQL syntax error
By perkiekat in forum General QuestionsReplies: 4Last Post: 12 Dec 2009, 09:13 PM -
1064 sql syntax error
By jpierre in forum Upgrading from 1.3.x to 1.3.9Replies: 2Last Post: 7 Sep 2006, 01:03 PM
Bookmarks