division error message

[JLMann]

Hi:

 

After a user logs in, they get a message at the top of the main screen that welcomes them back and asks them if they want to see what's new.

 

"Welcome back John! Would you like to see which new products are available to purchase?"

 

Its a different message from the one that shows there when a guest visits the site.

 

Clicking What's New generates a very messy error right on the main screen.

 

Warning: Division by zero in /home/swskatin/public_html/ecom/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_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name 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 p.products_date_added DESC, pd.products_name limit -0, 0

 

I have a few dozen products, but no new ones (that I know of) and it could be that would explain a divide by zero error.

 

I tried simply deleting the opportunity to see what is new, but can't find the message in any of the english php files. Numerous posts on this site say it should be in the index file, and numerous users say they can't find it there. I can't find it there either. I have edited the index file before to get a custom welcome so I thought perhaps I had deleted it already. But why is the message there then? So, I looked in the original index.php file which I had archived. It was not there either. Obviously the text has to be someplace, but I can't find it and have looked in most of the php files in the include/languages/english folder.

 

The other choice is to create some new products or designate some old ones as new. But frankly, I can't figure out how to do this either!

 

I really don't like the idea of an error message in the middle of my store's home page.

 

Any ideas how to fix this?

[♥geoffreywalton]

The solution is in the patches link in my signature block.

 

Enjoy