Error msgs

[Langly]

I did a dump of my database and ftp'ed it to my new host. I got the new hosts admin to import the sql file since it was 65 megs. I edited the impex config file to reflect the correct information. When I tried to access the /impex/index.php I login there fine but when I try to "ReDo Module" for users, threads, forums or posts I get an error. I'm not sure what error it is since it goes by to fast but it just isn't importing those tables for some reason. Any reason why this would happen and how can I correct it?

[Zachery]

Are you trying to import from another software to vBulletin? Or are you moving your website from one server to another and still using vBulletin?

[Langly]

Sorry I forgot to mention that part. The imported file I have is from my vbulletin 3.5.3 and I'm moving it to my new host which I am using vbulletin 3.5.3 there.

[Zachery]

So why go though all of that work when you can just restore the database?

Impex is for moving from Software A to vBulletin, or merging two forums.

You are only moving servers, just restore the database.

[Langly]

I have the new database setup the way I like, it has several mods and hacks added which the old one didn't have. The only thing I needed was the users, forums, threads and posts added. Plus, I told to use impex by vbulletin.com staff.

I'm importing a few tables at a time and testing each as I go while setting permissions etc..

[Zachery]

You were told to use impex by one of the staff members to move servers? I'd like to see this.

If you import the sql database directly over your current database, it will be your old database. Not the new.

[Langly]

Well why talk about doing it here: http://www.vbulletin.com/forum/showthread.php?t=176266

[Zachery]

I wasn't given all of the information to start with, we ALWAYS recomend upgrades, and direct moving, never using impex to upgrade or move servers. Its alot of additional work.

[Langly]

Ok, so now that I have the new host all setup and working fine, how do you suggest I move over the users, threads, posts? I see the new host uses, I think its UTF8, and the old host uses the latin in their tables. I'm not sure if this will create a problem or not.

[Langly]

I am getting this error when I try to ReDo the users, forums or threads:

Import / Export
build version : 1.28


Importing 1 Forums

From : 0 :: To : 1

Warning: Invalid argument supplied for foreach() in /impex/systems/vb3/007.php on line 106

Line 106 of 007.php is just "}" by itself.

So how can I get this converted over now? I've had to redo the forum twice, corrupted tables first time and phpmyadmin imports of tables didn't work.
I have the forums on my new host all setup and modded just fine. All I need to do is add the users, threads and posts in there and I'm done.

[Steve Machol]

The latest version off Impex is 1.2.9. Dowload and use that.

Also why aren't you just restoring the database instead of using Impex?

[Langly]

The latest version off Impex is 1.2.9. Dowload and use that.

Also why aren't you just restoring the database instead of using Impex?

I just tried version 1.3.0 impex and still the same error shows up. I cannot restore the database since several of the tables are corrupted and have garbage in the button names and other places. Plus its stuck on britsh language and I cannot restore the original language. Like I mentioned a few posts earlier, I have the new host all setup and modded and ready to go. All I need is to add the users, threads and posts. So what is the easiest way to do this without having to redo the who forum yet again? I'm trying to get it done asap before my next months bill date comes on my present host.

If worse comes to worse, whats the cost to get this fixed?

[Jerry]

I have the new database setup the way I like, it has several mods and hacks added which the old one didn't have. The only thing I needed was the users, forums, threads and posts added. Plus, I told to use impex by vbulletin.com staff..

So you have modified the target vBulletin before importing into it ?

What does the module 001 give you ? all green or all red ?

[Langly]

So you have modified the target vBulletin before importing into it ?

What does the module 001 give you ? all green or all red ?

I'm sorry, red or green? I don't have any colors. Here is what I have:

http://www.gocellular.org/crap/001.GIF

That is the 001 module "Check and update database"

http://www.gocellular.org/crap/004.GIF

This is my 004 module "Import user"

That error is the same for all the modules I try to run. As for modifying before I imported, no, I imported all but the users, threads and posts first, edited everything and then I was going to import the users, threads, posts. This is the point I am at now.

[Jerry]

The first image you posted is your main issue, ImpEx can't/isn't connecting to the source databases.

Have you configured ImpExConfig.php to have the source and target database details ?

[Langly]

Odd thing is that the info in there is correct.

[Jerry]

The only way that ImpEx can give that error is if the source database details are incorrect or the database is refusing the connection.

Are both sites in the same database or do you have two databases on the same server ?

[Langly]

2 databases on the same server.

[Jerry]

You'll have to start a support ticket so the source details can be checked.

[Langly]

I think I might have it, I'm updating counters atm.

[Jerry]

So it was the source details or database permissions ?

[Langly]

Umm, well .. hehe. I'm not sure how but it was set to
$impexconfig['source']['databasetype'] = 'mysql';
$impexconfig['source']['server'] = 'localhost';
$impexconfig['source']['user'] = 'user';
$impexconfig['source']['password'] = 'pass';
$impexconfig['source']['database'] = 'vb';
$impexconfig['source']['tableprefix'] = '';

# If the system that is being imported from uses a database,
# enter the details for it here and set 'sourceexists' to TRUE.
# If the source data is NOT stored in a database, set 'sourceexists' to FALSE
$impexconfig['sourceexists'] = TRUE;
$impexconfig['source']['databasetype'] = 'mysql';
$impexconfig['source']['server'] = 'localhost';
$impexconfig['source']['user'] = 'user';
$impexconfig['source']['password'] = 'pass';
$impexconfig['source']['database'] = 'new';
$impexconfig['source']['tableprefix'] = '';


Goes to show you should upgrade the config file too. :D

Thanks a TON!

[Gbml2u]

how i do setup