Restore a Deleted Members Account - How-to and Troubleshooting - wpForo 2.0

RE: Restore a Deleted Members Account

Macky — Wed, 04 Sep 2024 17:01:40 +0000

OK, its seems ot be all sorted now, maybe it just needed more time for the process to complete :) Thanks for the help everyone!!

RE: Restore a Deleted Members Account

Macky — Wed, 04 Sep 2024 14:41:53 +0000

Ok this time it worked, and the SQL said:

558 rows affected. for the posts and

16 rows affected. for the threads

I have deleted all caches like you explained in the previous posts, but the amounts on the users profile hasn't changed. What am I missing?

RE: Restore a Deleted Members Account

Macky — Wed, 04 Sep 2024 10:49:05 +0000

@robert Thanks Robert, ill give it a shot mate

RE: Restore a Deleted Members Account

Robert — Wed, 04 Sep 2024 09:50:16 +0000

@percysgrowroom,

Hmm, I asked you to change the red marked prefix wp_ , you've removed and changed the secondary _wpforo_ prefix as well. Please only change the red marked prefix: https://wpforo.com/community/postid/117172/

DO NOT REMOVE _wpforo_ part.

`wp_3cy42zznwz_posts` should be `wp_3cy42zznwz_wpforo_posts`

`wp_3cy42zznwz_topics` should be `wp_3cy42zznwz_wpforo_topics`

RE: Restore a Deleted Members Account

Macky — Sun, 01 Sep 2024 15:30:07 +0000

@robert I have never changed any table names mate, I dont know wat I am doing in databases so have never messed with it other than when I truncated the reactions table under you guys instructions. Because the likes were being really slow..... anyway, this is what I was putting into the SQL:

UPDATE `wp_3cy42zznwz_posts` SET `userid` = 13186, `email` = '' WHERE `name` = 'Anonymous 12345' AND `userid` = 0;

UPDATE `wp_3cy42zznwz_topics` SET `userid` = 13186, `email` = '' WHERE `name` = 'Anonymous 12345' AND `userid` = 0;

Does this help explain what the issue is? I have numerous sites on the same server so maybe thats why the table are different? I am not sure, but eager to get it fixed. Please let me know what to do next

RE: Restore a Deleted Members Account

Robert — Sun, 01 Sep 2024 14:21:52 +0000

@percysgrowroom.

It seems you've changed the table name. Please leave the SQL you're using here. Make sure the "`" symbols are not removed and the single quotes are not deleted. You've broken the SQL syntax for sure.

RE: Restore a Deleted Members Account

Macky — Sat, 31 Aug 2024 19:16:04 +0000

@robert I have followed these instruction exactly, my tables have different names from the standard names. It keeps coming up with this error:

#1054 - Unknown column 'name' in 'where clause'

RE: Restore a Deleted Members Account

RealAct — Tue, 27 Aug 2024 23:00:20 +0000

@percysgrowroom send me PM on your forum with some info where we could chat live. My username on your forum is @eli

RE: Restore a Deleted Members Account

Macky — Tue, 27 Aug 2024 19:07:06 +0000

@robert Thanks Robert, I appreciate you clearing that up for me mate :)

RE: Restore a Deleted Members Account

Robert — Tue, 27 Aug 2024 19:03:23 +0000

@percysgrowroom,

There is no any risk here. If the "Anonymous 1234" is set correctly then all will be fine, it's not set correctly then nothing will be changed. So please move forward and do that without any worry. Just copy and use the Anonymous user name you see on his/her posts.