Redmine

*Bug Report "(Mysql::Error: This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'"
As soon as we set "delete jobs" in hudson settings the plugin uses a sql qeury which is not supported by our mysql server. We use mysqld Ver 5.0.51a-24+lenny4 for debian-linux-gnu on x86_64 ((Debian)) .

ActiveRecord::StatementInvalid (Mysql::Error: This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery': SELECT * FROM `hudson_builds` WHERE (hudson_builds.hudson_job_id = 10 and hudson_builds.id not in (select hudson_builds.id from hudson_builds where hudson_builds.hudson_job_id = 10 AND (hudson_builds.id not in (select hudson_builds.id from hudson_builds where hudson_builds.hudson_job_id = 10 order by hudson_builds.number desc limit 3))))  ORDER BY hudson_builds.number LIMIT 1):
  vendor/plugins/redmine_hudson/app/models/hudson_build_rotator.rb:33:in `can_store?'
  vendor/plugins/redmine_hudson/app/models/hudson_job.rb:214:in `fetch_detail'
  /usr/local/lib/ruby/1.8/rexml/element.rb:891:in `each'
  /usr/local/lib/ruby/1.8/rexml/xpath.rb:53:in `each'
  /usr/local/lib/ruby/1.8/rexml/element.rb:891:in `each'
  vendor/plugins/redmine_hudson/app/models/hudson_job.rb:211:in `fetch_detail'
  vendor/plugins/redmine_hudson/app/models/hudson_job.rb:141:in `fetch_builds'
  vendor/plugins/redmine_hudson/app/models/hudson.rb:103:in `fetch_buildresults'
  vendor/plugins/redmine_hudson/app/models/hudson.rb:100:in `each'
  vendor/plugins/redmine_hudson/app/models/hudson.rb:100:in `fetch_buildresults'
  vendor/plugins/redmine_hudson/app/models/hudson.rb:39:in `fetch'
  vendor/plugins/redmine_hudson/app/controllers/hudson_controller.rb:29:in `index'
  passenger (2.2.14) lib/phusion_passenger/rack/request_handler.rb:92:in `process_request'
  passenger (2.2.14) lib/phusion_passenger/abstract_request_handler.rb:207:in `main_loop'
  passenger (2.2.14) lib/phusion_passenger/railz/application_spawner.rb:441:in `start_request_handler'
  passenger (2.2.14) lib/phusion_passenger/railz/application_spawner.rb:381:in `handle_spawn_application'
  passenger (2.2.14) lib/phusion_passenger/utils.rb:252:in `safe_fork'
  passenger (2.2.14) lib/phusion_passenger/railz/application_spawner.rb:377:in `handle_spawn_application'
  passenger (2.2.14) lib/phusion_passenger/abstract_server.rb:352:in `__send__'
  passenger (2.2.14) lib/phusion_passenger/abstract_server.rb:352:in `main_loop'
  passenger (2.2.14) lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously'
  passenger (2.2.14) lib/phusion_passenger/abstract_server.rb:163:in `start'
  passenger (2.2.14) lib/phusion_passenger/railz/application_spawner.rb:222:in `start'
  passenger (2.2.14) lib/phusion_passenger/spawn_manager.rb:262:in `spawn_rails_application'
  passenger (2.2.14) lib/phusion_passenger/abstract_server_collection.rb:126:in `lookup_or_add'
  passenger (2.2.14) lib/phusion_passenger/spawn_manager.rb:256:in `spawn_rails_application'
  passenger (2.2.14) lib/phusion_passenger/abstract_server_collection.rb:80:in `synchronize'
  passenger (2.2.14) lib/phusion_passenger/abstract_server_collection.rb:79:in `synchronize'
  passenger (2.2.14) lib/phusion_passenger/spawn_manager.rb:255:in `spawn_rails_application'
  passenger (2.2.14) lib/phusion_passenger/spawn_manager.rb:154:in `spawn_application'
  passenger (2.2.14) lib/phusion_passenger/spawn_manager.rb:287:in `handle_spawn_application'
  passenger (2.2.14) lib/phusion_passenger/abstract_server.rb:352:in `__send__'
  passenger (2.2.14) lib/phusion_passenger/abstract_server.rb:352:in `main_loop'
  passenger (2.2.14) lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously'

Please help!

Terence Mill wrote:

*Bug Report "(Mysql::Error: This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'"
As soon as we set "delete jobs" in hudson settings the plugin uses a sql qeury which is not supported by our mysql server. We use mysqld Ver 5.0.51a-24+lenny4 for debian-linux-gnu on x86_64 ((Debian)) .

[...]

Please help!

thanks for report.

I fixed this problem, version 1.0.6.1

this message is old.
new message is Hudson Plugin 1.0.5
please use new message next time.

I tried to install the plugin. It looks very cool! I got to the stage where I could enter the URL to my hudson-server, but got an Internal Error immediately afterwards. The log shows: "SocketError (getaddrinfo: Name or service not known)". I run hudson on a Windows-PC. Could someone please confirm or contradict that that is the problem? In other words: does the plug-in work when my hudson-server is a Windows PC?

Thanks!

It shouldn't make a difference whte the hudson run, except how the url looks like.

E.g the Plugins does not work with ssl (https) for us. Also the history and auto remove of build_run sdoes not work stable for us.

It would help a lot if it is possible to define different urls for Plugin (server2server) and that one where the user html is linked.
This way i could enabled http between dedicated redmine server and hudson but have the webseite made of https links.
Furthermore i would like to have green icons and text instead of blue. In the western part of the world we use "green" for sucessfull builds. In hudson i can use plugin for that, but the plugin seems to have its own logic!

Is this project still active?

I noticed that you can't build projects that requires parameters. Will this get fixed in the future.

Hi Aaron.

Aaron Stokes wrote:

Is this project still active?

Yes, I released 1.0.8. but developing slowly.
Created new topic Hudson Plugin 1.0.5

I noticed that you can't build projects that requires parameters. Will this get fixed in the future.

I'll fixed your require.
Can i ask how to use this feature?

• Retry build project with parameters of previous build.
• Build project with new parameters.
• Others...