1 Topic by zedd (edited by zedd 06/29/2009 12:26:05 am)

  • zedd
  • Member
  • Offline
  • From: Philippines, Davao
  • Registered: 03/23/2009
  • Posts: 33

Topic: error upgrading to 2.1.3

i got his error during the upgrade. i have no demo account demo.0

when i log in again, the version stays with 2.1.2

DATABASE ERROR : could not get user for admin
error code : 1146
error message : Table 'demo.0_users' doesn't exist
sql that failed was : SELECT * FROM 0_users WHERE user_id = 'admin'

  • zedd
  • Member
  • Offline
  • From: Philippines, Davao
  • Registered: 03/23/2009
  • Posts: 33

Re: error upgrading to 2.1.3

during the force upgrade, i go this error:


Seems that system upgrade to version 2.1 has been performed for this company already.
If something has gone wrong and you want to retry upgrade process you MUST perform database restore from last backup file first.

Database upgrade to version 2.1 failed for company 'Sterling'.
You should restore company database from latest backup file

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: error upgrading to 2.1.3

You should NOT do a software upgrade, when upgrading from 2.1.2 to 2.1.3. Only back your config_db.php file and other data files you have changed.
Please always follow the instructions in update.html when upgrading.
The only thing you should do, as pointed out in update.html, is to change the account classes class type in bank and general ledger tab.

/Joe

  • zedd
  • Member
  • Offline
  • From: Philippines, Davao
  • Registered: 03/23/2009
  • Posts: 33

Re: error upgrading to 2.1.3

Joe,

the version at the lower screen is still
FrontAccounting 2.1.2 - Theme: cool

it won't change to 2.1.3 ?

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: error upgrading to 2.1.3

The version stamp is in config.php. You have probably not updated this file. You can write the version in the file $variable, $version='2.1.3';

/Joe