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

I pasted your patch-account_credentials.sql into my directory. I ran my update and this is what I get:

A database query syntax error has occurred. The last attempted database query was: "ALTER TABLE `account_requests` ADD acr_type tinyint(255) unsigned NOT NULL default 0, ADD INDEX acr_type_del_reg (acr_type,acr_deleted,acr_registration) " from within function "DatabaseBase::sourceFile( /var/www/info/extensions/ConfirmAccount/backend/schema/mysql/patch-account_credentials.sql )". Database returned error "1060: Duplicate column name 'acr_type' (localhost)"

I tried, just to test, commenting out the "ADD acr_type tinyint(255) unsigned NOT NULL default 0," line, but then I am back to my 1170 error