View Issue Details

WikiJump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0032954Plugin - ReminderGeneralpublic2023-09-22 04:112024-09-26 07:00
Reporterkevin_kuo Assigned Tocas  
PrioritynormalSeverityminorReproducibilityalways
Status resolvedResolutionfixed 
Summary0032954: plugins/Reminder issues You don't have permission to access this resource.
Description

I want to send a reminder letter, but when the url is used, there is no permission and PHP is executed, and it shows Database query failed. Error received from database was #1054:

Can you help me find out the reason?
I have reference to this website" https://github.com/mantisbt-plugins/Reminder"，but smtp is OK!

[root@mantisbt-test bin]# /usr/bin/php /var/www/html/mantis/plugins/Reminder/scripts/bug_reminder_mail.php
APPLICATION ERROR 0000401: 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<=1696227483 and handler_id<>0 and mantis_bug_table.project_id NOT IN (0) order by mantis_bug_table.project_id,handler_id.

TagsNo tags attached.
Attached Files
image.png (15,331 bytes)   
image.png (15,331 bytes)   
image-2.png (7,212 bytes)   
image-2.png (7,212 bytes)   
image-3.png (30,204 bytes)   
image-3.png (30,204 bytes)   

Activities

dregad

dregad

2023-09-22 04:43

developer   ~0068127

@cas I guess this one's for you.
cas

cas

2023-09-25 13:02

developer   ~0068133

New version (2.20) is available via https://github.com/mantisbt-plugins/Tasks
Future issues/remarks/requests should be raised via https://github.com/mantisbt-plugins/Tasks/issues