Defect #10136

Error rake db:migrate in BuildsProjectsTree

Added by Alfonso Dou Oblanca over 10 years ago. Updated over 10 years ago.

Status:ClosedStart date:
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:Database
Target version:-
Resolution:Invalid Affected version:1.3.0

Description

I've got this error:

==  BuildProjectsTree: migrating ==============================================
rake aborted!
An error has occurred, all later migrations canceled:

OCIError: ORA-00905: missing keyword: SELECT count(*) AS count_all FROM "PROJECTS"  LEFT OUTER JOIN "PROJECTS" AS parent ON "PROJECTS"."PARENT_ID" = parent.id WHERE ("PROJECTS"."LFT" IS NULL OR "PROJECTS"."RGT" IS NULL OR "PROJECTS"."LFT" >= "PROJECTS"."RGT" OR ("PROJECTS"."PARENT_ID" IS NOT NULL AND ("PROJECTS"."LFT" <= parent."LFT" OR "PROJECTS"."RGT" >= parent."RGT"))) 
/var/www/redmine-1.3.0/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:227:in `log'
/var/lib/gems/1.8/gems/activerecord-oracle_enhanced-adapter-1.4.1/lib/active_record/connection_adapters/oracle_enhanced_adapter.rb:1308:in `log'
/var/lib/gems/1.8/gems/activerecord-oracle_enhanced-adapter-1.4.1/lib/active_record/connection_adapters/oracle_enhanced_adapter.rb:1262:in `select'
/var/www/redmine-1.3.0/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all_without_query_cache'
/var/www/redmine-1.3.0/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:62:in `select_all'
/var/www/redmine-1.3.0/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:13:in `select_one'
/var/www/redmine-1.3.0/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:19:in `select_value'
/var/www/redmine-1.3.0/vendor/rails/activerecord/lib/active_record/calculations.rb:237:in `execute_simple_calculation'
/var/www/redmine-1.3.0/vendor/rails/activerecord/lib/active_record/calculations.rb:134:in `calculate'
/var/www/redmine-1.3.0/vendor/rails/activerecord/lib/active_record/calculations.rb:130:in `catch'
/var/www/redmine-1.3.0/vendor/rails/activerecord/lib/active_record/calculations.rb:130:in `calculate'
/var/www/redmine-1.3.0/vendor/rails/activerecord/lib/active_record/calculations.rb:48:in `count'
/var/www/redmine-1.3.0/vendor/plugins/awesome_nested_set/lib/awesome_nested_set.rb:126:in `left_and_rights_valid?'
/var/www/redmine-1.3.0/vendor/plugins/awesome_nested_set/lib/awesome_nested_set.rb:112:in `valid?'
/var/www/redmine-1.3.0/vendor/plugins/awesome_nested_set/lib/awesome_nested_set.rb:168:in `rebuild!'
./db/migrate//105_build_projects_tree.rb:3:in `up_without_benchmarks'
/var/www/redmine-1.3.0/vendor/rails/activerecord/lib/active_record/migration.rb:282:in `send'
/var/www/redmine-1.3.0/vendor/rails/activerecord/lib/active_record/migration.rb:282:in `migrate'
/usr/lib/ruby/1.8/benchmark.rb:293:in `measure'
/var/www/redmine-1.3.0/vendor/rails/activerecord/lib/active_record/migration.rb:282:in `migrate'
/var/www/redmine-1.3.0/vendor/rails/activerecord/lib/active_record/migration.rb:365:in `__send__'
/var/www/redmine-1.3.0/vendor/rails/activerecord/lib/active_record/migration.rb:365:in `migrate'
/var/www/redmine-1.3.0/vendor/rails/activerecord/lib/active_record/migration.rb:491:in `migrate'
/var/www/redmine-1.3.0/vendor/rails/activerecord/lib/active_record/migration.rb:567:in `call'
/var/www/redmine-1.3.0/vendor/rails/activerecord/lib/active_record/migration.rb:567:in `ddl_transaction'
/var/www/redmine-1.3.0/vendor/rails/activerecord/lib/active_record/migration.rb:490:in `migrate'
/var/www/redmine-1.3.0/vendor/rails/activerecord/lib/active_record/migration.rb:477:in `each'
/var/www/redmine-1.3.0/vendor/rails/activerecord/lib/active_record/migration.rb:477:in `migrate'
/var/www/redmine-1.3.0/vendor/rails/activerecord/lib/active_record/migration.rb:401:in `up'
/var/www/redmine-1.3.0/vendor/rails/activerecord/lib/active_record/migration.rb:383:in `migrate'
/var/www/redmine-1.3.0/vendor/rails/railties/lib/tasks/databases.rake:112
/var/lib/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:205:in `call'
/var/lib/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:205:in `execute'
/var/lib/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:200:in `each'
/var/lib/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:200:in `execute'
/var/lib/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:158:in `invoke_with_call_chain'
/usr/lib/ruby/1.8/monitor.rb:242:in `synchronize'
/var/lib/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:151:in `invoke_with_call_chain'
/var/lib/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:144:in `invoke'
/var/lib/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:116:in `invoke_task'
/var/lib/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:94:in `top_level'
/var/lib/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:94:in `each'
/var/lib/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:94:in `top_level'
/var/lib/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:133:in `standard_exception_handling'
/var/lib/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:88:in `top_level'
/var/lib/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:66:in `run'
/var/lib/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:133:in `standard_exception_handling'
/var/lib/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:63:in `run'
/var/lib/gems/1.8/gems/rake-0.9.2.2/bin/rake:33
/usr/local/bin/rake:19:in `load'
/usr/local/bin/rake:19
Tasks: TOP => db:migrate

I follow this guide http://www.redmine.org/issues/2272


Related issues

Related to Redmine - Feature #944: Oracle Support in Redmine Closed 2008-03-28

History

#1 Updated by Etienne Massip over 10 years ago

  • Category set to Database
  • Status changed from New to Closed
  • Resolution set to Invalid

Closed as Oracle is not supported for now.

Also available in: Atom PDF