Newsletter-Only Subscriptions for v1.3x

[NotGoddess]

Is it possible to put the newsletter form on other pages that aren't part of the shop?
I have a blog and I would like to put the newsletter join form on the sidebar..is there a code that I could cut and paste on it?!

You can use the module 'show sidebox on external page' (http://www.zen-cart.com/index.php?ma...products_id=79) to do this. This would keep all the names/etc inside zencart, and they would be directed to the subscription pages there.

If you wish something completely separate from your cart you would want to look into a separate newsletter program like phpMailer or GroupMail.

-Ng_

[picou]

Hello,
After installing Everything seems to work just right until I try to send an email.
This is the error on the >tools>send e-mail page. (admin/mail.php)

-----------------
1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_german1_ci,IMPLICIT) for operation 'locate'
in:
[SELECT c.customers_email_address as customers_email_address FROM zen_customers as c LEFT JOIN zen_configuration as q on LOCATE( c.customers_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.
-----------------

I am using
Database: MySQL 4.1.9-max
PHP Version: 4.3.10 (Zend: 1.3.0)
HTTP Server: Apache/1.3.33 (Win32) PHP/4.3.10
Zen Cart 1.3.0.2

Could someone help?

[NotGoddess]

1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_german1_ci,IMPLICIT) for operation 'locate'

If you google 'illegal mix of collations' you'll get a lot of entries about this-basically it's saying the two tables (or fields) have the same language but different accents so can't compare. That or that the input is treated as a different collation (and same result).

In base, it's a MySQL problem. Usually they tell you to upgrade, but you can try checking the collations on those two fields to see if they compare, manually change, or run through the various search results you get on google (try searching first with your MySQL version in the query string to see if there are specific fixes for that version.

I'll try to see what I can do. Unfort I have to work within the confines of the query builder & audience.php for this or else hack them more than is done but there might be an alternative.

-Ng_

[picou]

I'm not confortable in MySQL stuff.
I did a search in My SQl and this is the return:

----------------------------
requête SQL:
SELECT *
FROM `new`.`zen_query_builder`
WHERE `query_id` LIKE '%customers_email_address%'
OR `query_category` LIKE CONVERT( _utf8 '%customers_email_address%'
USING latin1 )
COLLATE latin1_swedish_ci
OR `query_name` LIKE CONVERT( _utf8 '%customers_email_address%'
USING latin1 )
COLLATE latin1_swedish_ci
OR `query_description` LIKE CONVERT( _utf8 '%customers_email_address%'
USING latin1 )
COLLATE latin1_swedish_ci
OR `query_string` LIKE CONVERT( _utf8 '%customers_email_address%'
USING latin1 )
COLLATE latin1_swedish_ci
OR `query_keys_list` LIKE CONVERT( _utf8 '%customers_email_address%'
USING latin1 )
COLLATE latin1_swedish_ci
------------------------------

Is this any indication? What should I do?
Thanks for your help

[NotGoddess]

Picou,

I've been looking for a quick fix and can't find, other than those I already recommended.

For now, as long as you aren't using the test group, I suggest you just remove that statement from the query_builder table.

You can use phpMyAdmin to find it or run this in your sql patch page of the tools menu:

DELETE from zen_query_builder
WHERE query_name LIKE '%Email Test Group%';

I'll keep seeing if I can find another solution that will allow you to use the test group.

-Ng_

[DrByte]

NotGoddess,

I haven't studied your code or docs which likely explain the purpose of this query:

SELECT c.customers_email_address as customers_email_address FROM zen_customers as c LEFT JOIN zen_configuration as q on LOCATE( c.customers_email_address, q.configuration_value) >= 1 WHERE configuration_key = 'NEWSONLY_SUBSCRIPTION_TEST_GROUP'

Am I correct that you are attempting to find email addresses from the customers table which are listed in the NEWSONLY_SUBSCRIPTION_TEST_GROUP constant?

If so, then there may be a couple workarounds:

Option A: ensure that the group entries are delimited using % and , and ' -- like this: '%[email protected]%', '%[email protected]%', '%etc%', '%etc%'

Then change your query to:

SELECT c.customers_email_address as customers_email_address 
FROM customers as c 
LEFT JOIN configuration as q 
  on c.customers_email_address 
  LIKE  q.configuration_value 
WHERE configuration_key = 'EMAIL_FROM' ;

Option B: ensure that the entries are delimited with ' and , --- like this: '[email protected]', '[email protected]', 'etc', 'etc', 'etc'

Then use a query like this:

SELECT c.customers_email_address as customers_email_address 
FROM customers as c 
LEFT JOIN configuration as q 
  on c.customers_email_address 
  IN  (q.configuration_value) 
WHERE configuration_key = 'EMAIL_FROM' ;

I haven't tested exhaustively, but this may provide a workaround or perhaps help steer you in another direction.

[NotGoddess]

Thank you, DrByte. I'll most definately check those out. I tried joins originally but never quite got my syntax correct.

-Ng_

[bci7]

I am trying to send a newsletter through the tools newsletter feature. I created a newsletter using the drop down box. I save the newsletter. The status of the newsletters shows an X that says false? How or where do I send the newsletter? I know I can send email through the send email feature. Whats the point of having both the email and newsletter feature?

Thanks
Blain

[NotGoddess]

I save the newsletter. The status of the newsletters shows an X that says false? How or where do I send the newsletter?

Hi Blain. This thread is for the contribution, not general questions, but I answer anyway. Did you 'lock' the newsletter? After you 'save' you should have 2 options: preview or lock. You preview the letter to ensure it looks okay, then once it's all set to go, you lock it. Once a newsletter is locked you then get additional options to send it.

-Ng_

[picou]

Ok, the fix worked on the send e-mail portion.
Thanks.

I get another error when trying to access customers>customers:
Parse error: syntax error, unexpected '}' in /home/www/c292f5d8b8cfe582a86b725956f88de3/web/boutique_vin/admin/customers.php on line 1215

I've opened /admin/customers.php to see what is the problem, but there are only 1192 Lines.

What do you suggest?
Thanks