Page 1 of 2

Reminder Plugin for mantis 2.X

Posted: 27 Jun 2019, 08:35
by Jeremy13560
Hello all,

I have a question about Reminder plugin.

Currently I'm using Reminder for mantis 1.2 but I'm going to upgrade mantis to 2.X.

My problem:

I can't find reminder version for mantis 2.X directly on https://github.com/mantisbt-plugins/Reminder/releases.

The latest version provided is for mantis 1.3.

However I found 2.14 version on mantis BugTracker suitable mantis 2.X. Why can't we find this version released on official github ?

Thanks

Re: Reminder Plugin for mantis 2.X

Posted: 01 Jul 2019, 14:00
by cas
Here is one for version 2.x
Please let me know if you encounter issues.

Re: Reminder Plugin for mantis 2.X

Posted: 09 Jul 2019, 08:27
by Jeremy13560
Hello cas and thanks,

But I have a question: Why didn't you put this version on your official GitHub ? : https://github.com/mantisbt-plugins/Reminder

Thanks

Jeremy

Re: Reminder Plugin for mantis 2.X

Posted: 11 Jul 2019, 10:19
by amphetamine
2.13
https://www.mantisbt.org/bugs/view.php?id=24602

no matter 2.06 or 2.13 when click "download due issues" got the error

Code: Select all

APPLICATION ERROR #401

Database query failed. Error received from database was #1054: Unknown column 'Array' in 'where clause' for the query: select mantis_bug_table.id,summary,due_date,username,realname from mantis_bug_table,mantis_user_table where mantis_bug_table.handler_id=mantis_user_table.id and status in (Array) and due_date>1 and due_date<=172800 and mantis_bug_table.project_id IN (0).

Please use the "Back" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section.

Re: Reminder Plugin for mantis 2.X

Posted: 15 Jul 2019, 12:37
by cas
Did you verify the setup of the reminder plugin?
can you share those settings?

Re: Reminder Plugin for mantis 2.X

Posted: 16 Jul 2019, 12:18
by amphetamine
cas wrote: 15 Jul 2019, 12:37 Did you verify the setup of the reminder plugin?
can you share those settings?
Installation
Like any other plugin. After copying to your webserver :

Start mantis as administrator
Select manage
Select manage Plugins
Select Install behind Reminder
Once installed, click on the plugin's name for further configuration.
--
confg_inc.php:
$g_path = 'http://xxx.xxx.xxx/mantis/';

--
only change E-mail address of sender, others are remains the default value.

Re: Reminder Plugin for mantis 2.X

Posted: 16 Jul 2019, 13:53
by cas
I will try to replay your issue and prepare an update if needed.

Re: Reminder Plugin for mantis 2.X

Posted: 25 Jul 2019, 12:36
by amphetamine
cas wrote: 16 Jul 2019, 13:53 I will try to replay your issue and prepare an update if needed.
@cas
any updates?

Re: Reminder Plugin for mantis 2.X

Posted: 25 Jul 2019, 13:18
by cas
It is now on top of my todo list for mantis. I will let results know soonest.

Re: Reminder Plugin for mantis 2.X

Posted: 27 Jul 2019, 09:52
by cas
I reviewed the download program and could not replay the error message. I did found an issue which i fixed.
Attached version 2.14.

Re: Reminder Plugin for mantis 2.X

Posted: 27 Jul 2019, 10:50
by amphetamine
Thank you for updating the Reminder plugin!

Access forbidden!
plugins\Reminder\scripts\bug_reminder_mail_test.php
plugins\Reminder\scripts\bug_feedback_mail_test.php
plugins\Reminder\scripts\test.php

Re: Reminder Plugin for mantis 2.X

Posted: 28 Jul 2019, 07:31
by cas
did you check/adjust authorization settings on those files? Northing I can do about that, is on your server :(

Re: Reminder Plugin for mantis 2.X

Posted: 28 Jul 2019, 08:40
by amphetamine
remove .htaccess file under mantis/plugins/

run bug_feedback_mail_test.php
got

Code: Select all

@null@
Issues requiring your attention
Please review the following issues Please do not reply to this message
Finished processing your selection
run bug_reminder_mail_test.php
got

Code: Select all

APPLICATION ERROR #401

Database query failed. Error received from database was #1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and mantis_bug_table.project_id IN (0) order by handler_id' at line 1 for the query: select id,handler_id,project_id,summary from mantis_bug_table where status in (10) and handler_id>0 and due_date>= and mantis_bug_table.project_id IN (0) order by handler_id.

Please use the "Back" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section.

Re: Reminder Plugin for mantis 2.X

Posted: 28 Jul 2019, 10:51
by cas
Adjusted those files also, have another go :mrgreen:

Re: Reminder Plugin for mantis 2.X

Posted: 31 Jul 2019, 10:14
by cas
Also removed deprecated functions and fixed another script.