hello all, i'm following the document: http://wiki.koha.org/doku.php?id=22_to_30 and it's failing when executing the script koha-3.00.01-stable/misc/migration_tools/22_to_30/rebuild_unimarc_100.pl Creating/updating field 100 if needed DBD::mysql::st execute failed: Unknown column 'done' in 'where clause' at /usr/local/koha/lib/C4/Biblio.pm line 2299. DBD::mysql::st fetchrow_array failed: fetch() without execute() at /usr/local/koha/lib/C4/Biblio.pm line 2300. Use of uninitialized value in numeric eq (==) at /usr/local/koha/lib/C4/Biblio.pm line 2302. ... the reason is that the zebraqueue table isn't as expected: CREATE TABLE `zebraqueue` ( `id` int(11) NOT NULL auto_increment, `biblio_auth_number` int(11) NOT NULL default '0', `operation` char(20) NOT NULL default '', `server` char(20) NOT NULL default '', `done` int(11) NOT NULL default '0', `time` timestamp NOT NULL default CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `zebraqueue_lookup` (`server`, `biblio_auth_number`, `operation`, `done`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; but my actual table looks like: CREATE TABLE `zebraqueue` ( `id` int(11) NOT NULL AUTO_INCREMENT, `biblio_auth_number` int(11) NOT NULL DEFAULT '0', `operation` char(20) NOT NULL DEFAULT '', `server` char(20) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=9555 DEFAULT CHARSET=utf8; as you can see, done and time are missing, so my guess is that something was wrong during the script execution, update22to30.pl ? The only errors i had are: 090319 9:23:24 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072 DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`BDkoha4_test`.`#sql-455b_55bd`, CONSTRAINT `#sql-455b_55bd_ibfk_3` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE) at /home/henry/koha-3.00.01-stable/installer/data/mysql/update22to30.pl line 3442. ==================== An error occured during : alter table items ADD FOREIGN KEY holdingbranch (holdingbranch) REFERENCES branches (branchcode) on update CASCADE on delete RESTRICT It probably means there is something wrong in your DB : a row (items.holdingbranch) refers to a value in branches.branchcode that does not exist. solve the problem and run updater again (or just the previous SQL statement). You can find those values with select items.* from items where holdingbranch not in (select branchcode from branches) ==================== the last error is easily corrected, but for the first one, i have no idea if it's related to the uncomplete table? and how can i verify if others tables where affected during the update process? thanks in advance for reply, gerard