'Reminders for deadlines' using Mantis 1.1.6.?

[prabhurangan]

Dear Members,

I need to set up the 'reminder for deadlines' which should be automatically send for the users, to whom the task has been assigned. The reminder should be emailed for the user daily, if the assigned task is still in the same status.

Also i need a notification of the daily status for user, for which he enters his time for the task he has been assigned.


Regards,
Prabhu.

[Kirill]

You can use Remind plugin by Deboutv.
http://deboutv.free.fr/mantis/plugin.ph ... n=Reminder

[prabhurangan]

@Kiril

Can you please guide me how to use the Reminder plugin, I have downloaded it;

However if you guide me with some steps to configure it with my current mantis 1.1.6 it would be helpful for me

Regards,
Prabhu

[Kirill]

Can you please guide me how to use the Reminder plugin, I have downloaded it;

However if you guide me with some steps to configure it with my current mantis 1.1.6 it would be helpful for me

1) You must install with Plugin Manager.
2) http://deboutv.free.fr/mantis/plugin.ph ... nder#part5 - Configuration
3) http://deboutv.free.fr/mantis/plugin.ph ... nder#part6 - Usage

[prabhurangan]

@Kiril

I have done as such, but im facing some mysql error. In this if i execute the 'http://localhost/mantis/plugins/reminde ... r_send.php' Im facing this error. In the the project_id is not been send as a parameter in the WHERE clause of the query. I have marked bold to let you know.

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 MySQL server version for the right syntax to use near 'AND b.status<80 AND c.value<>'' AND ( c.value='1235001600' )' at line 1 for the query: CREATE TEMPORARY TABLE plugins_reminder_query_one_table SELECT b.id, b.summary, b.last_updated, b.view_state, b.status, b.project_id, b.priority, b.category, b.handler_id, c.value, b.reporter_id FROM mantis_bug_table b LEFT JOIN mantis_custom_field_string_table c ON c.bug_id=b.id WHERE c.field_id=3 AND b.project_id= AND b.status<80 AND c.value<>'' AND ( c.value='1235001600' ).

Please help me out to fix this issue.

[prabhurangan]

As mentioned in the part5 of configuration part:

What should be our input for points 2 and 3:

Allos sending by HTML browsing:
From Host:

In this the 2 point is a check box, whetther it should be Enabled or Disabled,
for point 3, From HOST: what should be specified in the text box: 'localhost' Or something else.

Please help me out in this.

[Kirill]

@Kiril

I have done as such, but im facing some mysql error. In this if i execute the 'http://localhost/mantis/plugins/reminde ... r_send.php' Im facing this error. In the the project_id is not been send as a parameter in the WHERE clause of the query. I have marked bold to let you know.

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 MySQL server version for the right syntax to use near 'AND b.status<80 AND c.value<>'' AND ( c.value='1235001600' )' at line 1 for the query: CREATE TEMPORARY TABLE plugins_reminder_query_one_table SELECT b.id, b.summary, b.last_updated, b.view_state, b.status, b.project_id, b.priority, b.category, b.handler_id, c.value, b.reporter_id FROM mantis_bug_table b LEFT JOIN mantis_custom_field_string_table c ON c.bug_id=b.id WHERE c.field_id=3 AND b.project_id= AND b.status<80 AND c.value<>'' AND ( c.value='1235001600' ).

Please help me out to fix this issue.

You can obtain support on official support forum of this plugin.
http://forum.morinie.fr/mantis/read.php ... 1#msg-2731