Please post a print screen of a post so we can see what you mean. It's not clear what the problem is at the moment.
Reactivate banned members now guests
Collapse
X
-
The mod that is supposed to restore not only the user but his/her posts flat out does not work.Nelson
www.Hobby-Machinist.comComment
-
I believe posts are linked with a userid, even if you delete the user the post will still have his id.
if you restore the user correctly with the same userid and he's not showing up in posts then you need to try some rebuilds:
Maintenance -> General Update Tools -> Update User Titles and Ranks
Maintenance -> General Update Tools -> Rebuild Thread InformationPlease feel free to contact me if you have any questions or concerns
Links: vBulletin Manual - Code Documentation - FAQ - Bug Tracker - Lemon Juice
vBulletin 5 Connect: Extensions - Articles - Features - PurchasesComment
-
Comment
-
I believe posts are linked with a userid, even if you delete the user the post will still have his id.
if you restore the user correctly with the same userid and he's not showing up in posts then you need to try some rebuilds:
Maintenance -> General Update Tools -> Update User Titles and Ranks
Maintenance -> General Update Tools -> Rebuild Thread Information
I think at this point, I should give up. I don't have the knowledge to do this, and there is no current mod that works with VB 4.2PL2.Nelson
www.Hobby-Machinist.comComment
-
I checked this with the database, when you delete a user all his posts userids converted to 0 but it is not the case with threads. User threads will still hold the ids.
If you have any experience with queries you can execute this to have his post back:
Code:UPDATE post SET userid = 'X' WHERE username = 'Y';
change Y to the user namePlease feel free to contact me if you have any questions or concerns
Links: vBulletin Manual - Code Documentation - FAQ - Bug Tracker - Lemon Juice
vBulletin 5 Connect: Extensions - Articles - Features - PurchasesComment
-
I checked this with the database, when you delete a user all his posts userids converted to 0 but it is not the case with threads. User threads will still hold the ids.
If you have any experience with queries you can execute this to have his post back:
Code:UPDATE post SET userid = 'X' WHERE username = 'Y';
change Y to the user nameMy Live vB5 Site - NZEating.com
vBulletin Hosting | vBulletin Services - Need hosting for your vB? Need it installed? Something else? Let me take that hassle off your hands.Comment
-
the query assign ids where a specific user name exist. For example if all of your posts userid = 0 I can retrive the id like this:
UPDATE post SET userid = '46668' WHERE username = 'Ace';
Here if I delete Ace first, I should retrieve his user row and id 46668 also before running this query.Please feel free to contact me if you have any questions or concerns
Links: vBulletin Manual - Code Documentation - FAQ - Bug Tracker - Lemon Juice
vBulletin 5 Connect: Extensions - Articles - Features - PurchasesComment
-
So if I understand, I have to restore the user first using the restore- user mod then run this query somewhere in the database using PhPadmin. I'm not sure where I would run this. If I make a copy of the database using PHP Admin, can one of you guys who know what you are doing walk me through this.
thanks again.Nelson
www.Hobby-Machinist.comComment
-
So if I understand, I have to restore the user first using the restore- user mod then run this query somewhere in the database using PhPadmin. I'm not sure where I would run this. If I make a copy of the database using PHP Admin, can one of you guys who know what you are doing walk me through this.
thanks again.Nelson
www.Hobby-Machinist.comComment
-
So if I understand, I have to restore the user first using the restore- user mod then run this query somewhere in the database using PhPadmin. I'm not sure where I would run this. If I make a copy of the database using PHP Admin, can one of you guys who know what you are doing walk me through this.
thanks again.Please feel free to contact me if you have any questions or concerns
Links: vBulletin Manual - Code Documentation - FAQ - Bug Tracker - Lemon Juice
vBulletin 5 Connect: Extensions - Articles - Features - PurchasesComment
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Comment