##// END OF EJS Templates
jro_apps » redmine
RSS
SQL error using PostgreSQL...
Jean-Philippe Lang -
r3:b1ede59d0289
parent child
Show More
Show file before | Show file after | Hide comments
@@ -0,0 +1,18
1 <?xml version="1.0" encoding="UTF-8"?>
2 <projectDescription>
3 <name>redmine</name>
4 <comment></comment>
5 <projects>
6 </projects>
7 <buildSpec>
8 <buildCommand>
9 <name>org.rubypeople.rdt.core.rubybuilder</name>
10 <arguments>
11 </arguments>
12 </buildCommand>
13 </buildSpec>
14 <natures>
15 <nature>org.radrails.rails.ui.railsnature</nature>
16 <nature>org.rubypeople.rdt.core.rubynature</nature>
17 </natures>
18 </projectDescription>
Show file before | Show file after | Hide comments
@@ -0,0 +1,19
1 # Settings specified here will take precedence over those in config/environment.rb
2
3 # In the development environment your application's code is reloaded on
4 # every request. This slows down response time but is perfect for development
5 # since you don't have to restart the webserver when you make code changes.
6 config.cache_classes = false
7
8 # Log error messages when you accidentally call methods on nil.
9 config.whiny_nils = true
10
11 # Enable the breakpoint server that script/breakpointer connects to
12 config.breakpoint_server = true
13
14 # Show full error reports and disable caching
15 config.action_controller.consider_all_requests_local = true
16 config.action_controller.perform_caching = false
17
18 # Don't care if the mailer can't send
19 config.action_mailer.raise_delivery_errors = false
Show file before | Show file after | Hide comments
@@ -33,7 +33,7 class ReportsController < ApplicationController
33 33 i.status_id=s.id
34 34 and i.tracker_id=t.id
35 35 and i.project_id=#{@project.id}
36 group by s.id, t.id")
36 group by s.id, s.is_closed, t.id")
37 37 @priorities = Enumeration::get_values('IPRI')
38 38 @issues_by_priority =
39 39 ActiveRecord::Base.connection.select_all("select s.id as status_id,
@@ -46,7 +46,7 class ReportsController < ApplicationController
46 46 i.status_id=s.id
47 47 and i.priority_id=p.id
48 48 and i.project_id=#{@project.id}
49 group by s.id, p.id")
49 group by s.id, s.is_closed, p.id")
50 50 @categories = @project.issue_categories
51 51 @issues_by_category =
52 52 ActiveRecord::Base.connection.select_all("select s.id as status_id,
@@ -59,7 +59,7 class ReportsController < ApplicationController
59 59 i.status_id=s.id
60 60 and i.category_id=c.id
61 61 and i.project_id=#{@project.id}
62 group by s.id, c.id")
62 group by s.id, s.is_closed, c.id")
63 63 end
64 64
65 65
Show file before | Show file after | Hide comments
@@ -11,6 +11,13 development:
11 11 host: localhost
12 12 username: root
13 13 password:
14
15 development_pgsql:
16 adapter: postgresql
17 database: redmine
18 host: localhost
19 username: postgres
20 password: "postgres"
14 21
15 22 test:
16 23 adapter: mysql
Show file before | Show file after | Hide comments
@@ -15,13 +15,13 class Setup < ActiveRecord::Migration
15 15
16 16 create_table "custom_fields", :force => true do |t|
17 17 t.column "name", :string, :limit => 30, :default => "", :null => false
18 t.column "typ", :integer, :limit => 6, :default => 0, :null => false
18 t.column "typ", :integer, :default => 0, :null => false
19 19 t.column "is_required", :boolean, :default => false, :null => false
20 20 t.column "is_for_all", :boolean, :default => false, :null => false
21 21 t.column "possible_values", :text, :default => "", :null => false
22 22 t.column "regexp", :string, :default => "", :null => false
23 t.column "min_length", :integer, :limit => 4, :default => 0, :null => false
24 t.column "max_length", :integer, :limit => 4, :default => 0, :null => false
23 t.column "min_length", :integer, :default => 0, :null => false
24 t.column "max_length", :integer, :default => 0, :null => false
25 25 end
26 26
27 27 create_table "custom_fields_projects", :id => false, :force => true do |t|
General Comments 0
You need to be logged in to leave comments. Login now