SMF Support > Install and Upgrade Help

Converting "instant_messages"... (part 1) Unsuccessful!

(1/1)

sircharlz:
Hello all,

I used the upgrade guide to upgrade my install of Yabbse.

I made a fresh folder on my server for smf, copied over the settings.php (and bak) and templete.php. I then ran upgrade.php and it went fine till I encountered this:


--- Code: ---Upgrading...
Converting members and personal messages...
   Converting "members"... (part 1)done.
   Converting "members"... (part 2)
   Members #1 - #60... done.
   Converting "members"... (part 3)done.
   Converting "members"... (part 3)done.
   Converting "members"... (part 3)done.
   Converting member statistics... done.
   Converting "instant_messages"... (part 1) Unsuccessful!
This query:
ALTER TABLE yabbse_instant_messages
CHANGE COLUMN ID_MEMBER_FROM ID_MEMBER_FROM mediumint(8) unsigned NOT NULL default 0,
CHANGE COLUMN msgtime msgtime int(10) unsigned NOT NULL default '0',
CHANGE COLUMN subject subject tinytext NOT NULL;
Caused the error:

Got error 127 from table handler
--- End code ---

Can you help?

Thanks.

sircharlz:
OK I got desperate and just flushed all the IM's from mysql and it worked.

[Unknown]:
D:\Program Files\MySQL\bin>perror 127
Error code 127:  Unknown error
127 = Record-file is crashed

I don't think there was anything else to be done, if that happened.... except a REPAIR.  But, at least you got it working.

-[Unknown]

Navigation

[0] Message Index