View Full Version : Error while trying to import users from XMB
RosaH
Tue 9th Nov '04, 7:32pm
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
Wed 10th Nov '04, 7:34pm
Anyone?
Steve Machol
Wed 10th Nov '04, 7:36pm
Does your XMB database use table prefixes? As the error states, the 'members' table does not exist in database 'jenny_board'.
RosaH
Wed 10th Nov '04, 8:08pm
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
Wed 10th Nov '04, 9:43pm
When did you download Impex? You could try redownloading it and reupload all fresh files.
Jerry
Fri 12th Nov '04, 8:20am
I've checked the XMB importer and the sourcetableprefix is in that bit of the code.
RosaH
Fri 12th Nov '04, 10:10am
I did as Steve said, and it worked. Thanks for the help! :D
Jerry
Fri 12th Nov '04, 10:23am
Coolio :D
vBulletin® v3.8.0, Copyright ©2000-2009, Jelsoft Enterprises Ltd.