Is it possible to change a usernumber id from 2 to 1? I ended up merging wrong and I wanted my main user to be user number 1, not 2. Is it possible to do this without corrupting the few thousand posts I have made? If so, do I need to know much mySQL coding, or do anything super major? A small tut on how to do this (if at all possible) would be nice!
No i don't believe so as the user id1 is already taken i'm not sure if you delete the user id 1 then try and do it but honestly wouldn't try it on a live board
Well you can try altering the table user i think and try changing the primary key of the user to 1
Oooh, such a really bad idea!
Userid is used all over the place as a foreign key, changing it is a really bad idea. You will need to change access, administrator, adminlog, usergroup, announcement, announcementread, article, attachment, calendarmoderator, cpsession, customavatar, customprofilepic, post...
I cant be bothered listing thhe rest, but basically it is most of the tables.
Userid is used all over the place as a foreign key, changing it is a really bad idea. You will need to change access, administrator, adminlog, usergroup, announcement, announcementread, article, attachment, calendarmoderator, cpsession, customavatar, customprofilepic, post...
I cant be bothered listing thhe rest, but basically it is most of the tables.
Yea i wasn't too sure on what to do just my guess =]
Userid is used all over the place as a foreign key, changing it is a really bad idea. You will need to change access, administrator, adminlog, usergroup, announcement, announcementread, article, attachment, calendarmoderator, cpsession, customavatar, customprofilepic, post...
I cant be bothered listing thhe rest, but basically it is most of the tables.
Exactly.The same also applies to forumids.I did try to alter them in the tables once and the ids placing got screwed up!Not advisable to!
07-23-2007, 04:35 PM
Stupid Question about users
Not advisable to!
Linear Mode
