upgrade hanging on Current Table: "log_online"

[Scott_T]

Trying to upgrade from 1.1.16 using the large upgrade.

I am hanging on the table backup at Current Table: "log_online"

I chose to check off on doing the table backup during the upgrade just to be safe. I did back up the DB via mysql.

Any help appreciated.

Scott

[Oldiesmann]

What version are you upgrading from? Unless you're upgrading from 1.1 RC3 or earlier, there's no need to use the large upgrade - you can just upgrade via the package manager.

[Scott_T]

Hey Oldiesmann,

I am at 1.1.16 and thought this would bring me to the latest ver 2...

I went into mysql and repaired that table and am rerunning...

Side note, I remember your gallery integration/bridge....It has been a while, but I think that was it....

This board was on YABB if you remember that one over a decade ago...LOL....

Will the large upgrade cause me an issue, I know it will kill my mods, but thought it was like a clean start....

Thanks,
Scott

[Scott_T]

Forcing it through without the table backup......On step 18 of 19....Will post back.

Scott

[Scott_T]

Bombing out again:

Executing: "Changing column names." (1 of 42)

Error!
Out of memory (Needed 10485520 bytes)

ACK!!!!

Granted my DB is fairly large.....

Any assistance appreciated.

Scott

[Oldiesmann]

Bombing out again:

Executing: "Changing column names." (1 of 42)

Error!
Out of memory (Needed 10485520 bytes)

ACK!!!!

Granted my DB is fairly large.....

Any assistance appreciated.

Scott

If you have shell access, it might be better to try running it that way.

Code Select Expand

cd /path/to/your/smf/installation
php -r upgrade.php

Otherwise, you can try adding this to the beginning of upgrade.php.

Code Select Expand

@ini_set('memory_limit', '256M');

The default PHP memory limit is 128MB, and 10485520 bytes is about 10MB, so upping the memory limit to 256MB should give you enough memory to work with.

[Scott_T]

Been a while since I used SSH so I am looking to download a client...

I tried adding the set memory statement and when it immediately bombed I looked into it and found that my host has us limited to 64m, hence an immediate bomb trying to grab 256....

Working on ssh now....

Scott

[Scott_T]

Kicked off the web browser upgrade again and it is going through further this time....Not sure why, but I am a few steps further and it is still running....

Will post back in a bit.

Scott

[Scott_T]

So upgrade ran through...However now it seems I am stuck and cannot get past maintenance message....Cannot get to front page or admin section, just redirects to maintenance message....

Thanks,
Scott

[Scott_T]

Got it...

In Settings.php:

Code Select Expand

[Select]

$maintenance = 2; # Set to 1 to enable Maintenance Mode, 2 to make the forum untouchable. (you'll have to make it 0 again manually!)


make the 2 a 0

[Bigguy]

I will mark this solved then. Glad you got it up and running.

[Scott_T]

Hey bigguy,

So to help others, I'll detail a few of the issues I had, even though I am not entirely sure of the resolution on the memory issue....I know I hate to read threads where someone fixes something and does not post how....

My host is cirtex and the space is shared. It looks like we are restricted to 64m memory. Why I was getting memory errors(out of) yesterday and not today is just odd, maybe traffic, I am not sure.

The locked in maintenance mode is outlined above in the settings.php....

My next step was to try to run the upgrade from shell access via putty. That is a freeware program for those who are not familiar to log into, if allowed, your web server and perform commands from there directly.

One last note, I wanted to do the upgrade because of intermittent errors saying my SMF and DB versions were not in synch. SMF was 1.1.16 and the DB said 1.1.12....

Will see how it all goes.

Thanks for the help

Scott

[Bigguy]

We are very glad you posted more info on the subject. It's always great to have as much as possible.