wowbb 1.65 import issue

[JakeAppliance]

I was doing my import from wowbb 1.65 tonight and all went well till i got down to import users, then this error came:

There seems to have been a slight problem with the Appliance Blog Forums database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

Now i can not login to my admin control panel.

Can you please help me resolve this?

Thankyou,

Jake

[Colin F]

If you see this error next time, view the sourcecode of the page and copy the exact mysql error message which should be in comments.

What error do you get when trying to log in?

[JakeAppliance]

Here is the email error i got:

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT * FROM vb3_cpsession
WHERE userid =
AND hash = 'a0dbc0f68e0a937d76d4f7fa2b9eb590'
AND dateline > 1122263318
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND hash = 'a0dbc0f68e0a937d76d4f7fa2b9eb590'
AND dateline >

mysql error number: 1064

Date: Monday 25th of July 2005 12:48:38 AM
Script: http://www.applianceblog.com/mainforums/impex/index.php
Referer: http://www.applianceblog.com/mainforums/impex/index.php
IP Address: 24.22.51.44

Here is the login error i now get:

You have entered an invalid username or password. Please press the back button, enter the correct details and try again. Don't forget that the password is case sensitive. Forgotten your password?

Jake

[Zachery]

Did you re-import? is this a second import? Did you try clearing the imported data?

[JakeAppliance]

I Just purchased vBulletin 3 last week, its a first time clean import.

After i got that error, i can't login now to clear the import data.

I think i know what i did wrong, as i was seaching in this forum to see if anyone else had the same error, I associated my wowbb userID with my current vb3 admin userID.
I read i could do that after i finished importing, in the admin control panel.

Do i have to re-install vb3 and start all over with everything? Hopefully not, Please say no!

Jake

[Zachery]

Probally, it would be the easiest way to fix things in the long run I'd think...

the other method you could do is upload tools.php to the admincp folder and use it to restore an imported accouint that you have access to admin status, or you can register a new account and do the same.

[JakeAppliance]

Thanks to you and Martin,

Making a new username and the tools.php solved the problem, i was able to finish my import properly, all seems to be working well now.

Thanks Again for your help!

John