spottedhaggis Posted November 17, 2005 Posted November 17, 2005 When I go to reviews in the admin page, I get the following error 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 '-8, 8' at line 1 select reviews_id, products_id, date_added, last_modified, reviews_rating from reviews order by date_added DESC limit -8, 8 The structure of reviews is as follows. `reviews_id` int(11) NOT NULL auto_increment, `products_id` int(11) NOT NULL default '0', `customers_id` int(11) default NULL, `customers_name` varchar(64) NOT NULL default '', `reviews_rating` int(1) default NULL, `date_added` datetime default NULL, `last_modified` datetime default NULL, `reviews_read` int(5) NOT NULL default '0', PRIMARY KEY (`reviews_id`) Can anyone help me fix this file. Born - Scotland Location - Kent, England Job - hunting for one
♥yesudo Posted November 17, 2005 Posted November 17, 2005 http://www.oscommerce.com/forums/index.php?sho...53entry654653 Your online success is Paramount.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.