Zen Cart Logo
Forums / General Questions / PHP Fatal error: 1064:You have an error in your SQL syntax

PHP Fatal error: 1064:You have an error in your SQL syntax

Views: 2,014

Results 1 to 3 of 3
5 Mar 2015, 3:00 AM
#1
chaptech avatar

chaptech

New Zenner

Join Date:
Mar 2015
Posts:
3
Plugin Contributions:
0

PHP Fatal error: 1064:You have an error in your SQL syntax

[05-Mar-2015 13:56:09] PHP Fatal 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 '' at line 1 :: SELECT categories_id, categories_name FROM categories_description WHERE categories_id= in /includes/classes/db/mysql/query_factory.php on line 120

Hi.

I am getting this error at order processing final checkout, the order processes and the email comes through to the customer and order goes into pending state for customer but that error happens on last complete order click, also if the customer goes into their orders and clicks on view the same error occurs.

Any assistance on what is breaking here would be appreciated

Regards

Nathan

5 Mar 2015, 3:40 AM
#2
twitchtoo avatar

twitchtoo

Totally Zenned

Join Date:
Apr 2007
Location:
Ontario, Canada
Posts:
1,733
Plugin Contributions:
14

Re: PHP Fatal error: 1064:You have an error in your SQL syntax

which mods and template are you using?

5 Mar 2015, 6:16 PM
#3
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,086
Plugin Contributions:
56

Re: PHP Fatal error: 1064:You have an error in your SQL syntax

I suggest that you install myDEBUG Backtrace (http://www.zen-cart.com/downloads.php?do=file&id=1879). That will let you know what module (and line number) called the query_factory class with the invalid SQL.