• Registered: 11/24/2010
  • Posts: 4

Topic: update from 2.2.5 to 2.3 rc3 issue

A client was using front accounting 2.2.5 but several bugs were causing problems, so we attempted to update to the latest version "2.3 RC3". This has apparently partially worked, but failed on the database update step. On the "software update" page next to 2.3 it says:

    Upgrade from version 2.2 to 2.3    alter2.3.sql    Partially installed (3/4)

and then underneath the table:   

    Database upgrades marked as partially installed cannot be installed automatically. You have to clean database manually to enable them, or try to perform forced upgrade.

I don't know where to start manually cleaning the database, what elements would cause problems for this updated version?

Any help would be greatly appreciated.

  • Registered: 12/25/2007
  • Posts: 2,447

Re: update from 2.2.5 to 2.3 rc3 issue

This message is displayed when some database scheme changes planned for this release are already found in db. This message can appear when user has done partial update to some early CVS version before upgrade to 2.3RC, but should not appear for clean upgrade from 2.2.x to 2.3RC.
There were a lot of database scheme changes between 2.2 and 2.3 versions, but  4  things are tested on Upgrade Software page and are considered as upgrade milestones. Those are:
. type, id  key  on comments table
. sys_pref table
. sales_order.payment_terms field
. purch_order.tax_included field

If some of those changes exists (but not all) the database is considered as partially upgraded and need manual intervention.

You will find list of all changes mades during software upgrade in:
. alter2.3.sql
. alter2.3rc.slq
. alter2.3.php contains code which cannot be easily performed via simple sql queries.

Hope it helps.
Janusz

  • From: Christchurch, New Zealand
  • Registered: 05/19/2008
  • Posts: 20

Re: update from 2.2.5 to 2.3 rc3 issue

Now we are getting message: "System is blocked after source upgrade until database is updated on System/Software Upgrade page" However in Software Upgrade we get: "2.3    Upgrade from version 2.2 to 2.3    alter2.3.sql    Installed" How do we move forward and remove the block please?

wbaileynzl's Website

  • From: Christchurch, New Zealand
  • Registered: 05/19/2008
  • Posts: 20

Re: update from 2.2.5 to 2.3 rc3 issue

Resolved thank you. manually loaded the sql script line by line through phpmyadmin

wbaileynzl's Website

  • ACHDI
  • New member
  • Offline
  • Registered: 03/31/2011
  • Posts: 1

Re: update from 2.2.5 to 2.3 rc3 issue

NIce to know you all.. My name : Achdi.. , Thank you for accepting me in this forum..

wbaileynzl : Thanks for the information , but how to manually loaded the sql script line by line to remove the Note notification