forum sub-area missing

Worker Joined: Feb 09, 2011 Posts: 188 Location: US

I created a user name from the same computer I created my admin name. I didn't have any issues with my forums till I changed the name/ updated the information for rn.htaccess to .htaccess.
After I did, the username that I created as a testing name (to make sure people could create accounts, etc.) started showing up in the forums in place of the admin postings. I deleted the name from MySQL nuke_user table, and it deleted the whole forum, not just the admin post.

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

That should not have deleted any forums. They probably just aren't showing because there is no user_id to match to. Use phpMyAdmin and look at your forum tables, in particular the bbposts, bbposts_text, and bbtopics. They are probably still there.

Posted: Mon Feb 14, 2011 10:04 am

I looked and the post, and the forum topic are still there, so how do I get them back, or include the new post in line with the old post? Sorry, newbie here.

Posted: Mon Feb 14, 2011 11:07 am

In the future, I would not edit the MySQL nuke_user table directly unless something is broken. Use the edit users link in admin instead.

as far as retrieving posts from a deleted user? ummm, not sure about that. anyone?

Posted: Mon Feb 14, 2011 11:16 am

I'm trying to find a topic where I tried to walk a person through something like this.

Posted: Mon Feb 14, 2011 12:35 pm

Is there a way to change the post back to the original user (ie: me). I don't know how the usernames got crossed, but the post that I put in as one user, got crossed and said it was the other user name that I created (ie: wrote by "George", but started showing up as "Ralf". I thought deleting the user account "Ralf" would fix it back to "George". If I am making any sense here.

Posted: Mon Feb 14, 2011 12:56 pm

You need to add a user record with the user_id of the person who created the topic/posts. Look in bbposts and/or bbtopics to get the user_id. Then insert a record into the nuke_users table with that user_id using phpMyAdmin. Other than adding a password and user name, just let the other values default unless you know them. Be sure to select the MD5 option for the password. That will restore the posts. Then you will need to contact the User to get the additional information. You could also pull the user record from a backup if you have a recent backup. Assuming you get that far, you will need to also update the the user's number of posts in the nuke_users table. I'm pretty sure you can find the code to do that in the forums.

Posted: Mon Feb 14, 2011 5:21 pm

If it is just one post then I would just change the id to your id instead of creating a user.

thumpn8974, go into the Your_Account administration and tell me the ID number of the user that you want this post/topic to belong to. I will give you a script to fix it.

Posted: Tue Mar 08, 2011 2:16 pm

It is okay, I ended up deleting the site and starting over again by installing an earlier backup. (always back up your site before making changes)<~ had to learn that the hard way.

registered · Posted: Sat Mar 12, 2011 8:01 am

thumpn8974 wrote:

. (always back up your site before making changes)<~ had to learn that the hard way.

And, always test your changes/updates locally using a copy of your site BEFORE you go and do it on your live site. I've used XAMPP for many years for this purpose. It creates an entire WAMP or LAMP environment for you to "play" in on your PC.

Posted: Sat Mar 12, 2011 10:57 am

I have never heard of that before. I will look into it; thanks for the info!