tickets #159471
closed
redmine queries with "tags" yield 500 error
Added by okurz 25 days ago.
Updated 2 days ago.
- Private changed from Yes to No
I suggest to contact the developer of the plugin.
- 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
- Priority changed from High to Normal
I can't explain that, but good to hear.
Same problem happened again. I have seen an outage of progress.opensuse.org yesterday evening. I assume that was due to an update being conducted. So likely related?
I don't know why it happens, and I think the issue is something other than the missing column. I inspected the database today, and compared it against backup dumps from the last few days, and no issue_tags
column is anywhere to be found.
Interesting!
After
/usr/bin/bundle.ruby2.7 exec /usr/bin/rake.ruby2.7 -t redmine:plugins NAME=redmineup_tags RAILS_ENV=production
and then restarting the Gunicorn server, your link works again, without the obscure column error message in the logs!
- Status changed from Workable to In Progress
- Status changed from In Progress to Resolved
Also available in: Atom
PDF