Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

[Contribution] Product Listing v.41


Guest

Recommended Posts

Posted

I have been having a go at this one for over a week now and am still having the same result. I have tried installing this on a clean install (26.06 Snapshot) but still cannot get it to wrok.Has anyone come across this problem?

 

Warning: Division by zero in /usr/www/htdocs/asylumnetnz/catalog/includes/classes/split_page_results.php on line 59

1064 - You have an error in your SQL syntax near ' p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, ' at line 1

 

select p.products_image, pd.products_name, pd.products_description, , p.products_id, p.manufacturers_id, 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_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 = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '19' order by pd.products_name

 

[TEP STOP]

Posted

Can anyone help on this. I have tried again on the latest snapshot but still the same problem. This is the only thing stopping me going live. Anyone??

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...