dveos wrote: ↑09 Nov 2017, 19:03
Hi Russ,
It's a start!
Please find instructions below, it's not 100% perfect yet as I noticed an issue with emails being sent through the "Activity" pop up. But seems to work perfectly when you email candidates through the standard procedure.
1, Firstly need to create two columns in the email_history table entitled for_id and for_module.
2, I have attached amended files for upload, don't think I'm missing anything.. then job done!
Basically what should happen is when an email goes out it logs the Candidate ID in the for_id column, and also module (i.e. Candidates). Then returns each email in the data grid.
Any issues let me know, or similarly if you can solve the activity email issue please do let me know!
Okay, I have now spent about 5 hours trying to get this patch to work. It does log activity, however all for_id's (candidate id's) as 0. Looking at the modified file I cannot see how mailer.php can obtain the candidate id. This means that $id=0. Initially it also reported a sql error:
MySQL Query Failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
NOW()
)' at line 18
INSERT INTO email_history (
from_address,
recipients,
text,
user_id,
site_id,
for_module,
for_id,
date
)
VALUES (
'XXXXXXXXXXX@XXXXXXXX',
'test7@XXXXXXXX',
'Subject: HELLO 3\n\nMessage:\nHELLO 3',
1251,
180,
'candidates',
,
NOW()
)
This was correct by changing the for_id query from %s to %d i.e. from a string to an integer. Emails are now sent and logged, however, with 0 as the candidate ID.