tbird22 Posted February 9, 2005 Share Posted February 9, 2005 I am just about ready to launch my store and was adding some contributions that I feel would be good for the store. After adding the contribution "Review Approval System 1.2 (MS2)." and following the instructions concerning the this contribution at: http://www.oscommerce.com/community/contri...approval+system I get this error message in the admin section under 'REVIEWS': "1054 - Unknown column 'approved' in 'field list' select reviews_id, products_id, date_added, last_modified, reviews_rating, approved from reviews order by date_added DESC limit 0, 20 [TEP STOP] and I get this message in the 'REVIEWS' Section on my stores homepage: 1054 - Unknown column 'r.approved' 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.approved = '1' order by r.reviews_id desc limit 10 [TEP STOP] I have a launch day of today and would truly want this contribution added to my store. In the README file it states: Execute the review_approve.sql query, which will add the "approved" column to the reviews table. I think this probably is where the mistake is at, but I'm not sure how to 'execute' this file. If someone can please show me some direction, I would greatly appreciate it and my store can open as scheduled. PLEASE HELP!!!! Link to comment Share on other sites More sharing options...
Singularity Posted February 9, 2005 Share Posted February 9, 2005 I am just about ready to launch my store and was adding some contributions that I feel would be good for the store. After adding the contribution "Review Approval System 1.2 (MS2)." and following the instructions concerning the this contribution at: http://www.oscommerce.com/community/contri...approval+system I get this error message in the admin section under 'REVIEWS': "1054 - Unknown column 'approved' in 'field list' select reviews_id, products_id, date_added, last_modified, reviews_rating, approved from reviews order by date_added DESC limit 0, 20 [TEP STOP] and I get this message in the 'REVIEWS' Section on my stores homepage: 1054 - Unknown column 'r.approved' 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.approved = '1' order by r.reviews_id desc limit 10 [TEP STOP] I have a launch day of today and would truly want this contribution added to my store. In the README file it states: Execute the review_approve.sql query, which will add the "approved" column to the reviews table. I think this probably is where the mistake is at, but I'm not sure how to 'execute' this file. If someone can please show me some direction, I would greatly appreciate it and my store can open as scheduled. PLEASE HELP!!!! <{POST_SNAPBACK}> Check this thread..... http://www.oscommerce.com/forums/index.php?showtopic=119226 ----------------------------------------------------------------------------- Adam Get your osc documentation here: http://www.oscommerce.info/ Link to comment Share on other sites More sharing options...
tbird22 Posted February 9, 2005 Author Share Posted February 9, 2005 Check this thread..... http://www.oscommerce.com/forums/index.php?showtopic=119226 <{POST_SNAPBACK}> Ok...I read all of that...but I think I am in the position of not knowing how to run the SQL file. Can someone give me some direction on how to do this. I have phpMyAdmin 2.6.0-pl3 but am very unfamiliar with how to use it. PLEASE HELP!!!! Link to comment Share on other sites More sharing options...
Singularity Posted February 10, 2005 Share Posted February 10, 2005 Ok...I read all of that...but I think I am in the position of not knowing how to run the SQL file. Can someone give me some direction on how to do this. I have phpMyAdmin 2.6.0-pl3 but am very unfamiliar with how to use it. PLEASE HELP!!!! <{POST_SNAPBACK}> I cut and paste this from a google search.... it seems to be right, but I haven't tried it... 1)On the left side(darker blue) Please select a database... Do so.... 2)On the top row on the right side of that new page... There is an SQL link.... Click it... 3)On that new page there is a box Run SQL In there just cut and glue your tables.... ----------------------------------------------------------------------------- Adam Get your osc documentation here: http://www.oscommerce.info/ Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.