List Info

Thread: ( Possible ) Error in upgrade script 2_2_5-2_3_0.mysql




( Possible ) Error in upgrade script 2_2_5-2_3_0.mysql
country flaguser name
Australia
2008-02-28 17:29:15
Greetings. I just updated my home server from dbmail 2.2.7
to 2.3.2. The
mysql upgrade script 2_2_5-2_3_0.mysql failed with:

ERROR 1091 (42000) at line 33: Can't DROP
'dbmail_sievescripts_1'; check
that column/key exists

This line says:
DROP INDEX dbmail_sievescripts_1 ON dbmail_sievescripts;

I'm not sure why my DB didn't have this index. AFAIK I have
run all the
previous upgrade scripts when upgrading.

Anyway, no problems - I manually run the rest of this
script, and the
2_3_0-2_3_2.mysql script ran without any errors.

--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2
9922 7989
email: dkasaknusconsulting.com.au
website:
http://www.nusconsult
ing.com.au




_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

[1]

about | contact  Other archives ( Real Estate discussion Medical topics )