I have an opencart 3 shop with Journal theme 3 , it has almost an year.
From time to time we have an issue inside admin, receiving an internal 500 error when changing order status AND checking Notify the client option.
If we don't check that option everything works fine, the order status is changing fast, when we click that it freezes and stay so for 1 minute or so and at the end we get Internal Server error 500. We are using Colored Order Status in Back Office to process orders.
These are the errors received in main error_log
Code: Select all
#0 /home/annd/storage/modification/system/library/db.php(58): DB\MySQLi->query('SELECT * FROM o...')
#1 /home/annd/public_html/catalog/model/design/theme.php(4): DB->query('SELECT * FROM o...')
#2 /home/annd/storage/modification/system/engine/loader.php(259): ModelDesignTheme->getTheme('mail/order_add', 'journal3')
#3 /home/annd/public_html/system/engine/proxy.php(47): Loader->{closure}(Array, Array)
#4 /home/annd/storage/modification/catalog/controller/event/theme.php(48): Proxy->__call('getTheme', Array)
#5 /home/annd/storage/modification/system/engine/action.php(79): ControllerEventTheme->override('mail/order_add', Array, '')
#6 /home/annd/storage/modification/system/engine/event.php(67): Action->execute(Object(Registry), Array)
#7 /home/annd/storage/modification/s in /home/annd/public_html/system/library/db/mysqli.php on line 40
[28-Mar-2020 15:32:06 UTC] PHP Fatal error: Uncaught Exception: Error: MySQL server has gone away<br />Error No: 2006<br />SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'journal3' AND route = 'mail/order_add' in /home/annd/public_html/system/library/db/mysqli.php:40
Stack trace:
#0 /home/annd/storage/modification/system/library/db.php(58): DB\MySQLi->query('SELECT * FROM o...')
#1 /home/annd/public_html/catalog/model/design/theme.php(4): DB->query('SELECT * FROM o...')
#2 /home/annd/storage/modification/system/engine/loader.php(259): ModelDesignTheme->getTheme('mail/order_add', 'journal3')
#3 /home/annd/public_html/system/engine/proxy.php(47): Loader->{closure}(Array, Array)
#4 /home/annd/storage/modification/catalog/controller/event/theme.php(48): Proxy->__call('getTheme', Array)
#5 /home/annd/storage/modification/system/engine/action.php(79): ControllerEventTheme->override('mail/order_add', Array, '')
#6 /home/annd/storage/modification/system/engine/event.php(67): Action->execute(Object(Registry), Array)
#7 /home/annd/storage/modification/s in /home/annd/public_html/system/library/db/mysqli.php on line 40
[28-Mar-2020 15:36:02 UTC] PHP Fatal error: Uncaught Exception: Error: MySQL server has gone away<br />Error No: 2006<br />SELECT * FROM oc_seo_url WHERE `query` = 'account/login' AND store_id = '0' AND language_id = '2' in /home/annd/public_html/system/library/db/mysqli.php:40
Stack trace:
#0 /home/annd/storage/modification/system/library/db.php(58): DB\MySQLi->query('SELECT * FROM o...')
#1 /home/annd/storage/modification/catalog/controller/startup/seo_url.php(140): DB->query('SELECT * FROM o...')
#2 /home/annd/public_html/system/library/url.php(64): ControllerStartupSeoUrl->rewrite('https://www.ann...')
#3 /home/annd/public_html/catalog/controller/account/forgotten.php(21): Url->link('account/login', '', true)
#4 /home/annd/storage/modification/system/engine/action.php(79): ControllerAccountForgotten->index()
#5 /home/annd/public_html/catalog/controller/startup/router.php(25): Action->execute(Object(Registry))
#6 /home/annd/storage/modification/system/engine/action.php(79): ControllerStartupRouter->index()
#7 /home/annd/storage/modification/system/e in /home/annd/public_html/system/library/db/mysqli.php on line 40
I contacted hosting and they say everything is fine and we have something not working well. Again, the errors occurs from time to time, it works well for a month or so and suddenly it doesn't work anymore.
Can anyone help me with and advice?
Thank you!
