Price Break

[Beaver78]

I have Install the Contribution Quantity Price Breaks Per Product Version 1.2.2

 

http://www.oscommerce.com/community/contri...rch,Price+Break

 

The Backend is running Ok.

 

But the Frontend say follow Error whats wrong?

 

Let's See What We Have Here

 

 

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p' at line 1

 

select count(select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, 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_price4_qty, p.products_price5_qty, p.products_price6_qty, p.products_price7_qty, p.products_price8_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 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 = \'1\' and p2c.categories_id = \'4\' order by pd.products_name) as total

 

[TEP STOP]

[Guest]

this part

 

select count(select ...........

 

indicates you did not install the module properly, so check the install instructions again.

[Jan Zonjee]

I have Install the Contribution Quantity Price Breaks Per Product Version 1.2.2

 

The Backend is running Ok.

 

But the Frontend say follow Error whats wrong?

 

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p' at line 1

 

select count(select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price,

This error is almost certainly unrelated to QPBPP. It is connected with the class found in catalog/includes/classes/split_page_results.php.

In the catalog/includes/modules/product_listing.php (line 14) that class is instructed to use product_id when doing a count:

  $listing_split = new splitPageResults($listing_sql, MAX_DISPLAY_SEARCH_RESULTS, 'p.products_id');

Instead of using p.products_id it is using $listing_sql in your case. Either you did something to catalog/includes/classes/split_page_results.php or catalog/includes/modules/product_listing.php to create this error.

[Beaver78]

Thanks Jan.

 

It is running!!

 

I have forgott to make update in product_listing.php.

 

Greets

Dirk