if I search "null" i get an error.

[chadlly2003]

My search for zencart seems to work. For some reason if I type in the search box "null" i get an error. WARNING: An Error occurred, please refresh the page and try again.

When I check my error log i see the following.

[21-Nov-2017 13:52:48 America/New_York] PHP Fatal error:  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 'GROUP BY p.products_id' at line 1 :: select distinct p.products_id FROM products p LEFT JOIN manufacturers m USING(manufacturers_id) LEFT JOIN products_description pd on p.products_id = pd.products_id JOIN products_to_categories p2c on p.products_id = p2c.products_id JOIN categories c on p2c.categories_id = c.categories_id LEFT JOIN meta_tags_products_description mtpd ON mtpd.products_id= p2c.products_id AND mtpd.language_id = 1 WHERE (p.products_status = 1                AND pd.language_id = 1  GROUP BY p.products_id  ==> (as called by) /home/xxx/public_html/includes/classes/split_page_results.php on line 84 <== in /home/xxx/public_html/includes/classes/db/mysql/query_factory.php on line 155

I have done some research and found this but i was still unable to solve my issue. If someone could assist me or lead me in the right direction i would appreciate it.

https://www.zen-cart.com/showthread....database-error

[lat9]

As the modified title of that posting indicates, the issue has been corrected in Zen Cart 1.5.5a and later. This Zen Cart GitHub commit contains at least some record of the changes.

[chadlly2003]

Thank you for the quick response. I managed to figure out my issue. I edited the following files based on the github documentation.

- includes/functions/functions_general.php
- includes/modules/checkout_new_address.php

The other files for whatever reason did not match so i just left them as is

[carlwhat]

oh dear.... i am reminded of this:

https://imgs.xkcd.com/comics/exploits_of_a_mom.png

best.