Squirrelcart Diagnostics - Failed: INSERT INTO `Orders`

[codeman43]

Hello Jamie,

It seems I have a couple of problems here. I receive an e-mail that is completely empty, meaning it does not have clean water details were the order number. I so that is related to the below error that squirrelcart produces. What do I mean to do to fix the below error?

Thanks.

MySQL error: 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 "e;"e; at line 1

Query was: SELECT record_number FROM Orders WHERE Order_Number =


04/06/2005 14:08:47
Query Failed: INSERT INTO `Orders` (`Order_Number`,`Ordered_By`,`Product_Total`,`Tax_ Total`,`Savings_Total`,`Shipping_Total`,`Grand_Tot al`,`Order_Date`,`Transaction_ID`,`Payment_Method` ,`Ship_Special_Instructions`,`Shipping_Details`,`P acking_Details`,`IP_Address`,`User_Agent`,`Host_Na me`,`Referring_URL`,`Referral_Date`,`Bill_First_Na me`,`Bill_Last_Name`,`Bill_Company`,`Bill_Street`, `Bill_Street_2`,`Bill_City`,`Bill_State_or_Provinc e`,`Bill_Postal_Code`,`Bill_Country`,`Bill_Email_A ddress`,`Bill_Phone`,`Bill_Fax`,`Ship_First_Name`, `Ship_Last_Name`,`Ship_Company`,`Ship_Street`,`Shi p_Street_2`,`Ship_City`,`Ship_State_or_Province`,` Ship_Postal_Code`,`Ship_Country`,`Ship_Email_Addre ss`,`Ship_Phone`,`Ship_Fax`,`Ship_Address_Is`) VALUES ("e;"e;,"e;"e;,"e;"e;,"e;"e;,"e;"e;,"e;"e;,"e;"e;,"e;"e;,"e;"e;,"e;"e;,"e;"e;,"e;"e;,"e;Shipping Breakdown: ----------------------------------------------- Ship using: - Cost: $ "e;,"e;66.194.132.146"e;,"e;Wget/1.7"e;,"e;"e;,"e;"e;,"e;2005-04-06 14:08:47"e;,"e;"e;,"e;"e;,"e;"e;,"e;"e;,"e;"e;,"e;"e;,"e;"e;,"e;"e;,"e;"e;,"e;"e;,"e;"e;,"e;"e;,"e;"e;,"e;"e;,"e;"e;,"e;"e;,"e;"e;,"e;"e;,"e;"e;,"e;"e;,"e;"e;,"e;"e;,"e;"e;,"e;"e;,"e;"e;)

[stevef]

I am having the same issue after upgrading to 1.6.0. Is there a fix?

Thanks,

Steve

[Rich]

This type of SQL error usually indicates that one of the database updates used during an upgrade was not applied to the database, or an error was received while applying it.

If you haven't changed much in your cart since the upgrade, your best bet would be to revert back to the database backup that you made prior to the upgrade (you DID make a backup, right?) and then apply the required database updates that are available on our Support page (http://www.squirrelcart.com/support.php).

If you did not create a backup, or if you run into any problems, please open a support request with the help desk (link is available on the Support page).