Error in Quantity Price Breaks mod when updating to MySQL 5

[danthman]

I installed Quantity Price Breaks about 2 years ago when our server was MySQL 4. It ran fine. They just upgraded and I made the changes to index.php and advanced_search_results.php to make my site run on MySQL 5 but I am having problems with the Quantity Price Breaks code. On the product info page I get this error message:

 

1054 - Unknown column 'p.products_id' in 'on clause'

 

select pd.products_name, p.products_model, p.products_image, p.products_id, p.manufacturers_id, p.products_price, p.products_weight, p.products_price1,p.products_price2,p.products_price3,p.products_price4, p.products_price5,p.products_price6,p.products_price7,p.products_price8, p.products_price1_qty,p.products_price2_qty,p.products_price3_qty,p.products_pri

ce4_qty, p.products_price5_qty,p.products_price6_qty,p.products_price7_qty,p.products_pri

ce8_qty, 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, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = '54' and pd.products_id = '54' and pd.language_id = '1'

 

How can I modify it to work with MySQL 5?

 

Thanks!

[BryceJr]

This is very common after an upgrade.

 

It is so common that a contribution was written for this.

 

http://addons.oscommerce.com

[danthman]

This is very common after an upgrade.

 

It is so common that a contribution was written for this.

 

http://addons.oscommerce.com

I looked there first. Nothing is mentioned about upgrading to MySQL 5

[♥geoffreywalton]

Ah but there is under

 

1054 - Unknown column 'p.products_id' in 'on clause

[BryceJr]

I looked there first. Nothing is mentioned about upgrading to MySQL 5

Really??!! You looked? I highly doubt that. None theless, it's a Friday. Here's a freebie.

 

You are right -->this doesn't exist.

[danthman]

Really??!! You looked? I highly doubt that. None theless, it's a Friday. Here's a freebie.

 

You are right -->this doesn't exist.

I found that long ago and applied it to the site in question and several other sites and it worked on the others. My problem is specific to the Quantity Price Breaks mod. I cannot find a solution because the error is in the the Quantity Price Break mod.

 

Is there anyone familiar with upgrading Quantity Price Breaks to MySQL 5?

[Jan Zonjee]

Is there anyone familiar with upgrading Quantity Price Breaks to MySQL 5?

Upgrade to version 1.2.9 (not the 1.3 series).