jro_apps/redmine Commit - r3:b1ede59d0289

SQL error using PostgreSQL...

Jean-Philippe Lang -

r3:b1ede59d0289

parent child

Context file:

r3:b1ede59d0289

Collapse all files

redmine/.project created 644 +18 0

@@ -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>

redmine/config/environments/development_pgsql.rb created 644 +19 0

@@ -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

redmine/app/controllers/reports_controller.rb +3 -3

                                                               i.status_id=s.id
                                                               and i.tracker_id=t.id
                                                               and i.project_id=#{@project.id}
-                                                            group by s.id, t.id")
+                                                            group by s.id, s.is_closed, t.id")
                 @priorities = Enumeration::get_values('IPRI')
                 @issues_by_priority =
                   ActiveRecord::Base.connection.select_all("select    s.id as status_id,
                                                               i.status_id=s.id
                                                               and i.priority_id=p.id
                                                               and i.project_id=#{@project.id}
-                                                            group by s.id, p.id")
+                                                            group by s.id, s.is_closed, p.id")
                 @categories = @project.issue_categories
                 @issues_by_category =
                   ActiveRecord::Base.connection.select_all("select    s.id as status_id,
                                                               i.status_id=s.id
                                                               and i.category_id=c.id
                                                               and i.project_id=#{@project.id}
-                                                            group by s.id, c.id")
+                                                            group by s.id, s.is_closed, c.id")
               end

redmine/config/database.yml +7 0

               host: localhost
               username: root
               password:
+            development_pgsql:
+              adapter: postgresql
+              database: redmine
+              host: localhost
+              username: postgres
+              password: "postgres"
             test:
               adapter: mysql

redmine/db/migrate/001_setup.rb +3 -3

                 create_table "custom_fields", :force => true do |t|
                   t.column "name", :string, :limit => 30, :default => "", :null => false
-                  t.column "typ", :integer, :limit => 6, :default => 0, :null => false
+                  t.column "typ", :integer, :default => 0, :null => false
                   t.column "is_required", :boolean, :default => false, :null => false
                   t.column "is_for_all", :boolean, :default => false, :null => false
                   t.column "possible_values", :text, :default => "", :null => false
                   t.column "regexp", :string, :default => "", :null => false
-                  t.column "min_length", :integer, :limit => 4, :default => 0, :null => false
+                  t.column "min_length", :integer, :default => 0, :null => false
-                  t.column "max_length", :integer, :limit => 4, :default => 0, :null => false
+                  t.column "max_length", :integer, :default => 0, :null => false
                 end
                 create_table "custom_fields_projects", :id => false, :force => true do |t|

General Comments 0

Write
Preview

You need to be logged in to leave comments. Login now

No TODOs yet

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
g 0-9	Goto bookmarked items from 0-9
n r	New repository page
n g	New gist page

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings
t s	Toggle sidebar on some pages