deano42 Posted May 3, 2006 Posted May 3, 2006 I have been using osC 2.2 with xoops for a month now, all working fine. But some of the users are now getting a sql tax error when adding items to the basket 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 tax_class_title from xoops_osc_tax_class where tax_class_id= [TEP STOP] Now for some its actually working fine, now i did modify some user details from the back end recently, i cant see how but i wonder if that would have caused the problem? Any ideas? Thanks Deano
chooch Posted May 3, 2006 Posted May 3, 2006 Could be that your host has upgraded the MySQL... anything below 4.5 should be ok-ish... if it is now % or more then you'll need to change it back Upon receiving fixes and advice, too many people don't bother to post updates informing the forum of how it went. Until of course they need help again on other issues and they come running back! Why receive the information you require in good faith for free, only to then have the attitude to ignore the people who gave it to you? There's no harm in saying, 'Thanks, it worked'. On the contrary, it creates a better atmosphere. CHOOCH
deano42 Posted May 4, 2006 Author Posted May 4, 2006 Checked with the Host, no upgrades have been done. Weird as only some users are experiancing the problem, Currently running MySQL 4.1.18-standard Have looked all around this forum, i see a number of 1064 errors but none seem to refer to the Tax Class. Thanks for all the help anyone can give! Deano
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.