0024602: Reminder plugin

ID	Project	Category	View Status	Date Submitted	Last Update
0024602	Plugin - Reminder	General	public	2018-07-11 09:29	2023-03-25 12:02

Reporter	P3t3r	Assigned To	cas
Priority	normal	Severity	minor	Reproducibility	have not tried
Status	closed	Resolution	fixed

Summary	0024602: Reminder plugin
Description	Hi, We are currently using MantisBT 2.15 and the latest version of the Reminder plugin 2.05, but it won't work unfortunately. I'm getting an SQL error when i run the assigned_bugs.php via an Windows BATCH file. It won't update the issues with an note and no messages were send by email.
Additional Information	APPLICATION ERROR 0000401: Database query failed. Error received from database was #1054: Unknown column 'mantis_bug_table.project_id' in 'where clause' for the query: SELECT DISTINCT b.id bug_id, b.summary, b.handler_id, u.realname, u.email FROM mantis_bug_table b JOIN mantis_user_table u ON (b.handler_id = u.id) WHERE status < ? and mantis_bug_table.project_id NOT IN (0). config_inc.php: $g_phpMailer_method = PHPMAILER_METHOD_SMTP is used for sending email PHP version 7.1
Tags	No tags attached.
Attached Files	screenshot.PNG (53,302 bytes) screenshot.PNG (53,302 bytes)

cas 2018-07-11 09:43 developer ~0060246	Is this a fresh install? I am running 2.16 and no issues

P3t3r 2018-07-11 12:20 reporter ~0060250	Yes

P3t3r 2018-07-11 12:23 reporter ~0060251	I have just uninstall the plug-in, downloaded the latest version of GitHub and keeping the same database error when I run assigned_bugs.php file via the batch file.

P3t3r 2018-07-18 08:20 reporter ~0060277	Hi Cas, Hope you can / want to assist me with this because i'm really excited about the plug-in. Peter

cas 2018-07-18 15:10 developer ~0060280	Peter, can you test with the following script: Reminder\scripts\bug_reminder_mail_test.php You can rubn this directly in the browser. Please post results here

cas 2018-08-29 08:32 developer ~0060525	Please install version 2.06 in which issue has been resolved.

rcfloresh 2018-10-12 16:37 reporter ~0060799	Where is the 2.06 version?? is in github??

cas 2018-10-13 03:53 developer ~0060800	Go with 2.13: https://mantisbt.org/bugs/view.php?id=24706#c60582

cas 2023-03-25 12:02 developer ~0067546	Future support via https://github.com/mantisbt-plugins