aksolanki Posted June 16, 2003 Posted June 16, 2003 I have just installed the osCommerce files and everything was going well until. 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 products_id, products_image, products_tax_class_id, products_price from products where products_status = '1' order by products_date_added desc limit [TEP STOP] Now I keep getting the error, I have done a lot of work personalising the files already and don't want to have to start again. Can anyone help me, please? Anil
mdfst13 Posted June 17, 2003 Posted June 17, 2003 It looks like it is not printing all of the SQL query. You are missing the value of the limit (i.e. are you limiting to 1, 2, 5, etc. rows?) and the terminating semi-colon (;). Is your variable long enough to hold the whole query? Did you comment out or delete part of the statement construction while making customizations? You might want to see if you can find from where the error is coming. I.e. is it in default.php, database.php, etc. Even if it is database.php that is throwing the error, where is the SQL query being constructed? Good luck, Matt I love deadlines. I like the whooshing sound they make as they fly by. ---Douglas Adams
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.