Getteing error msg.

[cujo]

Iam getting this error on 2 sites when trying to view the specials on the web site any help would be great.



Warning: Division by zero




in /home/motorspo/public_html/catalog/includes/classes/split_page_results.php on line 59

Warning: Division by zero in /home/motorspo/public_html/catalog/includes/classes/split_page_results.php on line 59

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 1

select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and s.status = '1' and s.customers_group_id = 0 order by s.specials_date_added DESC limit -0, 0

[cujo]

i have Specils in max settings set to 0 and when i click on the specils box on the left side of the web site that is set up in the info box admin i get the error. Now if i enable the specials to show in the middle of the web sites home page the error goes away but if i set it to 0 cause i do not want it in the middle of the Home page just in the info box the error comes up .

So any Help on how i can fix this so i can just have the info box that is in info box admin enable and not have the specils in the middle of the home page would be great thank you

Cujo

[jpf]

i have Specils in max settings set to 0....

That is why.... MAX setting should be more than 0.... This is the MAX specials to show..... if you want unlimited - them put maybe 100 or 1000 or 1000000 ......

[cujo]

all i want is to have no specils in the middle of my home page and to use the specils info box for my specilas but when i set the specils in max settings to 0 then when someone clicks on the specials info box arrow i get the error message you can se the specilas in the info box but when you click on ther arrow to see all specails the error comes up you can take a look at www.motorsports-nascar.com

Thank you
Cujo