Top Menu

Jump to content
Home
    Modules
      • Projects
      • Activity
      • Work packages
      • Gantt charts
      • Calendars
      • Team planners
      • Boards
      • News
    • Getting started
    • Introduction video
      Welcome to OpenProject Community
      Get a quick overview of project management and team collaboration with OpenProject. You can restart this video from the help menu.
    • Help and support
    • Upgrade to Enterprise edition
    • User guides
    • Videos
    • Shortcuts
    • Community forum
    • Enterprise support
    • Additional resources
    • Data privacy and security policy
    • Digital accessibility (DE)
    • OpenProject website
    • Security alerts / Newsletter
    • OpenProject blog
    • Release notes
    • Report a bug
    • Development roadmap
    • Add and edit translations
    • API documentation
  • Sign in
      Forgot your password?

      or sign in with your existing account

      Google

Side Menu

  • Overview
  • Activity
    Activity
  • Roadmap
  • Work packages
    Work packages
  • Gantt charts
    Gantt charts
  • Calendars
    Calendars
  • Team planners
    Team planners
  • Boards
    Boards
  • News
  • Forums

Content

Support Installation & Updates
  1. OpenProject
  2. Forums
  3. Support Installation & Updates
  4. [solved] Open Project suddenly crashed with a missing table error !!

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

Added by PC Chitalkar about 11 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)

RE: Open Project suddenly crashed with a missing table error !! - Added by PC Chitalkar about 11 years ago

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

RE: Open Project suddenly crashed with a missing table error !! - Added by Philipp Tessenow about 11 years ago

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

yours,
tessi

  • (1 - 2/2)
Loading...