I
I
iPonic2017-04-24 11:22:52
MySQL
iPonic, 2017-04-24 11:22:52

Why does error 1064 occur in cms opencart?

In general, after the transfer to a new hosting, an error appeared (or it already was), they gave me the best practices. This is a site on opencart, the error occurs in the selection by parameters. tell me where to drop.
error text
Fatal error: Uncaught exception 'ErrorException' with message '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 'OPTION SQL_BIG_SELECTS = 1' at line 1
Error No: 1064
SET OPTION SQL_BIG_SELECTS = 1' in /home/p435690/www/p435690.for-test-only.ru/system/database/mysqli.php:41 Stack trace: #0 /home/p435690/www/p435690.for-test -only.ru/vqmod/vqcache/vq2-system_library_db.php(20): DBMySQLi->query('SET OPTION SQL_...') #1 /home/p435690/www/p435690.for-test-only.ru /catalog/model/catalog/search_auto.php(170): DB->query('SET OPTION SQL_...') #2 /home/p435690/www/p435690.for-test-only.ru/vqmod/vqcache /vq2-catalog_controller_product_search_auto.php(263): ModelCatalogSearchAuto->getTotalTires(Array, Array) #3 [internal function]: ControllerProductSearchAuto->index() #4 /home/p435690/www/p435690.for-test-only.ru /vqmod/vqcache/vq2-system_engine_front.php(42): call_user_func_array(Array, Array) #5 /home/p435690/www/p435690.for-test-only. in /home/p435690/www/p435690.for-test-only.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
W
web-mechanic, 2017-04-25
@amfetamine

Most likely you have a limit on the duration of a request to mysql on your hosting

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question