movi2 Posted January 29, 2010 Share Posted January 29, 2010 I install a contribution about break prices in my oscommerce shop and i have 2 errors. 1) into admin area, catalog 1146 - Table 'promocio_osc2.products_to_discount_categories' doesn't exist select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_qty_blocks, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, ptdc.discount_categories_id, dc.discount_categories_name from products p left join products_to_discount_categories ptdc on p.products_id = ptdc.products_id left join discount_categories dc using(discount_categories_id), products_description pd, products_to_categories p2c where p.products_id = pd.products_id and pd.language_id = '3' and p.products_id = p2c.products_id and p2c.categories_id = '0' order by pd.products_name 2) when you try to see any item into www.mdisein.com 1054 - Unknown column 'p.products_qty_blocks' in 'field list' select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_qty_blocks, 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_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id, products_to_categories p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '3' and p2c.categories_id = '25' order by pd.products_name limit 0, 20 [TEP STOP] Please i need help. Best regards Juan Aguilar Granados mdisein@gmail.com Quote Link to comment Share on other sites More sharing options...
multimixer Posted January 29, 2010 Share Posted January 29, 2010 As I told you in my answer to your PM, the support forum for this contribution is --> here (<-- click on this link, it will take you to the topic) After you are in the topic hit the "reply" button and post your question there. You should try to find out first if your issue has been solved before, by searching and reading previous answers and questions You just posted in the v3 forum do you use version3 or version2 of osCommerce? You need to say this in your post in the forum Quote My community profile | Template system for osCommerce - New: Responsive | Feedback channel Link to comment Share on other sites More sharing options...
movi2 Posted January 29, 2010 Author Share Posted January 29, 2010 i use online merchant v2.2 rc2 As I told you in my answer to your PM, the support forum for this contribution is --> here (<-- click on this link, it will take you to the topic) After you are in the topic hit the "reply" button and post your question there. You should try to find out first if your issue has been solved before, by searching and reading previous answers and questions You just posted in the v3 forum do you use version3 or version2 of osCommerce? You need to say this in your post in the forum Quote Link to comment Share on other sites More sharing options...
multimixer Posted January 29, 2010 Share Posted January 29, 2010 Ok, so you post in the forum I told you if you can not find an answer Quote My community profile | Template system for osCommerce - New: Responsive | Feedback channel Link to comment Share on other sites More sharing options...
Jan Zonjee Posted May 29, 2010 Share Posted May 29, 2010 I install a contribution about break prices in my oscommerce shop and i have 2 errors. The place for these questions is the support thread of course. However, it looks like you haven't run the sql file (price_break.sql). Obviously, you then get errors about missing tables and fields in tables... 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.