Thread:Project:Support desk/ConfirmAccount extension sql error/reply

Add

$wgShowSQLErrors = 1;

to the bottom of LocalSettings.php and try again to see the query, which causes the actual error.

Just for clarification: You use MediaWiki 1.20.x and not MediaWiki 1.2.0, right?