Was: In koha-3.02.00 where is the cataloguing? After installing koha 3.02.00.004 again, this time from scratch on my test box, everything works fine. However, after putting my backup database in, and it runs updatedatabase.pl it fails miserably (and that's also where my cataloguing page disappears, among other things) Backups are made with mysqldump, is there a way to restore my backup in the new version another way? Or any way where updatedatabase won't fail? I have access to absolutely everything, could I maybe make a selective backup and run that (which tables would I need?) It's a mostly standard install on Debian. See below for errors. Thanks, Marty I have a total of 45 DBD::mysql::db do failed errors, 5 Times: Table 'kohatable' already exists at 5 Times: Duplicate column name 17 Times: Duplicate entry 1 Time: Duplicate key name 14 Times: a foreign key constraint fails 2 Times: You have an eror in your SQL syntax (Huh?) 1 Time: Can't create table p { margin-bottom: 0.21cm; } 1 updatedatabase.pl: DBD::mysql::db do failed: Table 'hold_fill_targets' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 1969. 2 updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'item_level_request' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 1988. 3 updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'AllowRenewalLimitOverride' for key 1 at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2035. 4updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'reserves-HOLD' for key 1 at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2049. 5 updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry '4' for key 1 at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2053. 6 updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry '4-sms-0' for key 1 at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2054. 7 updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry '4-email-0' for key 1 at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2055. 8 updatedatabase.pl: DBD::mysql::db do failed: Duplicate key name 'issn' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2062. 9 updatedatabase.pl: DBD::mysql::db do failed: Table 'branch_transfer_limits' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2098. 10 updatedatabase.pl: DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`koha/permissions`, CONSTRAINT `permissions_ibfk_1` FOREIGN KEY (`module_bit`) REFERENCES `userflags` (`bit`) ON DELETE CASCADE ON UPDATE CASCADE) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2117. 11 updatedatabase.pl: DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`koha/permissions`, CONSTRAINT `permissions_ibfk_1` FOREIGN KEY (`module_bit`) REFERENCES `userflags` (`bit`) ON DELETE CASCADE ON UPDATE CASCADE) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2118. 12 updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'AllowHoldPolicyOverride' for key 1 at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2151. 13 updatedatabase.pl: DBD::mysql::db do failed: Table 'branch_item_rules' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2152. 14 updatedatabase.pl: DBD::mysql::db do failed: Table 'default_branch_item_rules' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2163. 15 updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'holdallowed' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2171. 16 updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'holdallowed' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2175. 17 updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'OPACAmazonCoverImages' for key 1 at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2260. 18 updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'AmazonCoverImages' for key 1 at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2262. 19 updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'smsalertnumber' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2298. 20 updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'AmazonReviews' for key 1 at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2377. 21 updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'AllowNotForLoanOverride' for key 1 at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2395. 22 updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'RenewalPeriodBase' for key 1 at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2412. 23 updatedatabase.pl: DBD::mysql::db do failed: Can't create table './koha/#sql-7d6_6f.frm' (errno: 150) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2421. 24 updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'viewISBD' for key 1 at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2455. 25 updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'viewLabeledMARC' for key 1 at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2456. 26 updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'viewMARC' for key 1 at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2457. 27 updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'AWSPrivateKey' for key 1 at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2501. 28 updatedatabase.pl: DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`koha/permissions`, CONSTRAINT `permissions_ibfk_1` FOREIGN KEY (`module_bit`) REFERENCES `userflags` (`bit`) ON DELETE CASCADE ON UPDATE CASCADE) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2680. 29 updatedatabase.pl: DBD::mysql::db do failed: Table 'fieldmapping' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2695. 30 updatedatabase.pl: DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`koha/permissions`, CONSTRAINT `permissions_ibfk_1` FOREIGN KEY (`module_bit`) REFERENCES `userflags` (`bit`) ON DELETE CASCADE ON UPDATE CASCADE) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2744. 31 updatedatabase.pl: DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`koha/permissions`, CONSTRAINT `permissions_ibfk_1` FOREIGN KEY (`module_bit`) REFERENCES `userflags` (`bit`) ON DELETE CASCADE ON UPDATE CASCADE) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2745. 32 updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'finedays' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2752. 33 updatedatabase.pl: DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`koha/permissions`, CONSTRAINT `permissions_ibfk_1` FOREIGN KEY (`module_bit`) REFERENCES `userflags` (`bit`) ON DELETE CASCADE ON UPDATE CASCADE) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3070. 34 updatedatabase.pl: DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`koha/permissions`, CONSTRAINT `permissions_ibfk_1` FOREIGN KEY (`module_bit`) REFERENCES `userflags` (`bit`) ON DELETE CASCADE ON UPDATE CASCADE) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3182. 35 updatedatabase.pl: DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`koha/permissions`, CONSTRAINT `permissions_ibfk_1` FOREIGN KEY (`module_bit`) REFERENCES `userflags` (`bit`) ON DELETE CASCADE ON UPDATE CASCADE) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3298. 36 updatedatabase.pl: DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`koha/permissions`, CONSTRAINT `permissions_ibfk_1` FOREIGN KEY (`module_bit`) REFERENCES `userflags` (`bit`) ON DELETE CASCADE ON UPDATE CASCADE) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3339. 37 updatedatabase.pl: DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`koha/permissions`, CONSTRAINT `permissions_ibfk_1` FOREIGN KEY (`module_bit`) REFERENCES `userflags` (`bit`) ON DELETE CASCADE ON UPDATE CASCADE) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3385. 38 updatedatabase.pl: DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''YesNo')' at line 2 at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3449. 39 updatedatabase.pl: DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''YesNo')' at line 2 at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3453. 40 updatedatabase.pl: DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`koha/permissions`, CONSTRAINT `permissions_ibfk_1` FOREIGN KEY (`module_bit`) REFERENCES `userflags` (`bit`) ON DELETE CASCADE ON UPDATE CASCADE) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3550. 41 updatedatabase.pl: DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`koha/permissions`, CONSTRAINT `permissions_ibfk_1` FOREIGN KEY (`module_bit`) REFERENCES `userflags` (`bit`) ON DELETE CASCADE ON UPDATE CASCADE) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3552. 42 updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'reserves-HOLDPLACED' for key 1 at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3561. 43 updatedatabase.pl: DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`koha/permissions`, CONSTRAINT `permissions_ibfk_1` FOREIGN KEY (`module_bit`) REFERENCES `userflags` (`bit`) ON DELETE CASCADE ON UPDATE CASCADE) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3663. 44 updatedatabase.pl: DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`koha/permissions`, CONSTRAINT `permissions_ibfk_1` FOREIGN KEY (`module_bit`) REFERENCES `userflags` (`bit`) ON DELETE CASCADE ON UPDATE CASCADE) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3672. 45 updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'HomeOrHoldingBranchReturn' for key 1 at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3754.