tickets #159471
openredmine queries with "tags" yield 500 error
0%
Description
Steps to reproduce¶
- Click on https://progress.opensuse.org/issues?query_id=757
- Observe the error "An error occurred while executing the query and has been logged. Please report this error to your Redmine administrator."
- Compare to another query https://progress.opensuse.org/issues/?query_id=230 showing no problems, likely due to not querying for "tags"
Updated by crameleon 10 days ago
- Status changed from New to Workable
- Assignee set to crameleon
Hi,
thanks for reporting. The following error is logged:
ERROR -- : [d6e88531-ecd1-4dfc-889f-530a70caea2d] Query::StatementInvalid: Mysql2::Error: Unknown column 'issues.issue_tags' in 'where clause'
This is the same issue I already faced in the past and had been in contact with RedmineUP about. I thought it was resolved after I installed a patched version of the plugin which they provided for us, but it seems it still occurs on some queries.
Part of the issue is that RedmineUP internally changes their "redmine_crm" library - so the official release of the new "Tags" plugin has a dependency conflict on the official release of the "Checklists" plugin. Naturally, I want to keep both plugins enabled.
They requested us to test three more patched versions of the "Checklists" plugin, but I have not gotten to it -unfortunately there is currently no test instance, and I don't want to gamble with plugins causing database migrations on the production.
Will have to see if there's a better interim solution.
Best,
Georg
Updated by crameleon 10 days ago
- Blocked by tickets #159480: Build new progress-test.o.o added
Updated by crameleon 10 days ago
For reference, previous work on this issue was commented on here:
https://progress.opensuse.org/issues/133532#note-63
Updated by okurz 10 days ago
ok, good. I can see that now https://progress.opensuse.org/issues?query_id=757 works fine again