Hi, thanks for providing this plugin, exactly what I needed! Anyway, I noticed that if I post via email (I use postie to do that) no notifications are sent. Regular posts via the admin interface seem to trigger notifications just fine, not sure what the problem might be. Can anyone confirm this?

Hello there,
I just installed the plugin and everything seems fine. But somehow it won’t work.
I already changed the index.php as noted in the install.txt because the /maillist directory is in my wordpress directory, this solved the Problem with some errors when I tried to access the Email Notification settings. But still I don’t receive any mails. The confirmations and such are sent just fine, but I get no notifications. And btw, the Email Notification settings don’t show up in the Options BUT under Manage.
Any Ideas?

How are you posting to your blog?

Is notify set to “Yes”, post status set to “Publish” and are your posts NOT future dated?

Since your maillist directry is in your WordPress, this should work in the index.php file…

include (ABSPATH.”/maillist/wpemn_config.php”);

As noted above, “Moved the admin panel under the “Manage” Tab”.

I have (probably) the same problem as Vincent. I’ve installed the plugin, everything seems to work fine - the confirmation messages are sent, even the “Email List Subscribers” function works fine. The only problem is that I’m not receiving the notifications. I’m publishing posts in a regular way from the admin area, Notify Subscribers is set to yes and I’m not changing the date. Also the line is in the header file of my template.

Thanks for your help.

Hi -
Let me preface this comment by saying I am (unfortunately) a new user of wordpress & it’s plugins, so instructions are not always clear to me. So I apologize in advance for any stupid questions.

Everything “appears” to be in the right place now…. but….
When I go to “Manage”, then to “Email Notification”, I’m getting a db connect error - copied here:

Warning: mysql_connect(): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) in /hsphere/local/home/pavlik/kilvap.com/wp/wp-content/plugins/wp-email-notification/index.php on line 44

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /hsphere/local/home/pavlik/kilvap.com/wp/wp-content/plugins/wp-email-notification/index.php on line 45

I’ve doublechecked my /maillist/wpemn_config.php file and all of my DB settings appear to be fine. Also, the database is up and running (verified by successfully running “install.php”.

Likewise, I’m not getting any email when I users sign up for post notifications. Any help is greatly appreciated - Thanks!

After going back and reading previous comments from previous plugin releases, I went ahead and installed this plugin using the same DB that I installed my WordPress site with.

The Warning messages are still displayed on the “Manage > Email Notification” page, but at least I have the functionality now! I tested out everything and it all seems to work. Now if I could get the errors to go away…

Great plugin - should come in very handy!

Make sure that the index.php file is including the wpemn_config.php file…most likely the path needs updated and then everything will work.

Brian, could you confirm the behaviour I described in my first post above or is it just me again, messing things up as usual?
Nora

Hopefully someone else might know the answer to that one…I’ve never tinkered with posting via e-mail.

My hunch is that the plugin is either not being triggered due to the same reason there are some issues posting with clients like Ecto OR certain variables aren’t set.

I’m having the same problem as a lot of people. I upgraded from 2.2. I followed the instructions to the letter. I removed all of my subscribers except my email address. I then tested the upgrade. every function works except the actual notification of a new post. I post from the admin page. I don’t change the setting and it is set to notify by default. It worked fine in 2.2 but now with 2.3 it doesn’t. I can send an email from the “manage” area and the subscribe emails work. Just not the post. The comment emails even work. I suspect it has something to do with the “future post” feature but I don’t know.

Can anyone explain what the future post feature actually is for? I suspect that it is a trigger so that you can write a post with a future date and then it will send the post notification after that date. Someone tell me if I’m wrong!

Many people “future date” posts. Since future dated posts don’t show up until that date/time has past, notifications shouldn’t be sent until the post is “live” on the site.

I’m having trouble with your plugin. I followed the instructions that came with the plugin, and I added the extra line in the header. I also changed line 19 for line 22, and I subscribed a user to test the plugin.

I encountered 2 problems:

PROBLEM ONE: ERROR IN HEADER
I have the following errors in the header of my page

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/xxxx/public_html/wp-content/plugins/wp-email-notification/email_notification_2.3.php on line 369
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/xxxx/public_html/wp-content/plugins/wp-email-notification/email_notification_2.3.php on line 372

Both of these errors dissappear if I take out the extra line in the header

PROBLEM TWO: INCOMPLETE WRITE POST/PAGE
When I try to create or edit an existing post/page I get an incomplete version of it. I don’t get to see anything below the Save/Post buttons. If I disable the plugin it then renders the page completely

has anyone experienced this?

Problem one…from what I’ve seen in the past, it sounds like the DB connection info is either not being set or is incorrect.

Problem two…I’ve not seen that one. Do you have any other post releated plugins installed?

Brian was very helpful with the problem I was having since my upgrade to v2.3.

Problem: Posts were made from within the admin area and immediatly published. The email notifications were not being sent. All other “on-demand” email functions worked properly.

Solution: The problem I was having was related the the new “future-post” feature and the fact that I live in the Central time zone and my WP blog is hosted on the West Coast. Every post I made seemed to be a future post because I am 2 hours ahead of my server. My WordPress settings say -5GMT but my server is physically located at -7GMT. A change had to be made to the plugin file to accomodate this difference.

around line #135 and #360, you will find:
$curr_date = date(”YmdHi”);
had to be changed to:
$curr_date = date(”YmdHi”, time() + 7200);

where 7200 is the number of seconds (60 (seconds) * 60 (minutes) * 2 (hours)) difference between the two times. Of course, if you are in the same time zone as your server, you won’t have this problem and won’t have to edit these lines.

I hope I explained this easy enough! Email me if you have any questions!

Thank you, I solved the problem!!

Maybe I didn’t pay attention to what I was doing but now that I think of it I should have noticed it earlier. I assumed that when you use the install script it asks for your database because you can set one up just for WP Email Notification. i did this. I set a special database and well, obviously the required WP tables weren’t there!

This is why I had error number one, it was looking for a table and it didn’t find one. Error number two I believe was caused because the plugin needs to get the post information and also didn’t find the table. It gave no errors, but once I solved error number one it also dissappeared.

I’d like to make a suggestion for the plugin. Is it possible to include the installer inside the script so that when you install it and go to Manage>Email Notifications it asks you to install the plugin if necessary? It’s obvious that it needs to reside in WP’s database so this way you can ensure that this problems don’t happen to someone else…

Anyone got problem with Email Notification 2.3.0 and Chenpress 3.0 ?

When I activate the Email Notification plugin Chenpress disaspears from the edit box.

/Andreas

Created post,
saved it (as a draft),
future dated it,
saved again,
Opened again later, but published with, notify as “yes” and edit timestamp checked (set about 28 hours ahead).
The mail went straight out to list, when I thought it would only come later.
It is not present on the blog page, as expected.
Any ideas?

Another weird thing.
Today, I published, future dated by 5 minutes and I still have no email half and hour later.
Just me?
v2.2 worked fine for me.

Did you put the function call in your header file.

And was your site visited within that 1/2 hour? For it to work your page has to be hit in order to trigger the notification.

The comment referring to the time issue by David Peterson solved my issues with emails being sent at strange times. I am 12 hours ahead of my server which makes an even bigger difference.

Thank you Brian for kindly looking into my problem here, great plugin too.

I’m having the same problem as a lot of people here. Everything is working correctly but no posts are being sent. I’m also in the same time zone as my server, so that’s not the issue. I even checked the server time with a php script and all is well.

Now there’s this about “put the function call in your header file” and I’m not sure what that’s all about. Am I missing something?

I can’t get it to send out the emails either. Everything else works fine and dandy. Server time is even the same as wordpress time too. Am I missing something?

The function is required is you’re future dating posts.

Can you send e-mails from the admin area?

Because of the WPG2 plug-in and it’s use of the theme header, I put that line of the code in the sidebar template. This isn’t going to cause me any problems is it?

It should be fine…it just won’t run when pages that don’t include the sidebar are hit.

I was having similar problems with notifications not being sent. I changed the:
// Send the notification
add_action(’publish_post’, ‘email_notification_send’,5);
line in email_notification_2.3.php to
// Send the notification
add_action(’publish_post’, ‘email_notification_send’);
and that seemed to fix the problem.

I have the following problem : the plugin doesn’t work complaining that

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in c:\paul\web\4p\wp-content\plugins\wp-email-notification\email_notification_2.3.php on line 370

I think I have identified the problem : since I have two blog in the same MySQL database, I used two different table_prefix (’wp_’ and ‘4p_’). This plugin create tables with the prefix ‘wp_’ (which is bad) but try to access tables with the prefix ‘4p_’ (the prefix of the blog on which I want to use the plugin) (this is right).

I think the install script must be corrected.

You are correct that it hard codes the table prefix “wp_”.

In the next major release this is scheduled to be changed, but in the meantime your option is to change “wp_” to the prefix of your blog.

I tried installing your plugin today. Installation works, tables have been created and config table is filled with data. Activation fine but then I click on Email Notification and keep getting this:

Warning: main(/maillist/wpemn_config.php): failed to open stream: No such file or directory in /home/olivicas/public_html/wp-content/plugins/wp-email-notification/index.php on line 19

Warning: main(/maillist/wpemn_config.php): failed to open stream: No such file or directory in /home/olivicas/public_html/wp-content/plugins/wp-email-notification/index.php on line 19

Warning: main(): Failed opening ‘/maillist/wpemn_config.php’ for inclusion (include_path=’.:/usr/lib/php:/usr/local/lib/php’) in /home/olivicas/public_html/wp-content/plugins/wp-email-notification/index.php on line 19

Any ideas???

Matthew, you need to go into the index.php file and make sure the path to wpemn_config.php is correct for your server setup.

Hi,
First thanks for this plug-in, i’ll be use in the new wessite of my job, but i find a problem width the table_prefix, and i see a few comments about the similar problem.
I changed the ‘wp_’ for $table_prefix, and its look well.
I changed in the install.php, upgraded.php, and all in the maillist folder files.

I hope that this comments serves to you to the next upgrade.

Thanks and sorry width my english.

I have a silly question… In the install.txt file, instruction #7 reads “Put form code in template…”

What template? Does this mean the email_template.html?

I don’t understand why the instructions couldn’t have just named the exact template… this is confusing. Please help!

Thanks,
kopper

Hi, I have a silly question… I am installing this plugin and following along with the instructions in the install.txt file, but instruction line #7 says to “Put form code in template…” but it does not specify WHAT template to put it in! Does it mean to put the code in the email_template.html file? If so, why couldn’t it have just named that specific template? This is confusing! Please help.

Thanks,
kopper

Please disregard the above message, I figured out it needed to be installed in one of the php files for my blog, so I added it to the sidebar.php file and it looks good so far. I activated the plugin and edited the “Update Settings” area the way I want it. Next, I added a couple of test email addresses and then checked the admin area to make sure they were listed there and are subscribed, and they are, so everything appears to be installed properly, except I can’t get it to send out email notifications of new posts. The only way I can get it to work is if I go into the admin area> Manage > Email Notification > Email List Subscribers… That works. But the automatic emailing of the subscribers when there’s a new post isn’t working at all, and I have the default setting for “Notify Subscribers” on the “Create New Post” page set at “Yes.”

Is there something I’m not doing right? Why would it work from the admin area but not the automatic email when a new post is created?

Thanks,
kopper

I’m also getting some kind of weird error/warning message in Firefox whenever I try to post a message here! Something about something not being set properly in the comments.php file…

It needs to go into the one of your theme files. Most likely you’ll want to put it into your sidebar file.

Have at last got this working correctly.
Is there any relatively easy way to get this plugin to use the site template for the various messages it displays on blank pages? (like subscription confirmations etc).
Thanks…

I followed all the instructions, and the plugin seems to work, but the administration area looks as below:

Warning: main(/maillist/wpemn_config.php): failed to open stream: No such file or directory in /web/htdocs/www.cronache-egovernment.it/home/wp-content/plugins/wp-email-notification/index.php on line 19

Warning: main(): Failed opening ‘/maillist/wpemn_config.php’ for inclusion (include_path=’.:/php/lib/php/’) in /web/htdocs/www.cronache-egovernment.it/home/wp-content/plugins/wp-email-notification/index.php on line 19
Import Addresses :: Export Addresses :: Remove Addresses :: Email List Subscribers :: Update Settings

Warning: mysql_connect(): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) in /web/htdocs/www.cronache-egovernment.it/home/wp-content/plugins/wp-email-notification/index.php on line 44

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /web/htdocs/www.cronache-egovernment.it/home/wp-content/plugins/wp-email-notification/index.php on line 45

why?

You need to go into the index.php file and make sure the path to wpemn_config.php is correct for your server setup.

I have installed the pluging today and everything seems to work just fine albeit there where some initial issues with delay in dispatching the mails. I have traced down the problem to a time setup in the blog apparently still on daylight saving time.

Hopefully it should work without delaying mails now.

There appear to be some problems however, when posting from ecto.
Could you, or some body else, please confirm whether or not this plugin works with ecto?

BTW Nice addition to WP, the missing bit has finally come into place on my website.
Thank you for the good work Brian.

Sorry, I forgot to ask this in my previous comment.

Is there a way to get the WP email notification to send me a list of the subscribers?
I have checked into the several options available in WP but can’t find this feature.

Thanks

I’ve not tested it, but I’ve been told that there are still issues with posting with Ecto.

Under the Manage > Email Notification, click on “Export Addresses”.

“Remove Addresses” will allow you to clean up your DB as well.

Great plugin. Managed a last to get it installed without odd errors. I noted that for some reason installing it as described produced all the many common errors people have stated here, then after much mucking around it has started working but (as far as I can tell) the settings I have ended up with are the ones in the instructions which are exactly as I first started out with– odd).

I have two questions…
1. Can anyone suggest a relatively simply way to get the pages the plugin producers (sub confirmation etc) to use the site template? I am not too keen on this white page with a look and feel completely different from the site)

2. It does not send out notifications as far as I can tell. I can send messages from the admin area though. They come through immediately. Any idea why this might be?

Thanks a lot…

Jonathan

OK I found the administration services Tab and everything seems under controll now.
Thank you for that.

Let me take this opportunity to quote directly from my own weblog:

As Italians say, “appetite grows eating” so next logical step was encouraging people that already correspond with me on a regular basis, to subscribe.
I already have a vCard attachment which I use as a signature but I wanted to add some mechanism to link from the signature directly on the list subscription.

Again, WordPress came to rescue me.
WordPress “static Pages” are like Posts, except they can do much more than Posts, and they live outside of the normal blog chronology.
You can use Pages to organize and manage any amount of content which is basically what I did.
Creating a suitable page with some code embedded in it allows me to trigger subscription linking directly to it from a email avoiding the use of HTML code which, in a mail message, could be erroneously filtered as spam.

A little bit of tweaking the style sheet fixed some minor display problems and we are now all set ready to go!

I hope this hint could be of any help to somebody trying to obtain the same.
Cheers

Pieter

1. At the moment I’d suggest adding a header and a footer to the maillist/index.php file. In a future release I’m going to pull the plugin into WP and that won’t be an issue. (Right now this was written in a manner which it could be used without WP.)

2. It’s probably a conflict with another plugin or some other WP process. See Bob Wallace’s fix above and see if that fixes it for you.

Thanks! This is precisely the problem I had. (I created a 2nd database). I think your suggestion is an excellent one to avoid confusion. Failing that, a sentence in the install.txt would have saved me an hour.

everything seemed to be working correctly so i did a test subscribe and that seemed to be ok but email never came so i did another test signup and that seemed fine but again no email was snet.

I went to look at my list of subscribers and I get this error listed:
“Could not successfully run query (SELECT * FROM wp_email_list) from DB: No Database Selected”

When installing the plugin, everthing seemed fine. I’m baffled. In my config under the maillist folder the database settings are fine.

Please help.

On part 1, do you know if your host allows the use of mail()? In the admin panel, see if you can e-mail list subscribers (you’ll need to import your address first).

On part 2 of your question, if your DB information is correct, most likely you either have the tables in a DB that isn’t the same as your WP DB or the path to the config file needs to be updated.

Does this plugin allow me to email the entries as completely HTML? Several plugins only support partial html tags. I want to send a newsletter type email that is fully formatted. Thanks!

I’m not sure what you’re referring to, but the built in templating system is completely HTML.

I am using XAMPP to set up a new site offline. I had a problem with the line
index.php -> line 23 -> “include (”$DOCUMENT_ROOT/maillist/wpemn_config.php”);”

In the plugin update-monitor.php I saw another way to type this, I changed it and now it works!
I suggest to change it in the next release:

include (ABSPATH . “/maillist/wpemn_config.php”);

That is in there as an option, but only works if your maillist directory resides in your WP root. (Some people use this outside of WP.) But in a future release this will be integrated into WP more fully.

Brian: I’ve been using the plugin for a while now, and upgraded with no problems. It’s a great plugin and I appreciate your work on it. I do have a question though (or a feature suggestion).

If I send a full post in the nice HTML format (or not HTML), there’s really no reason for people to visit the site. I know I can not send the full post, but that only sends the title and link. What I’d love to be able to do is send the title, link and excerpt. That then helps drive traffice to the site.

Anyway to do this currently?

Thanks,
John

It seems that there is a bug. When the ticket is saved, recorded for later publishing. It doesnt work. The email isn’t sent. In my case, you should publish right away the document. If you save it before and record without publishing, the document doesn’t get notified to users.

Brian, I dont understand your reply.
All I was saying is: With the existing code the plugin returs errors. With this line modivied it does not but works fine!

Hello Brian,

I have set up wp blog at http://www.vidyanidhi.org.in/blog and while signing-in I am getting the following msgs
Notice: Undefined index: action in C:\root\site\wordpress\maillist\index.php on line 18

Notice: Undefined index: id in C:\root\site\wordpress\maillist\index.php on line 19

Notice: Undefined index: addr in C:\root\wordpress\maillist\index.php on line 20

and while confirming the subscription I get these mgs

Notice: Undefined index: id in C:\Web_App\site\wordpress\maillist\index.php on line 19

Notice: Undefined index: email in C:\Web_App\site\wordpress\maillist\index.php on line 28.

Furthermore, no email notifications for comments are being sent to other domain address es except for email addresses which belong to the same domain (eg: my@vidyanidhi.org.in) but when I start a new posting emails are sent to all of them including addys which are not from the said domain. Plz help me.

Thank you,

Kiran

In the file you have two options, with the second one being commented out.

Is notify set to “Yes” when you go from Draft to Publish?

This was written for and tested on *nix servers running Apache, PHP & MySQL.

If anyone has any Windows tips on setting this up, please chime in.

I was wondering if it was possible to let someone just subscribe and then return to the homepage showing them any text that they have subscribed in a pop-up box or rather not show anyting and just return to the main homepage.

You could add the functionality but it’s not there by default.

I have pretty much given up the idea of installing this script… I have followed everytihng to the T and though its says finished.. the install is riddled with error, which are as follows:

nstalling

You have successfully written data to wpemn_config.php

Warning: mysql_connect(): Unknown MySQL Server Host ‘ mysql31.secureserver.net’ (0) in /home/content/i/n/j/injinuity/html/maillist/install.php on line 210

…

If what you quoted is what you entered, it looks like you have an added space in front of your server host.

And if this doesn’t work for you, there’s always the Subscribe2 WordPress plugin which is similar in functionality.

hahah you were absolutely right.. there was a small blank space before my sql server host.. lord how dumb of me.. thanks a lot brian.

Did eveything.. finally everything is work.. only error left is a display on the top of my page.. an error.. which says

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/i/n/j/injinuity/html/wp-content/plugins/wp-email-notification/email_notification_2.3.php on line 369

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/content/i/n/j/injinuity/html/wp-content/plugins/wp-email-notification/email_notification_2.3.php on line 372

Do you have any other DB related plugin installed? It sounds like there might be a query naming conflit.

only wordpress database backup by scott merril ( http://www.skippy.net/plugins/ ) and Short stats..

To narrow it down, deactivate those plugins and see if the issue is still there.

deactivating all the plugins is also not resolving the issuue…

putting the line in the header file is creating the error.. when you say header template.. do you mean the emai ltemplate or the header.php.. FYI I have added the line to the header.php

after removing that line, there is no error but after you signup an error is shown.

No Database Selected
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/content/i/n/j/injinuity/html/maillist/index.php on line 38

No Database Selected
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/content/i/n/j/injinuity/html/maillist/index.php on line 60
No Database SelectedThanks for subscribing.

when I said line I meant the line of code in header.php