Setduedate doesn't work

[fatacoto]

Hi experts,

I've just being using Mantis 1.2.12.

I've installed some plugins and it seems going fine, except setduedate 3.20, which I have installed succesfully but it doesn't give any efect after creating ticket.

I've tried to add due_date column to be shown in the view issues page, but it remains blank, I've tried with both: default configuration of setduedate and and tried by category/project, but same result.

thanks in advance for your help.

[atrol]

I never used this plugin myself.
If it uses the MantisBT standard field, this might be the solution:
Add the following lines to file config_inc.php and to adjust the access levels to your needs

Code: Select all

$g_due_date_update_threshold = MANAGER;
$g_due_date_view_threshold = DEVELOPER;

[cas]

it uses the default field and it does assume the funtionality to be enabled. I created this plugin and it works flawlesly.
Will adjust the documentation to reflect the prerequisites.

[fatacoto]

Guys,

I don't know how to thank u,

Atrol you are always responding on time with the real fix to the issues.
Cas the pluging you have devlopped is amazing.

Thank you guys.

[fatacoto]

Hi Cas,

in the due date column it shows yyyy/mm/dd can we add hh:mm ?

[cas]

Yes, would bepossible by adjusting the date format. This for now is onlypossible within the code itself (short_date_format => normal_date_format).

[fatacoto]

So can I made it myself in the original plugin file?

Also I have read you were talking about the reminder when due date is near, can u send me the link to download please?

Thank you.

[cas]

Yes, you could do it yourself.

The reminder plugin you can find within the mantis bugtracker

[fatacoto]

Hi Cas,

I found it and realy amazing based on its description,

but it 's showing an error message

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 due_date>1 and due_date<=1359563343' at line 1 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 () and due_date>1 and due_date<=1359563343.

what does it mean?
appreciate you help

[cas]

will look into this but please report in the bugtracker (http://mantisbt.org/bugs) so it is tracked for all others too.

It looks like the category_id field is not filled which is assumed by the plugin.
can you check this & report it in the bugtracker?