Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

SQL error in admin reviews page


spottedhaggis

Recommended Posts

Posted

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...