Hi,

I recently migrated a bunch of users (around 100) into a fresh installed 3.5.5 board, and only ONE user is constantly getting this error when logging in, but I don't know why or how to fix it.

I've tried:

1 - Removing his default avatar completely.
2 - Adding a new avatar from the boards selection.
3 - Added a new user and merged the two users into the new user. (This obviously resulted in the original user being deleted once completed, so I renamed the new user to match the old deleted user.)
4 - Changing his usergroup up and down again.

I have also rebuilt the relevant counters and attempted the "Fix broken profiles" setting after each attempt.

What is this code saying is wrong and how do I fix it?

Any suggestions would be appreciated.

-snake

can i get the whole error?

__________________

well you can see the problem:" WHERE user.userid =;" The userid variable is blank, Do this query: "SELECT user.userid, user.username FROM user WHERE user.username = 'THE USERNAME HERE'" And tell me what it comes back with.

I ran the query, and it returns the username and the userid. The username being themadhatter and the userid being 108 and the result generated in 0.0004s.

I don't get it?

-snake

PS, here's the full error as it was requested:

as i said, i quote:

I ran the query you gave, it returned the username and userid correctly. I am still not able to login as this user, getting this error still:

At login, I supply the username and password and it says "thank you for logging in themadhatter" followed instantly by this error.

the query wasn't going to fix anything just to see if there was actually a userid allocated to that user. Try reuploading all the scripts again just incase one got corrupted.

I see. Uploading the boards scripts doesn't seem to have had any effect.

It baffles me that no other users have reported any issues whatsoever, and extensive testing I've done alone has revealed no issues.
I can access this user's posts on the board as well as his profile via the admincp without issue, so vb appears to be able to locate him, but not when it matters, ie login time for him.

As an alternative, how could I delete this user WITHOUT having all his posts on the board marked as "guest" and then attempt re-adding him. Perhaps this would solve it?

-snake

<bump>

Re-uploading ALL the boards files has had no effect, so this tells me that the fault lies in the database, right? My idea above should work though, shouldn't it? But how?

-snake

BACK UP YOUR DB FIRST!!!!

easier said than done... It's not just changing the id in one table but alot of tables. BUT what you could do is change all the posts. Delete the old user, make a new one then run: Then run BUT BACK UP YOUR DB FIRST!!!!
And then it should work