support

Author Topic: Database error on currency  (Read 8750 times)

Offline llegrand

  • Hero Member
  • *****
  • Posts: 1813
  • Karma: +529/-7
    • View Profile
Database error on currency
« 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


Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 2171
  • Karma: +345/-13
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: Database error on currency
« Reply #1 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...
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline llegrand

  • Hero Member
  • *****
  • Posts: 1813
  • Karma: +529/-7
    • View Profile
Re: Database error on currency
« Reply #2 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

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 2171
  • Karma: +345/-13
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: Database error on currency
« Reply #3 on: February 05, 2014, 11:19:32 AM »
regaring query...
You can try to disable setting
Quote
Auto 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

 

Powered by SMFPacks Social Login Mod