WordPress MU

Hi,

I recently installed a fresh copy of WPMU 1.2.3 and while testing I found activation emails were not delivered to few email IDs. I checked this forum and found many people having similar problems but there was no concrete solution available.
Anyway, just wanted to know if there is any solution or plugin that can be used to resend the activation email and manage the inactive users from admin CP ?

At present, no there isn't.

I'd suggest adding that to Trac though, as that is a pretty decent idea for improvement.

Ok will do that. Can u post the link to do that.

http://trac.mu.wordpress.org/newticket

Thanks. Done.

super quick and dirty :
1) add "status" column to wp_signups defaulting to 0.
2) Create this script:
<?php
$user = "xxx";
$dbname = "yyy";
$pass = "zzz";
$host = "localhost";
$co = mysql_connect($host, $user, $pass);
if (!$co) {
exit();
}
mysql_select_db($dbname);
$today = date('Y-m-d');
$sql = "SELECT * FROM wp_signups WHERE active=0 AND status=0 AND registered<=DATE_SUB('".$today."', INTERVAL 1 DAY)";
$res = mysql_query($sql);

$k=0;
while($row=mysql_fetch_array($res)) {
$k++;
if($k%10==0) { sleep(2); }
if($row['domain']!='') {
$to = $row['user_email'];
$subject = 'Your blog activation';
$headers = "MIME-Version: 1.0\n" .
"From: email@domain.com\n" .
"Content-Type: text/plain; charset=\"ISO-8859-1\"\n";
$body = "your blurb here - activation : http://". $row['domain']."/wp-activate.php?key=".$row['activation_key'];
mail($to, $subject, $body, $headers, '-femail@domain.com');

$sql1 = "UPDATE wp_signups SET status=1 WHERE domain='".$row['domain']."'";
mysql_query($sql1);
}
}

mysql_close($co);
?>

3) Add it to crontab to run once a day.

untested as is (just extracted some stuff from my own script), use at your own risk blablabla. If you want to make things clean, replace mysql functions with WP's abstraction layer etc. Didn't take the time to do it myself.

Looks cool. I guess WPMU dev team would take a hint from this.

For a quick fix...

I just peek at the DB sign up table. Look up the activation code and build the link myself.

It works in a pinch when you just want to help one of your users out.

Can someone point me to the code that sends out email when a user registers.

Ok here is the error log message I got from my host

2007-07-20 06:29:04 1IBrbU-0000wM-3l H=localhost (host15.hostmonster.com) [127.0.0.1] F=<ktplcom@host15.hostmonster.com> rejected after DATA: syntax error in 'From:' header when scanning for sender: missing or malformed local part in """ <>"

Now can anyone help please :-)

Note the empty double quotes and the <> marks. An email address is not being put in there.

Open up a ticket, assign it a high priority, and give this link as an discussion of the issue.

http://exim.dsmirror.nl/exim-html-4.40/doc/html/FAQ_0.html#TOC87

I'd dig through the code myself for a fix but I don't feel right doing that anymore.

I guess WPMU dev team would take a hint from this.

Did I miss something? Is something broke on wpmudev?

Thanks,
Andrew

Andrew, I think they mean Donncha and not you.

Yeah, that would be my guess since there is a space there.

Pls do not hijack.

This is regarding a common problem many people are facing and may be someone could help.

Here is the error log message I got from my host, when a user tries to create an account (blog) and email is not sent. WPMU 1.2.3

2007-07-20 06:29:04 1IBrbU-0000wM-3l H=localhost (host15.hostmonster.com) [127.0.0.1] F=<ktplcom@host15.hostmonster.com> rejected after DATA: syntax error in 'From:' header when scanning for sender: missing or malformed local part in """ <>"

Ok I did few things here and there and its working now !!!
I guess the following changes to php.ini file made it to work (or may be something else). But still in case anyone is facing similar problem, set these variables in your php.ini file.

register_globals = Off
display_errors = Off
memory_limit = 32M

You mean they weren't already?

Wow. That has to hurt.

Just to throw in an idea here, I'd add something to the wp-signup.php page saying to folks that if they don't get an email within x amount of hours to send in an email to your support address from the email address they created the account with. Takes seconds for you to check the activation table to see if it's in there and another two seconds to create the blog.

That and mention checking in their spam folders.

I deleted the WPMU installation and database and did fresh install and now again its not working. I mean there is no activation email.
The entries are there in database (signup table) pending activation.

drmiketemp: "Takes seconds for you to check the activation table to see if it's in there and another two seconds to create the blog."

You are right but if none of the user gets mail just imagine what would I be doing whole day (and night) everyday.

I am trying to recreate the step that made it work. I would appreciate if someone could help.

Ticket opened http://trac.mu.wordpress.org/ticket/381

not fixed yet

Did you apply the fix in 1020?

Plugin to resend activation emails:
http://mu.wordpress.org/forums/topic.php?id=5827