search

naidu / redmine-dmsf

Automatically exported from code.google.com/p/redmine-dmsf
0 stars 0 forks source link

MySQL Error in serarching within dmsf files. #168

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
redmine-dmsf plugin version: 1.2.0
redmine version: 1.2.1

there is an SQL problem while searching text within specific project and 
enabling search within dmsf files.
(See attachmement Schermata.png)
the serach works well when no project is selected
(See attachement Schermata-1.png) 

This is the production log:

ActiveRecord::StatementInvalid (Mysql::Error: Column 'project_id' in where 
clause is ambiguous: SELECT count(DISTINCT `dmsf_files`.id) AS count_all FROM 
`dmsf_files`  LEFT OUTER JOIN `projects` ON `projects`.id = 
`dmsf_files`.project_id  LEFT OUTER JOIN `dmsf_file_revisions` ON 
dmsf_file_revisions.dmsf_file_id = dmsf_files.id AND 
dmsf_file_revisions.`deleted` = 0 WHERE ((projects.status=1 AND projects.id IN 
(SELECT em.project_id FROM enabled_modules em WHERE em.name='dmsf') AND 
project_id IN (52) AND dmsf_files.deleted = 0) AND (((LOWER(dmsf_files.name) 
LIKE '%prova%') OR (LOWER(dmsf_file_revisions.title) LIKE '%prova%') OR 
(LOWER(dmsf_file_revisions.description) LIKE '%prova%')))) ):
  /usr/lib/ruby/vendor_ruby/active_record/connection_adapters/abstract_adapter.rb:227:in `log'
  /usr/lib/ruby/vendor_ruby/active_record/connection_adapters/mysql_adapter.rb:324:in `execute'
  /usr/lib/ruby/vendor_ruby/active_record/connection_adapters/mysql_adapter.rb:639:in `select'
  /usr/lib/ruby/vendor_ruby/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all_without_query_cache'
  /usr/lib/ruby/vendor_ruby/active_record/connection_adapters/abstract/query_cache.rb:60:in `select_all'
  /usr/lib/ruby/vendor_ruby/active_record/connection_adapters/abstract/query_cache.rb:81:in `cache_sql'
  /usr/lib/ruby/vendor_ruby/active_record/connection_adapters/abstract/query_cache.rb:60:in `select_all'
  /usr/lib/ruby/vendor_ruby/active_record/connection_adapters/abstract/database_statements.rb:13:in `select_one'

Original issue reported on code.google.com by davide.v...@gmail.com on 13 Oct 2011 at 2:36

Attachments:

GoogleCodeExporter commented 9 years ago

Original comment by vit.jo...@gmail.com on 13 Oct 2011 at 7:42

GoogleCodeExporter commented 9 years ago

Original comment by vit.jo...@gmail.com on 13 Oct 2011 at 8:17

GoogleCodeExporter commented 9 years ago

Original comment by vit.jo...@gmail.com on 17 Nov 2011 at 10:51