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/