Post by megalca » Tue Mar 02, 2021 7:24 am

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

New member

Posts

Joined
Sun Apr 07, 2019 5:49 am

Post by paulfeakins » Tue Mar 02, 2021 7:45 pm

megalca wrote:
Tue Mar 02, 2021 7:24 am
Error: Malformed packet
I've never seen that one before but it sounds like you should contact your web host.

For quick, professional OpenCart support please email info@antropy.co.uk


User avatar
Guru Member
Online

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - Reigate, Surrey, United Kingdom

Post by grgr » Tue Mar 02, 2021 9:56 pm

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.

-
Image Image Image Image
VIEW ALL EXTENSIONS * EXTENSION SUPPORT * WEBSITE * CUSTOM REQUESTS


User avatar
Active Member

Posts

Joined
Mon Mar 28, 2011 4:08 pm
Location - UK

Post by megalca » Wed Mar 03, 2021 12:13 am

Thanks a lot for the reply and useful input!!

New member

Posts

Joined
Sun Apr 07, 2019 5:49 am

Post by megalca » Wed Mar 03, 2021 3:14 am

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!!

New member

Posts

Joined
Sun Apr 07, 2019 5:49 am

Post by mikeinterserv » Wed Mar 03, 2021 3:30 am

what is your php version
and what is your mysql version

Active Member

Posts

Joined
Thu May 28, 2020 6:55 am
Location - Wales

Post by megalca » Wed Mar 03, 2021 4:11 am

Hi
PHP Version 7.3.21
MySQL Version 5.7.33-cll-lve

New member

Posts

Joined
Sun Apr 07, 2019 5:49 am

Post by mikeinterserv » Wed Mar 03, 2021 4:15 am

If you have access to php my admin or mysql client
Run
SHOW CREATE TABLE oc_translation
under options select full text

Active Member

Posts

Joined
Thu May 28, 2020 6:55 am
Location - Wales

Post by megalca » Wed Mar 03, 2021 4:58 am

Thanks for your reply.
Not expert on mysql but think that is for creating a table named: oc_translation.?
I checked database and that table already exists.
thanks

New member

Posts

Joined
Sun Apr 07, 2019 5:49 am

Post by mikeinterserv » Wed Mar 03, 2021 5:24 am

No it actually shows you the table info
No worries - I'm sure you'll find the answer

Active Member

Posts

Joined
Thu May 28, 2020 6:55 am
Location - Wales

Post by megalca » Wed Mar 03, 2021 7:52 am

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

New member

Posts

Joined
Sun Apr 07, 2019 5:49 am

Post by mikeinterserv » Wed Mar 03, 2021 8:18 am

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

Active Member

Posts

Joined
Thu May 28, 2020 6:55 am
Location - Wales

Post by megalca » Wed Mar 03, 2021 10:23 am

Hi!
I use repair and optimize on cpanel php myadmin.
These are my language settings:
https://i.imgur.com/WVK41NG.png

New member

Posts

Joined
Sun Apr 07, 2019 5:49 am

Post by sw!tch » Wed Mar 03, 2021 2:01 pm

megalca wrote:
Tue Mar 02, 2021 7:24 am
#6 /home/ninja/public_html/mydomain.com/sy in /home/public_html/storage/modification/system/library/db/mysqli.php on line 40
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!


Active Member

Posts

Joined
Sat Apr 28, 2012 2:32 pm
Location - USA

Post by mikeinterserv » Wed Mar 03, 2021 9:24 pm

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

Active Member

Posts

Joined
Thu May 28, 2020 6:55 am
Location - Wales

Post by megalca » Thu Mar 04, 2021 12:57 am

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

New member

Posts

Joined
Sun Apr 07, 2019 5:49 am

Post by mikeinterserv » Thu Mar 04, 2021 1:24 am

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

Active Member

Posts

Joined
Thu May 28, 2020 6:55 am
Location - Wales

Post by sw!tch » Thu Mar 04, 2021 2:25 am

megalca wrote:
Thu Mar 04, 2021 12:57 am
Extensions:
I am only using extensions downloaded from the opencart marketplace. I would even know where to start to make an extension.
Thanks
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!


Active Member

Posts

Joined
Sat Apr 28, 2012 2:32 pm
Location - USA

Post by megalca » Thu Mar 04, 2021 3:35 am

Hi
Thanks a lot in advance for your help!
oc_language table:
https://i.imgur.com/v8WFBMa.png

New member

Posts

Joined
Sun Apr 07, 2019 5:49 am

Post by megalca » Thu Mar 04, 2021 3:39 am

Using basel theme (from themeforest)
Here are the extensions
https://i.imgur.com/XQ3h4s1.png

New member

Posts

Joined
Sun Apr 07, 2019 5:49 am
Who is online

Users browsing this forum: Google [Bot] and 34 guests