Support Forum
Support Forum
Offline
I have an issue and don't know what's causing it.
I have posts that are changing from the user they posted under to being posted under guest. I tried to use the "recount user posts" button to see if that would fix it but it did not. I'm not able to reassign either, I get an error: 'A Suspect Request has been Rejected' which means plugin conflicts I believe.
This is happening to me as a moderator and to my users as well.
http://khanduras.net/forums/mo.....-mod/#p156
qualakon is myself and maldreth is a member of the site.
Is there a way to see what's going on? Have you seen this before?
Edit: It's also made some of us New Members
Offline
the only way for a post to be reassigned to a guest is if the wp user is deleted... remember, all users are wp users not forum users...
as to the reassign, what are you entering for new user? it should be the user id (a number)... and assume you running 5.3.1?
Visit Cruise Talk Central and Mr Papa's World
Offline
I appreciate the prompt reply, thanks for your assistance.
I am using SP 5.3.1
My bad, I was using the user name, it allowed me to reassign via user id.
Should have read the sign.
Can you think of why this happened? The users weren't deleted as I am still qualakon with the same user id and can post with new posts going to my name. I'm just curious so I can prevent it from happening to other users. So far it's hit three different members.
Offline
well, as I said, we dont have a facility for changing them like that short of deleting the user...
for a post in question, what is the user id of the poster (look in sfposts table - you can get the post id via the forum tools properties)? does that user id match the user id of the poster in sfmembers table?
guess you could also make sure the the users match up in wp users table vs sfmembers table... you didnt import users or anything did you?
Visit Cruise Talk Central and Mr Papa's World
Offline
Well I'm not too sure how it happened, but I was able to change all the NULL posts back to the appropriate user id. It only happened to some posts, not all. And only to three users, Admin, Mod and a prominent user.
It simply converted the post to a Guest post, copied the appropriate data back into Guest name and email so it was easy to fix. Hard to say what caused it though.
Regardless I appreciate the support. Thanks for that.
Offline
glad you are back where you want. please let us know if you see it happen again...
Visit Cruise Talk Central and Mr Papa's World
Offline
I changed the admin for security reasons and I deleted the admin before I reassigned the forum postings. Now the admin is a guest but doesn't show the forum posts associated with it to reassign them. There are over 3000 to change the user id on and doing this one by one with phpmyadmin will take forever. Are there any solutions to make this go quicker?
Thanks
Offline
Deleting an active admin account is a really bad idea.... if you can select all of the posts that were once the this users and are now classed as guests then you can perform a single update query to change the user_id for all of them in one go. As long as you have suitable criteria to select them in the first place.
 |
YELLOW
SWORDFISH
|
Offline
@yellow-swordfish
Thank you for your reply.
Yes I can get them all to come up. They are the only ones in the user id column to have a null value. But I don't know how to write the update sql and replace with new text id number in phpmyadmin.
BTW I have done this manually for about 500 so far. Very tedious and time consuming work. I have noticed though that the number of posts under my new profile isn't changing at all when I change to my new profile id through sql. Any help and suggestions would be GREATLY appreciated.
Offline
If the value in the column is truly NULL then you can use a query such as:
UPDATE wp_sfposts SET user_id = XXX WHERE user_id IS NULL AND guest_name='';
Note:
- If your table prefix is NOT the default 'wp_' then change the table name accordingly.
- Replace XXX with your user ID.
- I have added the check for an empty guest_name in case any previous guest posts exist as they too have a user_id of NULL. Note these are two single quotes at the end NOT one double quote.
Assuming this is successful then when run go to the forum admin > toolbox > housekeeping and run the task to clean up the post counts.
Before doing the above make a BACKUP of your database!
|
YELLOW
SWORDFISH
|
All RSS1 Guest(s)