Email on birthday

Hartenheer · Post by **Hartenheer** » Sun Aug 23, 2015 10:11 am

I sought, not found

Is there an extension to automatically send an e-mail if one's birthday/

Post by **Raul [ThE KuKa]** » Sun Aug 23, 2015 10:47 am

It is possible on soon...
https://github.com/ForumHulp/emailonbirthday

Best regards.

Hartenheer · Post by **Hartenheer** » Sun Aug 23, 2015 11:44 am

Special thanks

Hartenheer · Post by **Hartenheer** » Sun Aug 23, 2015 11:56 am

I had this before, but did not work.

It says shift in html.
This does not work either.

John P · Post by **John P** » Sun Aug 23, 2015 3:58 pm

What means shift in html?

The extension is for validating since July 3 2015

Post by **Raul [ThE KuKa]** » Sun Aug 23, 2015 5:00 pm

John P, yes. Your extension is in the process of validation.

But Hartenheer he's right.

On ACP - Board Configuration - Board features

E-mail on your birthday: (Yes or No)
Send every member a birthday email on his / her birthday

Use html in email: (Yes or No) (Only possible with enabled extension forumhulp\htmlemail)
Send a html email instead of plain-text.

I think this option (Use html in email) should only be displayed if the extension is installed.

John P · Post by **John P** » Sun Aug 23, 2015 9:56 pm

It's a point Raul although it's explained and not switchable unless the html extension is enabled.

Galixte de EzCom · Post by **Galixte de EzCom** » Mon Sep 28, 2015 4:29 am

Hi,

the « HTML email » extension is here: https://github.com/ForumHulp/htmlemail.

Siava · Post by **Siava** » Sat Jan 02, 2016 10:35 am

John P wrote:The extension is for validating since July 3 2015

I have a problem with this extension.
After send birthday emails got error in cron (I'm using system cron):

Code: Select all

PHP Fatal error:  SQL ERROR [ mysqli ]<br /><br />Column 'user_id' cannot be null [1048]<br /><br />
......
in /.../forum/phpbb/db/driver/driver.php on line 855

and cron locks.

This piece of code caused the error:
/ext/forumhulp/emailonbirthday/cron/task/core/birthday.php

Code: Select all

				$userlist = array_map(function ($entry)
				{
					return $entry['name'];
				}, $msg_list);

				$this->log->add('admin', $this->user->data['user_id'], $this->user->data['session_ip'], 'BIRTHDAYSEND', false, array(implode(', ', $userlist)));

Code: Select all

PHP Fatal error:  SQL ERROR [ mysqli ]<br /><br />Column 'user_id' cannot be null [1048]<br /><br />SQL<br /><br />INSERT INTO phpbb_log  (user_id, log_ip, log_time, log_operation, log_type, log_data) VALUES (NULL, NULL, 1451772784, 'BIRTHDAYSEND', 0, ' .....

John P · Post by **John P** » Fri Jan 08, 2016 6:54 am

Looks like system cron is running without a user.
Investigating...

Siava · Post by **Siava** » Sat Jan 09, 2016 3:46 pm

cron/task/core/birthday.php
find

Code: Select all

				$this->log->add('admin', $this->user->data['user_id'], $this->user->data['session_ip'], 'BIRTHDAYSEND', false, array(implode(', ', $userlist)));

replace with

Code: Select all

				$user_id = (empty($this->user->data)) ? ANONYMOUS : $this->user->data['user_id'];
				$user_ip = (empty($this->user->ip)) ? '' : $this->user->ip;
				$this->log->add('admin', $user_id, $user_ip, 'BIRTHDAYSEND', false, array(implode(', ', $userlist)));

RMcGirr83 · Post by **RMcGirr83** » Sat Feb 20, 2016 2:39 pm

Anonymous is still a user of the forum (the guest user account).

cally6008 · Post by **cally6008** » Mon Apr 18, 2016 3:18 pm

Does this work yet ? Has it been validated ?

thejdm · Post by **thejdm** » Wed Feb 08, 2017 3:47 pm

Looking for an email on birthday and this is what came up. Tried the zip file from the gitHub link, uploaded as per directions and no luck. It doesn't show in the Extensions Manager to enable it in 3.2

Hartenheer · Post by **Hartenheer** » Wed Feb 08, 2017 4:09 pm

For me it works perfectly 3. 2.
You just need to download the three extensions and activation