Newsletter-Only Subscriptions for v1.3x

[Alex Clarke]

I've just installed the latest version of this contribution and ran into the following error.

When clicking on the install button from the Customers | Subscription Management page (in my Zen Cart Admin) I receive the following error message.

1364 Field 'query_keys_list' doesn't have a default value
in:
[INSERT INTO zen_query_builder (query_category, query_name, query_description, query_string) VALUES ('email,newsletters', 'Email Test Group - Newsletter-only subscribers', 'Returns name and email address of Newsletter-only subscribers designated in Email test group configuration.', 'SELECT s.email_address as customers_email_address FROM TABLE_SUBSCRIBERS as s LEFT JOIN TABLE_CONFIGURATION as q on LOCATE( s.email_address, q.configuration_value) >= 1 WHERE configuration_key = ''NEWSONLY_SUBSCRIPTION_TEST_GROUP'' ') ]
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.

Anyone else experienced this or know of a work around?

[CJPinder]

I've just installed the latest version of this contribution and ran into the following error.
When clicking on the install button from the Customers | Subscription Management page (in my Zen Cart Admin) I receive the following error message.
Anyone else experienced this or know of a work around?

Hmmm... that looks like a bug. Attached is a zip file with an updated subscription_manager.php file. You need to unzip it then upload it to admin/includes/functions/extra_functions . Hopefully it should fix the problem. I haven't had a chance to test it but it should work.

Regards,
Christian.

[Alex Clarke]

Thanks Christian, that fixed it.

Did this have something to do with MySQL running in strict mode?