Form Storage Failed Upgrade on 4.1.5

Bug #1103587 reported by Carl Leitner
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
I2CE
Fix Committed
Undecided
Unassigned

Bug Description

Could not add version column to form_history table:
MDB2 Error: already exists
_doQuery: [Error message: Could not execute statement]
[Last executed query: ALTER TABLE `form_history` ADD `version` TINYINT UNSIGNED NOT NULL DEFAULT '0']
[Native code: 1060]
[Native message: Duplicate column name 'version']

Revision history for this message
Carl Leitner (litlfred) wrote :

If verified, this is a critical bug as it will prevent updating of iHRIS to 4.1.5

Carl Leitner (litlfred)
Changed in i2ce:
status: New → Fix Committed
Revision history for this message
Carl Leitner (litlfred) wrote :

fixed in 4.1-dev with revision 3126:
  http://bazaar.launchpad.net/~intrahealth+informatics/i2ce/4.1-dev/revision/3126
will be a part of the 4.1.6 release.

If you are running into this issue, you can download and replace the following two files:

The file /var/lib/iHRIS/lib/4.1.5/I2CE/modules/Forms/modules/FormStorage/FormStorage.xml
http://bazaar.launchpad.net/~intrahealth+informatics/i2ce/4.1-dev/view/3126/modules/Forms/modules/FormStorage/FormStorage.xml

The file /var/lib/iHRIS/lib/4.1.5/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage.php
http://bazaar.launchpad.net/~intrahealth+informatics/i2ce/4.1-dev/view/3126/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage.php

Revision history for this message
Sovello Hildebrand (sovellohpmgani) wrote :

I tried to install 4.1.4 and then updated/upgraded that to 4.1.5 and the process produced no errors.
It should ideally be ok. Maybe the problem was because the 4.1.4 instance had data in it!

Revision history for this message
Carl Leitner (litlfred) wrote :

If this was on a dump of Botswana data, than you should be able to ignore this.
Cheers.
-carl

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.