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" <fridolyn.somers@gmail.com> 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 <alen.vodopijevec@gmail.com>
Hi,
recent update on our testing system produced the following error..
However, it seems tha... _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org 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 fridolyn.somers@gmail.com _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org 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/