UBB.threads PHP Forum Software Community Forums UBB.threads 6 Version 6 Support mysql database

How can I import a mysql database from UBB threads 5.1.1 to a claen configuration of the UBB threads 6.1

Basically you're going to do a mysqldump on the database, then import it into a clean database/install of 6.1.

There are detailed instructions here.

Hope that helps ya. <img border="0" title="" alt="[Wink]" src="images/icons/wink.gif" />

Josh
Measurection.com Admin
ThreadsDev.com Moderator
See my How To/Site Help Library Foum at ThreadsDev.
"Happiness comes through doors you didn't even know you left open. "

So if Iám right, I have installed the new Ubbthread v6.1 and the only thing I have to do now is a Mysql dump, does it matter that the old database is a version 5.1.1 <img border="0" title="" alt="[Roll Eyes]" src="images/icons/rolleyes.gif" />

And will the old Admin be accessable <img border="0" title="" alt="[Confused]" src="images/icons/confused.gif" />

Right.... do a Mysql dump on your old forum.

Import it into the new install. Now because it's a database from version 5, you'll need to treat it like an upgrade and run all the altertables needed to get you to 6.1. <img border="0" title="" alt="[Smile]" src="images/icons/smile.gif" />

Run them in order.

I don't see an altertable for 5.1.1, they seem to start at 5.2.

I don't know if there was an Altertable from 5.1 to 5.2. The upgrade instructions don't seem to go back that far. Brett or Rick could answer that for sure.

Then you'd need to run:
altertable-5.2-5.3.php
altertable-5.3-5.4.php
altertable-5.4.1-5.4.2.php
etc.... all the way up to
altertable-6.0-6.1.php

Once you do that, then your imported database should work fine in 6.1. Yes, all users, posts, forums and messages will be intact. Nothing will change. The admin usernames will be the same. <img border="0" title="" alt="[Smile]" src="images/icons/smile.gif" />

Hope that helps ya. <img border="0" title="" alt="[Wink]" src="images/icons/wink.gif" />

Josh
Measurection.com Admin
ThreadsDev.com Moderator
See my How To/Site Help Library Foum at ThreadsDev.
"Happiness comes through doors you didn't even know you left open. "

Rick Says:

If you are running the PHP version of 5.1.1 then the 5.2 is the first Altertable you need to run.

If your 5.1.1 was Perl...then there will be another altertable that you'll need to run. One that I don't see in the current 6.1 distibution... but I bet infopop could help you with that if needed. <img border="0" title="" alt="[Wink]" src="images/icons/wink.gif" />

Josh
Measurection.com Admin
ThreadsDev.com Moderator
Register to see my How To/Site Help Library Forum at ThreadsDev.com.
"Happiness comes through doors you didn't even know you left open. "

I did what you said, http://forum.mydomain.nl/altertable-5.2-5.3.php
but I have the following error: ------------

Altering the posts table to better designate main topic posts (Speed improvement)...
SQL ERROR: Unable to do_query: ALTER TABLE solexPosts ADD B_Topic INT(1) UNSIGNED DEFAULT '0' NOT NULL , ADD INDEX topic_ndx (B_Topic)
Table 'solex.solexposts' doesn't existRe-indexing the main topics for each board...
SQL ERROR: Unable to do_query: UPDATE solexPosts SET B_Topic = 1 WHERE B_Main = B_Number
Table 'solex.solexposts' doesn't existAltering Users table to allow for thread age display preference...
SQL ERROR: Unable to do_query: ALTER TABLE solexUsers ADD U_ActiveThread INT(4) UNSIGNED
Table 'solex.solexusers' doesn't existDone...
------------------------

Don't panic. It looks like it's just not finding the tables.

Looks like it's using "solex" as the table prefix and not finding them. Instead of looking for solexPosts it should be looking for w3t_Posts.

Are you sure your table prefix wasn't "w3t_"? I thought all early versions of threads used w3t_ as the table prefix.

Did you choose "solex" as the table prefix option in the config of the new install? You might try changing that to "w3t_" as older versions of threads used that as the standard prefix. There wasn't an option to change the table prefix until version 6.1.

Download the config.inc.php for that install that you set up and look for this:

$config['tbprefix'] = "w3t_";

It probably says "solex" there instead. Try changing it to "w3t_".

Josh
Measurection.com Admin
ThreadsDev.com Moderator
Register to see my How To/Site Help Library Forum at ThreadsDev.com.
"Happiness comes through doors you didn't even know you left open. "

I did the setup again an put the w3t_ in the field, but then I have the following error by: http://forum.mydomain.nl/createtable.php

Creating the tables...
SQL ERROR: Unable to do_query: CREATE TABLE w3t_Boards( Bo_Title text, Bo_Description text, Bo_Keyword varchar(100) NOT NULL, Bo_Total INT(9) UNSIGNED, Bo_Last INT(11) UNSIGNED, Bo_HTML varchar(3) DEFAULT 'On' NOT NULL, Bo_Markup varchar(3) DEFAULT 'On' NOT NULL, Bo_Number INT(9) UNSIGNED DEFAULT '0' AUTO_INCREMENT PRIMARY KEY, Bo_Created INT(11) UNSIGNED, Bo_Expire INT(4) UNSIGNED, Bo_Approve varchar(3) DEFAULT 'Off' NOT NULL, Bo_Moderated varchar(3) DEFAULT 'no', Bo_Cat INT(4) UNSIGNED DEFAULT '1' NOT NULL, Bo_Read_Perm varchar(250) DEFAULT '-3-4-', Bo_Write_Perm varchar(250) DEFAULT '-3-4-', Bo_Threads INT(9) UNSIGNED unsigned DEFAULT '0', Bo_Sorter INT(4) UNSIGNED, Bo_CatName varchar(255), Bo_ThreadAge INT(4) UNSIGNED, Bo_Poster varchar(64), Bo_Reply_Perm varchar(25) DEFAULT '-3-4-', Bo_Moderators text, Bo_SpecialHeader INT(1), Bo_Stylesheet varchar(50), Bo_LastNumber INT(9), Bo_lastMain INT(9) ,UNIQUE indx1 (Bo_Keyword), INDEX indx2 (Bo_Number), INDEX Cat_ndx (Bo_Cat) )
Table 'w3t_boards' already existsBoard table created...

+ more errors

That would make sense. It's telling you that they are already there.

If this is your test database...and you have already imported your copy of the database using the mysqldump and mysql command... (like that infopop instruction document explains) then you don't need to create them with createtable.... they should already be there.

But now at least you've got the w3t_ set.

I'm thinking that the altertables should work for you this time. It just wasn't finding them before. Now it's finding them...and knows that they are already there.

See if you get any errors with the altertables now.

Josh
Measurection.com Admin
ThreadsDev.com Moderator
Register to see my How To/Site Help Library Forum at ThreadsDev.com.
"Happiness comes through doors you didn't even know you left open. "

1/ delete Mysql database
2/ make new database
3/ setup the new UBBTHREADS
4/ stop ad step 6 (before creating tabels)
5/ Restore previous database (v5.1.1)
6/ Delete Install.php etc.
7/ run altertable-5.2-5.3.php until 6.1
8/ login with old administrator

Is this correct?

Why don't you just do a regular upgrade from the 5 series to the 6 series?

I suspect that trying to hook the old database to the new scripts won't work because the new scripts are going to be looking for columns that are simply NOT going to be there.

Regards,

Brett Harris
Infopop Corporation

I did do a completly new setup but when I want to put theold database (5.1.1) back I have the following error:

E:\mysql\bin>mysql solex < f:\solex.dump
ERROR 1050 at line 11: Table 'w3t_addressbook' already exists

If we can solve this problem

Seems like you've got the steps right.

Brett is right.. you are basically "upgrading". I'm thinking that you are either moving it all to a new location (new url or new server) or you are trying to get your new copy working and keep your old as a backup which is why you are working so hard at setting up a duplicate.

You won't be able to use 6.1 until you go through all the altertables (which add all the new columns etc..)

I think at this point you could skip steps 3 and 4 as I think you've got everything all configured by running the install script once already.

The install script is really for a new forum... starting from scratch with no users and no posts...running it may be further complicating "restoring/transfering from a backup" which is basically what you are trying to do.

Josh
Measurection.com Admin
ThreadsDev.com Moderator
Register to see my How To/Site Help Library Forum at ThreadsDev.com.
"Happiness comes through doors you didn't even know you left open. "

</font><blockquote><font size="1" face="">quote:</font><hr /><font size="" face="">E:\mysql\bin>mysql solex < f:\solex.dump
ERROR 1050 at line 11: Table 'w3t_addressbook' already exists</font><hr /></blockquote><font size="" face="">You must have gone through the create table process already.... hence it already exists.

If you want to create this second install.... you need to create the database solex... but don't run the install. It'll be empty. It will create the tables when you import your old database using the mysql command. <img border="0" title="" alt="[Smile]" src="images/icons/smile.gif" />

Josh
Measurection.com Admin
ThreadsDev.com Moderator
Register to see my How To/Site Help Library Forum at ThreadsDev.com.
"Happiness comes through doors you didn't even know you left open. "

Could you tell where I can find version 5.1.1.zip in the mebers area Because I lost this file ;-(

I want to reinstall the old version and upgrade from there

I don't think you can download that anymore.

But you don't really need the actual 5.1.1 files to upgrade.

You could install the 6.1 files into your current threads directory.

Don't overwrite main.inc.php, config.inc.php and theme.inc.php and run the altertable scripts from there.

Someone else asked a similar question earlier today here.

Or did you already delete/overwrite your 5.1.1 install? Is it working and live now?

If so.... then manually edit the main.inc.php file as well as the config.inc.php file with database name, paths, urls etc...
Then you should be able to run the altertables from there and be all upgraded. <img border="0" title="" alt="[Smile]" src="images/icons/smile.gif" />

Josh
Measurection.com Admin
ThreadsDev.com Moderator
Register to see my How To/Site Help Library Forum at ThreadsDev.com.
"Happiness comes through doors you didn't even know you left open. "

I don't have a copy of my old ubbt 5.1.1 any more only the database I have and I need the data from the old database.

When I do install a compleet new version 6.1 erverthing works fine, only I can't put the old database back because of errors ;-(

I there not a stand alone program that can converse the database in version 6.1 so I can put it back with restore function?

The 6.1.1 version of ubbthreads is what you need. You point this at your old database and then run through the altertables to convert it to current. You will get errors trying to access the forums until all of the altertables are run.

-------------------
Rick Baker
UBBThreads developer

I think I understand now.

You've got an old threads database sitting around.... but no copy of threads. But you need the data from that threads database. So now you've got 6.1 and you are just trying to get at the data?

If that's the case... copy the 6.1 files to your server. Edit the path in main.inc.php and paths, urls and database username, password etc.. in config.inc.php. Upload those to the 6.1 install directory. Don't run the install script.

Create a database on your server. Use the mysql command to restore the data from your dump to it.

Then run your altertable scripts in order.

Once you are done, you should be able to get at all the data using 6.1.

If I understood your situation correctly... did that make sense?

Josh
Measurection.com Admin
ThreadsDev.com Moderator
Register to see my How To/Site Help Library Forum at ThreadsDev.com.
"Happiness comes through doors you didn't even know you left open. "

Ok I will start again, but are you sure there is no altertable-5.1-5.2.php because all of these files going one version up <img border="0" title="" alt="[Confused]" src="images/icons/confused.gif" />

As Rick told me.... not if you were running a PHP version of 5.1.1.

If you were running a Perl version of 5.1.1 there would be an altertable to run.... but it's not in the main distribution. Infopop could probably get it fo you.

Do you remember if your 5.1.1 was Perl or PHP. Perl came first, and I guess that 5.2 was the first change in the PHP version.

But that's an important question for you to think about if you continue to have trouble.

PS- If you are doing this to be a "live board" then you might as well head on over to the members area and get 6.1.1 (released tonight) which will include some bug fixes. <img border="0" title="" alt="[Razz]" src="images/icons/tongue.gif" />

Josh
Measurection.com Admin
ThreadsDev.com Moderator
Register to see my How To/Site Help Library Forum at ThreadsDev.com.
"Happiness comes through doors you didn't even know you left open. "

This is what I have done:

1/ Make new database (solex)
2/ restore database (version 5.1.1)
3/ delete all files on server
4/ Have download version 6.1.1 from infopop
5/ modify: config.inc.php and main.inc.php
6/ upload all files except: install.php and creattabele.php
7/ if you look to forum i look like this: http://forum.solex.nl//ubbthreads.php
8/ then I did the first altertable: http://forum.solex.nl/altertable-5.2-5.3.php

And Than I have this error:
----------------------------
Altering the posts table to better designate main topic posts (Speed improvement)...
SQL ERROR: Unable to do_query: ALTER TABLE w3t_Posts ADD B_Topic INT(1) UNSIGNED DEFAULT '0' NOT NULL , ADD INDEX topic_ndx (B_Topic)
Duplicate column name 'B_Topic'Re-indexing the main topics for each board...
Altering Users table to allow for thread age display preference...
SQL ERROR: Unable to do_query: ALTER TABLE w3t_Users ADD U_ActiveThread INT(4) UNSIGNED
Duplicate column name 'U_ActiveThread'Done..
---------------
or is this normal <img border="0" title="" alt="[Confused]" src="images/icons/confused.gif" />

I have the PHP version 5.1.1

I think that I noted in another thread that trying to run the 5.5.1 code against a 6.1 database is not going to work necessarily.

Upgrade the entire thing or stay with the current product.

Regards,

Brett Harris
Infopop Corporation

I think he was having trouble running the altertable scripts even upgrading which I think had to do with his settings.

I got an email from him, so I *think* he's gotten this up and running. <img border="0" title="" alt="[Smile]" src="images/icons/smile.gif" />

Josh
Measurection.com Admin
ThreadsDev.com Moderator
Register to see my How To/Site Help Library Forum at ThreadsDev.com.
"Happiness comes through doors you didn't even know you left open. "