removing users - strange behavior

Posted: Fri Mar 30, 2007 7:05 am

Hi,

I'm using CNB YA 4.4.2 for a while now.

Deleting a user before I installed CNB YA, always left the forum posts of the deleted user available. This is desired behavior.

Using CNB YA I noticed that, removing a user also removes the form posts (does not display) of this user as well. This is not good.

Any thoughts?

Sells PC To Pay For Divorce Joined: Posts: 5661

removing a user in cnbya ?
But that just disables the user right? , it doesnt delete the user..

Posted: Sat Mar 31, 2007 3:22 am

It takes more than one step to be able to delete (remove) an active user.
1. disable user
2. remove user

The thing is that in std. nuke the delete methode will some how keep the forum posts of this user.
The delete methode of CNB YA does not do that.

Posted: Sun Apr 01, 2007 8:13 am

Standard nuke changes the user_id of forum posts of deleted users to that of the admin. Not doing this can have bad effects like throwing the database tables out of synch.

New Member Joined: Oct 31, 2005 Posts: 2

I have been searching for a fix for this exact problem for several months. I don't know of any more terms, phrases or sites that I can search for a fix.

Just to be clear what my problem is; when I deactivate a user, then remove them (delete user account) from the database. Any posts that they authored in my forums disappear. These post should be given a different user_id and remain in the forums. However, The posts are not removed from the database, they are simply not associated with an active user_id any longer and are not displayed. They should be reassigned a default user_id automatically.

If this issue is a byproduct of CNBYA 4.4.2 and is not fixable, I will gladly go back to the standard Your_Account module.
I know it can with CNBYA in some capacity, because I have it working on one of the sites I help admin. However, that site, which is the only one it works on, was converted *phpbb forum database over to run on Ravens Distro 7.6.

If anyone has a fix, or has a link, or has anything that might help me resolve this problem, please help me out. It would be greatly appreciated.

Thank you,
TWChad.

Posted: Fri Jun 15, 2007 3:22 pm

I have taken a little deeper look into the problem.

It is correct, that the standard nuke "delete user" function replaces all post of this user ID with the user ID 1, hence the anonumous.
It does some "more complex" sql queries and then modifies the user ID field.

The delete function of CNBYA just removes the user ID form the users table, which causes the discribed behavior. Sad

The CNBYA function seems to be quite equal to the original procedure, as far as my understanding of the code is.
On the other hand, what resons or use cases where given to design the CNBYA functions this way:?:
IMO cut'n paste would have done the job.

I've not gotten to test some experimental cut'n paste code yet. Rolling Eyes

Was'nt there something like version 5 of CNBYA?
Maybe this problem is adressed.

Posted: Fri Jun 15, 2007 8:46 pm

This is not a fix, but a alternate solution:

I found out that if you delete a user through the Forum Admin Panel instead of using the CNBYA Admin panel, the user will be deleted and that users posts will be re-associated with Anonymous and stay intact in the forums. Essentially this will eliminate the problem described in this thread.

Hopefully if 5.0 ever happens, this problem will be eliminated all together.

Hope this helps someone else.

As you can see I've been a member of a long time and simply using the search feature I have been able to find a fix for all my problems up until now.
Thanks again for an awesome site and all the contributions from everyone.