UBB.threads PHP Forum Software Community Forums UBB.threads 6 Version 6 Support 6.4.4 -> 6.5: Step 37

How to fix and proceed ? <img src="https://www.ubbcentral.com/boards/images/graemlins/confused.gif" alt="" />

[]
Updating step to 37 .... OK
Dropping ununsed indexes... FAILED
SQL Query: ALTER TABLE w3t_Posts DROP INDEX w3t_Postsindex2
Reason for failure: Got error 122 from table handler
Upgrade Step: http://www.inpiega.com/Forum/install/upgrade.php?step=altertable
[/]

Probably it's my server problem, more or less at any operation W3t_Posts is marked as "in use" and unusable...

Try running a "repair table w3t_Posts" command from a phpMyAdmin installation. You could also ask your host to do this for you.

Hi Charles, repair has been performed but I'm still getting the same error.

May I have the SQL command executed in step 37 so I can ask my server admin to run it for me ?

In altertable-6.5.php it's

function alterstep37() {
global $config;
$query = "
ALTER TABLE {$config['tbprefix']}Posts
DROP INDEX {$config['tbprefix']}Postsindex2
";
do_query($query,"Dropping ununsed indexes...");

}

Thanks JC, so in MySQL I only need t perform a:
ALTER TABLE w3t_Posts DROP INDEX w3t_Postsindex2
?

ALTER TABLE w3t_Posts
DROP INDEX w3t_Postsindex2

Unless you do not use w3t_ . MAKE BACKUPS FIRST <img src="https://www.ubbcentral.com/boards/images/graemlins/smile.gif" alt="" />

Wait.

If your table is marked as crashed, then trying to run the alter will do nothing.

In this case, you must speak to your web hosting provider before you can continue the upgrade process. They will need to examine the error with the table and repair it for you.

Once your table has been repaired, you can try the upgrade process again. It will automatically pick up the altertable where it left off.