[Koha-devel] Duplicate column // 3.03

[Fridolyn SOMERS]

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 at 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 at 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 at gmail.com
-------------- section suivante --------------
Une pi?ce jointe HTML a ?t? nettoy?e...
URL: </pipermail/koha-devel/attachments/20110308/d0078b3e/attachment.htm>