I was getting a SQL statement error with one of your queries. The error was unknown column 'true' in 'where clause'. The problem can be found in the following statement within modules/templatename/no_account.php about line 119

$check_email_query = "select count(*) as total
from " . TABLE_CUSTOMERS . "
where customers_email_address = '" . zen_db_input($email_address) . "'
and COWOA_account != true";
The COWA_account field is a tinyint field, so 'true' is not a valid value. I'm not sure about the != in SQL, but I know <> works. So, the following change makes the code work for me.

$check_email_query = "select count(*) as total
from " . TABLE_CUSTOMERS . "
where customers_email_address = '" . zen_db_input($email_address) . "'
and COWOA_account <> 1";
Tim