help, please! - split-page-results error division by zero

[barco57]

it seems to have worked out well, except ....

Famous last words......... too much.

[DrByte]

Sounds like you set your "Maximum Value" for one of the entries in Admin->Configuration->Maximum Values to 0 and ended up with something you didn't expect.

[vibehappy]

hey, thanks! you were right, and somehow eventhough i spent hours looking at it trying to find the right one to change back, i didn't see it until you said that...lol. guess that's the way it works. thanks so much!!!

[shaz]

I get a similar error - check max values nothing set to 0, any suggestions..
below is the warning/error

Warning: Variable passed to each() is not an array or object in /home/public_html/online/includes/classes/db/mysql/query_factory.php on line 114

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/public_html/online/includes/classes/db/mysql/query_factory.php:114) in /home/public_html/online/includes/functions/sessions.php on line 108

Warning: Cannot modify header information - headers already sent by (output started at /home/public_html/online/includes/classes/db/mysql/query_factory.php:114) in /home/public_html/online/includes/init_includes/init_templates.php on line 78

..
Warning: Division by zero in /home/public_html/online/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, MAX_DISPLAY_PRODUCTS_LISTING' at line 7
in:
[select 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 zen_products_description pd, zen_products p left join zen_manufacturers m on p.manufacturers_id = m.manufacturers_id, zen_products_to_categories p2c left join zen_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 = '9' limit -0, MAX_DISPLAY_PRODUCTS_LISTING]

Thanks for your help

[Ajeh]

First, look to see if in Configuration ... Maximum Values ... you have an entry for:

Products Listing- Number Per Page
Maximum Number of Products to list per page on main page

Next, peek in the configuration table via phpMyAdmin and see if there is a configuration_key for:
MAX_DISPLAY_PRODUCTS_LISTING

It almost looks like you are missing this ...

[shaz]

Products Listing- Number Per Page
this is set to 10.


just going to check configuration table via phpMyAdmin

[shaz]

Checked via phpMyAdmin - MAX_DISPLAY_PRODUCTS_LISTING is there and set to 10

HELP!!