Post by Huma » Thu Mar 26, 2020 8:49 pm

Hi all, i`m using OC 3.0.3.2 + Journal theme
the permissions: folders - 775, and files 644

In my erorr log i see these warning, can you help me

Code: Select all


 PHP Warning:  unlink(/home/my_domain/storage/cache/cache.catalog.language.1585215112): No such file or directory in /home/my_domain/public_html/system/library/cache/file.php on line 68

 PHP Warning:  unlink(/home/my_domain/storage/cache/cache.catalog.language.1585215114): No such file or directory in /home/my_domain/public_html/system/library/cache/file.php on line 68

 PHP Warning:  mysqli::query(): MySQL server has gone away in /home/my_domain/public_html/system/library/db/mysqli.php on line 18

 PHP Warning:  mysqli::query(): Error reading result set's header in /home/my_domain/public_html/system/library/db/mysqli.php on line 18

- PHP Warning:  mysqli::__construct(): (HY000/2002): Connection refused in /home/my_domain/public_html/system/library/db/mysqli.php on line 7

PHP Warning:  DB\MySQLi::__construct(): Couldn't fetch mysqli in /home/my_domain/public_html/system/library/db/mysqli.php on line 10

PHP Warning:  mysqli::__construct(): (HY000/2002): Connection refused in /home/my_domain/public_html/system/library/db/mysqli.php on line 7

Newbie

Posts

Joined
Fri Mar 09, 2012 8:05 pm

Post by straightlight » Thu Mar 26, 2020 9:30 pm

MySQL server has gone away
Contact your host to resolved this issue. As for the language cache issue, see this FAQ: viewtopic.php?f=134&t=215776#p750077

The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.


Regards,
Straightlight
Opencart.com Administrator / Quality Assurance Analyst / Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by Huma » Thu Mar 26, 2020 10:47 pm

straightlight wrote:
Thu Mar 26, 2020 9:30 pm
MySQL server has gone away
Contact your host to resolved this issue. As for the language cache issue, see this FAQ: viewtopic.php?f=134&t=215776#p750077
1. What do you mean for DB and hosting company? This is my vps :( but i can`t find info for this anywhere

2. i fix this, thanks

Newbie

Posts

Joined
Fri Mar 09, 2012 8:05 pm

Post by straightlight » Thu Mar 26, 2020 10:50 pm

1. What do you mean for DB and hosting company? This is my vps :( but i can`t find info for this anywhere
When you see: MySQL server has gone away message, you need to contact your host to resolved this issue.

The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.


Regards,
Straightlight
Opencart.com Administrator / Quality Assurance Analyst / Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by foobarac » Mon Jun 01, 2020 9:20 am

Guys, it's not always the Host servers fault in this case.

The DB transaction is inflight so if you have modules/processes that do other things during the process i.e send emails out to confirm an order or confirm the opening of an account, and this hangs - then you are going to get the "PHP Warning: mysqli::query(): MySQL server has gone away" in your error logs.

However the problem could be that your SMTP server is hanging (which was my problem).

New member

Posts

Joined
Fri Sep 21, 2018 9:46 pm

Post by letxobnav » Mon Jun 01, 2020 12:25 pm

an smtp server does not "hang".
attempts to communicate time out after a few seconds but if you set your db connection timeout short, you will lose that connection during ANY slow script.
Ergo, it is still your db connection setting which is wrong.

Crystal Light Centrum Taiwan
Extensions: MailQueue | SUKHR | VBoces

“Data security is paramount at [...], and we are committed to protecting the privacy of anyone who is associated with our [...]. We’ve made a lot of improvements and will continue to make them.”
When you know your life savings are gone.


User avatar
Expert Member

Posts

Joined
Fri Aug 18, 2017 4:35 pm
Location - Taiwan

Post by foobarac » Tue Jun 02, 2020 12:23 pm

letxobnav wrote:
Mon Jun 01, 2020 12:25 pm
an smtp server does not "hang".
When it's working correctly it won't ::)

New member

Posts

Joined
Fri Sep 21, 2018 9:46 pm
Who is online

Users browsing this forum: No registered users and 8 guests