Internal Server Error

Fatal error: Uncaught Exception: Error: Variable 'sql_mode' can't be set to the value of 'MYSQL40'<br />Error No: 1231<br />SET @@session.sql_mode = 'MYSQL40' in /home/excelle2/public_html/zehraavadh.com/system/library/db/mysqli.php:40 Stack trace: #0 /home/excelle2/public_html/zehraavadh.com/system/library/db.php(45): DB\MySQLi->query('SET @@session.s...') #1 /home/excelle2/public_html/zehraavadh.com/install/model/install/install.php(35): DB->query('SET @@session.s...') #2 /home/excelle2/public_html/zehraavadh.com/system/storage/modification/system/engine/loader.php(248): ModelInstallInstall->database(Array) #3 /home/excelle2/public_html/zehraavadh.com/system/engine/proxy.php(47): Loader->{closure}(Array, Array) #4 /home/excelle2/public_html/zehraavadh.com/install/controller/install/step_3.php(11): Proxy->__call('database', Array) #5 /home/excelle2/public_html/zehraavadh.com/system/storage/modification/system/engine/action.php(79): ControllerInstallStep3->index() #6 /home/excelle2/public_html/zehraavadh.com/system/engine/router.php(67): Action->execute(Object(Registry)) #7 /home/excelle2/public_html/zehraavadh.com/system/engine/router.php(56): Router->execute(Object(Action)) #8 /home/excelle2/public_html/zehraavadh.com/system/framework.php(165): Router->dispatch(Object(Action), Object(Action)) #9 /home/excelle2/public_html/zehraavadh.com/system/startup.php(104): require_once('/home/excelle2/...') #10 /home/excelle2/public_html/zehraavadh.com/install/index.php(40): start('install') #11 {main} thrown in /home/excelle2/public_html/zehraavadh.com/system/library/db/mysqli.php on line 40

Remove MYSQL40

got this

It seems like the issue is arising due to an outdated SQL mode setting ('MYSQL40') being used during the installation process. Modern MySQL versions do not support this mode, which is causing the error.

I would recommend following xxvirusxx's advice to remove the 'MYSQL40' setting from your configuration. Additionally, you might consider updating your MySQL to a more recent version to avoid such compatibility issues in the future.

To further assist you, could you please share the OpenCart and MySQL versions you are currently using? Knowing this could help the community provide more targeted assistance.