Error while trying to import users from XMB

[RosaH]

I'm trying to import users from XMB and I keep getting this error:

Invalid SQL:
SELECT * FROM members
ORDER BY uid
LIMIT 0,500
mysql error: Table 'jenny_board.members' doesn't exist

I HAVE set the table prefix for the source tables, but it doesn't seem to detect it

[RosaH]

Anyone?

[Steve Machol]

Does your XMB database use table prefixes? As the error states, the 'members' table does not exist in database 'jenny_board'.

[RosaH]

Does your XMB database use table prefixes? As the error states, the 'members' table does not exist in database 'jenny_board'.

Yes, they have the prefix xmb2_ and i HAVE set that in the config file, but it doesn't seem to detect it or something

Here's my config file:

[ Target Database ]
; The following settings allow ImpEx to connect to the vBulletin 3
; database into which you will be importing data.
targetdatabasetype = mysql
targetserver = localhost
targetuser = jenny_general
targetpassword = *******
targetdatabase = jenny_board
targettableprefix = vb_
[ 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 = localhost
sourceuser = jenny_general
sourcepassword = *******
sourcedatabase = jenny_board
sourcetableprefix = xmb2_

[Steve Machol]

When did you download Impex? You could try redownloading it and reupload all fresh files.

[Jerry]

I've checked the XMB importer and the sourcetableprefix is in that bit of the code.

[RosaH]

I did as Steve said, and it worked. Thanks for the help!

[Jerry]

Coolio