Hello,
I am getting an error message like this on my error log :
2013-01-26 8:02:02 - PHP Notice: Error: MySQL server has gone away<br />Error No: 2006<br />SELECT * FROM language WHERE status = '1' in /home/a2496201/public_html/system/database/mysql.php on line 49
I am using Opencart Version 1.5.4. Please let me know the solution asap.
Thanks
I am getting an error message like this on my error log :
2013-01-26 8:02:02 - PHP Notice: Error: MySQL server has gone away<br />Error No: 2006<br />SELECT * FROM language WHERE status = '1' in /home/a2496201/public_html/system/database/mysql.php on line 49
I am using Opencart Version 1.5.4. Please let me know the solution asap.
Thanks
Sounds like a hosting issue. Mysql is controlled by your host, not by opencart itself. Could have been a temporary issue as hosting companies do restart servers at various times.
Running Opencart v3.0.3.2 with multi-stores and the default template from https://www.labeshops.com which has links to all my stores.
This could also be a timeout issue when the server never gets the result from a MySQL call because the process has stalled. The latter can happen because the automatic currency update when in the admin backend, which calls the external http://download.finance.yahoo.com/d/quotes.csv. Disable the automatic currency update at System > Settings > Local > Auto Update Currency and then try again.zikjohnny wrote:Hello,
I am getting an error message like this on my error log :
2013-01-26 8:02:02 - PHP Notice: Error: MySQL server has gone away<br />Error No: 2006<br />SELECT * FROM language WHERE status = '1' in /home/a2496201/public_html/system/database/mysql.php on line 49
I am using Opencart Version 1.5.4. Please let me know the solution asap.
Thanks
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Hi,
I got the similar problem (just different file). My opencart version is 1.5.4
Notice: Error: MySQL server has gone away
Error No: 2006
UPDATE op_currency SET value = '1.00000', date_modified = '2013-12-11 02:32:51' WHERE code = 'MYR' in /home/mydomain/public_html/system/database/mysql.php on line 49
As I read JNeuhoff said:
I could not log in into the dashboard to disable the auto update currency (it throws the error when I log in)
So what I do is I go to phpMyAdmin, find the database for setting
If your table prefix is oc_ then find oc_setting
find this line from the table config_currency_auto
(It will be a long list, so maybe it will be on third of fourth page, just click the arrow- Mine is on fourth page of the list)
where the key is : config_currency_auto --> change the value from 1 to 0.
Refresh your dashboard and the errors resolved. Hope this helps!
I got the similar problem (just different file). My opencart version is 1.5.4
Notice: Error: MySQL server has gone away
Error No: 2006
UPDATE op_currency SET value = '1.00000', date_modified = '2013-12-11 02:32:51' WHERE code = 'MYR' in /home/mydomain/public_html/system/database/mysql.php on line 49
As I read JNeuhoff said:
SOLUTION I FOUND:This could also be a timeout issue when the server never gets the result from a MySQL call because the process has stalled. The latter can happen because the automatic currency update when in the admin backend, which calls the external http://download.finance.yahoo.com/d/quotes.csv. Disable the automatic currency update at System > Settings > Local > Auto Update Currency and then try again.
I could not log in into the dashboard to disable the auto update currency (it throws the error when I log in)
So what I do is I go to phpMyAdmin, find the database for setting
If your table prefix is oc_ then find oc_setting
find this line from the table config_currency_auto
(It will be a long list, so maybe it will be on third of fourth page, just click the arrow- Mine is on fourth page of the list)
where the key is : config_currency_auto --> change the value from 1 to 0.
Refresh your dashboard and the errors resolved. Hope this helps!
Hello guys,
I'm sorry I'm bumping an old post but you really saved my day after 72hours of fighting with the hosting company because of this error.
Thank you a lot!!!
For others in the same situation -->
The problem as I see it is indeed because of the damn update currency file that JNeuhoff said earlier that it calls the csv from yahoo finance. But why it created an error after 1 year of no problems in my case, is because the hosting company blocked the mysql server for international connections due to a flood problem. So if you get this error talk to your hosting company and see if they have applied any international restrictions for the mysql server, and also go to phpmyadmin and do what zailin said and it will work.
Good luck
I'm sorry I'm bumping an old post but you really saved my day after 72hours of fighting with the hosting company because of this error.
Thank you a lot!!!
For others in the same situation -->
The problem as I see it is indeed because of the damn update currency file that JNeuhoff said earlier that it calls the csv from yahoo finance. But why it created an error after 1 year of no problems in my case, is because the hosting company blocked the mysql server for international connections due to a flood problem. So if you get this error talk to your hosting company and see if they have applied any international restrictions for the mysql server, and also go to phpmyadmin and do what zailin said and it will work.
Good luck
OC rules -> Cheri Bijou
Thanks zailin.
I was not able to login in admin because of this exception. Your suggestion related to setting 'config_currency_auto' to 0 in 'oc_setting' fixed the issue for now.
However, for longer term fix, I will work with my hosting provider.
Thanks a ton.
I was not able to login in admin because of this exception. Your suggestion related to setting 'config_currency_auto' to 0 in 'oc_setting' fixed the issue for now.
However, for longer term fix, I will work with my hosting provider.
Thanks a ton.
Who is online
Users browsing this forum: No registered users and 100 guests