An exception occured in driver: SQLSTATE[42000] [1064]

[Alex]

Iam using Pretashop 1.7 and admin area showing following error after enabling debug

(3/3) SyntaxErrorException
An exception occured in driver: SQLSTATE[42000] [1064] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '@@sql_mode,'ONLY_FULL_GROUP_BY',''))' at line 1

in AbstractMySQLDriver.php line 90
at AbstractMySQLDriver->convertException('An exception occured in driver: SQLSTATE[42000] [1064] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near \'@@sql_mode,\'ONLY_FULL_GROUP_BY\',\'\'))\' at line 1', object(PDOException))
in DBALException.php line 145
at DBALException::driverException(object(Driver), object(PDOException))
in Driver.php line 47
at Driver->connect(array('driver' => 'pdo_mysql', 'host' => 'localhost', 'port' => '', 'dbname' => 'admin_rands', 'user' => 'admin_rands', 'password' => '12323343', 'charset' => 'UTF8', 'driverOptions' => array('SET sql_mode=(SELECT REPLACE(@@@@sql_mode,\'ONLY_FULL_GROUP_BY\',\'\'))'), 'serverVersion' => 5.1, 'defaultTableOptions' => array()), 'admin_rands', '12323343', array('SET sql_mode=(SELECT REPLACE(@@@@sql_mode,\'ONLY_FULL_GROUP_BY\',\'\'))'))
at Connection->connect()
in Connection.php line 942
at Connection->query('SELECT name FROM isdi_module WHERE active = 1')
in ModuleRepository.php line 70
at ModuleRepository->getActiveModules()
in ModuleRepository.php line 88
at ModuleRepository->getActiveModulesPaths()
in appDevDebugProjectContainer.php line 3449
at appDevDebugProjectContainer->getPrestashop_Bundle_Routing_Converter_RoutingCacheKeyGeneratorService()
in appDevDebugProjectContainer.php line 3429
at appDevDebugProjectContainer->getPrestashop_Bundle_Routing_Converter_CacheProviderService()
in appDevDebugProjectContainer.php line 2064

Also home page showing following error but working after enabling debug mod in defines.inc.php. I need it work with debug off too. How to fix this?

Quote

This page isn’t working
rands.co.za is currently unable to handle this request. 

 

Edited September 2, 2020 by Alex
edit (see edit history)

[Alex]

Hello? any help?

[Alex]

I disabled all modules through phpmyadmin but istill its not working