Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

qbpbb error Quantity Price Breaks Per Product v1.3.6


movi2

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • 4 months later...

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...

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...