When I add the following code to show the error
I then receive this error message when clicking on those HTTP 500 error sub categories and search.ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
I checked the htaccess file and it looks fine but still receiving these errors only on very certain search or sub categories.Fatal error: Uncaught Exception: Error: 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 'ASC' at line 1<br />Error No: 1064<br />SELECT geo_zone_id FROM z06_zone_to_geo_zone GROUP BY `geo_zone_id` ASC in /public_html/system/library/db/mysqli.php:40 Stack trace: #0 /public_html/system/storage/modification/system/library/db.php(84): DB\MySQLi->query() #1 /public_html/catalog/model/shipping/free_shipping_per_item.php(131): DB->query() #2 /public_html/catalog/model/shipping/free_shipping_per_item.php(63): ModelShippingFreeShippingPerItem->getSiteActiveGeoZones() #3 /public_html/vqmod/vqcache/vq2-system_storage_modification_system_engine_loader.php(150): ModelShippingFreeShippingPerItem->isFreeShipping() #4 public_html/system/engine/proxy.php(13): Loader->{closure}() #5 /public_html/vqmod/vqcache/vq2-catalog_controller_product_search.php(258): Proxy->__call() #6 /public_html/system/library/db/mysqli.php on line 40