Issue concerning account status

While I understand that the forums just gotten upgraded and everything is not exactly completed, I temporarily had to make another account [this is Blazer by the way]. Not sure if this is part of it still being completed but every time I try to login into my actual account, I get an error saying that it was incorrect or rather that it kept saying that the username did not belong to any account. plus I also noticed that in all of the posts and/or topics I created, it has me labeled as a guest user as well as being considered a lurker. not sure if anyone else is also experiencing this as well on their own accounts and again im not sure if this has something to do with the upgrade itself or not but I just figured that I felt that this should be informed as again this account is only temporary.

 

Are you logging in using your latest account name? If not, that's the problem.

 

Yeah, I used to log in as "TMortonBlitz" which was my name at registration, but after the update I had to put in "Bakayote".

 

I tried doing that and im still getting the same error. I don't understand why it's not working for me.

 

It seems that the ability to edit usernames post registration is also gone; this issue seems like it could make reimplementing that feature a lot harder (if at all)

EDIT: Nevermind, this layout is way too different, everything is hard to find now...

 

No, the abilities to change your username are still there. Go to your account settings, then on the "Display Name" tab.

 

Strange how it thinks that I'm this blazefirelp person which I never used that name before as that actually used to belong to someone already back on the old boards. It must have mistaken me for him as my display name was just Blazer by itself.

edit: Just did a member search to make sure and my original account is no where to be found at all.

 

Blazefirelp is a different person entirely.

 

I kinda figured that's what happened, though it kinda sucks that the upgrade would just out right delete it like that. Well knowing now that all of my old posts/threads can be redirected to this account (if you are able to that is as you said), I suppose it won't be so bad. And seeing as you need an example of a post I made on my old account, I'll just use this one for now as it was one I started before

 

I am fairly good with SQL, and I already got my hands dirty with similar tasks in the past (see Sonic Retro Shibunoa incident). Sadly, by the looks of Blazer's "guest" post it doesn't look like it has any recognisable traits which could be used in the "where" statement of the query. One might argue that with guest posting disabled there would be a low number of false positives which aren't posted by Blazer if all guest posts are selected, though it should be verified. Either way, if you need SQL help, feel free to contact me.

edit: a possible query with a low number of false positives might be "all guests posts made after Blazer joined the forum", unless other people's accounts shared his same faith, of course. Also, I'm saying all this without looking at the raw data, it might be possible to use other fields such as ip or user agent to pinpoint Blazer's posts.

 

I might be able to lend a hand as well. My MySQL knowledge is a bit rusty, but I could probably re-acquaint myself and unravel things. With any luck, the posts themselves still have fields attached to them that could help undo the swallowed account, though there's no telling without seeing the DB firsthand. I've also got a couple of other MySQL guys I can pull from if needed, so there's that.

 

Ok it seems to be working again. thank you and I'll be sure to inform you if I find any other issues.

 

As I mentioned, you might be able to perform a query on them using his IP or his user_agent as "where" parameter, given that no other field contains better informations.

 

Sorry for the double post, but I realised there's a much better way to do this, without any false positives at all. You mentioned you have a backup of the old posts, you can run a query over that to retrieve a list of post IDs. First of all, you should import the old table in the new database, with a different name (e.g. posts_old). Then you can get away with a nested query. I don't know the structure of the IPB tables, so this is pseudo-SQL code:

Code:

UPDATE posts_new_table SET user_id = (blazer's new ID) WHERE post_id in (SELECT post_id FROM posts_old_table WHERE user_id = (blazer's old ID))

Of course I can't know if there are other differences between guest posts and user posts without looking at the actual tables, but this is a start. Also wow, I had to edit this message like 7 times before it recognised my edits, how retarted can this board software be? Is it too late to rollback?

 

While entertaining myself with the piles of ancient conversations SSRG has in store, I found one of Blazers disconnected "Guest" posts in this thread.

Hope this helps :3

EDIT: Oh okay... I'm not sure how this works, so...