Project

General

Profile

error running creation of SCM svn repositories with

Added by Manuel Bocos over 12 years ago

The Info of my install (Ubuntu hardy, Redmine 1.3.1 from february integrated ok with ldap AD):

About your application's environment
Ruby version 1.8.6 (i486-linux)
RubyGems version 1.3.7
Rack version 1.1.3
Rails version 2.3.14
Active Record version 2.3.14
Active Resource version 2.3.14
Action Mailer version 2.3.14
Active Support version 2.3.14
Application root /var/www/redmine_new
Environment production
Database adapter mysql
Database schema version 20120127174243

About your Redmine plugins
redmine ics export plugin (aka redmics) 1.3.dev

Running this command to test svn access:
ruby /var/www/redmine_new/extra/svn/reposman.rb --redmine luxor --svn-dir /var/repos/svn --owner www-data --url http://luxor/svn/projects/[Projectname] --key=[key] --verbose

It shows on console:
Unable to connect to http://luxor/sys/: Failed with 500 Internal Server Error

The error show at log/apache2/redmine_error:

ActiveRecord::StatementInvalid (Mysql::Error: Column 'identifier' in order clause is ambiguous: SELECT `projects`.`id` AS t0_r0, `projects`.`name` AS t0_r1, `projects`.`description` AS t0_r2, `projects`.`homepage` AS t0_r3, `projects`.`is_public` AS t0_r4, `projects`.`parent_id` AS t0_r5, `projects`.`created_on` AS t0_r6, `projects`.`updated_on` AS t0_r7, `projects`.`identifier` AS t0_r8, `projects`.`status` AS t0_r9, `projects`.`lft` AS t0_r10, `projects`.`rgt` AS t0_r11, `repositories`.`id` AS t1_r0, `repositories`.`project_id` AS t1_r1, `repositories`.`url` AS t1_r2, `repositories`.`login` AS t1_r3, `repositories`.`password` AS t1_r4, `repositories`.`root_url` AS t1_r5, `repositories`.`type` AS t1_r6, `repositories`.`path_encoding` AS t1_r7, `repositories`.`log_encoding` AS t1_r8, `repositories`.`extra_info` AS t1_r9, `repositories`.`identifier` AS t1_r10, `repositories`.`is_default` AS t1_r11 FROM `projects` LEFT OUTER JOIN `repositories` ON repositories.project_id = projects.id WHERE ((projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='repository')) AND (projects.status = 1)) ORDER BY identifier):
app/models/project.rb:250:in `find'
app/controllers/sys_controller.rb:22:in `projects'
passenger (3.0.11) lib/phusion_passenger/rack/request_handler.rb:96:in `process_request'
passenger (3.0.11) lib/phusion_passenger/abstract_request_handler.rb:513:in `accept_and_process_next_request'
passenger (3.0.11) lib/phusion_passenger/abstract_request_handler.rb:274:in `main_loop'
passenger (3.0.11) lib/phusion_passenger/classic_rails/application_spawner.rb:321:in `start_request_handler'
passenger (3.0.11) lib/phusion_passenger/classic_rails/application_spawner.rb:275:in `send'
passenger (3.0.11) lib/phusion_passenger/classic_rails/application_spawner.rb:275:in `handle_spawn_application'
passenger (3.0.11) lib/phusion_passenger/utils.rb:479:in `safe_fork'
passenger (3.0.11) lib/phusion_passenger/classic_rails/application_spawner.rb:270:in `handle_spawn_application'
passenger (3.0.11) lib/phusion_passenger/abstract_server.rb:357:in `__send__'
passenger (3.0.11) lib/phusion_passenger/abstract_server.rb:357:in `server_main_loop'
passenger (3.0.11) lib/phusion_passenger/abstract_server.rb:206:in `start_synchronously'
passenger (3.0.11) lib/phusion_passenger/abstract_server.rb:180:in `start'
passenger (3.0.11) lib/phusion_passenger/classic_rails/application_spawner.rb:149:in `start'
passenger (3.0.11) lib/phusion_passenger/spawn_manager.rb:219:in `spawn_rails_application'
passenger (3.0.11) lib/phusion_passenger/abstract_server_collection.rb:132:in `lookup_or_add'
passenger (3.0.11) lib/phusion_passenger/spawn_manager.rb:214:in `spawn_rails_application'
passenger (3.0.11) lib/phusion_passenger/abstract_server_collection.rb:82:in `synchronize'
passenger (3.0.11) lib/phusion_passenger/abstract_server_collection.rb:79:in `synchronize'
passenger (3.0.11) lib/phusion_passenger/spawn_manager.rb:213:in `spawn_rails_application'
passenger (3.0.11) lib/phusion_passenger/spawn_manager.rb:132:in `spawn_application'
passenger (3.0.11) lib/phusion_passenger/spawn_manager.rb:275:in `handle_spawn_application'
passenger (3.0.11) lib/phusion_passenger/abstract_server.rb:357:in `__send__'
passenger (3.0.11) lib/phusion_passenger/abstract_server.rb:357:in `server_main_loop'
passenger (3.0.11) lib/phusion_passenger/abstract_server.rb:206:in `start_synchronously'
passenger (3.0.11) helper-scripts/passenger-spawn-server:99

Anyone have any idea if this is a bug at MySQL query or im doing something wrong?
No more wikis, tutorials neither examples to read and test on internet and test.
Many thanks in advance.


Replies (1)

RE: error running creation of SCM svn repositories with - Added by S. Ruttloff over 12 years ago

To find reason for this failure is not so easy.
Have a look into your webserver logs. Maybe you find a advice there.

SaaS Redmine and Subversion / Git Hosting

    (1-1/1)