Content
[solved] Open Project suddenly crashed with a missing table error !!
Added by PC Chitalkar over 10 years ago
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’
@
Replies (2)
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
Good that you’ve found a solution :)
I mark your thread as solved.
yours,
tessi