AbanteCart Community

Shopping Cart Operations => Support => General Support => Topic started by: llegrand on February 05, 2014, 10:11:58 AM

Title: Database error on currency
Post by: llegrand on February 05, 2014, 10:11:58 AM
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

Title: Re: Database error on currency
Post by: abolabo on February 05, 2014, 10:21:38 AM
i see that error related to mysql-server issue, not to a code.. :-\
also you can to delete currencies that don't needed anymore...
Title: Re: Database error on currency
Post by: llegrand on February 05, 2014, 11:01:25 AM
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










Title: Re: Database error on currency
Post by: abolabo on February 05, 2014, 11:19:32 AM
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.