Database update error on upgrade from 3.2.6 to 3.2.7 using debian package
Hi When I upgraded our Koha install from 3.2.6 to 3.2.7. I had the following error messages are they important? DBD::mysql::db do failed: Can't DROP 'itemsstocknumberidx'; check that column/key exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 4020. DBD::mysql::db do failed: Duplicate key name 'itemstocknumberidx' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 4021. yours John
John Seymour schreef op wo 27-04-2011 om 09:14 [+1000]:
When I upgraded our Koha install from 3.2.6 to 3.2.7. I had the following error messages are they important?
They do look a bit contradictory, "it doesn't exist!", "hey, it's a duplicate!", but it shouldn't cause any problems. If you're so inclined you might want to check the database against the statements in updatedatabase.pl:4020 to ensure the index is correct.
DBD::mysql::db do failed: Can't DROP 'itemsstocknumberidx'; check that column/key exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 4020. DBD::mysql::db do failed: Duplicate key name 'itemstocknumberidx' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 4021. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5957 6D23 8B16 EFAB FEF8 7175 14D3 6485 A99C EB6D
participants (2)
-
John Seymour -
Robin Sheat