UBB.Developers Forums UBB.threads 7 Development How Do I? major upgrade...

Ok, I'm running ubb.threads 6.02 and it's time to upgrade. (You think so?? )

In 6.02, I've taken out views and ratings and translated it to finnish, everything else is default.

When I'm upgrading it (with some help of course...) should I just install new version, do modifications and then move database (all the users). Is this possible?

I have pretty active board so I would like to keep the upgradde hasslefree.

One more thing. What happens to translated files. Can I use them or do I have to edit it again with browser-feature?

Thanks again!

luuker

It's definatately a good idea to setup a test board - do all your modificatiosn and make sure it works - then move it over to your real board and alter your database.

The language files have been updated quite a bit since 6.02. So you'll want to start fresh - or compare them to add all the new langague strings. The whole admin section has been added to language files too.

Threads does offer the ability to add/create languages on the fly from the admin menu - as well as choose the charset etc... so maybe it'll be easier. But I think the files have changed enough that you'll need to start fresh.

[]JoshPet said:
It's definatately a good idea to setup a test board - do all your modificatiosn and make sure it works - then move it over to your real board and alter your database.
[/]

All right. How this works?

Just move all new files to replace old files?

It can't be that simple...

If you have properly set up a test board and added what modifications you want and it works then you simply copy those files over to the public board ( minus config.inc,main.inc and theme.inc.php) and run the altertables in order from your old board to new

And don't overwrite your custom headers or things like that.

Ok, we tried it, but it agve us a lot of errors.

My test forum's table prefix is different than my public forum's. Can that be problem? What is table prefix?

I read Infopop's instructions about upgrading, but it's still unclear to me.

With major upgrade like this, can I transfer all the files (exept config.inc,main.inc and theme.inc.php) at once and then run all altertables (6.0 -> 6.1, 6.1 -> 6.2, 6.2 -> 6.3) Can the altertable be run without browser? I think it timed us out first time.

When we tried it, it gave us error about fetch array.
All help is much apprechiated!

Your table prefix is this w3t_ If yours is different make sure your production and test are the same.

Oh no!

It's not the same. Can I change it somehow?

Thats your problem then. What is the prefix set for in the config section? This is all that should matter. You can set this for the exact prefix you are using making sure they match and it should work.

Which board has a non-w3t_ prefix, the test board or the production board?

One thing to watch out for: there may still be some places in the scripts that incorrectly have "w3t_" hardcoded, instead of using the configuration variable $config['tbprefix']. If you're using a prefix other than "w3t_", it would be a good idea to search all the script files for "w3t"; use the Linux grep command, the Windows search function, or an equivalent utility to do this.

Good point Any hacks that have a hard coded w3t_ are going to cause this problem. Threads itself should be coded correctly to allow the proper prefix.

I remember this issue well when I installed a hack that was hard coded to a main table without a prefix and if you installed one things failed. Was an easy fix but those are the things Dave is talking about.

Is always best to start from scratch on a test board and install a WORKING TEST BOARD WITH NO HACKS AND YOUR DATABASE PORTED THEN HACK.

It should, but that's not necessary a safe assumption. Searching for "w3t" turned out to be difficult, because it's used all over the place in cookie names. But I found these:

[6.3.2]

File ubbthreads\altertable-6.0-6.1.php:
UPDATE w3t_Users

File ubbthreads\altertable-6.1-6.2.php:
DROP INDEX w3t_Postsindex4

Actually, I think the custom table prefix was added in 6.2, so maybe those are ok.

-----
Edit: Rick confirmed that those are ok.

You guys rock!

Test board has different table prefix.

Public board has w3t_.

If I change all test board's tables to w3t_ will it do the job?

So here is what we gonna do:

1. Change all test board table prefix's to w3t_.
(can this be done?)

2. Transfer all test board's files (exept config.inc,main.inc and theme.inc.php) at once

3. Run all altertables (6.0 -> 6.1, 6.1 -> 6.2, 6.2 -> 6.3)
and between altertables we should update config.inc with browser.

That will do it?

Sorry about all these questions..