COWOA email issue

[monicaverma]

I did a full install of COWOA 2.0c - store stopped working, removed COWOA and restored store files from backup.

I also traced back my steps mentioned in the install file
- In the tpl_header.php file reset the line to the original
<?php if (($_SESSION['customer_id']) { ?>
- Removed from /includes/filenames.php
define('FILENAME_ORDER_STATUS', 'order_status');

Now admin not sending email. Cannot send newsletters, or email

New account emails and email after orders are being sent.

Error I get is
"1054 Unknown column 'COWOA_account' in 'where clause'
in:
[select customers_email_address, customers_firstname, customers_lastname from zen_customers where COWOA_account != 1 order by customers_lastname, customers_firstname, customers_email_address ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields."


I am using the following versions
Zencart version v1.3.9f
COWOA 2.0c
OS/Hosting Type: Linux / 4GH Web Hosting
PHP Version: PHP 5.2

My store is being hosted on a GoDaddy LInux server.

Any help will be very appreciated.

Thanks!
Monica

[FFNick]

We were getting this exact same error running Zen Cart 1.3.9 without COWOA. A plain vanilla install.

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 ':email AND COWOA_account != 1' at line 9

line number is irrelevant because fault is much further down.

Find header_php.php somewhere in /includes/modules/pages/login/

includes/modules/pages/login/header_php.php

First of all make a backup copy of header_php.php by adding an X at end of .php EG (header_php.phpx)

Now edit a copy of header_php.php by looking for

WHERE customers_email_address = :email

and change :email to :emailAddress
Save and upload, replacing faulty header_php.php

:emailAddress appears a few lines later.

This is repeating an answer from an earlier thread for current users.