News:

AbanteCart v1.4.2 is released.

Main Menu

Database error on currency

Started by llegrand, February 05, 2014, 10:11:58 AM

Previous topic - Next topic

llegrand

This is new to my installation:  previous to 1.1.8 update I only use US  currency on my cart.  In checking this error I see that Canadian, Eur and Pound Sterling are in my list. Only US is ON,  others are off.

this is the error:

2014-02-04 19:29:59 - database error:  AbanteCart core v.1.1.8 Error: MySQL server has gone away<br />Error No: 2006<br />UPDATE currencies
                                      SET value = '0.7397', date_modified = NOW()
                                      WHERE code = 'EUR' in <b>/home/mmonline/public_html/shop/core/database/mysql.php</b> on line <b>114</b>

What do I need to do to correct this error?

thanks


abolabo

i see that error related to mysql-server issue, not to a code.. :-\
also you can to delete currencies that don't needed anymore...
"No one is useless in this world who lightens the burdens of another."
― Charles Dickens

llegrand

Yes,  I saw that also about the database.  I did check prior to the original post and the currency table in the database is there and all appeared well, shows the same info as the grid within Admin.

So do I "assume" that this is just an odd thing and just monitor for recurrance  or run a "repair" on the database or??? Your guidance is appreciated.

Lee











abolabo

regaring query...
You can try to disable setting
QuoteAuto Update Currency:
Set your store to automatically update currencies daily. Yahoo server is used.
in menu system->settings->details first.

about "MySQL server has gone away"...i recommend to ask your hosting provider about it.
"No one is useless in this world who lightens the burdens of another."
― Charles Dickens

Forum Rules Code of conduct
AbanteCart.com 2010 -