My account

[<|TGC|Rezak>]

Well...
Do you remember when all recent users got lost?
That day i tried to log in, and as expected - it said wrong login/password...
The next day i tried to log in again, and this time it did! With my login and password it logged in... so i thought that site admin found the way to rescue the users data...
The only thing was that when i logged in i had a new avatar (the one you can see now) which i never set up... well, i thought, a little bug but ok...
But today i realised this thing - go to my profile and click the link "Find all posts by <|TGC|Rezak>" - you will see 22(!!!) posts which i have never writen!!!
Also my profile doesn't seem mine old...
I guess in some way my login had been associated to an other user, the only thing that is mine - is only login and password...
--------------------------------------------------------------------
Example:
http://www.sog-team.co.uk/forum/showthread.php?t=1514
:wtf:

[Matt]

Indeed, and this issue is to be expected all over the forum. The main problems alot of us will encounter are listed below:

- Posts associated with wrong users
- PMs (Private messages) associated with wrong users
- Profiles of new registered users will be incorrect or associated wrongly.

You ask why? well the table we lost due to corruption was called "user" which stored everything to do with a user including profile, username, password etc

However, posts, PMs and arcade scores etc are stored in another table that was not corrupted. Basically these tables contain user ID's which should correspond to the users concerned, but since losing 200 forum accounts last week, those user ids do not exist. Instead as people re-register over the user ID, they automatically get associated with whatever was there previously. With me? ;)

So, I shall look into your account mate, will remove what you didnt post but I need you to update your profile with your details or correct them if wrong.

Thanks

[<|TGC|Rezak>]

Sure, i understand, i was thinking of something like this...
So is the problem in the ID field of users table wich is auto-increment, and new registering users get associated the ids already used for old users?
In this case you can just insert-delete some empty rows, to reach the old ID number i think...
Anyway there is absolutely no problem mate, feel free to leave my fake messages, ect, i dont care...

[Matt]

Close mate ;)

It could be done like that, but it needs to be done in 14 tables opposed to one. The User table is correct now, but the others are not working in conjunction with it. The others say for instance that User X posted a message "hello" with user id 340, when in fact now we have a latest user id of 234. In that respect, the post has no person associated with it. However, should someone register in 340, the post becomes assigned to them as well as the other 13 tables associating things like profile, pms & arcade scores from the old user X of id 340. The list is endless and every table of 240 ids onwards would need to be corrected.

However, im using alot of MYSQL queries to correct alot of it ;)

So, instead, we are warning new registerants of the issue and inform them to update their profile again while I remove any possible PMs from previous on there account etc.

Long job indeed, but one table I will physically be correcting is the "pm" table, as ill try to restore as many as possible to those who may have lost them.

[Tim]

Yeah, it seems the easiest thing would be to scrap the whole DB all together ..... *Looks for delete button* ... JK ..... On Topic, as Matt said everyone else is having the same issue, and not sure if just adding tables to the DB with the missing IDs would make the difference and it would/could be a bit time consuming .... I think :s

EDIT: Matt posted before me and I understand better now :lol:

[<|TGC|Rezak>]

Yeah, i got it now Matt
Anyway, even using your example - if the latest user id is 234 now - add and delete for example 200 rows, so the next user who will regist - will have the id 435... and no user will have the id 340 in the future...

[Tim]

Or ... you can just delete the 200+ rows that are existing from the other tables of the DB and you won't have that problem with new users :) ... sounds easier doesn't it?

[<|TGC|Rezak>]

Yeah sure, but it is not good to delete rows used by scripts i think... never know what can happen...

[Matt]

If you are half an expert with MYSQL and vbulletin, you will understand deleting rows or tables is detremental to the websites running.

SQL Queries are a wiser choice as long as you know what each does ;)