I&
#039;m running Mantis 1.1.1 on Windows and it has worked pretty well, but a lot of the things I wish were built into it, I found here! Thanks for the great plugins! That said, I&
#039;m seeing some issues with the Reminder plugin.
It install fine, but when I go to test it via the web interface (reminder_send.php) I get the following error:
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='1219118400' )' at 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=0 AND b.project_id= AND b.status<80 AND c.value<>'' AND ( c.value='1219118400' )
Interestingly, the email is still sent, but it does not appear to include all the appropriate data. Also the links back to Mantis in the HTML portion of the email aren&
#039;t coming out correct.
Instead of seeing
<correct URL>/view.php?id=18, I see
<correct URL>/plugins/reminder/view.php?id=18. The "/plugins/reminder" part of the path should not be there.
Anyone else seen this?
Thanks!