Thread:Project:Support desk/Errors 1170 and 1146/reply (5)

Ahh, that was my fault when typing in here. When running the update script again, it says "unsigned"

The last attempted database query was: "ALTER TABLE `account_requests` CREATE TABLE IF NOT EXISTS `account_credentials` ( acd_id int unsigned NOT NULL auto_increment PRIMARY KEY, acd_user_id int unsigned NOT NULL, acd_real_name varchar(255) binary NOT NULL default , acd_email tinytext NOT NULL, acd_email_authenticated varbinary(14) default NULL, acd_bio mediumblob NOT NULL, acd_notes mediumblob NOT NULL, acd_urls mediumblob NOT NULL, acd_ip VARCHAR(255) NULL default , acd_filename VARCHAR(255) NULL, acd_storage_key VARCHAR(64) NULL, acd_areas mediumblob NOT NULL, acd_registration varbinary(14) NOT NULL, acd_accepted varbinary(14), acd_user int unsigned NOT NULL default 0, acd_comment varchar(255) NOT NULL default '' ) ENGINE=InnoDB, DEFAULT CHARSET=utf8 " from within function "DatabaseBase::sourceFile( /var/www/info/extensions/ConfirmAccount/backend/schema/mysql/patch-account_credentials.sql )". 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 'CREATE   TABLE IF NOT EXISTS `account_credentials` ( acd_id int unsigned NOT NULL' at line 2 (localhost)"