Thread:Project:Support desk/Installation Extension ConfirmAccount

Hello,

I have troubles installing the "confirm account" extension. I use MediaWiki 1.18., PHP 5.2.17 and MySQL 5.1.49.

I started as described at the page: Loading the current snapshot, install it to the extension directory, writing the require_once line to the localsettings.php. Since I do not have shell access and the maintance script does not work via webbrowser, I used to start the install script in the mw-config folder again.

Unfortunatly, the script stopped during the database update giving the following error messages:

(...) ...user_former_groups table already exists. Creating account_requests table... An error occured: Es gab einen Syntaxfehler in der Datenbankabfrage. Die letzte Datenbankabfrage lautete: „CREATE TABLE IF NOT EXISTS `account_requests` ( acr_id int unsigned NOT NULL auto_increment PRIMARY KEY, acr_name varchar(255) binary NOT NULL default , acr_real_name varchar(255) binary NOT NULL default , acr_email tinytext NOT NULL, acr_email_authenticated binary(14) default NULL, acr_email_token binary(32), acr_email_token_expires binary(14), acr_bio mediumblob NOT NULL, acr_notes mediumblob NOT NULL, acr_urls mediumblob NOT NULL, acr_ip VARCHAR(255) NULL default , acr_filename VARCHAR(255) NULL, acr_storage_key VARCHAR(64) NULL, acr_type tinyint(255) unsigned NOT NULL default 0, acr_areas mediumblob NOT NULL, acr_registration char(14) NOT NULL, acr_deleted bool NOT NULL, acr_rejected binary(14), acr_held binary(14), acr_user int unsigned NOT NULL default 0, acr_comment varchar(255) NOT NULL default  ) ENGINE=MyISAM, DEFAULT CHARSET=mysql4 “ aus der Funktion „DatabaseBase::sourceFile( ixxx/xxx/extensions/ConfirmAccount/ConfirmAccount.sql )“. Die Datenbank meldete den Fehler: „1115: Unknown character set: 'mysql4' (localhost)“.

Since the database is now corrupted, I need to do a db dump in order to install a previous version.

I used the script without problems before updating my older version to 1.18. When I choose to install confirmaccount, I get error messages, when I uncheck the extension (only installing all the other extensions), it works fine.

Any help is appreciated!