Support Forum

Unable to import users

AS Austin Sehling
Austin Sehling
Member

Hello,

I am using the simple press data importer and I am receiving this error: Error: Unable to query USERS using the db settings supplied.

I have checked the db settings and I believe they are correct .

 

I am also getting this error above the first error: Warning: Creating default object from empty value in /problem-with-post-edit-buttonome/tt/public_html/wp-content/plugins/sp-import/admin/spimport-setup.php on line 32

I am not sure if they are related.

Any help would be appreciated . Thank you , AJ

23 Answers

New Answer

MP Mr Papa
Mr Papa
Member

there are two db settings…  one for the incoming and one for wp…  they both need to be correct and additionally, both must be on the same server… is this the case?

what type of import are you doing?  ie from which other forum sw…

AS Austin Sehling
Austin Sehling
Member

Thank you for the fast response ,

I am importing for vBulletin.

They are both on the same server, I am double checking the db settings .

 

MP Mr Papa
Mr Papa
Member

okay, let us know…  ones to check are prefix and host as folks get those wrong the most…

YS Yellow Swordfish
Yellow Swordfish
Member

It might be useful if you could also PM me the data you set in the import form. Can you PM this to both Mr Papa and to Yellow Swordfish please.

YS Yellow Swordfish
Yellow Swordfish
Member

Bit what values did you put in the import form? Both for the source and the target?

AS Austin Sehling
Austin Sehling
Member

I filled in all the spaces that the form had with the info in the pm , I am not sure what other information I need to input?

YS Yellow Swordfish
Yellow Swordfish
Member

I think it looks OK. The only thing I question is the new database name. Are you sure it has ‘tt_’ in front of it?

And you can import the password but WP will not be able to recognise them I am afraid as they use a different security hashing technique.  But that wont effect the import as such.

AS Austin Sehling
Austin Sehling
Member

I created the new data base and it added the tt in front automatically. I am no mysql expert so perhaps there is a better way to create it?

That is fine on the passwords . The user will just be prompted to create a new password correct? 

Thank you for all your help.

YS Yellow Swordfish
Yellow Swordfish
Member

Can you tell me how you copied the database and what tools were you using to do it with?

AS Austin Sehling
Austin Sehling
Member

I exported the forum database with  phpmyadmin  and then created a new database in mysql and imported the database with phpmyadmin .

YS Yellow Swordfish
Yellow Swordfish
Member

To be honest I am somewhat stumped. The warning error you received actually suggests that one of those fields is empty and that doesn’t really make much sense. The vBulletin importer script was actually written by a user so I am not as familiar with it as some of the others. I will have to spend a little time looking through the code to see if I can spot anything – but I do know other users have successfully used it.