eNewsletter isn't sending anything...

What version of Drupal are you running?

I haven't tested this on PHP5 or Apache 2.x so there might be issues there.

Anyone succesfully running enewsletter on PHP5 or Apache 2.x?

Hi, just updated eNewsletter, and added some simple debugging messages which will display if view yoursite.com/cron.php

If you have time please update, there is a new UPDATE.txt to guide you, and let me know what results you get.

Hi ! I've the same problem. I've uninstaled the old version. That was sending emails. With a bad format I don't know why!

So I've resolved to try this new version. All is in place, but I cant seem to see any emails getting out.

Also I cant see any check box to include a new article on the newsletter. But If i go to an old article I can see that checkbox unchecked. When I check the checkbox and re-submit the article and go back to him (Not using browser back button) the box it's un-checked again. Wen I edit and article I can see the check box but have the same problem. Also at the Data Base I never see any new entries on the "publication_nodes" table.

I tried with old and new articles.

The cron says: Time to send newsletter: Newsletter At least 1 subscriber: YES

But when I go to the site:
Publication Send Start Sent
Current manual 0
Previous 2006-01-06 22:21 0

And I get no email.

In the old version (not the CVS one) the only problem I had was with formating.
My drupal it's ver. 4.6.5

Regards,

The newsletter is not sending because there are no nodes included.

You should be seeing this in cron:

"At least 1 node in newsletter: YES"

How old is the version you're updating from?

Also, have you checked the content type you want is enabled for enewsletters?

admin/node/configure/types

Thank you..

I forgot about the the content type: admin/node/configure/types, That fixed it. Thank you very much!

Now still have the same problem that I had in version eNewsltter V7

The email that arives at the subcriber. Has some text before the real newsletter. I mean beafore the:
"Dear ....,". I'm using the Default HTML Template

I give you an example (It's from the email Source Code): The text I wrote it's some "a a a a a a a a" with the title: "teste3":
--Source--

<p>teste3 a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a<br />
<a >Web page...</a>';http://eventosenegocios.com/enewsletter/preferences/3/ZZAvACzp = 'http://eventosenegocios.com/enewsletter/preferences/3/ZZAvACzp';http://eventosenegocios.com/enewsletter/account/ZZAvACzp = 'http://eventosenegocios.com/enewsletter/account/ZZAvACzp';?&gt;Dear Escapadelas,<br />
in the latest issue of Newsletter.</p>
<p><h1>teste3</h1><p>a a a a a a a a a a a a a </p><p>a a a a a a a a a a a a a </p><p>a a a a a a a a a a a a a </p><p>a a a a a a a a a a a a a </p><p>a a a a a a a a a a a a a </p><p>a a a a a a a a a a a a a </p><p>a a a a a a a a a a a a a </p><p>a a a a a a a a a a a a a </p><p>a a a a a a a a a a a a a </p><p>a a a a a a a a a a a a a </p><p>a a a a a a a a a a a a a </p><p>a a a a a a a a a a a a a </p>
<a href="http://eventosenegocios.com/node/212">Web page...</a></p>
<p>Update your details: <a href="http://eventosenegocios.com/enewsletter/preferences/3/ZZAvACzp">Update</a><br />
Unsubscribe: <a href="http://eventosenegocios.com/enewsletter/account/ZZAvACzp">Unsubscribe</a></p>

--Source---

Regards,

Sorry! The version I had was: Dev release 8

Wow, I'm surprised it works at all!

I included a warning on the bottom of the README.txt not to update from the old developer previews to the newer versions. There where a lot of database changes, and I still need to work on an update script to safely make the change.

What you could do is just create a new template and switch the newsletter to that, might work better.

Be sure to keep a backup of your database, and test well before using it live.

Hi!

I've been all Sunday around this issue. Let me add more data:
I've backed up the old version. I still have the old enewletter DBs in the server after all the Tables are different. The module files are easy to replace.
I've just installed the new version to see if the error still remained.

I'm back to the Old version:
enewsletter.module,v 1.18 2005/05/11 15:13:10
enewsletter_send_receive.inc,v 1.11 2005/05/11 15:13:11
html2txt.module,v 1.3 2005/05/11 15:13:11

The last newsletter I sent in December 2005 went ok. The first I sent this year not.
I started to think what was different on the site. And I remembered that I upgraded Drupal from:
4.6.4 to 4.6.5. Was just uploading files and no change on the database. That was the only difference.

Could that cause this issue?

I've tried to create a new Newsletter add my self to it and create a new article. But I get always the same error. I've tried in TXT and HTML.

I've about 300 user on the Official Newsletter. I'm supposed to send a new one next Wednesday. But things are not looking good.

Regards,

Just to had up more info:
This issue happened at both my sites: escapadelas.com and eventosenegocios.com
I'm using the Multisite feature: Two Databases but only one folder with all drupal files.

Warning, I haven't had much time to work on the update script or to test it, so use this with caution...

Attached is a list of all the changes that were made to the database since v8.

On the back up of your v8 database make the changes in the file.

Next you also need to convert some of the data...

Look in enewsletter.module for this line:

   //$items[] = array('path' => 'admin/enewsletters/update', 'title' => t('update'), 'callback' => 'enewsletter_update', 'access' => $administer);

Delete the // at the begining of the line to uncoment the code. You will now have an 'update' link in the menu (admin/enewsletters/update)

Click on that to update the data.

Comment out the line of code above - it should only be run once!

Check if that's worked. To check create a new template and a new email.

Hi!

I've revoved the old module files, inserted the SQL one by one on MySQL, also upgraded on the Drupal Enewsletter nenu once.

I got this error now: "Fatal error: Call to undefined function: schedule_count_qued() in /home/ruiaxe/public_html/escapadelas/modules/enewsletter/enewsletter.module on line 114"

Mmmh, that's weird, I ldid a search for "schedule_count_qued" in the enewsletter.module, but it's not there.

Can you check you're using enewsletter.module version:

// $Id: enewsletter.module,v 1.16 2005/12/21 01:16:07 MegaGrunt Exp $

The other file enewsletter_send_receive.inc should be:

// $Id: enewsletter_send_receive.inc,v 1.5 2005/12/18 18:41:23 MegaGrunt Exp $

I had :(

$Id: enewsletter.module,v 1.4 2005/09/25 22:07:27 MegaGrunt Exp $

$Id: enewsletter_send_receive.inc,v 1.2 2005/09/25 12:10:24 MegaGrunt Exp $

But now I don't see the newsletter I had. I can see it on the Database on Publications
But not on the Drupal interface: Message: "There are no email newsletters".

Ohh I forgot to tell! I've installed the new files. But still no newsletter

Could you do an SQL dump of these tables and attach it here:

publication_terms
publications
publications_nodes

I can take a look, and maybe see where things have gone wrong.

Here it is:

OK, in 'publications' table, add a field:

`type` varchar(20) NOT NULL default ''

For each publication give `type` a value of 'enewsletter'.

Announcements has been split of into a seperate announcement.module, I haven't had time to get that working again, but you can get more or less the same functionality by not including $nodes in your template and setting it to manual send out.

You'll have to set your newsletters to a new template, because the way template choices are stored has changed, so it needs to refresh - should look something like this in the db 'publications' table, templates:

a:2:{s:4:"html";s:1:"2";s:4:"text";s:1:"1";}

You can drop these fields:

`template_text`
`template_html`
`start'
`first`
`next`
`last`
`every`
`frequency`

I'm realy sorry for giving you all this trouble.

Well I did what you said. And the results are this:

I can see the Newsletter I had. But. It has no subscribers on it!

I tried to create a new newletter for testing porposes but it doesn't send any email. I get this on the Cron job: "Time to send newsletter: teste"

Also I get this erros on Drupal:
------
Unknown column 'w.hash' in 'field list' query: SELECT s.*, u.*, w.hash FROM subscribed s LEFT JOIN identity_hash w ON w.uid = s.uid LEFT JOIN users u ON s.uid = u.uid LEFT JOIN bounced_email_count b ON u.mail = b.email LEFT JOIN schedules_sent m ON (m.uid = s.uid AND m.publication_id = s.publication_id AND m.pub_time = '1136768553') WHERE s.publication_id = '7' AND (b.bounces IS NULL OR b.bounces < '2') AND m.sent IS NULL ORDER BY s.uid LIMIT 0, 50 em /home/ruiaxe/public_html/escapadelas/includes/database.mysql.inc na linha 66.
--------
Unknown column 'hash' in 'field list' query: INSERT INTO identity_hash (uid, hash) VALUES ('1', 'koYlJE4L') em /home/ruiaxe/public_html/escapadelas/includes/database.mysql.inc na linha 66.
--------
Unknown column 'hash' in 'where clause' query: SELECT uid FROM identity_hash WHERE hash = 'koYlJE4L' LIMIT 1 em /home/ruiaxe/public_html/escapadelas/includes/database.mysql.inc na linha 66.
--------
Unknown column 'hash' in 'field list' query: SELECT hash FROM identity_hash WHERE uid = '1' LIMIT 1 em /home/ruiaxe/public_html/escapadelas/includes/database.mysql.inc na linha 66.

If don't mind and have MSN menseger add me: " povinho AT hotmail DOT com ".I'll be here after 19h00 I'm from Portugal I've the same Time Zone has UK. That way I get you and Admin account to the site and you can verify for yourself.

Again I'm sorry for all the trouble.

I don't have MSM, but you can catch me on Skype or AIM. If you click on my contact tab and send me an email I'll send you my details directly.

Closing this as there is no specific issue, and thread is getting side tracked.

I need eNewsletter Module in drupal 6.x.
If You have that module then pls send me in my email address.
My email address is raj.c8887@gmail.com

I have a Drupal 5 version that is being used on some projects, but still need to update it to Drupal 6. Anyone interested in sponsoring the port to Drupal 6 please get in touch.

gwwprogrammer: Please do not hijack existing issues for your own issue, please open a new one instead. Reverting the title.