I was working on the layout of my viewProd.tpl file when I started getting a MySQL error in IE:
MySQL Error Occured
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 'Select 1' at line 1
QUERY = SELECT CubeCart_options_bot.option_id, CubeCart_options_bot.value_id, option_price, option_symbol, assign_id FROM `CubeCart_options_bot` INNER JOIN `CubeCart_options_mid` ON CubeCart_options_mid.value_id = CubeCart_options_bot.value_id INNER JOIN `CubeCart_options_top` ON CubeCart_options_bot.option_id = CubeCart_options_top.option_id WHERE assign_id = Select 1
The site is still working fine in Firefox, Opera, Safari and can be viewed at www.warriorstradingpost.com
I immediately restored a working version of my viewProd.tpl file - no luck. I also emptied my admin sessions table and product options tables with no luck.
Any help is appreciated.