I'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'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 &#039;AND b.status<80 AND c.value<>&#039;&#039; AND ( c.value=&#039;1219118400&#039; )&#039; 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<>&#039;&#039; AND ( c.value=&#039;1219118400&#039; )

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!

Quote
rtomasi
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 &#039;AND b.status<80 AND c.value<>&#039;&#039; AND ( c.value=&#039;1219118400&#039; )&#039; 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<>&#039;&#039; AND ( c.value=&#039;1219118400&#039; )

I&#039;ll take a look, it seems to be an issue with the project id.

Quote

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!

You should set the $g_path variable into the config_inc.php file (ex.: $g_path = &#039;[example]#039

Vincent

---

Mantis: 1.1.0, 1.1.5, 1.1.1
PHP: 5.0.4
SQL: MySQL 5.0.19
OS: Linux

Please complete your signature with your environment informations.
Enable skype notification here

Thanks for the prompt response Vincent! I look forward to a fix (hopefully it&#039;s something simple

The new version of the Reminder plugin does not appear to fix the problem. Was it meant to be a fix?

Thanks!

I forgot this bug (because it was not reported in the bugtracker).

[bugtracker.morinie.fr]

Vincent

---

Mantis: 1.1.0, 1.1.5, 1.1.1
PHP: 5.0.4
SQL: MySQL 5.0.19
OS: Linux

Please complete your signature with your environment informations.
Enable skype notification here

I have added it to the bugtracker. Issue #405.