Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1054 - Unknown column 'reviews_status' in 'where clause'


bdazle

Recommended Posts

Hi all...

 

Pleas help , i am very newbie and just getting a grip....i have managed to create my website with osc 2.3 moving from 2.2

Problem i am now having is that everytime i click on any product on the homepage, i get the follow error

 

1054 - Unknown column 'reviews_status' in 'where clause'

 

select count(*) as count from reviews where products_id = '628' and reviews_status = 1

 

[TEP STOP]

 

and also get error after i install the review modules in the (admin panel) my website comes up with this error below ...

 

1054 - Unknown column 'r.reviews_status' in 'where clause'

 

select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' and r.reviews_status = 1 order by r.reviews_id desc limit 10

 

[TEP STOP]

 

pls help

Link to comment
Share on other sites

You have not made the necessary database changes to enable the 2.3.1 files to work on a 2.2 database.

 

Can you pls assist on what necessary database changes i need to make for the 2.2 database to work with 2.3.1

Link to comment
Share on other sites

  • 8 months later...

The change required to fix the above seems to have been missed in the upgrade guide.

 

You'll need to run this query:

 

ALTER TABLE `reviews` ADD `reviews_status` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `last_modified';

 

See this thread for reference:

 

http://www.oscommerce.com/forums/topic/369330-any-easy-way-to-move-customer-from-22-rc2a-to-231/

 

 

FYI: I did a clean install of v2.3.1 on a test server. I retored the v2.2rc2a database to the test server. I applied all the changes listed in the upgrade guide and then ran the above query. osCommerce v2.3.1 seems to be working, but a lot of testing remains.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...