Reminder Plugin for mantis 2.X

General discussion of Mantis.

Moderators: Developer, Contributor

Jeremy13560
Posts: 3
Joined: 22 Nov 2018, 08:45

Reminder Plugin for mantis 2.X

Post 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
cas
Posts: 1586
Joined: 11 Mar 2006, 16:08
Contact:

Re: Reminder Plugin for mantis 2.X

Post by cas »

Here is one for version 2.x
Please let me know if you encounter issues.
Attachments
Reminder206.zip
(22.14 KiB) Downloaded 503 times
Jeremy13560
Posts: 3
Joined: 22 Nov 2018, 08:45

Re: Reminder Plugin for mantis 2.X

Post 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
amphetamine
Posts: 113
Joined: 05 Jun 2019, 00:17

Re: Reminder Plugin for mantis 2.X

Post 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.
cas
Posts: 1586
Joined: 11 Mar 2006, 16:08
Contact:

Re: Reminder Plugin for mantis 2.X

Post by cas »

Did you verify the setup of the reminder plugin?
can you share those settings?
amphetamine
Posts: 113
Joined: 05 Jun 2019, 00:17

Re: Reminder Plugin for mantis 2.X

Post 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.
cas
Posts: 1586
Joined: 11 Mar 2006, 16:08
Contact:

Re: Reminder Plugin for mantis 2.X

Post by cas »

I will try to replay your issue and prepare an update if needed.
amphetamine
Posts: 113
Joined: 05 Jun 2019, 00:17

Re: Reminder Plugin for mantis 2.X

Post 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?
cas
Posts: 1586
Joined: 11 Mar 2006, 16:08
Contact:

Re: Reminder Plugin for mantis 2.X

Post by cas »

It is now on top of my todo list for mantis. I will let results know soonest.
cas
Posts: 1586
Joined: 11 Mar 2006, 16:08
Contact:

Re: Reminder Plugin for mantis 2.X

Post 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.
Attachments
Reminder214.zip
(22.52 KiB) Downloaded 433 times
amphetamine
Posts: 113
Joined: 05 Jun 2019, 00:17

Re: Reminder Plugin for mantis 2.X

Post 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
cas
Posts: 1586
Joined: 11 Mar 2006, 16:08
Contact:

Re: Reminder Plugin for mantis 2.X

Post by cas »

did you check/adjust authorization settings on those files? Northing I can do about that, is on your server :(
amphetamine
Posts: 113
Joined: 05 Jun 2019, 00:17

Re: Reminder Plugin for mantis 2.X

Post 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.
cas
Posts: 1586
Joined: 11 Mar 2006, 16:08
Contact:

Re: Reminder Plugin for mantis 2.X

Post by cas »

Adjusted those files also, have another go :mrgreen:
Attachments
Reminder215.zip
(22.5 KiB) Downloaded 398 times
cas
Posts: 1586
Joined: 11 Mar 2006, 16:08
Contact:

Re: Reminder Plugin for mantis 2.X

Post by cas »

Also removed deprecated functions and fixed another script.
Attachments
Reminder216.zip
(22.49 KiB) Downloaded 603 times
Post Reply