[Koha] Database update error on upgrade from 3.2.6 to 3.2.7 using debian package

Robin Sheat robin at catalyst.net.nz
Wed Apr 27 11:26:20 NZST 2011


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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part
Url : http://lists.katipo.co.nz/pipermail/koha/attachments/20110427/77f4093d/attachment.pgp 


More information about the Koha mailing list