[Koha-devel] Duplicate column // 3.03

[Chris Cormack]

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 at 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 at gmail.com>

> >
> > Hi,
> >
> > recent update on our testing system produced the following error..
> However, it seems tha...
> _______________________________________________
> 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

_______________________________________________
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/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: </pipermail/koha-devel/attachments/20110311/bd3886f8/attachment.htm>