Reminder Plugin for mantis 2.X

[atorde]

Yes, I know, but I get a 500 error and I don't know how to find out what the error is.

[cas]

I have checked the script and there indeed was an issue in the test script.
please download the latest version of bug_reminder_mail_test.php from:
https://github.com/mantisbt-plugins/Reminder
This file is located in the scripts folder (the normal script is correct).

[atorde]

now this error appears



If I launch the script from ssh now this comes out:







If I launch the original script from ssh it gives this error:

[cas]

That is not an error message, that is the script for the commandline.
If you run the testscript, you will see what the script finds based upon the settings of the plugin.
In case you like to try (no guarantees whatsoever) edit this script and remove lines 3,4,5,6

[cas]

Not sure what your setup is but this I cannot replicate.
The test script is for the browser, the other one is just for the commandline.

[cas]

Apparently it is cause of php8.3 that this error occurs. I will check this.

[atorde]

I've looked for the table that says it doesn't exist in the error Table 'dbs12991597.mantis_project_user_lis_table' and it looks like setup doesn't create it


I think the script has an error and is missing the letter "T".
dbs12991597.mantis_project_user_lis_table Vs dbs12991597.mantis_project_user_list_table

[cas]

Please copy the latest files from the script directory here https://github.com/mantisbt-plugins/Reminder
Both the bug_reminder_mail.php & bug_reminder_mail_test.php have been adjusted.
Make sure they are copied to your installation on the correct spot again in the scripts directory of the plugin.
By the way, these conversations you can better route through Github, the home of the plugin.

[atorde]

The errors seem the same. The version you attach is still 2.21

[cas]

I checked on github and changes were not properly committed (most likely my mistake ).
Please download the bug_reminder_mail_test.php & bug_reminder_mail.php again.
The other message is correct because the non-test script you cannot run in the browser. This runs fine from the command line

I indeed did not update the version (yet).

[atorde]

Thank you very much Cas. Now it ends correctly.
I have seen an error in the SQL statement because I have configured a limit of 2 days for the reminder (172800s) and the query indicates that the due_date (unix format) must be less than or equal to 172800. The correct thing would be due_date <= UNIX_TIMESTAMP(DATE_ADD(now(), INTERVAL 172800 second))

[cas]

The "error" you found, was caused by a faulty statement which now is also corrected on Github.
So now you can download version 2.22 and hopefullyou then have a working environment

[atorde]

The script is finally finished!!!



... but I don't receive any email

Launching bug_reminder_mail_test.php from the browser should I receive an email?

I have configured a crontab as follows and I am not receiving emails either: */5 * * * * php /kunden/homepages/20/d383534261/htdocs/mantis/plugins/Reminder/scripts/bug_reminder_mail.php


I have tried sending an email from ssh and it works correctly

[cas]

No, the test script does not send any mail. it just shows the results of the various queries and also to whom an email would be sent. So in case that script states that it found results like in your case, then the actual script should send an email to test@bitcrumb.es for 3 issues.
I assume the email address is correct but better check. Did you check the email table from Mantis if the mails ended up there?
Did you check the php logs?

[cas]

I have added an additional scrit for you on Github called "bug_reminder_mail_special.php".
This one you can run in the browser so you get all the feedback and it acually will send the email (does not create the note).
Hope this helps in finding the issue.