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.
Code:
[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
Bookmarks