Is there a way to delete a user login account?
Thanks,
Chuck
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
www.mimesweeper.com
**********************************************************************
Chuck,
First, find the user_id for the account you wish to delete e.g.
select user_id from user where user_name = 'old_user_name';
Assuming they have no contributions, you can just delete the user record. e.g.
delete from user where user_name = 'old_user_name';
However, if the reason you are deleting is because you have two user accounts for the same person, and the old user account has already been used to make edits, and you want to merge the two accounts, you also need to fix several other tables to point to the new username e.g. lets say the old user_id is 66, and the new user_id is 99:
update old set old_user_text = 'old_user_name' where old_user = 66;
update cur set cur_user_text = 'old_user_name' where cur_user = 66;
update recentchanges set rc_user_text = 'old_user_name' where rc_user = 66;
update archive set ar_user_text = 'old_user_name' where ar_user = 66;
update image set img_user_text = 'old_user_name' where img_user = 66;
update old set old_user = 99 where old_user = 66;
update cur set cur_user = 99 where cur_user = 66;
update recentchanges set rc_user = 99 where rc_user = 66;
update archive set ar_user = 99 where ar_user = 66;
update image set img_user = 99 where img_user = 66;
Note that the user_id and user_name fields are duplicated in each of these five tables (for performance reasons).
There may be a script to do all this that I am unaware of. If so can someone please mention it.
If you just want to change the user name, then just update the user_name on the user table and the user_text on the other five tables. Again, there may be a script for this.
Michael Richards
-----Original Message-----
From: mediawiki-l-bounces(a)Wikimedia.org
[mailto:mediawiki-l-bounces@Wikimedia.org]On Behalf Of Chuck Bishop
Sent: Monday, October 04, 2004 3:30 PM
To: mediawiki-l(a)Wikimedia.org
Subject: [Mediawiki-l] Delete user account
Is there a way to delete a user login account?
Thanks,
Chuck
We were also able to reproduce this behavior (changes being overwritten) when both users were editing without being logged in. Since we have an internal wiki we made login mandatory before editing pages to avoid this problem (and because many people were asking for it anyway), but that of course is not possible on many installations.
Michael Richards
PS http://meta.wikimedia.org/wiki/Require_users_log_in_to_edit
Gartnerpedia Installation:
Suse SLES 9 Linux
Apache 2.0.49-27.8
MySQL 4.0.18-32.1
PHP 4.3.4
Mediawiki 1.3
We just upgraded from 1.3.0_beta4 to 1.3.5. All went well except one
of our main contributors is reporting that on every page she now sees a
message of the form:
Retrieved from "http://www.thisurl.whatever"
in which it shows the URL of the current page as a link.
It shows up just below the last of the text in an article, within the
article block. She is using XP and sees the problem in Netscape 7.1
and AOL 8.0, whether logged in or not.
I don't see it, whether using OS X/Safari/IE/Netscape, or Windows 98/IE.
Any ideas what it could be and how to get rid of it?
Thanks,
Michelle
Hi Rowan,
this is what I would have expected.
I did the test again and it worked as you've described it, unless the
conflicting editings are done under the same username. I don't know if
this is a bug or feature, but shouldn't be a real problem.
Thanks for you help,
Steffen
Hi,
I have pages which contains "Ant" and "CVS" in header and normal text.
But if I search for "ant", "Ant", "ANT", "cvs" or "CVS" I get no matches.
I added "Ants" to the page text and a search for "ants" is successfull.
Is there a minimum length for search terms and if so why I don't get a
message informing me about that fact?
A search for "cvs" in Wikipedia is successfull by the way...
Ciao,
Steffen
Hi,
Dan Kelley wrote:
> Yes, 3 characters is the minimum. Apparently that can be changed but
I've read that, too. But in fact, 4 characters seems to be the minimum,
at least up to version 1.3.3.
Markus
> it requires changing something about the database, so I didn't bother
> when I learned that.
>
> On Oct 2, 2004, at 7:07 AM, Steffen Siebert wrote:
>>
>> Hi,
>>
>> I have pages which contains "Ant" and "CVS" in header and normal text.
>> But if I search for "ant", "Ant", "ANT", "cvs" or "CVS" I get no
>> matches.
>>
>> I added "Ants" to the page text and a search for "ants" is successfull.
>>
>> Is there a minimum length for search terms and if so why I don't get a
>> message informing me about that fact?
Hi,
a little test with mediawiki showed that if two users are editing the
same page in parallel, the changes of the user who saves last overwrites
(removes) all changes the other user saved.
Is it possible to enable database locking (either optimistic or
pessimistic) to prevent this?
Ciao,
Steffen
After upgrading my version of MediaWiki, my images directory was somehow
corrupted. I tried replacing the files from backup, but that didn't work
for some reason. (Sorry, this was a while ago.)
I re-uploaded all my files, but now the links in my wiki pages don't point
to the same paths in my upload directory. How can I fix this? Do I have to
run md5sum on all my files, and update the md5 in the database?
Thanks,
David
_____________________________________________________________________
David Coppit david(a)coppit.org
The College of William and Mary http://coppit.org/
"Government big enough to supply everything you need is big enough to take
everything you have ... The course of history shows that as a government
grows, liberty decreases." -- Thomas Jefferson
Hi folks
I just downloaded mediawiki and was trying to install it.
However, the configure script fails with the following error message:
Fatal error: Cannot redeclare class namespace in
/hobbes/public_html/wiki/includes/Namespace.php on line 57
What's wrong? The configure-directory is fully read- and writable (even to
everyone at the moment)...
Thanks for any answers
thomas