What's New? Goes to Error page when I click on (more). Huh?

When I click on (more) in the What's New sidebox...it gives me this...

Warning: Division by zero in /var/www/vhosts/shopatalis.com/httpdocs/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 10
in:
[SELECT p.products_id, p.products_type, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status FROM products p LEFT JOIN manufacturers m ON (p.manufacturers_id = m.manufacturers_id), products_description pd WHERE p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 order by pd.products_name limit -0, 0]

Is there a way to fix this?

Thanks in Advance!
LMW1

When hovering over the "more" link this is what is presented

http://www.shopatalis.com/index.php?main_page=products_new&zenid=0d952780a1103d30ae06153b156432ed

and it should be

http://http://www.shopatalis.com/index.php?main_page=products_new

You some how have a zenid included with yours that should not be there

kobra:

You some how have a zenid included with yours that should not be there

This is automatically inserted by Zen when a session has been started. It wouldn't cause that problem. If you take off that part of the string, it still gives the error.

http://www.shopatalis.com/index.php?main_page=products_new
(still gives the error)

lmw1:

When I click on (more) in the What's New sidebox...it gives me this...

Warning: Division by zero in /var/www/vhosts/shopatalis.com/httpdocs/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 10
in:
[SELECT p.products_id, p.products_type, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status FROM products p LEFT JOIN manufacturers m ON (p.manufacturers_id = m.manufacturers_id), products_description pd WHERE p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 order by pd.products_name limit -0, 0]

Is there a way to fix this?

Thanks in Advance!
LMW1

I would check a few things:

1. Line 76 in the **includes/classes/split_page_results.php **

2. That line is referencing something in your database (that has to do with featured products) which is probably missing (thus causing a "division by zero" error). Find that and correct it, and you probably have your answer.

**3) Just for kicks, re-upload a NEW version of the file "includes/classes/split_page_results.php " and see what happens. **

4. It is only a problem with the Featured products (maybe you are referencing one that "has no name" or something -- check your admin "featured products section for this). I can tell this because if you type any of the following into your browser, it works fine http://www.shopatalis.com/index.php?main_page=contact_us
   or
   http://www.shopatalis.com/index.php?main_page=login

etc.. (al1 default pages in zen)

5. I would also take a close look at the products you have listed as "featured" in the Admin. Pay attention to portions of them that are "listed as part of the error" in the string you are getting. (Like the products name).

Check your Maximum Values and make sure you don't have one set to 0 as dividing by 0 isn't logical ... :smile:

Specifically peek at:

New Products Listing- Number Per Page
Number of new products listed per page