More info...
This site was updated from 1.3.x to 1.5.0, then 1.5.1. The site wasn't used very much and in hindsight, I probably should have just did a clean install of V1.5.1 but everything seemed fine untll I ran across these issues with the shopping cart.
I installed a fresh copy of v1.5.1 on another domain (same server), populated with the demo data and all the cart functions worked as expected. Perhaps my best option would be a clean install and restore of the database. I attempted to restore the exported database to the fresh install but had no success. I couldn't get past this error during the import...
Code:
There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below:
----BEGIN CUT----
eNo1jbEOgjAYhE3Y/qe4B6iNRdHYrSENmvxQbMHB1TgwUBdJ5O0tGm+8fN+d9d55jVKhzMG20VDI
oRSFLtUZUT2HC2sUciOP+/X9OY5THF4z9cHDBQFT2aYTuNqE8xCnN2p3OzObRaG2Nhq75BbUntqF
Ei4sa1upDj+e2DSVxiPS94iy1T8f1lAklQ==
----END CUT----
----BEGIN RAW----
ERROR: C1 C2 LEN: 1 2 11
STR:
MySQL: 5.0.96-community
USR OS, AGENT, VER: Linux MOZILLA 5.0
PMA: 4.0.5
PHP VER,OS: 5.3.17 Linux
LANG: en
SQL:
----END RAW----
SQL query:
MySQL said: Documentation
#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
Any suggestions on how to proceed, at this point?
Thanks!