@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'
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.
@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
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`
@robert Thanks Robert, ill give it a shot mate
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?
OK, its seems ot be all sorted now, maybe it just needed more time for the process to complete 🙂 Thanks for the help everyone!!