[solved] Open Project suddenly crashed with a missing table error !!

Started April 28, 2014 18:27 · 2 replies · 2 participants

My open project has suddenly stopped working after i spent 4 days to set it all up and add 9 projects
needless to say i can do a do a over

can someone pls help .. here is my log when i get a 500 error

rebooted servers etc ( i run through passenger)

Started GET “/login?back_url=http%3A%2F%2Fprojects.6degreesit.com%2F” for 42.104.25.11 at 2014-04-28 18:19:36 +0000
Processing by AccountController#login as HTML
Parameters: {“back_url”=>“http://projects.6degreesit.com/”}
Rendered hooks/login/_auth_provider.html.erb (0.1ms)
Rendered account/login.html.erb within layouts/base (5.3ms)
Completed 500 Internal Server Error in 27.9ms

ActionView::Template::Error (Mysql2::Error: Table ‘openproject.principal_roles’ doesn’t exist: SHOW FULL FIELDS FROM `principal_roles`):
73: <%= link_to(I18n.t(‘label_home’), home_url, :class => ‘home-link’) %>
74:

75:

76: <%= render_top_menu_left %>
77:

78: <%= render :partial => ‘search/mini_form’ %>
79:
app/models/user.rb:782:in `flatten’
app/models/user.rb:782:in `candidates_for_global_allowance’
app/models/user.rb:643:in `allowed_to_globally?’
app/models/user.rb:607:in `allowed_to?’
lib/redmine/menu_manager/menu_helper.rb:251:in `call’
lib/redmine/menu_manager/menu_helper.rb:251:in `allowed_node?’
lib/redmine/menu_manager/menu_helper.rb:218:in `block in menu_items_for’
lib/redmine/menu_manager/menu_helper.rb:217:in `each’
lib/redmine/menu_manager/menu_helper.rb:217:in `menu_items_for’
lib/redmine/menu_manager/top_menu_helper.rb:138:in `split_top_menu_into_main_or_more_menus’
lib/redmine/menu_manager/top_menu_helper.rb:120:in `main_top_menu_items’
lib/redmine/menu_manager/top_menu_helper.rb:112:in `render_main_top_menu_nodes’
lib/redmine/menu_manager/top_menu_helper.rb:33:in `block in render_top_menu_left’
lib/redmine/menu_manager/top_menu_helper.rb:32:in `render_top_menu_left’
app/views/layouts/base.html.erb:76:in `_app_views_layouts_base_html_erb**_3060773978554070364_72609600’
@

I found the problem
my Gemfile.plugin had a wrong line in there and it was causing a plugin to be installed half baked . the code was there but the DB rake did nothing
I installed the plugin right by fixing the Gemfile & we are back in business

Philipp Tessenow

04/30/2014 10:42 AM

Good that you’ve found a solution :)
I mark your thread as solved.

yours,
tessi

Content

[solved] Open Project suddenly crashed with a missing table error !!