[Koha] Cataloguing disappears after updatedatabase runs

16 Nov 2010

      (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.