4.0.5 to 4.1.1, total failure

[krustyx]

I can't believe how complicated it is to upgrade my forums... first time its like this... having 4 days of downtime to do this...

[krustyx]

So you think the problem will be solved with the console?

You think its a timeout problem?

The command is still the same and will stay jammed at the same place, i don't see why it wouldnt

[krustyx]

What this command is used for anyway? Is there any way to skip this / bypass / whatever

* Step #15
*
*/
function step_15()
{
$this->run_query(
sprintf($this->phrase['vbphrase']['update_table'], 'searchcore_text'),
"DELETE " . TABLE_PREFIX . "searchcore_text
FROM " . TABLE_PREFIX . "searchcore_text
LEFT JOIN " . TABLE_PREFIX . "searchcore ON (" . TABLE_PREFIX . "searchcore.searchcoreid = " . TABLE_PREFIX . "searchcore_text.searchcoreid)
WHERE " . TABLE_PREFIX . "searchcore.searchcoreid IS NULL"
);

It just doesnt work with my database, the process is running for 20+ hours... i need to bypass this step, help me

[Steve Machol]

I believe this is most likely caused by a timeout issue and the command line option would be the best option to try at this point. That is why I suggested it.

I do not know how to manually bypass that step.

[krustyx]

Well, even if the webpage timeout, the process will still continue to run and finish properly it that would be the case, so step 15 would be OK, but it stays there.

[Steve Machol]

I didn't say the web page timed out. I'm talking about the server timing out on that step. If that times out, this stops processing.

At this point the next step is to try the command line option.

[krustyx]

Well, that will be next week because the websites are down for 48 hours already... will keep you posted

Is there any way to see where the process is working in the database, if its stuck or if its still processing lines?

[Paul M]

I believe you can bypass the step[s] by updating the database to say that step has run.

Alternatively, you might also find it quicker to just empty your search tables, and then rebuild them after the upgrade.

However, as a first choice, i'd go with using the command line upgrade option.

To view what mysql is doing, run "show processlist;" as a mysql command.

[krustyx]

that table will be empty if i empty the search index?