Project

General

Profile

Actions
Copy link

Defect #3757

closed

Issuses assigned to ID problem

Added by Jacek Kazimierz Strzałkowski over 14 years ago. Updated about 14 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
Start date:
2009-08-19
Due date:
% Done:

0%

Estimated time:
Resolution:
Cant reproduce
Affected version:
0.8.4

Description

Hello,

I need help with resolving my db problem.
When I sending request https://.../issues?assigned_to_id=me
I get an error in production.log:

Parameters: {"set_filter"=>"2", "action"=>"index", "controller"=>"issues", "assigned_to_id"=>"me"}

ActiveRecord::StatementInvalid (Mysql::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1: SELECT count(DISTINCT `issues`.id) AS count_all FROM `issues` LEFT OUTER JOIN `issue_statuses` ON `issue_statuses`.id = `issues`.status_id LEFT OUTER JOIN `projects` ON `projects`.id = `issues`.project_id WHERE ((issues.assigned_to_id IN ('4')) AND (issue_statuses.is_closed=0) AND (projects.status=1 AND EXISTS (SELECT em.id FROM enabled_modules em WHERE em.name='issue_tracking' AND em.project_id=projects.id) OR (projects.status=1 AND EXISTS (SELECT em.id FROM enabled_modules em WHERE em.name='issue_tracking' AND em.project_id=projects.id) AND issues.author_id = 4)) AND ) ):

I know that it's a MySQL query syntax problem, but i don't know how to fix it.
My system settings:
MySQL 5.0.45
ruby 1.8.6
Rails 2.2.2

Thanks in advance.

Actions
Copy link

Also available in: Atom PDF