Simple Machines Community Forum

SMF Support => Converting to SMF => vBulletin => Topic started by: toups on April 19, 2009, 09:58:39 AM

Title: Converter.php trying to connect to VB database with wrong user
Post by: toups on April 19, 2009, 09:58:39 AM
For my databases for my webhost I can only have 1 user have permission to access each database.  Since the SMF database and VB database are separate they each have separate users and the converter.php tries to use the SMF user to access the VB database which it can't.  This gives me the error :

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of vBulletin 3.7. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: SELECT command denied to user 'dbo282826531'@'74.208.16.66' for table 'ODVBuser'


because of it.  So is there any way I can define the username it should use to connect to the VB database so I can convert my forum?  Thanks!
Title: Re: Converter.php trying to connect to VB database with wrong user
Post by: ThorstenE on April 19, 2009, 01:14:38 PM
sorry, but the only solution: install SMF to the same database as vBulletin is installed. convert.php & SMF needs access to the vBulletin database, without access to the database a conversion is impossible.

But SMF tables have a different table prefix (smf_ by default) and will not modify your vBulletin in any way..
Installing SMF (http://docs.simplemachines.org/index.php?board=2.0;sort=subject)
Title: Re: Converter.php trying to connect to VB database with wrong user
Post by: toups on April 19, 2009, 01:39:06 PM
Quote from: TE on April 19, 2009, 01:14:38 PM
sorry, but the only solution: install SMF to the same database as vBulletin is installed. convert.php & SMF needs access to the vBulletin database, without access to the database a conversion is impossible.

But SMF tables have a different table prefix (smf_ by default) and will not modify your vBulletin in any way..
Installing SMF (http://docs.simplemachines.org/index.php?board=2.0;sort=subject)

database that VB is on doesn't have enough room left on it to install SMF and import all the info into SMF on the same database =\
any way I can import the database information not through a converter..? kind of pointless to go to smf if I can't keep my data for it.
Title: Re: Converter.php trying to connect to VB database with wrong user
Post by: ThorstenE on April 19, 2009, 01:45:12 PM
The only other solution: an offline conversion (with XAMPP for example) .. export your vBulletin to your home computer, convert it locally and then move the converted SMF to your host.

How do I move my SMF board to a different host? (http://docs.simplemachines.org/index.php?topic=489)