bdazle Posted April 7, 2011 Share Posted April 7, 2011 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 More sharing options...
burt Posted April 7, 2011 Share Posted April 7, 2011 You have not made the necessary database changes to enable the 2.3.1 files to work on a 2.2 database. Link to comment Share on other sites More sharing options...
bdazle Posted April 11, 2011 Author Share Posted April 11, 2011 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 More sharing options...
multimixer Posted April 11, 2011 Share Posted April 11, 2011 Read the upgrade guide My community profile | Template system for osCommerce - New: Responsive | Feedback channel Link to comment Share on other sites More sharing options...
Karl53 Posted January 9, 2012 Share Posted January 9, 2012 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.