Hi Andreas, unfortunately my post to this list from Sep 11th, 12:56 CEST is not in the list archive... On Fri, 18 Oct 2013 13:12:49 +0200 Andreas Herrmann <a.herrmann@heinlein-support.de> wrote:
Hi there,
after updating OBS 2.4 (zypper ref; zypper up) I just get an application error 500, when I want to list all projects in the webui. 'osc list' still works
==> /srv/www/obs/api/log/production.log <== [INFO |# 3196] Processing by WebuiController#all_projects as XML [INFO |# 3196] iChain user extracted from header: adm_ahe [INFO |# 3196] Completed 500 Internal Server Error in 57ms [FATAL|# 3196] NoMethodError (undefined method `id' for nil:NilClass): app/controllers/webui_controller.rb:270:in `all_projects' config/initializers/wrap_parameters.rb:35:in `call'
==> /srv/www/obs/webui/log/production.log <== [FATAL|# 2680] ActiveXML::Transport::Error (#Net::HTTPInternalServerError:0x000000059b46f0): lib/activexml/transport.rb:461:in `handle_response' lib/activexml/transport.rb:400:in `http_do' app/models/api_details.rb:26:in `find' app/controllers/project_controller.rb:39:in `list' app/controllers/project_controller.rb:35:in `list_public'
Any ideas?
My answer from Sep 11th: ... and I thought, that I was the sole user running into that problem! There are (at least) two database entries missing after an update to 2.4 from a previous OBS installation. Add the two entries in the projects and repositories table: root# mysql -u root -p[database password] api_production mysql> insert into projects (id,name,title,description,created_at,updated_at) values ('2','deleted',NULL,NULL,now(),now()); mysql> insert into repositories (id,db_project_id,name,remote_project_name,rebuild,block,linkedbuild,hostsystem_id) values ('1','1','deleted',NULL,NULL,NULL,NULL,NULL); mysql> quit You of course may want to check, that there are no entries with the same id's are in the tables already. The update process does not cover these entries, as they are most probably so basic, that they are expected to be there. PLEASE check the wrapped lines for the insert statements above. Greetings, Stefan -- Stefan Botter Network Manager Jacobs University Bremen gGmbH Campus Ring 1 | 28759 Bremen | Germany Commercial registry: Amtsgericht Bremen, HRB 18117 President & Geschäftsführer: Prof. Dr. Heinz-Otto Peitgen Provost & Geschäftsführerin: Prof. Dr.-Ing. Katja Windt Chair Board of Governors: Prof. Dr. Karin Lochte