Added by Stéphane V almost 8 years ago
Hello,
On a resh Openproject installation (manual install, development, branch stable/7) I just added gem ‘openproject-meeting’, git: ‘https://github.com/finnlabs/openproject-meeting.git’, :branch => ‘stable/7’
in my Gemfile.plugins and run bundle install and rake db:reset succesfully.. but : The table “meetings” seems not created :-/
The following error is displayed when I try to display the admin panel :
Showing /home/stephane/www/openproject7/app/views/admin/projects.html.erb where line #68 raised:
Mysql2::Error: Table ‘openproject7_dev.meetings’ doesn’t exist
Where can I find the structure of the table ? There seems to be no database schema with the plugin :-/
Replies (2)
I found the following code in the db schema.rb from openproject 6, which seems has been removed since in openproject 7…
create_table “meeting_content_journals”, force: :cascade, options: “ENGINE=InnoDB DEFAULT CHARSET=utf8” do |t|
t.integer “journal_id”, null: false
t.integer “meeting_id”
t.integer “author_id”
t.text “text”, limit: 65535
t.boolean “locked”
end
create_table “meeting_contents”, force: :cascade, options: “ENGINE=InnoDB DEFAULT CHARSET=utf8” do |t|
t.string “type”
t.integer “meeting_id”
t.integer “author_id”
t.text “text”, limit: 65535
t.integer “lock_version”
t.datetime “created_at”, null: false
t.datetime “updated_at”, null: false
t.boolean “locked”, default: false
end
create_table “meeting_journals”, force: :cascade, options: “ENGINE=InnoDB DEFAULT CHARSET=utf8” do |t|
t.integer “journal_id”, null: false
t.string “title”
t.integer “author_id”
t.integer “project_id”
t.string “location”
t.datetime “start_time”
t.float “duration”, limit: 24
end
create_table “meeting_participants”, force: :cascade, options: “ENGINE=InnoDB DEFAULT CHARSET=utf8” do |t|
t.integer “user_id”
t.integer “meeting_id”
t.string “email”
t.string “name”
t.boolean “invited”
t.boolean “attended”
t.datetime “created_at”, null: false
t.datetime “updated_at”, null: false
end
create_table “meetings”, force: :cascade, options: “ENGINE=InnoDB DEFAULT CHARSET=utf8” do |t|
t.string “title”
t.integer “author_id”
t.integer “project_id”
t.string “location”
t.datetime “start_time”
t.float “duration”, limit: 24
t.datetime “created_at”, null: false
t.datetime “updated_at”, null: false
t.index [“project_id”, “updated_at”], name: “index_meetings_on_project_id_and_updated_at”, using: :btree
end
I created a migration to create the tables with
rails g migration add_documents_and_meetings_tables
and paste the above content and run it. This solved the problem for now…