[Koha-devel] koha 3.0 - inexistant table 'borrower_attributes' during update

[Frère Sébastien Marie]

I have a problem when I update koha, during last stage (database update in webinstaller).

KOHA Version: 3.0 (git track origin/3.0.x)
  update 0f6359539cd3a16d28537b18d3c23447b0cd17fb to b2a4853fc53c471664a54630b783c9cc7ac4f93f

Database version:
  update 3.00.01.007 to 3.00.02.012

--- webinstaller log ---
[Mon Jun 29 16:11:59 2009] updatedatabase.pl: inside 3.00 at koha/installer/data/mysql/updatedatabase.pl line 1963.
[Mon Jun 29 16:11:59 2009] updatedatabase.pl: DBD::mysql::db do failed: Table 'koha.borrower_attributes' doesn't exist at koha/installer/data/mysql/updatedatabase30.pl line 248.
[Mon Jun 29 16:11:59 2009] updatedatabase.pl: DBD::mysql::db do failed: Table 'koha.borrower_attributes' doesn't exist at koha/installer/data/mysql/updatedatabase30.pl line 249.
--- end ---

--- part of "koha/installer/data/mysql/updatedatabase30.pl" ---
+$DBversion = "3.00.02.005";
+#$DBversion = '3.01.00.010';
+if ( C4::Context->preference('Version') < TransformToNum($DBversion) ) {
+    $dbh->do("ALTER TABLE `borrower_attributes` MODIFY COLUMN `attribute` VARCHAR(64) DEFAULT NULL");
+    $dbh->do("ALTER TABLE `borrower_attributes` MODIFY COLUMN `password` VARCHAR(64) DEFAULT NULL");
+    print "Upgrade to $DBversion done (bug 2687: increase length of borrower attribute fields)\n";
+    SetVersion ($DBversion);
+}
--- end ---

--- patch GIT ---
commit c1901a84aeaee55a8590d64f8ee1fcac328cf264
Author: Henri-Damien LAURENT <henridamien.laurent at biblibre.com>
Date:   Wed May 6 15:42:19 2009 +0200

    UpdateDatabases for 3.0.2
    
    updating elements in order to make 3.0.2 work
    
    Signed-off-by: Henri-Damien LAURENT <henridamien.laurent at biblibre.com>
--- end ---


Shortly, updatedatabase30.pl tried to update 'borrower_attributes' table, but this table doesn't exist in my version... (koha 3.0)

This modification (the part that failed) is for bug 2687 (increase the length of the password field to VARCHAR(64)).

I think is a bug correction for koha 3.1, but not for 3.0 (I hope for my database... else where is my 'borrower_attributes' table ?)

Should I ignore this error, with no problem for data integrity (in futures updates) ?

Thank.
-- 
Frère Sébastien Marie
Abbaye Notre Dame de La Trappe
61380 Soligny-la-Trappe

http://www.latrappe.fr/