Hello,
I'm trying to configure the Cowa mod in version 1.3.8 on IIS6. I'm copying the files to the directories as required and when I paste the queries into the box and hit send this is what I get:
1364 Field 'query_keys_list' doesn't have a default value
in:
[INSERT INTO query_builder ( query_id , query_category , query_name , query_description , query_string ) VALUES ( '', 'email,newsletters', 'Permanent Account Holders Only', 'Send email only to permanent account holders ', 'select customers_email_address, customers_firstname, customers_lastname from TABLE_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.
Can someone help? I'm stumped.
Thanks!
Bookmarks