Hi, recent update on our testing system produced the following error.. However, it seems that everything is working fine. Update report : * Upgrade to 3.03.00.014 done (Add flexible shelf browser constraints) * Upgrade to 3.03.00.015 done (Bug 5619: Add subfield 9 to marc21 648,654,655,656,657,658,662) * Upgrade to 3.03.00.016 done (OpacPrivacy reimplementation) * Upgrade to 3.03.00.017 done (Enable currency rates >= 100) * Upgrade to 3.03.00.018 done (Correct language descriptions) * Upgrade to 3.03.00.019 done (Correct language descriptions for Norwegian) Update errors : * [Thu Mar 3 23:33:20 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'privacy' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3984. * [Thu Mar 3 23:33:20 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'privacy' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3985. Regards, alen
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 that everything is working fine.
Update report :
- Upgrade to 3.03.00.014 done (Add flexible shelf browser constraints) - Upgrade to 3.03.00.015 done (Bug 5619: Add subfield 9 to marc21 648,654,655,656,657,658,662) - Upgrade to 3.03.00.016 done (OpacPrivacy reimplementation) - Upgrade to 3.03.00.017 done (Enable currency rates >= 100) - Upgrade to 3.03.00.018 done (Correct language descriptions) - Upgrade to 3.03.00.019 done (Correct language descriptions for Norwegian)
Update errors :
- [Thu Mar 3 23:33:20 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'privacy' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline 3984. - [Thu Mar 3 23:33:20 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'privacy' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline 3985.
Regards, alen
_______________________________________________ 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
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/
participants (3)
-
alen vodopijevec -
Chris Cormack -
Fridolyn SOMERS