SQL error 1064??

[paperzombie]

HELP! Something has happened to my site. I haven't installed anything recently, I was just changing around and turning off some of the "new product" boxes when I clicked to refresh and this is what I got..

Warning: Division by zero in /home/heyprett/public_html/shop/includes/classes/split_page_results.php on line 76
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 '-0, 0' at line 7
in:
[select p.products_image, pd.products_name, p.products_quantity, p.products_id, p.products_type, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status 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 p2c.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 = '2' order by p.products_sort_order, pd.products_name limit -0, 0]

I searched all over and couldn't find anything..

I just did a fresh install and everything has been working great. When I click on server info it says:

Zen Cart 1.3.7
Database Patch Level: 1.3.8

[DrByte]

I just did a fresh install and everything has been working great. When I click on server info it says:

Zen Cart 1.3.7
Database Patch Level: 1.3.8

Um ... your first problem is that your site files are for v1.3.7 and your database is at 1.3.8.
That's a dangerous position to be in.
You should finish the upgrade of your PHP files first.
It's possible that your other error may go away automatically after that.

[DrByte]

In the meantime, check what you've got set in Admin->Configuration->Maximum Values->Products Listing- Number Per Page. You shouldn't set that to zero!!! (nor leave it blank). Put a number in it. The default is 10.