Extension talk:Renameuser

From MediaWiki.org

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)".

$this->tables['logging'] = array('log_user_text','log_user');

mysql> describe logging;
+---------------+---------------------+------+-----+----------------+----------------+
| 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              |                | 
+---------------+---------------------+------+-----+----------------+----------------+
10 rows in set (0.00 sec)

include_once('includes/SpecialRenameuser.php') ;

 
function newFromConfirmationCode...

  static function newFromId( $id ) {
          $u = new User;
          $u->mId = $id;
          $u->mFrom = 'id';
          return $u;
        }


  function newFromConfirmationCode( $code ) {

--- 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 );
 

patch -p0 <SpecialRenameuser_body.php.newFromName.patch

[edit] 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)

[edit] 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:

$this->tables = array(
  // 1.5 schema
  'user' => 'user_name',
  'revision' => 'rev_user_text',
  'image' => 'img_user_text',
  'oldimage' => 'oi_user_text',

  // Very hot table, causes lag and deadlocks to update like this
  /*'recentchanges' => 'rc_user_text'*/
);

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

[edit] 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

[edit] 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)

[edit] 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)

[edit] 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)

[edit] 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 rev:27703. --Raymond 06:32, 21 November 2007 (UTC)

[edit] 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)

[edit] 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)

[edit] 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)

[edit] 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)

[edit] 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:

1. Reading the disclaimer at the bottom of the page
2. Upgrading your wiki and not using ancient version of MediaWiki?

Nearly all extensions in SVN use the wfLoadExtensionMessages() 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)

[edit] 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 00:34, 14 April 2008 (UTC)¨

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

[edit] 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.)

[edit] 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)

[edit] 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 —The preceding unsigned comment was added by 207.45.248.20 (talk • contribs) . Please sign your posts with ~~~~!

[edit] 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)

[edit] 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. iAlex 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|C) 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)

[edit] 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|C) 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?

[edit] 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)

[edit] 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)

[edit] 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.