[Koha] Koha 3.02.00 many updatedatabase errors

Wed Nov 10 04:20:09 NZDT 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 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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20101109/8ff7bc60/attachment-0001.htm 