Invision To Vbulletin

[Magicalneo]

ok I just bought vbulletin yesterday night and I posted a help thread in the main vbulletin forum but no one seems to understand how to solve this problem , I would really like someone who is well knowledgeable in vbulletin to help me.

Well first of all I have sucessfully installed vbulletin and next I want to transfer my old data/mysql DB from my invision 2.0.4 forum to Vbulletin 3.0.8 but I can't seem to do that without a converter which was like something that converted my phpbb DB to the INvison data last time.

Right now a guy introduced me something called impex and so I uploaded it into my forums folder and the next step is pretty confusing how do I even use it? I read many post but can't seem to understand the next step , if anyone would help me, I would really appreciate it since this is something really hard I encounter with vbulletin.

[Rover416]

Check your PM.:)

[ManagerJosh]

Magic, I don't get what's the problem

[Magicalneo]

Check your PM.:)

Yeah ok its was great but in dreamweaver when i edit it those things seems to be in yellow text before the <?php tag so I suppose the stuff won't work even after I fill up the infomation inside..?

[Steve Machol]

<Moved to correct forum>

Please describe exactly what you are doing and what the problem is.

[Magicalneo]

The problem is , I can't get my invision DB into my Vbulletin DB , I encounter loads of **** errors and also The impexconfig file inside has this * icon which allows the entire script to be unuse so if its yellow will it still work?

[Steve Machol]

What are the errors?

[Magicalneo]

ERROR with the database or file system, please check config.

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /impex/db_mysql.php on line 248



There seems to have been a slight problem with the Forums database.
Please try again by pressing the refresh (javascript:window.location=window.location;) button in your browser.
An E-Mail has been dispatched to our Technical Staff (magicalneo@hotmail.com), who you can also contact if the problem persists.
We apologise for any inconvenience.

Database error in vBulletin 3.0.8:
Invalid SQL:
SELECT id, name
FROM members
ORDER BY id
LIMIT 0,25
mysql error:
mysql error number: 0
Date: Sunday 07th of August 2005 04:55:14 AM
Script: http://www.animequazo.com/forums/impex/index.php
Referer: http://www.animequazo.com/forums/impex/index.php
Username: Magicalneo
IP Address: 202.156.2.114

[Steve Machol]

This means the db info in your ImpExConfig,php file is wrong. Please view the online instructions here:

http://www.vbulletin.com/docs/html/impex

Is the IPB database on the same server as your vB? If not, you may not have permission to access the IPB database remotely. In that case you will need to backup and restore the IPB db on your vB server.

[Magicalneo]

This means the db info in your ImpExConfig,php file is wrong. Please view the online instructions here:

http://www.vbulletin.com/docs/html/impex

Is the IPB database on the same server as your vB? If not, you may not have permission to access the IPB database remotely. In that case you will need to backup and restore the IPB db on your vB server.

its on the same server

[Steve Machol]

Then the info in ImpExConfig.php is wrong - most likely the source info.

[Magicalneo]

Eh please I really need my problem to be solved i dun really care much of anything anymore , it doesn't matter even if I get hacked or something I just have to solve this hard problem.... please help I have no other way.... or u can let the admin see the image..

[Floris]

You specificly show in your image that your source is a mysql database, you have the setting set to false, change that to true.

[Magicalneo]

A source database was not entered in ImpExConfig.php

I got that error when I change it to true.

[Floris]

A source database was not entered in ImpExConfig.php

I got that error when I change it to true.


Not according to the picture you gave me?

[Magicalneo]

Not according to the picture you gave me?

I changed the false to true.. but whats with the mysql?

[Steve Machol]

What is the latest error?

[Magicalneo]

What is the latest error?

it says this

A source database was not entered in ImpExConfig.php

[Steve Machol]

You need to enter a valid source database in ImpExConfig.php.

[Magicalneo]

You need to enter a valid source database in ImpExConfig.php.

example?

[Magicalneo]

The new error I encounter..

[Steve Machol]

Your ImpExConfig.php source data is wrong. You need to enter the valid info for the IPB database.

[Magicalneo]

Your ImpExConfig.php source data is wrong. You need to enter the valid info for the IPB database.

ic so the vbuletin info goes ontop and the IPB below right?

[Magicalneo]

Just asking
I think i found out whats my problem

can u tell me whats
targetdatabase
sourcedatabase

Is this in myphpadmin or something?

[Steve Machol]

The target info is the vB database, the source info is the IPB one.

[Magicalneo]

The target info is the vB database, the source info is the IPB one.

dun really understand what are you trying to say VB database? or could u specfically tell me whats the name of both of them.

[Steve Machol]

We have no way of know what your database info is. The target info will be tthe same as in your vB config.php file. I assume IPB has a similar config file in which it's database info resides.

[Magicalneo]

We have no way of know what your database info is. The target info will be tthe same as in your vB config.php file. I assume IPB has a similar config file in which it's database info resides.

Tell me which line is the Target Info and whatever and I try to match it thanks...

[Steve Machol]

This is the target info area (for the vB info):

targetdatabasetype = mysql
targetserver = localhost
targetuser = "username"
targetpassword = "password"
targetdatabase = vbulletin_forum
targettableprefix =

And this is the source are for the IPB info:

sourcedatabasetype = mysql
sourceserver = localhost
sourceuser = "username"
sourcepassword = "password"
sourcedatabase =
sourcetableprefix =

[Magicalneo]

This is the target info area (for the vB info):

targetdatabasetype = mysql
targetserver = localhost
targetuser = "username"
targetpassword = "password"
targetdatabase = vbulletin_forum
targettableprefix =

And this is the source are for the IPB info:

sourcedatabasetype = mysql
sourceserver = localhost
sourceuser = "username"
sourcepassword = "password"
sourcedatabase =
sourcetableprefix =

thats for the impexconfig , what I'm talking about is the config.php that is in the vbulletin 3.0.8 file , which line says vbulletin_forum

maybe u can add me or msn or something to prevent more of these spam..

[Jerry]

thats for the impexconfig , what I'm talking about is the config.php that is in the vbulletin 3.0.8 file , which line says vbulletin_forum

maybe u can add me or msn or something to prevent more of these spam..

The target information is read by impex if it is installed correctly, you must set up impexconfig for the source.

[Magicalneo]

So how the hell do I do it? targetdatabasetype = mysql
targetserver = supremeserver20.com
targetuser = "magicalneo_board"
targetpassword = "******"
targetdatabase = magicalneo_board
targettableprefix =
[ Source Database ]
; 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
sourceexists = true
; mysql OR mssql
sourcedatabasetype = mysql
sourceserver = supremeserver20.com
sourceuser = "magicalneo_forum"
sourcepassword = "******"
sourcedatabase = magicalneo_forum
sourcetableprefix =

Like this?

[Jerry]

Is supremeserver20.com the localhost ? and you still need your souretableprefix.

[Magicalneo]

I have this in myphpadmin

ibf_members
but no magicalneo_forum.members

[tzrtim]

sourcetableprefix ibf_

that should change magicalneo_forum.members to ibf_members

targetdatabasetype = mysql
targetserver = supremeserver20.com
targetuser = "magicalneo_board"
targetpassword = "******"
targetdatabase = magicalneo_board
targettableprefix =
[ Source Database ]
; 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
sourceexists = true
; mysql OR mssql
sourcedatabasetype = mysql
sourceserver = supremeserver20.com
sourceuser = "magicalneo_forum"
sourcepassword = "******"
sourcedatabase = magicalneo_forum
sourcetableprefix = ibf_

[Magicalneo]

Thanks alot all my problem has been solved..


sourcetableprefix ibf_

that should change magicalneo_forum.members to ibf_members

targetdatabasetype = mysql
targetserver = supremeserver20.com
targetuser = "magicalneo_board"
targetpassword = "******"
targetdatabase = magicalneo_board
targettableprefix =
[ Source Database ]
; 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
sourceexists = true
; mysql OR mssql
sourcedatabasetype = mysql
sourceserver = supremeserver20.com
sourceuser = "magicalneo_forum"
sourcepassword = "******"
sourcedatabase = magicalneo_forum
sourcetableprefix = ibf_

[Magicalneo]

I have the members in there now but the forums are not there..

http://animequazo.com/forums/index.php?

[Steve Machol]

Please read the Importing HOWTO thread:

http://www.vbulletin.com/forum/showthread.php?t=116398

Take special note of The End Game section. Following these steps should solve those issues.

[Magicalneo]

Please read the Importing HOWTO thread:

http://www.vbulletin.com/forum/showthread.php?t=116398

Take special note of The End Game section. Following these steps should solve those issues.

ty the last part helped me alot by now my forums should be stable...

[Magicalneo]

I have a few problems my members can't seem to login and the memberlist seems to only have 2 person , anyone can help?

[Steve Machol]

As the IPB import thread states, the passwords cannot be imported. Your users need to reset their passwords, which they can do with this link:

http://www.yoursite.com/forums/login.php?do=lostpw

There are two options you need to check to set whether or not members are viewable on memberlist:

1. By usergroup:

Admin CP -> Usergroups -> Usergroup Manager -> Edit -> Usergroup Options -> Viewable on the Memberlist -> Yes

2. By post count:

Admin CP -> vBulletin Options -> User Listing & Profile Viewing -> Minimum Posts