PDA

View Full Version : Errors converting from phpbb2



Tschnitker
Sun 25th Jul '04, 1:02pm
I just purchased and installed VB, and am now trying to import it.

When I get to the 2nd import step, I get this error (some minor things edited for security)


Database error in vBulletin:ImpEx Source 3.0.3:
Invalid SQL:
SELECT user_id,username
FROM users
ORDER BY user_id
LIMIT 0,25
mysql error: Table databasename.users' doesn't exist
mysql error number: 1146
Date: Sunday 25th of July 2004 09:02:47 AM
Script: http://www.zcarchat.com/impex/index.php
Referer: http://www.zcarchat.com/impex/index.php
Username: XXXX
IP Address: XXXXXX



It says the databasename.users doesn't exist, but when I go into mysql I can see it there and the data within.

Help!

WHM-Host
Sun 25th Jul '04, 1:21pm
You need to edit the impex_config..

Tschnitker
Sun 25th Jul '04, 4:43pm
You need to edit the impex_config..

I did edit it, I checked it and rechecked it.

When I go through the first step, where it tests the connection to the database, it works....The 2nd one is where it always fails.

Steve Machol
Sun 25th Jul '04, 5:32pm
Did you add the correct table prefixes?

Tschnitker
Sun 25th Jul '04, 6:21pm
Yep, the prefixes/database/usernames are exactly the same as my config file for the phpbb2 site. (and yes I did enter in the correct info for the new database)

Steve Machol
Mon 26th Jul '04, 2:32am
Hmmm...the error doesn't indicate a table prefix:

mysql error: Table databasename.users' doesn't exist

AFAICT this error definitely means that either this table doesn't exist, or the info in your config file is wrong.