Cataloguing disappears after updatedatabase runs
(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 tried other installs (3.02.005) but I keep having things disappear. See below for the errors. Thanks, Marty 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.
I just love answering my own questions... After some trial and error I made a selective backup of the database; sudo mysqldump -p temp accountlines accountoffsets action_logs auth_header auth_subfield_structure auth_tag_structure auth_types biblio biblio_framework biblioitems borrowers branchcategories branches branchrelations class_sort_rules class_sources currency deletedbiblio deletedbiblioitems deletedborrowers deleteditems import_batches import_biblios import_records issues issuingrules items itemtypes statistics temp_upg_biblioitems_call_num userflags zebraqueue systempreferences z3950servers stopwords sessions reserves reserveconstraints repeatable_holidays printers categories > test5.sql And after setting up Koha again, and importing this backup with; sudo mysql -p koha < test5.sql it seems to work fine so far, even if I still get many errors from the updatedatabase.pl I hope it can help somebody, Marty --- On Mon, 11/15/10, Marty <ontariowolf64@yahoo.com> wrote: From: Marty <ontariowolf64@yahoo.com> Subject: [Koha] Cataloguing disappears after updatedatabase runs To: "koha koha" <koha@lists.katipo.co.nz> Received: Monday, November 15, 2010, 7:52 PM (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 tried other installs (3.02.005) but I keep having things disappear. See below for the errors. Thanks, Marty
participants (1)
-
Marty