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.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

_______________________________________________
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