XF 2.2 Upgrade from 2.1 to 2.2 issues

Stuart Wright

Well-known member
Running from the CLI on our sandbox (xf2.avforums.com):
Running upgrade to 2.2.0 Alpha, step 9... done.
Running upgrade to 2.2.0 Alpha, step 10...
In AbstractStatement.php line 228:

xf_post: MySQL query error [1034]: Incorrect key file for table 'xf_post'; try to repair it


xf:upgrade [--skip-statistics]

Exception query:

ALTER TABLE xf_post
ADD type_data MEDIUMBLOB NOT NULL AFTER position,
ADD vote_score INT NOT NULL,
ADD vote_count INT UNSIGNED NOT NULL DEFAULT '0',
ADD KEY thread_id_score_date (thread_id, vote_score DESC, post_date)
 
Solution
Your post table appears to be corrupt. You can try running REPAIR TABLE xf_post; on it, though you'd want to try why. It's plausible that there might be disk space issues, for example.

This might also imply that your post table is MyISAM which generally isn't correct. If that's the case, you might want to look at why that is (and check that it's not that in production).
Your post table appears to be corrupt. You can try running REPAIR TABLE xf_post; on it, though you'd want to try why. It's plausible that there might be disk space issues, for example.

This might also imply that your post table is MyISAM which generally isn't correct. If that's the case, you might want to look at why that is (and check that it's not that in production).
 
Solution
Ouch, rather you that me! :LOL:


spongebob squarepants good luck GIF
 
The repair didn't work, the table is InnoDB.
Checked disk space and it's 99% full. Good call, Mike.

Ok, so running it again after freeing up some space. 2.2.0 Alpha step 10 has taken 40 minutes so far with 24,706,543 posts.

Any idea how long this step finally took? I'm testing it now on our dev site and it's been running a while...
 
Back
Top Bottom