Extension talk:Renameuser/Archive 2

log_user_text
Hi, I'm getting this error message when trying to rename a user in MW 1.15.1: A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:

(SQL query hidden)

from within function "RenameuserSQL::rename". MySQL returned error "1054: Unknown column 'log_user_text' in 'where clause' (xenon.ion.lu)". I noticed that the extension tries to do this on line 392 in SpecialRenameuser_body.php $this->tables['logging'] = array('log_user_text','log_user');

although there's no such field in the logging table: mysql> describe logging; +---+-+--+-+++ +---+-+--+-+++ +---+-+--+-+++ 10 rows in set (0.00 sec)
 * Field        | Type                | Null | Key | Default        | Extra          |
 * log_id       | int(10) unsigned    | NO   | PRI | NULL           | auto_increment |
 * log_type     | varbinary(10)       | NO   | MUL |                |                |
 * log_action   | varbinary(10)       | NO   |     |                |                |
 * log_timestamp | binary(14)         | NO   | MUL | 19700101000000 |                |
 * log_user     | int(10) unsigned    | NO   | MUL | 0              |                |
 * log_namespace | int(11)            | NO   | MUL | 0              |                |
 * log_title    | varbinary(255)      | NO   |     |                |                |
 * log_comment  | varbinary(255)      | NO   |     |                |                |
 * log_params   | blob                | NO   |     | NULL           |                |
 * log_deleted  | tinyint(3) unsigned | NO   |     | 0              |                |


 * Hi,
 * We are getting the same error at http://www.appropedia.org. We would like to use this to get rid of some inappropriate vandal names that appear in the author footers on some pages.
 * Thank you, --LRG 23:27, 30 November 2009 (UTC)


 * Hi All,
 * Any progress on this? Appropedia is still having the error, and now a member is requesting a rename.  If anyone wants to work on this, we would love to assist.  Thank you, --LRG 04:01, 2 January 2010 (UTC)


 * Hi,
 * After searching blindly, I came across a bug fix in Release r51997 on 16 June 2009 for bug #3732 which added the field log_user_text.
 * My wiki also gets this error message although I too am running 1.15.1 which was released after this date.
 * This has exhausted my knowledge. Hope it helps someone else go further and resolve this problem. --GarethLewis 02:56, 16 January 2010 (UTC)


 * Running extension from trunk?
 * I would guess that you are propably running Renameuser from trunk, just change to the corresponding branch instead using:  - change path appropriately - and then use   - if that doesn't do it, try going back to REL1_14 in the path. Kasper Tikjøb Andersen 12:59, 25 January 2010 (UTC)

Fails silently
I was just trying to rename a user, and while it accurately notes whether the source user doesn't exist or the target user exists, it seems to fail silently on reasonable requests. I submit two usernames, get returned to the screen with neither error nor success message, but find the move to have failed... after 4 tries, it worked. This may just have been general unhappiness of the db, affecting many things; I filed it as a transient bug (4969). Sj 02:36, 12 February 2006 (UTC)

I can't seem to get the extension to show itself. : < --Markthebike 06:52, 10 April 2006 (UTC)

What about earlier MW versions?
Could someone advise me where to get this extension for MediaWiki 1.6.8? We're not allowed to upgrade to MW 1.7x, as we don't have PHP 5 running on our server yet...

I heard this extension was available for MW 1.5x, so where could we get those earlier versions for pre-1.7 MediaWiki? Thanks for helping. --Faterson 19:53, 8 August 2006 (UTC)

One more for the 1.6.8 request... Aquatiki 02:12, 22 August 2006 (UTC)

SpecialRenameuser.php from SVN rev 13413 worked fine for our intranet's 1.6.6 install. 68.13.123.37


 * Ditto on the 1.5 version: I found it was once possible here.

I would be very happy too to get the earlier version, because i have to stick to MediaWiki 1.6.9. --84.170.249.59 10:40, 5 February 2007 (UTC)


 * Well, this looks very helpfull --84.170.250.214 15:08, 6 February 2007 (UTC)

Help
Shouldn't there be any instructions on how to install the extension or did I miss the article which describes how to install extensions in general, to which nevertheless shall be referred to (by a link or so) from this article ? Just copying the three files to  seems not to be enough.

Any help is appreciated. Thanks in advance

--141.41.37.95 07:06, 18 September 2006 (UTC)

I solved it myself: That a file ExtensionFunctions.php has to be downloaded seems to be an important point.

Put it there where the LocalSettings.php is: [source]


 * Thanks for the help. The documentation for Renameuser is severely missing... *grumble*
 * --62.225.150.98 14:27, 25 September 2006 (UTC)


 * Could somebody please help me install this extension? I am not a wiki expert yet.
 * I have MediaWiki version 1.7.1


 * Thanks in advance!
 * --Baskolff 10:50, 31 October 2006 (UTC)


 *  The Solution is as follows: 

include_once('includes/SpecialRenameuser.php') ;
 * Get the ExtensionFunctions.php as mentioned above
 * Download the 3 Files and copy them in your includes/ Directory
 * Add following line to your Localconfig.php

Thats it !! Tested on Mediawiki 1.8.2 --Ckleber 09:15, 6 December 2006 (UTC)

Fatal Error
on 1.8.2: Fatal error: Call to undefined method User::newfromid in /mnt/198/0/wiki/includes/SpecialRenameuser_body.php on line 264

+2 to initial report (I get this error as well with mediawiki-1.8.2).

+1 to initial report (I get this error as well with mediawiki-1.7.1). The solution below fixes mediawiki-1.7.1 as well.

Fatal error: Call to undefined method User::newfromid in /.../extensions/Renameuser/SpecialRenameuser_body.php on line 330 on MW-1.7.1
 * I suppose the workaround beneath works, but shouldn't this be fixed in the extension instead? --Jamasi 01:06, 16 June 2007 (UTC)

Workaround:
seems to be a problem with 1.8.2 add the following lines in includes/User.php and it should work. Find the line function newFromConfirmationCode... and change into static function newFromId( $id ) { $u = new User; $u->mId = $id; $u->mFrom = 'id'; return $u; }

function newFromConfirmationCode( $code ) {

Patch
--- SpecialRenameuser_body.php.ORIG    2007-07-19 08:09:28.000000000 +0900 +++ SpecialRenameuser_body.php 2007-07-19 08:10:59.000000000 +0900 @@ -381,7 +381,7 @@                }                 // Clear caches and inform authentication plugins -              $user = User::newFromId( $this->uid ); +              $user = User::newFromName( $this->old ); $user->invalidateCache; $wgAuth->updateExternalDB( $user );

Save this as  in your   directory, then run: patch -p0 <SpecialRenameuser_body.php.newFromName.patch

Instructions for use
I added instructions, based on the above comments and my own experience, to the article. Thanks all for your help on figuring this out. --LRG 21:09, 15 January 2007 (UTC)

Quick Question
Will the user keep his contributions?

For example if i rename user X to user Y, will everything that user X edited appear as edited by user Y and the the contributions won't be all outa wack.--71.217.192.176 01:02, 7 February 2007 (UTC)

help
I did that, no error message came up or anything, but it didn't work.--X66x66 21:32, 5 April 2007 (UTC)

Why cant you keep the extension in a directory in Extensions?
Why do we need to copy an extension OUTSIDE the Extensions folder? Is this not an extension? --Kenny5 00:45, 14 April 2007 (UTC)
 * I have edit the installation directions to reflect this.--74.141.69.143 00:57, 14 April 2007 (UTC)

Doesnt do anything for Recent Changes
If we have an abusive user register with a bad username, this extension doesnt do anything to rename the occurance of that name there. --74.141.69.143 00:57, 14 April 2007 (UTC)
 * If your wiki is not under heavy load of edits you can remove the comment markers ( /* */ ) from the last but one line of this block:

You can find this in Renameuser_body.php at line 283. --Jamasi 01:34, 21 June 2007 (UTC)

Error messages when renaming and upon accessing Special:Allmessages
On my wiki, trying to rename a user gives:


 * Fatal error: Call to undefined function wfQueriesMustScale in /home/ihope/public_html/mediawiki/extensions/Renameuser/SpecialRenameuser_body.php on line 289

and trying to open Special:Allmessages gives both


 * Warning: require(/home/ihope/public_html/mediawiki/extensions/Renameuser/RenameUserJob.php) [function.require]: failed to open stream: No such file or directory in /home/ihope/public_html/mediawiki/includes/AutoLoader.php on line 302

and


 * Fatal error: require [function.require]: Failed opening required '/home/ihope/public_html/mediawiki/extensions/Renameuser/RenameUserJob.php' (include_path='/home/ihope/public_html/mediawiki:/home/ihope/public_html/mediawiki/includes:/home/ihope/public_html/mediawiki/languages:.:/pear/lib:/var/www/pear/lib') in /home/ihope/public_html/mediawiki/includes/AutoLoader.php on line 302

This page as it is now doesn't mention RenameUserJob.php as I can see. --71.205.100.59 21:02, 28 June 2007 (UTC)

works for me. Consider updating

Fatal error: undefined function wfQueriesMustScale
Even the same problem, when i filled in the form to change a user:

Fatal error: Call to undefined function wfQueriesMustScale in /var/www/xims/extensions/Renameuser/SpecialRenameuser_body.php on line 289

But no other errors ;)!


 * Your report is missing something quite important: version of your MediaWiki --Jamasi 02:09, 30 June 2007 (UTC)
 * Fixed, this was a backwards-compatibility issue. Aaron 03:12, 30 June 2007 (UTC)

Special:Renameuser not accessible by neither Bureaucrat nor Sysop
Hey, my administrator user in my MediaWiki 1.6.10 system (installation verified through Special:Version) has both Bureaucrat and Sysop rights (from some time '^_^), and I can't see the Special:Renameuser page in the list, nor access it by using Go!. What's the problem?.

-Smiley 00:57, 29 July 2007 (UTC)

Ugh! I found out it may be that it requires PHP5, which I don't have. Grr...

-Smiley 00:57, 29 July 2007 (UTC)

no braces?
This didn't work for me (mediawiki 1.7.1): require_once( "{$IP}/extensions/Renameuser/SpecialRenameuser.php" );

Instead, this did: require_once( "$IP/extensions/Renameuser/SpecialRenameuser.php" );

Consider updating? --68.2.74.79 03:04, 12 September 2007 (UTC)

Please fix a language error
Please change the following line in SpecialRenameuser_body.php:
 * $success = $oldPage->moveTo( $newPage, false, wfMsg( 'renameuser-move-log', $oldusername->getText, $newusername->getText ) );

to
 * $success = $oldPage->moveTo( $newPage, false, wfMsgForContent( 'renameuser-move-log', $oldusername->getText, $newusername->getText ) );

because now it uses the user language, not the content language, and this makes the following error:

I have Dutch as my user language, and I have renamed a user, you can see the log in English and the log in Dutch. You can see it's both in Dutch, please fix that error.

Thanks, SPQRobin 17:12, 20 November 2007 (UTC)


 * Fixed with 27703. --Raymond 06:32, 21 November 2007 (UTC)

Not moving subpages
I notice that it moves the user page and the talk page, but what about sub pages? 69.54.2.183 05:33, 2 December 2007 (UTC)

Class 'Job' not found
I'm running MediaWiki 1.11.0, PHP 5.2.3 (cgi-fcgi), MySQL 5.0.24a-standard-log

Unfortunately, I'm stopped with a very basic error:

Fatal error: Class 'Job' not found in (snip)/extensions/Renameuser/RenameUserJob.php on line 6

The only related reference to "class job" I've found online shows abstract class Job is defined in includes/JobQueue.php

I've verified my installation has includes/JobQueue.php. I have *not* installed the ExtensionFunctions.php mentioned above, as that code seems to have no reference to Job, and is circa version 1.7.

Can someone point me in the right direction?

Thanks! - Thunderrabbit 18:32, 21 December 2007 (UTC)
 * You can either update MediaWiki or get older versions from branches/extensions. Aaron 23:57, 20 February 2008 (UTC)

One exception - signatures
Signatures are currently not updated with this tool and instructions suggest changing them manually. This treats signatures like they are marginal tools when in reality they are all over the place and make the wiki's main way for user interaction. I think it's time to add signatures to this tool. Surely someone can think of technical ways to implement this.

Maybe future signatures would be an internal part of the display somehow and thus could be changed automatically, but currently they're manual and they should be dealt with. -79.181.126.193 11:36, 31 December 2007 (UTC)


 * The old name should be a redirect to the new one, so it is not that big of an issue. Aaron 19:12, 31 December 2007 (UTC)

Version requirement incorrect?
The page claims the minimum requirement is "MediaWiki version 1.7.0", but it's attempting to call wfLoadExtensionMessages, which as far as I know is a 1.11 addition. Should this be updated? --Krenn 20:52, 20 February 2008 (UTC)
 * Someone updated all of the extension messaging and didn't update these pages. It probably should be updated. Aaron 23:56, 20 February 2008 (UTC)

Call to undefined function wfLoadExtensionMessages

 * MediaWiki: 1.10.0
 * PHP: 5.2.5 (cgi-fcgi)
 * MySQL: 5.0.24-community-nt
 * Website: (Company intranet wiki)

This morning I added the four files for Renameuser to the ...\extensions\RenameUser directory. I then added require_once( "${IP}/extensions/Renameuser/SpecialRenameuser.php"); to my LocalSettings.php file. Now when I click on the Special Pages link to get to Special:Special page, I get the following error:  PHP Fatal error: Call to undefined function wfLoadExtensionMessages in C:\Inetpub\wwwroot\mediawiki\extensions\Renameuser\SpecialRenameuser_body.php on line 9  I tried removing the curved brackets from IP in the require_once, but the error persists. Does this mean I need to use the ExtensionsFunction.php above? If not, what could cause this problem? --Fmmarianicolon 16:09, 26 February 2008 (UTC)


 * Update your wiki to 1.11 or a newer version. The function wfLoadExtensionMessages is not present in 1.10, the require_once call and curly brackets/lack of those have nothing to do with that. -- Sayuri 16:22, 26 February 2008 (UTC)
 * Who's the genius that left reference to it working on 1.7 and up in the main page content then? I just went all through downloading and installing this, only to notice this detail in this talk page when it didn't work! --Anon


 * How about:
 * Reading the disclaimer at the bottom of the page
 * Upgrading your wiki and not using ancient version of MediaWiki?
 * Nearly all extensions in SVN use the  function as of now. If you want a version that works with 1.7, try using one of the older ones. Renameuser might've been designed - or worked - once on 1.7, but things change. -- Sayuri  13:32, 11 March 2008 (UTC)

There is an easy fix for missing wfLoadExtensionMessages: just make your own one. I use 1.10.x and I have put the next function into my file LocalSettings.php, and now every extension that uses wfLoadExtensionMessages works fine. function wfLoadExtensionMessages( $extensionName ) { global $wgExtensionMessageFile; global $wgMessageCache; if ( empty($wgExtensionMessageFile[$extensionName]) || !$wgExtensionMessageFile[$extensionName] ) { $wgExtensionMessageFile[$extensionName] = true; require( "extensions/$extensionName/$extensionName.i18n.php" ); # adapt the path if necessary foreach ( $messages as $lang => $langMessages ) { $wgMessageCache->addMessages( $langMessages, $lang ); }       }        return true;

} Happy wikiing! Lexw 15:12, 21 July 2008 (UTC)

Username with accent to usename without accent (impossible)
Hi, (and sorry for my poor english)

I need to rename a user which current name is Exâmplenáme to Examplename. I cannot do it. I get the following error: You cannot rename a user to the same thing as before. May someone help?

Many thanks. 84.227.30.77 23:31, 13 April 2008 (UTC)


 * I don't know what the problem is or how to solve what is casuing it, but I do have an idea for how to solve this specific dillemma. Rename the user to something such as Examplename2. Then, rename the user again to "Examplename".  See if that works. Smaug  [[Image:Tournesol.png|20px]] 00:34, 14 April 2008 (UTC)¨


 * Thank you. I will try it! --84.226.33.114 14:27, 15 April 2008 (UTC)

What does the "block log" button do?
Does anybody know what this button does?

(And by the way, a nice idea might be to build context sensitive help into these extensions. Just a thought.  Or how about special pages automatically providing links to mw:help:extension name, or some similar solution.)

Headers Already Sent
I get this error

Warning: Cannot modify header information - headers already sent by (output started at /home/codev/public_html/en/w/extensions/Renameuser/SpecialRenameuser.php:1) in /home/codev/public_html/en/w/includes/WebResponse.php on line 10

Any idea on what to do to fix this? Thanks.--71.221.196.127 03:06, 20 May 2008 (UTC)
 * What version of MW and what SVN revision of renamuser? Aaron 03:42, 20 May 2008 (UTC)
 * MediaWiki 1.12.0
 * PHP 5.2.5 (apache2handler)
 * MySQL 5.0.45-community
 * Renameuser Revision 35072 (the current one)--71.221.196.127 05:17, 20 May 2008 (UTC)


 * When does this happen? Add error_reporting( E_ALL ); to the top of localsettings.php. Aaron 07:05, 20 May 2008 (UTC)
 * Whenever loading a page it happens twice at the top of the page 2 times and 5 more times at the bottom but the rest of the page will load, adding error_reporting( E_ALL ); to the top of localsettings.php dosen't make any noticeable diffrence.-71.221.196.127 13:40, 20 May 2008 (UTC)
 * Check your UTF Encoding for the files and concert it to utf-8. This fix the problem.--Ozz 17:05, 20 May 2008 (UTC)
 * What would be the easiest way to do that? I do not have any shell access to the server, only cpanel--71.221.196.127 20:23, 20 May 2008 (UTC)
 * I don't know cpanel, but i you have ftp access download the extensin again and convert it (maybe with Ultraedit) to UTF8 and upload again.--Ozz 04:50, 21 May 2008 (UTC)
 * Dosen't solve the problem.--CoDEVwiki 00:21, 23 May 2008 (UTC)

User and password are the same
If the password is equal to the new username, the user won't be able to connect, maybe the extension should verify that MD5(user_id,"-",MD5("new_username")) is different to password before changing username

error
Fatal error: Call to undefined method OutputPage::addWikiMsg in /www/free-site-host.com/j/d/r/jdrowwiki/htdocs/wiki/extensions/Renameuser/SpecialRenameuser_body.php on line 34

Any ideas? 80.189.51.96 15:24, 20 October 2008 (UTC)

FATAL ERROR
Fatal error: Call to undefined method AuthPlugin::getUserInstance in /home/mysite/public_html/wiki/extensions/Renameuser/SpecialRenameuser_body.php on line 425


 * ->>on line 425

/**	 * The old username *	 * @var string * @access private */	var $old;

/**	 * The new username *	 * @var string * @access private */	var $new;

/**	 * The user ID	  * * @var integer * @access private */	var $uid; Anyone can help me with this, I don't understand why I get this error with different username to change --189.182.41.5 09:26, 31 December 2008 (UTC)
 * AuthPlugin::getUserInstance has been introduced in 1.14, try to download an older version of this extension. i Alex  13:12, 31 December 2008 (UTC)
 * I get the same error. Downloading the one previous version of the extension doesn't solve it for me. --Smithjd 21:33, 13 January 2009 (UTC)
 * There are snapshots of three different versions of this extension in the extension distributor, and even older versions are available in SVN. Use the version that matches the version of MediaWiki you're running. —Emufarmers(T 03:22, 14 January 2009 (UTC)


 * I also got this error message... I have downloaded and installed Renameuser-trunk-r45661.tar.gz to the turnkeylinux-mediawiki version 1.13.2-1. When I changed a username it seemed, that everything worked correct ,... but as i dont know php: Is there any failure in my wiki system possible? And should I continue using it anyway?? Gregor --90.152.146.248 18:30, 16 January 2009 (UTC)
 * The Solution for me was: I downloaded the renameuser-version, with the same version as i have in my wiki (before I was blind...) installed it. Then i didnt get the failure again. --90.152.144.128 14:17, 3 February 2009 (UTC)

Blank page when hitting rename button
Ok, it's not working. These are my steps:
 * 1) Downloaded and unpacked (Version r44056)
 * 2) Transferred to mediawiki-root/extensions/Renameuser
 * 3) Added piece of code to LocalSettings.php
 * 4) Downloaded ExtensionFunctions.php
 * 5) Transferred to mediawiki-root/extensions

Result: I hit the rename button and a blank page loads. Argghh! On the screenshots it shows a kind of confirmation list about the changes after hitting the rename button, this is what is missing with my installation. Thanks for any help in advance. 62.143.129.61 14:53, 3 January 2009 (UTC)

Anyone? 62.143.129.61 22:06, 6 January 2009 (UTC)


 * Make sure you're running the latest stable release of MediaWiki (1.13.3). Renameuser could have broken compatibility even with 1.13, so you might be forced to use an older version if you're not willing to run 1.14 alpha.  Beyond that, check Apache's error log. —Emufarmers(T 03:55, 8 January 2009 (UTC)


 * I have the same issue. Apache error log says "Call to undefined method AuthPlugin::getUserInstance" What version would work with 1.13?

Bulk user rename
Has anyone written code that allows for lots of users to be renamed from the command line using the logic in this extension (bulk renameuser for mediawiki)?

The use case is a mediawiki where someone hacked User::isValidUserName to allow lower-case lowercase) usernames, which is something that I don't want to have to manually maintain between revisions until the end of time :-)

If not, I'll probably be doing so this weekend (as well as learning enough PHP to get by) and will post what I end up doing here... -- Djbclark 19:31, 8 May 2009 (UTC)

sql error message on 1.14
I just installed this extension on v1.14 and got this error message when I tried to use it.

A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:

(SQL query hidden)

from within function "RenameuserSQL::rename". MySQL returned error "1054: Unknown column 'log_user_text' in 'where clause' (localhost)".

Any ideas? --Jake4d 04:35, 16 July 2009 (UTC) PS: I am on a shared server with Siteground if that makes a difference


 * You're using the svn trunk version of RU. You need to get the one specific to REL_1_14. Either use /branches/REL1_15/extensions/Renameuser or download the specific snapshot for your MW version. --Morbus Iff 17:26, 20 July 2009 (UTC)


 * Works perfectly! Thanks, I must have been tired when I downloaded the extension and got the wrong one.--Jake4d 18:49, 20 July 2009 (UTC)

user does not exist...
I am having a problem trying to rename a user, actually any user, when i am logged in as an account in the sysop group that is not wikisysop.

The error returned is user (username) does not exist, it has the original user name.