MoonFaery Posted February 12, 2008 Share Posted February 12, 2008 I installed everything and when I go to test it.. I click on Add To Wishlist and I get this: My Wish List contains: Image Product Name Price Select 1054 - Unknown column 'p.products_id' in 'on clause' select pd.products_id, pd.products_name, pd.products_description, p.products_image, p.products_status, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products p, products_description pd left join specials s on p.products_id = s.products_id where pd.products_id = '106' and p.products_id = pd.products_id and pd.language_id = '1' order by products_name [TEP STOP] ---and when I log in as a customer I get: 1146 - Table 'mysticd2_osc2.customers_wishlist' doesn't exist select products_id from customers_wishlist where customers_id = '5' and products_id = '106{1}7{2}39' [TEP STOP] Quote Link to comment Share on other sites More sharing options...
MoonFaery Posted February 12, 2008 Author Share Posted February 12, 2008 And one of the steps was: STEP 2 - Run the provided wishlist.sql file This file will update your database and add the tables "customers_wishlist" and "customers_wishlist_attributes" What does that mean? Quote Link to comment Share on other sites More sharing options...
TCH-Bruce Posted February 12, 2008 Share Posted February 12, 2008 That means it will add tables to your database. It must be run. You can run it in phpadmin. Quote Link to comment Share on other sites More sharing options...
MoonFaery Posted February 13, 2008 Author Share Posted February 13, 2008 (edited) Ok, I did that.. but the errors from my previous post are still there. Correction, the first one in the first post is still there (not the 2nd): My Wish List contains: Image Product Name Price Select 1054 - Unknown column 'p.products_id' in 'on clause' select pd.products_id, pd.products_name, pd.products_description, p.products_image, p.products_status, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products p, products_description pd left join specials s on p.products_id = s.products_id where pd.products_id = '42' and p.products_id = pd.products_id and pd.language_id = '1' order by products_name [TEP STOP] Edited February 13, 2008 by MoonFaery Quote Link to comment Share on other sites More sharing options...
MoonFaery Posted February 13, 2008 Author Share Posted February 13, 2008 (edited) I finally got some help on the oscommerce forum and got it fixed Edited February 13, 2008 by MoonFaery Quote Link to comment Share on other sites More sharing options...
TCH-Bruce Posted February 13, 2008 Share Posted February 13, 2008 Glad you got it going. Quote Link to comment Share on other sites More sharing options...
MoonFaery Posted February 13, 2008 Author Share Posted February 13, 2008 Glad you got it going. Thank you Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.