There is a minor problem, the alter table doesn't add the column because it already exists. The problem is this is reported as an error, it doesn't stop the rest of the upgrades and it needs to be there because for a while the structure.sql file was out of date. All that needs to be done is to alter it to check for column existance first. Patch of course gratefully accepted
Chris On 8 Mar 2011 22:26, "Fridolyn SOMERS" <[email protected]> wrote: Hie, Your right, I think there is a major problem with updatedatabase.pl : Concerning the field 'privacy' of borrowers : revision 3.01.00.072 : ALTER TABLE `borrowers` ADD `privacy` INTEGER NOT NULL DEFAULT 1; revision 3.03.00.006 : ALTER TABLE deletedborrowers ADD `privacy` int(11) AFTER smsalertnumber; revision 3.03.00.016 : ALTER TABLE `borrowers` ADD `privacy` INTEGER NOT NULL DEFAULT 1; ALTER TABLE `deletedborrowers` ADD `privacy` INTEGER NOT NULL DEFAULT 1; When updating to revision 3.03.00.016, the field 'privacy' already exists normally. This function has been set by bug 3881 : http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3881 You may reopen it unless there is something else. Regards, 2011/3/4 alen vodopijevec <[email protected]> > > > > Hi, > > > > recent update on our testing system produced the following error.. > However, it seems tha... > _______________________________________________ > Koha-devel mailing list > [email protected] > http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel > website : http://www.koha-community.org/ > git : http://git.koha-community.org/ > bugs : http://bugs.koha-community.org/ > -- Fridolyn SOMERS ICT engineer PROGILONE - Lyon - France [email protected] _______________________________________________ Koha-devel mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
_______________________________________________ Koha-devel mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
