Guest Posted June 27, 2003 Posted June 27, 2003 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]
Guest Posted June 28, 2003 Posted June 28, 2003 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??
Recommended Posts
Archived
This topic is now archived and is closed to further replies.