mantisbt-plugins/reminder

This plugin can be used to send periodic email reminders to bug reporters, managers, and assignees.

reminder's Issues

Problem running reminder from commandline

Hi,

I have the following issue which I don't understand.

After a while of debugging bug_reminder_mail.php I have the following behaviour.

If I remove the ( php_sapi_name() != 'cli' ) and run the script from the browser I do get mail reminders.

If I however run the script using php from cli I don't get any mail reminders.

php version 5.4.23 mantis 1.2.15.

Any idea?

Greetings,

Fred

"Run scheduled script on the account of:" field

Greetings,
I can't understand what account shall I enter in the aforementioned field available via Mantis Configure Plugins page. I also couldn't find description of that field in readme. Could you please elaborate what exactly is supposed to be entered in that field?

APPLICATION ERROR #401 with Mantis 2.26.1

php8.1-fpm / mantisbt 2.26.1

start via cron:
/usr/bin/php /var/www/job/plugins/Reminder/scripts/bug_reminder_mail.php

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 ')' at line 1, 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,21,30,40,50,53,54,55,56,57,60,71) and due_date<=1713986272 and handler_id<>0 and due_date>1 and bugs.project_id NOT IN ().

"Database query failed" while trying to launch bug_reminder_mail.php

Greetings,
I'm getting error when I launch bug_reminder_mail.php script via Cron. See exact error message below:

APPLICATION ERROR #401: Database query failed. Error - #1054: Unknown column 'mantis_bug_table.project_id' in 'where clause', 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 (50) and due_date<=1696318201 and handler_id<>0 and due_date>1 and mantis_bug_table.project_id NOT IN (0) order by handler_id.

The column in question, 'mantis_bug_table.project_id', does exist (as far as I understand) if I check it myself via PHPMyAdmin (screnshot attached).
Could you please assist me on that? Regretfully I'm not at all proficient in database administration, so I'd need instructions if it'll be necessary to do something about database itself.

My MantisBT version is 2.25.2
My Reminder Plugin version is 2.17

Support channel and README file update

Hi @CasN

Today someone opened an issue on MantisBT bugtracker regarding your plugin. I moved it to the specific project for this plugin, but earlier this year I added a sticky issue to redirect people here.

I only realized today that Issues were not enabled for some reason, so I changed that in the repo's settings. The README file needs to be updated.

I let you take care of that, respond to the user and close the issue.

print_successful_redirect() is deprecated since MantisBT 2.26.0