Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Broken Reviews, SQL error


kinomuto

Recommended Posts

Hi all,

 

I've got a SQL error on the reviews.php page:

 

/catalog/reviews.php

 

Error is as follows:

 

HEADING_TITLE

 

TABLE_HEADING_PRODUCTS TABLE_HEADING_RATING TABLE_HEADING_DATE_ADDED TEXT_APPROVED TABLE_HEADING_ACTION

1064 - You have an error in your SQL syntax near 'select reviews_id, products_id, date_added, last_modified, reviews_rating, appro' at line 1

 

select count(select reviews_id, products_id, date_added, last_modified, reviews_rating, approved from reviews order by date_added DESC) as total

 

[TEP STOP]

 

I had just put on the Review Approval Contribution and can reverse to the back ups but wondered if anyone had a quick solution to this or had come across this before?

 

TIA

 

Kino

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...