New location and version

[Blackstone]

SMF Version: SMF 1.0.6
I'm attempting to move my forum to a new location, meaning new domain, but I want to upgrade from 1.0.6 to 1.1 RC2 at the same time.

Is there any way to do this quickly and easily? If not, what would be the long way around it? Thanks!

Blackstone

[Elmacik]

1- How do I move my SMF board to a different host?
2- Upgrading to a newer version

[Blackstone]

Thanks! I will be trying that. =)

[Blackstone]

Okay, I'm in the process of updating my forum, running the 'update.php' file, and I ran into this error:

Upgrading...
Upgrading log system...
done.
    Converting log tables (this might take some time!)... Unsuccessful!
This query:
UPDATE new_log_boards
SET ID_MSG = IF(logTime BETWEEN 1 AND 1127609689, 26, ........ IF(logTime <= 1128001391, 481, IF(logTime <= 1128001416, 482, IF(logTime <= 1128001434, 483, IF(logTime <= 1128016697, 488, IF(logTime <= 1128044789, 499, IF(logTime <= 1128044832, 500, 0)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
WHERE logTime BETWEEN 1 AND 1128044833
AND ID_MSG = 0;
Caused the error:
Thread stack overrun: 118796 bytes used of a 126976 byte stack, and 8192 bytes needed. Use 'mysqld -O thread_stack=#' to specify a bigger stack.

Any help would be appreciated... o.o

[Elmacik]

Try upgrade rather than update.

[Blackstone]

>.< Oops, sorry, that's what I'm using. Not sure why I said update...

[Elmacik]

Why not ignoring that error? If the upgrade goes well in other steps, I would have ignored the error you get.
Because logs are dynamic anyway; when you bring your forum up again, logs will be re-created.
By the way you can try re-pressing the upgrade button.

[Blackstone]

I can't ignore the error... it won't let me go on. All it gives me is a button to try again. Should I try emptying the new_log_boards table and see if that fixes the problem?

[Elmacik]

Thats a good idea
When the upgrade is done, you'd better to do the forum maintenances.

[Blackstone]

It didn't work... o.o I emptied out the table and retried it, but it gives me the same error. I'm not sure what else I can do...

[Elmacik]

If you can still reach to the administration control panel, empty out the unimportant logs and try again.
If it doesnt work some how, then try dropping the log tables and recreating them after the upgrade.
But dont forget, you should use 1.1 RC2 structure when you are re-creating.

[Blackstone]

I tried both of those, and no matter what I do, it won't let me get past that point. It always gives me the same error. I tried upgrading to 1.0.7 and then to 1.1 RC2, and it still gives me the same error. x.x