Newsletter-Only Subscriptions for v1.3x

So I should delete all the files associated with the mod again and reinstall? Ok, I'll try that. Thanks.

Hi NotGoddess,

I'm still having problems with the subscription_manager.php script within extra_functions. They keep giving me the '1267 Illegal mix of collations' error message when trying to send out newsletters. Tried applying the directions in an earlier post by Dr. Byte for hours in all sorts of variants but only ended up with parsing errors. Don't know what to try next.

Quote:

---

Originally Posted by DrByte

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:

Code:

---

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:

Code:

---

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' ;

---

---

Did you try this out with success? If so I would really appreciate it if you could give me directions on how to change the code without wrecking it. I'd really like to start using the newsletter functions of Zen Cart but keep running into this.

Somehow I have gotten this to work - after my previous QUOTA issue. I tried again and based on the error message, added the includes/templates/YOUR_TEMPLATE/templates files to the template_default/templates folder as well as to mine.

Really, I have not much of a clue what I'm doing. It's just trial and error!

But I'm glad I've gotten this to work. I hope these other probs get resolved too b/c this is such a great add-on.

davale,
check out post 428, It fix the 1267.

You will find shortly after that that you will need to do the fix in 431 as well.

Thanks for your help Virtualahmad,
I deleted all the files and reinstalled the mod. Still no sidebox. I noticed if I add the subscribe.php file to my Sidebox folder, I'm able to choose the subscribe sidebox in Admin/Tools/Layout Boxes Controller, after I set the box up, it messes up my website. So I have to remove it and add it to my YOUR_TEMPLATE file which now it doesn't show up in Admin/Tools/Layout Controller as an option.

Is there anything else I can try?

when you say "YOUR_TEMPLATE" folder, is that the actual name of the folder you are putting the file in ?

Just using the "Your_Template" as provided in the mod. Mines is my own site name. This is where I added Subscribe.php and all my overrides into.

you should be adding all the files that are currently in the "your_template" folder to whatever your template folder is. So for example, if you FTP to your site, and look in the /includes/templates/ folder, if you have "template_default", "classic", "your_template", and "trustit", and you are using the "trustit" template, then all your files should be put in the corresponding "trustit" template folders.

unless I am misunderstanding what you are saying...

Big Thanks to Virtualahmad.
I now have my Newsletter Subscribe Sidebox. :clap:

One last question(hopefully)...the box to add your email address isn't wide enough. It seems to cut off the word address. Is there a way to widen this? Thanks.