MaTBoY Posted July 18, 2005 Share Posted July 18, 2005 Hi Guys, I need some help! I recently installed the 'Seperate Pricing per Customer' mod to my site exactly as per instructions. When you click down the product tree you get this error 1064 - You have an error in your SQL syntax near '-_db' at line 1 show table status from soccerstop_com_au_-_db [TEP STOP] It only occurs when clicking through the tree. If you click through via the actual items in the main page the site works fine. I have STS Template system also installed, and the server is running MySQL 3.23.58 If any of you have advice or a fix I'd be exceptionally grateful! Thanks in advance guys! :thumbsup: Quote Link to comment Share on other sites More sharing options...
Jan Zonjee Posted July 18, 2005 Share Posted July 18, 2005 1064 - You have an error in your SQL syntax near '-_db' at line 1show table status from soccerstop_com_au_-_db [TEP STOP] The problem is the hyphen in the database name. It was mentioned in the changelog_v411.txt file ;)- includes/functions/database.php see: http://www.oscommerce.com/forums/index.php?sho...ndpost&p=563454 (the sql statement "show table status from" has a problem with hyphens in the table name, therefore backticks should be placed around it in that case) Quote Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.