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

      OpenProject ID 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. db fail to upgrade from bitnami 4.0 to debian package install 6.0 - Table 'announcements' already exists

db fail to upgrade from bitnami 4.0 to debian package install 6.0 - Table 'announcements' already exists

Added by Andrea Consadori over 8 years ago

Hi,
i came from bitnami install, i export manually the sql and the yml file as described in manual backup guide.
Then i install debian package version of openproject 6.0 and restore the db.

once i run openproject run bundle exec rake db:migrate it fails with
“Mysql2::Error: Table ‘announcements’ already exists: CREATE TABLE `announcements` (`id` int(11) auto_increment PRIMARY KEY, `text` text, `show_until` date, `active` tinyint(1) DEFAULT 0, `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB”

and
openproject run bundle exec rake db:seed
You have 21 pending migrations:
20121114100641 AggregatedAnnouncementsMigrations
20141215104802 MigrateAttachmentsToCarrierWave
20150116095004 PatchCorruptAttachments
20150623151337 HideMailByDefault
20150629075221 AddScmTypeToRepositories
20150716133712 AddUniqueIndexOnJournals
20150716163704 RemoveFilesystemRepositories
20150729145732 AddStorageInformationToRepository
20150819143300 UnderscoreScmSettings
20150820133700 DenullifyDisplaySums
20150827133700 RemoveProjectHomepage
20151005113102 RemoveSummaryFromProject
20151028063433 BoolearlizeBoolCustomValues
20151116110245 FixCustomizableBoolValues
20160125143638 IndexMemberRolesInheritedFrom
20160419103544 AddAttributeVisibilityToTypes
20160503150449 AddIndexesForLatestActivity
20160504064737 AddIndexForLatestMeetingActivity
20160504070128 AddIndexForLatestCostActivity
20160726090624 AddSlugToWikiPages
20160803094931 WikiMenuTitlesToSlug
Run `rake db:migrate` to update your database then try again.

what’s the correct path to fix it?


Loading...