Previous Thread
Next Thread
Print Thread
Rate Thread
#254700 07/28/2003 2:45 AM
Joined: Jan 2003
Posts: 45
User
User
Offline
Joined: Jan 2003
Posts: 45
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

Sponsored Links
Joined: Nov 2001
Posts: 10,369
I type Like navaho
I type Like navaho
Joined: Nov 2001
Posts: 10,369
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.

Daine #254702 09/15/2003 6:15 AM
Joined: Jan 2003
Posts: 45
User
User
Offline
Joined: Jan 2003
Posts: 45
[]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...

Joined: Apr 2001
Posts: 3,266
Member
Member
Offline
Joined: Apr 2001
Posts: 3,266
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

Joined: Jun 2003
Posts: 1,025
Junior Member
Junior Member
Offline
Joined: Jun 2003
Posts: 1,025
And don't overwrite your custom headers or things like that.

Sponsored Links
Joined: Jan 2003
Posts: 45
User
User
Offline
Joined: Jan 2003
Posts: 45
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!

Joined: Apr 2001
Posts: 3,266
Member
Member
Offline
Joined: Apr 2001
Posts: 3,266
Your table prefix is this w3t_ If yours is different make sure your production and test are the same.

Joined: Jan 2003
Posts: 45
User
User
Offline
Joined: Jan 2003
Posts: 45
Oh no!

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


Joined: Apr 2001
Posts: 3,266
Member
Member
Offline
Joined: Apr 2001
Posts: 3,266
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.

Joined: Apr 2002
Posts: 1,768
Addict
Addict
Offline
Joined: Apr 2002
Posts: 1,768
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.

Sponsored Links
joeuser #254710 09/22/2003 11:25 AM
Joined: Apr 2001
Posts: 3,266
Member
Member
Offline
Joined: Apr 2001
Posts: 3,266
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.

Joined: Apr 2002
Posts: 1,768
Addict
Addict
Offline
Joined: Apr 2002
Posts: 1,768
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.

Last edited by Dave_L; 09/22/2003 12:14 PM.
joeuser #254712 09/22/2003 11:48 AM
Joined: Jan 2003
Posts: 45
User
User
Offline
Joined: Jan 2003
Posts: 45
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?


Joined: Jan 2003
Posts: 45
User
User
Offline
Joined: Jan 2003
Posts: 45
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..


Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
Posts: 70
Joined: January 2007
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)