Reminder Plugin for mantis 2.X

General discussion of Mantis.

Moderators: Developer, Contributor

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

Reminder Plugin for mantis 2.X

Post by Jeremy13560 » Jun 27, 2019 3:35 am

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: 666
Joined: Mar 11, 2006 11:08 am
Contact:

Re: Reminder Plugin for mantis 2.X

Post by cas » Jul 01, 2019 9:00 am

Here is one for version 2.x
Please let me know if you encounter issues.
Attachments
Reminder206.zip
(22.14 KiB) Downloaded 30 times

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

Re: Reminder Plugin for mantis 2.X

Post by Jeremy13560 » Jul 09, 2019 3:27 am

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: 57
Joined: Jun 04, 2019 7:17 pm

Re: Reminder Plugin for mantis 2.X

Post by amphetamine » Jul 11, 2019 5:19 am

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: 666
Joined: Mar 11, 2006 11:08 am
Contact:

Re: Reminder Plugin for mantis 2.X

Post by cas » Jul 15, 2019 7:37 am

Did you verify the setup of the reminder plugin?
can you share those settings?

amphetamine
Posts: 57
Joined: Jun 04, 2019 7:17 pm

Re: Reminder Plugin for mantis 2.X

Post by amphetamine » Jul 16, 2019 7:18 am

cas wrote:
Jul 15, 2019 7:37 am
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: 666
Joined: Mar 11, 2006 11:08 am
Contact:

Re: Reminder Plugin for mantis 2.X

Post by cas » Jul 16, 2019 8:53 am

I will try to replay your issue and prepare an update if needed.

amphetamine
Posts: 57
Joined: Jun 04, 2019 7:17 pm

Re: Reminder Plugin for mantis 2.X

Post by amphetamine » Jul 25, 2019 7:36 am

cas wrote:
Jul 16, 2019 8:53 am
I will try to replay your issue and prepare an update if needed.
@cas
any updates?

cas
Posts: 666
Joined: Mar 11, 2006 11:08 am
Contact:

Re: Reminder Plugin for mantis 2.X

Post by cas » Jul 25, 2019 8:18 am

It is now on top of my todo list for mantis. I will let results know soonest.

cas
Posts: 666
Joined: Mar 11, 2006 11:08 am
Contact:

Re: Reminder Plugin for mantis 2.X

Post by cas » Jul 27, 2019 4:52 am

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 10 times

amphetamine
Posts: 57
Joined: Jun 04, 2019 7:17 pm

Re: Reminder Plugin for mantis 2.X

Post by amphetamine » Jul 27, 2019 5:50 am

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: 666
Joined: Mar 11, 2006 11:08 am
Contact:

Re: Reminder Plugin for mantis 2.X

Post by cas » Jul 28, 2019 2:31 am

did you check/adjust authorization settings on those files? Northing I can do about that, is on your server :(

amphetamine
Posts: 57
Joined: Jun 04, 2019 7:17 pm

Re: Reminder Plugin for mantis 2.X

Post by amphetamine » Jul 28, 2019 3:40 am

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: 666
Joined: Mar 11, 2006 11:08 am
Contact:

Re: Reminder Plugin for mantis 2.X

Post by cas » Jul 28, 2019 5:51 am

Adjusted those files also, have another go :mrgreen:
Attachments
Reminder215.zip
(22.5 KiB) Downloaded 13 times

cas
Posts: 666
Joined: Mar 11, 2006 11:08 am
Contact:

Re: Reminder Plugin for mantis 2.X

Post by cas » Jul 31, 2019 5:14 am

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

Post Reply