Reminder Plugins issure

General discussion about MantisBT Plugins

Moderators: Developer, Contributor

Post Reply
kevin_kuo
Posts: 2
Joined: 22 Sep 2023, 08:15

Reminder Plugins issure

Post by kevin_kuo »

[root@mantisbt-test scripts]# php bug_reminder_mail.php
APPLICATION ERROR #401: Database query failed. Error received from database was #1054: Unknown column 'mantis_bug_table.project_id' in 'where clause' for the query: select bugs.id, bugs.handler_id, bugs.project_id, bugs.priority, bugs.category_id, bugs.status, bugs.severity, bugs.summary from mantis_bug_table bugs JOIN mantis_bug_text_table text ON (bugs.bug_text_id = text.id) where status in (20) and due_date<=1696237797 and handler_id<>0 and mantis_bug_table.project_id IN (0) order by mantis_bug_table.project_id,handler_id.
[root@mantisbt-test scripts]#

I don't understand why this is happening...
cas
Posts: 1564
Joined: 11 Mar 2006, 16:08
Contact:

Re: Reminder Plugins issure

Post by cas »

would you mind posting this on https://github.com/mantisbt-plugins/Reminder
I will then look into it.
My first analysis already gave me some ideas :mrgreen:
cas
Posts: 1564
Joined: 11 Mar 2006, 16:08
Contact:

Re: Reminder Plugins issure

Post by cas »

Hi Kevin,
you can find a new version (2.20) on https://github.com/mantisbt-plugins/Reminder
Please raise new issues/remarks/request there as well.
Post Reply