Hi,
Hope you are doing very well!
Using 3.0.3.3
Haven't done any changes but recently I am having issue where site goes down.
Checking error log see this: (please see below)
I am able to repair it through phpmyadmin, and site works again, however this is a recurring problem.
Any ideas?
thanks!
[01-Mar-2021 23:00:01 UTC] PHP Fatal error: Uncaught Exception: Error: Malformed packet<br />Error No: 2027<br />SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '') in /home/public_html/storage/modification/system/library/db/mysqli.php:40
Stack trace:
#0 /home/ninja/public_html/mydomain.com/system/library/db.php(45): DB\MySQLi->query('SELECT * FROM o...')
#1 /home/ninja/public_html/mydomain.com/catalog/model/design/translation.php(6): DB->query('SELECT * FROM o...')
#2 /home/ninja/public_html/storage/modification/system/engine/loader.php(248): ModelDesignTranslation->getTranslations('engb')
#3 /home/ninja/public_html/mydomain.com/system/engine/proxy.php(47): Loader->{closure}(Array, Array)
#4 /home/ninja/public_html/mydomain.com/catalog/controller/event/translation.php(6): Proxy->__call('getTranslations', Array)
#5 /home/ninja/public_html/storage/modification/system/engine/action.php(79): ControllerEventTranslation->index('engb', '', Array)
#6 /home/ninja/public_html/mydomain.com/sy in /home/public_html/storage/modification/system/library/db/mysqli.php on line 40
Hope you are doing very well!
Using 3.0.3.3
Haven't done any changes but recently I am having issue where site goes down.
Checking error log see this: (please see below)
I am able to repair it through phpmyadmin, and site works again, however this is a recurring problem.
Any ideas?
thanks!
[01-Mar-2021 23:00:01 UTC] PHP Fatal error: Uncaught Exception: Error: Malformed packet<br />Error No: 2027<br />SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '') in /home/public_html/storage/modification/system/library/db/mysqli.php:40
Stack trace:
#0 /home/ninja/public_html/mydomain.com/system/library/db.php(45): DB\MySQLi->query('SELECT * FROM o...')
#1 /home/ninja/public_html/mydomain.com/catalog/model/design/translation.php(6): DB->query('SELECT * FROM o...')
#2 /home/ninja/public_html/storage/modification/system/engine/loader.php(248): ModelDesignTranslation->getTranslations('engb')
#3 /home/ninja/public_html/mydomain.com/system/engine/proxy.php(47): Loader->{closure}(Array, Array)
#4 /home/ninja/public_html/mydomain.com/catalog/controller/event/translation.php(6): Proxy->__call('getTranslations', Array)
#5 /home/ninja/public_html/storage/modification/system/engine/action.php(79): ControllerEventTranslation->index('engb', '', Array)
#6 /home/ninja/public_html/mydomain.com/sy in /home/public_html/storage/modification/system/library/db/mysqli.php on line 40
I've never seen that one before but it sounds like you should contact your web host.
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Seen that once before, I can't remember what the final resolution was but I think it might have been a setting "max_allowed_packet."
Have to speak to host.
Have to speak to host.
-
VIEW ALL EXTENSIONS * EXTENSION SUPPORT * WEBSITE * CUSTOM REQUESTS
Hi!
Good day
Wrote to host.
They responded:
"I have checked the thread you have provided us with and from what I can see they point out that the issue could be caused due to the max_allowed_packet quota. At this point, the same is set to
max_allowed_packet=256M
Considering this is globally configured for the MySQL service on the entire shared server we cannot modify it as such a change will reflect on all our customers located on the same server. Besides, the error message my colleague provided does not seem to state the packets are too large. Hence, I personally believe the same is not related to the limit."
Any ideas?
thanks!!
Good day
Wrote to host.
They responded:
"I have checked the thread you have provided us with and from what I can see they point out that the issue could be caused due to the max_allowed_packet quota. At this point, the same is set to
max_allowed_packet=256M
Considering this is globally configured for the MySQL service on the entire shared server we cannot modify it as such a change will reflect on all our customers located on the same server. Besides, the error message my colleague provided does not seem to state the packets are too large. Hence, I personally believe the same is not related to the limit."
Any ideas?
thanks!!
If you have access to php my admin or mysql client
Run
SHOW CREATE TABLE oc_translation
under options select full text
Run
SHOW CREATE TABLE oc_translation
under options select full text
Hi Mike
thanks for the explanation.
Just a newbie trying to learn a bit.
I ran it:
SHOW CREATE TABLE oc_translation
oc_translation CREATE TABLE `oc_translation` (
`translation_id` int(11) NOT NULL AUTO_INCREMENT,
`store_id` int(11) NOT NULL,
`language_id` int(11) NOT NULL,
`route` varchar(64) NOT NULL,
`key` varchar(64) NOT NULL,
`value` text NOT NULL,
`date_added` datetime NOT NULL,
PRIMARY KEY (`translation_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
thanks for the explanation.
Just a newbie trying to learn a bit.
I ran it:
SHOW CREATE TABLE oc_translation
oc_translation CREATE TABLE `oc_translation` (
`translation_id` int(11) NOT NULL AUTO_INCREMENT,
`store_id` int(11) NOT NULL,
`language_id` int(11) NOT NULL,
`route` varchar(64) NOT NULL,
`key` varchar(64) NOT NULL,
`value` text NOT NULL,
`date_added` datetime NOT NULL,
PRIMARY KEY (`translation_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
OK that's it
when you say you repair the database what are you doing exactly to repair it.
What is your language extension
Your select statement is selecting where langauge id=0 - I don't think that is right for a start, minimum should be 1
unless you do have a language with id 0
What is in your language table
when you say you repair the database what are you doing exactly to repair it.
What is your language extension
Your select statement is selecting where langauge id=0 - I don't think that is right for a start, minimum should be 1
unless you do have a language with id 0
What is in your language table
Hi!
I use repair and optimize on cpanel php myadmin.
These are my language settings:
https://i.imgur.com/WVK41NG.png
I use repair and optimize on cpanel php myadmin.
These are my language settings:
https://i.imgur.com/WVK41NG.png
What ocmod are you using that would need to modify the system/library/db/mysqli.php??
Full Stack Web Developer :: Send a PM for Custom Work.
Backup and learn how to recover before you make any changes!
There is more going on than you are telling us.
A read will not damage a database.
So other errors are occurring as well that you have not listed.
You either have a bad extension/modification
OR
You have made your own and are using OC forum to help you debug it :-)
Your extension is the problem
A read will not damage a database.
So other errors are occurring as well that you have not listed.
You either have a bad extension/modification
OR
You have made your own and are using OC forum to help you debug it :-)
Your extension is the problem
Sorry, not sure what you mean
I am sharing all I can read in the error log. (it is showing several times every day)
Here is is again.
[03-Mar-2021 16:00:01 UTC] PHP Fatal error: Uncaught Exception: Error: Malformed packet<br />Error No: 2027<br />SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '') in /home/public_html/storage/modification/system/library/db/mysqli.php:40
Stack trace:
#0 /home/public_html/mydomain.com/system/library/db.php(45): DB\MySQLi->query('SELECT * FROM o...')
#1 /home/public_html/mydomain.com/catalog/model/design/translation.php(6): DB->query('SELECT * FROM o...')
#2 /home/public_html/storage/modification/system/engine/loader.php(248): ModelDesignTranslation->getTranslations('engb')
#3 /home/public_html/mydomain.com/system/engine/proxy.php(47): Loader->{closure}(Array, Array)
#4 /home/public_html/mydomain.com/catalog/controller/event/translation.php(6): Proxy->__call('getTranslations', Array)
#5 /home/public_html/storage/modification/system/engine/action.php(79): ControllerEventTranslation->index('engb', '', Array)
#6 /home/public_html/mydomain.com/sy in /home/public_html/storage/modification/system/library/db/mysqli.php on line 40
Extensions:
I am only using extensions downloaded from the opencart marketplace. I would even know where to start to make an extension.
Thanks
I am sharing all I can read in the error log. (it is showing several times every day)
Here is is again.
[03-Mar-2021 16:00:01 UTC] PHP Fatal error: Uncaught Exception: Error: Malformed packet<br />Error No: 2027<br />SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '') in /home/public_html/storage/modification/system/library/db/mysqli.php:40
Stack trace:
#0 /home/public_html/mydomain.com/system/library/db.php(45): DB\MySQLi->query('SELECT * FROM o...')
#1 /home/public_html/mydomain.com/catalog/model/design/translation.php(6): DB->query('SELECT * FROM o...')
#2 /home/public_html/storage/modification/system/engine/loader.php(248): ModelDesignTranslation->getTranslations('engb')
#3 /home/public_html/mydomain.com/system/engine/proxy.php(47): Loader->{closure}(Array, Array)
#4 /home/public_html/mydomain.com/catalog/controller/event/translation.php(6): Proxy->__call('getTranslations', Array)
#5 /home/public_html/storage/modification/system/engine/action.php(79): ControllerEventTranslation->index('engb', '', Array)
#6 /home/public_html/mydomain.com/sy in /home/public_html/storage/modification/system/library/db/mysqli.php on line 40
Extensions:
I am only using extensions downloaded from the opencart marketplace. I would even know where to start to make an extension.
Thanks
Link to extension
The database is being effected by something else, ie the extension somehow
The data cannot be read
Did your hosts change php version or anything
Look in phpmyadmin at language table - do you have a language with ID 0
As switch mentioned - why is it needing to modify mysqli - we need to see the extension
The database is being effected by something else, ie the extension somehow
The data cannot be read
Did your hosts change php version or anything
Look in phpmyadmin at language table - do you have a language with ID 0
As switch mentioned - why is it needing to modify mysqli - we need to see the extension
List the extensions please? Link to site? Are you using Journal theme?
Full Stack Web Developer :: Send a PM for Custom Work.
Backup and learn how to recover before you make any changes!
Who is online
Users browsing this forum: paulfeakins and 415 guests