https://www.redmine.org/https://www.redmine.org/favicon.ico?16793021292018-10-27T02:08:08ZRedmineRedmine - Defect #29848: Query to determine role ids is incorrecthttps://www.redmine.org/issues/29848?journal_id=881112018-10-27T02:08:08ZGo MAEDA
<ul></ul><p>I could not reproduce the problem.</p>
<p>Could you try without plugins if you are using any plugins?</p> Redmine - Defect #29848: Query to determine role ids is incorrecthttps://www.redmine.org/issues/29848?journal_id=881822018-10-30T20:00:30ZFrank Schwarz
<ul></ul><p>There were no pertinent plugins active at the time the error occurred. I migrated from 3.2-stable. Project membership was set up via groups (not via individual users).</p>
<p>I wonder why there are two role_id columns: one in "Members" and one in "MemberRoles". The former remains "0" for all project-member assignments.</p>
<p>Current environment:<br /><pre>
Environment:
Redmine version 3.4.6.stable
Ruby version 2.5.1-p57 (2018-03-29) [x86_64-linux-gnu]
Rails version 4.2.10
Environment production
Database adapter Mysql2
SCM:
Subversion 1.9.7
Git 2.17.1
Filesystem
Redmine plugins:
redmine_auth_source_passwd 1.0.0.dev --> another AuthSource
redmine_html_attachments 0.0.1.dev --> patches Attachment to allow HTML-Attachments
redmine_ics_export 3.0.1.dev --> https://github.com/buschmais/redmics
redmine_overdue_notification_task 0.3.0 --> extends Mailer + Rake task
</pre></p> Redmine - Defect #29848: Query to determine role ids is incorrecthttps://www.redmine.org/issues/29848?journal_id=964012020-02-23T09:15:54ZFrank Schwarz
<ul><li><strong>Status</strong> changed from <i>New</i> to <i>Resolved</i></li></ul><p>For some unknown reasons the <code>members</code> table (still) had a <code>role_id</code> column. Dropping that column manually, removed the join-table confusion.</p> Redmine - Defect #29848: Query to determine role ids is incorrecthttps://www.redmine.org/issues/29848?journal_id=964022020-02-23T12:21:51ZMarius BÄ‚LTEANU
<ul><li><strong>Status</strong> changed from <i>Resolved</i> to <i>Closed</i></li><li><strong>Resolution</strong> set to <i>Invalid</i></li></ul><p>Frank Schwarz wrote:</p>
<blockquote>
<p>For some unknown reasons the <code>members</code> table (still) had a <code>role_id</code> column. Dropping that column manually, removed the join-table confusion.</p>
</blockquote>
<p>Thanks for your feedback.</p>