Topic on Project:Support desk

Trying to install ConfirmAccount extension, however when I run the update.php script, I get the following error.

Renaming eu_wiki_id -> eu_local_id... already done.

• _mime_minor fields are already long enough.

Creating account_requests table...A database query syntax error has occurred. The last attempted database query was: "CREATE TABLE `account_requests` (

acr_id int unsigned NOT NULL auto_increment,
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 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 ,
PRIMARY KEY (acr_id),
UNIQUE KEY (acr_name),
UNIQUE KEY (acr_email(255)),
INDEX (acr_email_token),
INDEX acr_type_del_reg (acr_type,acr_deleted,acr_registration)
) TYPE=InnoDB

" from within function "DatabaseBase::sourceStream". Database returned error "1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=InnoDB' at line 28 (127.0.0.1)"

Could you offer some help to a newby?

Honestly, more likely there's something wrong with the extension, then it is you're doing something wrong. If no one else responds here, you might want to try contacting the author of the extension.

It looks like the extension was using the old TYPE= syntax instead of ENGINE=. This is fixed in trunk.