Defect #2266
closedPGError after svn up to 2082 && add plugin 'Customer'
0%
Description
Hello world.
My hands_motions:
svn up
Status against revision: 2082
ruby script/plugin install http://svn.rails-engines.org/engines/tags/rel_2.0.0/
mv vendor/plugins/rel_2.0.0 vendor/plugins/engines
rake db:migrate_plugins
git clone git://github.com/edavis10/redmine-customer-plugin.git vendor/plugins/customer_plugin
rake db:migrate_plugins #without RAILS_ENV??? 8-0
mongrel_rails cluster::stop
mongrel_rails cluster::start
Without any errors or warnings!
Login into app, && goto /projects/activity/progect_uid
Parameters: {"action"=>"activity", "id"=>"portamarket", "controller"=>"projects"}
ActiveRecord::StatementInvalid (PGError: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list
: SELECT DISTINCT "journals".id FROM "journals" LEFT OUTER JOIN "issues" ON "issues".id = "journals".journalized_id LEFT OUTER JOIN "projects" ON "projects".
id = "issues".project_id LEFT OUTER JOIN "journal_details" ON journal_details.journal_id = journals.id WHERE (journals.journalized_type = 'Issue' AND (jou
rnal_details.prop_key = 'status_id' OR journals.notes <> '')) AND (1=1 AND (journals.created_on BETWEEN '2008-11-03' AND '2008-12-03') AND ((projects.id = 17 O
R projects.parent_id = 17) AND (projects.status=1 AND EXISTS (SELECT em.id FROM enabled_modules em WHERE em.name='issue_tracking' AND em.project_id=projects.id
)))) ORDER BY journals.created_on DESC LIMIT 10):
Or goto account/show/account_id
Parameters: {"action"=>"show", "id"=>"3", "controller"=>"account"}
ActiveRecord::StatementInvalid (PGError: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list
: SELECT DISTINCT "journals".id FROM "journals" LEFT OUTER JOIN "issues" ON "issues".id = "journals".journalized_id LEFT OUTER JOIN "projects" ON "projects".
id = "issues".project_id LEFT OUTER JOIN "journal_details" ON journal_details.journal_id = journals.id WHERE (journals.journalized_type = 'Issue' AND (jou
rnal_details.prop_key = 'status_id' OR journals.notes <> '')) AND (1=1 AND (journals.user_id = 3) AND (((projects.status=1 AND EXISTS (SELECT em.id FROM enable
d_modules em WHERE em.name='issue_tracking' AND em.project_id=projects.id)) AND (1=0 OR projects.is_public = 't' OR projects.id IN (1,2,4,11,3,14,19,20,22)))))
ORDER BY journals.created_on DESC LIMIT 10):
WTF???
Updated by Jean-Philippe Lang about 16 years ago
- Category set to Database
- Status changed from New to Closed
- Resolution set to Fixed