Thanks you all - Well, I have another question about that - Can I DELETE users?
Thanks!
Peleg.
You can always just go into SQL and delete users.
TK
-----Original Message----- From: mediawiki-l-bounces@Wikimedia.org [mailto:mediawiki-l-bounces@Wikimedia.org] On Behalf Of FreeAll Support Sent: Tuesday, March 28, 2006 5:48 AM To: mediawiki-l@Wikimedia.org Subject: Re: [Mediawiki-l] Duplicate a wiki or a wiki database - DELETE users
Thanks you all - Well, I have another question about that - Can I DELETE users?
Thanks!
Peleg.
_______________________________________________ MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
Deleting users is a double-edged sword. It's simple enough to do in SQL but could cause problems when breaking the relational structure of the database. A safe option would be to update the archive, revision and recentchanges tables, altering the numeric user_id foreign key to be 0 for each of the rows corresponding to users you want to delete, then deleting them.
This way, MediaWiki treats the user as nonexistent and won't throw up bizarre errors in obscure places later on.
Rob Church
On 28/03/06, FreeAll Support support@freeall.org wrote:
Thanks you all - Well, I have another question about that - Can I DELETE users?
Thanks!
Peleg.
MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
Moin,
On Tuesday 28 March 2006 16:22, Rob Church wrote:
Deleting users is a double-edged sword. It's simple enough to do in SQL but could cause problems when breaking the relational structure of the database. A safe option would be to update the archive, revision and recentchanges tables, altering the numeric user_id foreign key to be 0 for each of the rows corresponding to users you want to delete, then deleting them.
This way, MediaWiki treats the user as nonexistent and won't throw up bizarre errors in obscure places later on.
Is there a maintainance script to do this?
best wishes,
Tels
On 28/03/06, Tels nospam-abuse@bloodgate.com wrote:
Is there a maintainance script to do this?
When I've fixed and committed it.
Rob Church
Moin Rob,
On Wednesday 29 March 2006 20:37, Rob Church wrote:
On 28/03/06, Tels nospam-abuse@bloodgate.com wrote:
Is there a maintainance script to do this?
When I've fixed and committed it.
Cool, thanx in advance,
Tels
mediawiki-l@lists.wikimedia.org