Bug #1887
closed
Postgres error creating new host when selecting hostgroup and environment
Description
Since updating Foreman to develop/75bd351e4217fe04f583642799dbb3f028f0fbcc creating a new host triggers an internal error (500) when selecting the hostgroup and thus the environment (production). Here are debug logs from the event: http://pastie.org/4909049. Attached is also a screenshot just for orientation and reference.
Using PostgreSQL 9.1 on Ubuntu 12.04.1.
Files
| foreman-new-host-pgsql-error.png | View foreman-new-host-pgsql-error.png | 53.1 KB | Screenshot of "new host" interface |
Updated by Andreas Ntaflos over 12 years ago
Some background information on what I believe is the problem here:
http://stackoverflow.com/questions/9758793/rails-3-activerecord-postgresql-uniq-command-doesnt-work/11476714#11476714
http://archives.postgresql.org/pgsql-sql/2007-02/msg00161.php
Updated by Joseph Magen over 12 years ago
- Status changed from New to Resolved
This is caused by lower() on the default_scope.
- default_scope :order => 'lower(puppetclasses.name)'
+ default_scope :order => 'puppetclasses.name'
has been committed
Updated by Ohad Levy over 12 years ago
- Category set to Database
- Assignee set to Joseph Magen
- Target version set to 1.1