Defect #30964

500 appears when trying to filter by last updated by

Added by Alexander Kupchenko 3 months ago. Updated 3 months ago.

Status:ClosedStart date:
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:Issues filter
Target version:-
Resolution:Duplicate Affected version:

Description

OS

Operating System: Fedora 26 (Twenty Six)
CPE OS Name: cpe:/o:fedoraproject:fedora:26
Kernel: Linux 4.14.11-200.fc26.x86_64
Architecture: x86-64

Production log

Query::StatementInvalid: Mysql2::Error: This version of MariaDB doesn't yet support 'SUBQUERY in ROW in left expression of IN/ALL/ANY': SELECT
 COUNT(*) FROM `issues` INNER JOIN `projects` ON `projects`.`id` = `issues`.`project_id` 
INNER JOIN `issue_statuses` ON `issue_statuses`.`id` = `issues`.`status_id` 
WHERE (projects.status <> 9 AND EXISTS (SELECT 1 AS one FROM enabled_modules em 
WHERE em.project_id = projects.id AND em.name='issue_tracking')) AND ((issues.status_id IS NOT NULL) AND  
EXISTS (SELECT 1 FROM journals sj WHERE sj.journalized_type='Issue' 
AND sj.journalized_id=issues.id AND (sj.user_id IN ('205')) 
AND sj.id = (SELECT MAX(journals.id) FROM journals   WHERE journals.journalized_type='Issue' AND journals.journalized_id=issues.id   
AND ((journals.private_notes = 0 OR journals.user_id = 7 OR (projects.status <> 9))))))
  Rendered common/error.html.erb within layouts/base (0.2ms)
  Rendered plugins/redmine_tags/app/views/tags/_header_assets.html.erb (0.5ms)
Completed 500 Internal Server Error in 74ms (Views: 26.7ms | ActiveRecord: 17.8ms)

Environment:
  Redmine version                3.4.0.stable
  Ruby version                   2.4.2-p198 (2017-09-14) [x86_64-linux]
  Rails version                  4.2.8
  Environment                    production
  Database adapter               Mysql2
SCM:
  Subversion                     1.9.7
  Git                            2.13.6
  Filesystem                     
Redmine plugins:
  redmine_autoclose              0.0.5
  redmine_tags                   3.2.0

MariaDB Server: 10.2.14-MariaDB

Ruby dependencies versions in attached Gemfile.lock

1.png (9.45 KB) Alexander Kupchenko, 2019-03-05 03:25

2.png (9.31 KB) Alexander Kupchenko, 2019-03-05 03:25

Gemfile.lock (4.81 KB) Alexander Kupchenko, 2019-03-05 03:26


Related issues

Duplicates Redmine - Defect #30367: "Last updated by" filter causes an SQL error with MariaDB Closed

History

#1 Updated by Marius BALTEANU 3 months ago

  • Status changed from New to Closed
  • Resolution set to Duplicate

MariaDB is not yet supported by Redmine, please see #19395 and #30367.

#2 Updated by Marius BALTEANU 3 months ago

  • Related to Defect #30367: "Last updated by" filter causes an SQL error with MariaDB added

#3 Updated by Marius BALTEANU 3 months ago

  • Related to deleted (Defect #30367: "Last updated by" filter causes an SQL error with MariaDB)

#4 Updated by Marius BALTEANU 3 months ago

  • Related to Defect #30367: "Last updated by" filter causes an SQL error with MariaDB added

#5 Updated by Marius BALTEANU 3 months ago

  • Related to deleted (Defect #30367: "Last updated by" filter causes an SQL error with MariaDB)

#6 Updated by Marius BALTEANU 3 months ago

  • Duplicates Defect #30367: "Last updated by" filter causes an SQL error with MariaDB added

Also available in: Atom PDF