Thread:Project:Support desk/Errors 1170 and 1146

Hello all, and thank you for your time

I am using Mediawiki 1.19 and using the ConfirmAccount extension. When I go to accept an account, I receive this error:

(SQL query hidden)

from within function "AccountConfirmSubmission::acceptRequest". Database returned error "1146: Table 'tuxmicro_mwiki.account_credentials' doesn't exist (localhost)".

I researched and found that it is because I need to run my update for php, so I ran

php maintenance/update.php

In doing so, I receive this error:

Database returned error "1170: BLOB/TEXT column 'acr_email' used in key specification without a key length (localhost)"

I went to extensions/ConfirmAccount/backend/schema/mysql/patch-account_credentials.sql and deleted "ADD INDEX acr_type_del_reg"

When I rerun the php update script, I then get a 1064 error. From here, I am lost