Ghost: migration failed when update to latest ghost

[sooxt98]

[sooxt98]

I tried to delete the ghost_prod.members_stripe_customers_subscriptions table, now i can't even rollback...

[matthanley]

Hey @sooxt98 👋

In future, please use the issue template provided to ensure we can reproduce and effectively troubleshoot the issue.

For this issue, it would be great if you could provide:

• Reproduction steps
• Ghost Version (migrating _from_ and _to_)
• Node Version
• OS
• Installation method (e.g. manual/ghost-cli)

We also ask that you please do not use GitHub for help or support 😄. If you need assistance with your self-hosted Ghost instance, our forum is a great place to get community support, plus it helps create a central location for searching problems/solutions.

Thanks!

[sooxt98]

@matthanley

Reproduction steps

cd /var/www/ghost
ghost update

Ghost Version (migrating from and to)

2 to 3 (not sure 2.xxx which)

Node Version

12.18.3

OS

ubuntu

Installation method

ghost-cli

[gurpreetatwal]

Running into the same issue

• 2.13.1 -> 3.29.1 fails
• 2.13.1 -> 3.29.0 fails
• 2.13.1 -> 3.28.0 succeeds :)

Node.js Version: 12.18.3

Reproduction steps

1. start with fresh mysql database, no content, nothing but casper theme
2. start ghost 2.13.1
3. stop ghost
4. ghost update
5. start ghost
6. error

node current/index.js log output

[2020-08-15 06:38:50] INFO Blog is in maintenance mode.
[2020-08-15 06:38:50] INFO Ghost is running in development...
[2020-08-15 06:38:50] INFO Listening on: 127.0.0.1:2368
[2020-08-15 06:38:50] INFO Url configured as: http://localhost:2368/
[2020-08-15 06:38:50] INFO Ctrl+C to shut down
[2020-08-15 06:38:50] INFO Ghost boot 2.594s
[2020-08-15 06:38:50] INFO Creating database backup
[2020-08-15 06:38:50] INFO Database backup written to: /tmp/ghost-bug-report/content/data/ghost.ghost.2020-08-15-06-38-50.json
[2020-08-15 06:38:50] INFO Adding table: actions
[2020-08-15 06:38:50] INFO Adding permission for browse:action
[2020-08-15 06:38:50] WARN Adding permission(Browse Actions) to role(Administrator)
[2020-08-15 06:38:50] WARN Adding permission(Browse Actions) to role(Admin Integration)
[2020-08-15 06:38:51] INFO Adding column type in integrations table
[2020-08-15 06:38:51] INFO Adding "Zapier" integration
[2020-08-15 06:38:51] INFO Skip setting db_hash
[2020-08-15 06:38:51] INFO Skip setting next_update_check
[2020-08-15 06:38:51] INFO Skip setting notifications
[2020-08-15 06:38:51] INFO Skip setting session_secret
[2020-08-15 06:38:51] INFO Skip setting title
[2020-08-15 06:38:51] INFO Skip setting description
[2020-08-15 06:38:51] INFO Skip setting logo
[2020-08-15 06:38:51] INFO Skip setting cover_image
[2020-08-15 06:38:51] INFO Skip setting icon
[2020-08-15 06:38:51] INFO Skip setting default_locale
[2020-08-15 06:38:51] INFO Skip setting active_timezone
[2020-08-15 06:38:51] INFO Skip setting force_i18n
[2020-08-15 06:38:51] INFO Skip setting permalinks
[2020-08-15 06:38:51] INFO Skip setting amp
[2020-08-15 06:38:51] INFO Skip setting ghost_head
[2020-08-15 06:38:51] INFO Skip setting ghost_foot
[2020-08-15 06:38:51] INFO Skip setting facebook
[2020-08-15 06:38:51] INFO Skip setting twitter
[2020-08-15 06:38:51] INFO Skip setting labs
[2020-08-15 06:38:51] INFO Skip setting navigation
[2020-08-15 06:38:51] INFO Skip setting slack
[2020-08-15 06:38:51] INFO Skip setting unsplash
[2020-08-15 06:38:51] INFO Skip setting active_theme
[2020-08-15 06:38:51] INFO Skip setting active_apps
[2020-08-15 06:38:51] INFO Skip setting installed_apps
[2020-08-15 06:38:51] INFO Skip setting is_private
[2020-08-15 06:38:51] INFO Skip setting password
[2020-08-15 06:38:51] INFO Skip setting public_hash
[2020-08-15 06:38:51] INFO Skip setting members_public_key
[2020-08-15 06:38:51] INFO Skip setting members_private_key
[2020-08-15 06:38:51] INFO Skip setting members_session_secret
[2020-08-15 06:38:51] INFO Skip setting theme_session_secret
[2020-08-15 06:38:51] INFO Skip setting ghost_public_key
[2020-08-15 06:38:51] INFO Skip setting ghost_private_key
[2020-08-15 06:38:51] INFO Skip setting members_email_auth_secret
[2020-08-15 06:38:51] INFO Skip setting members_stripe_webhook_id
[2020-08-15 06:38:51] INFO Skip setting members_stripe_webhook_secret
[2020-08-15 06:38:51] INFO Skip setting accent_color
[2020-08-15 06:38:51] INFO Skip setting lang
[2020-08-15 06:38:51] INFO Skip setting timezone
[2020-08-15 06:38:51] INFO Skip setting codeinjection_head
[2020-08-15 06:38:51] INFO Skip setting codeinjection_foot
[2020-08-15 06:38:51] INFO Skip setting secondary_navigation
[2020-08-15 06:38:51] INFO Skip setting meta_title
[2020-08-15 06:38:51] INFO Skip setting meta_description
[2020-08-15 06:38:51] INFO Skip setting og_image
[2020-08-15 06:38:51] INFO Skip setting og_title
[2020-08-15 06:38:51] INFO Skip setting og_description
[2020-08-15 06:38:51] INFO Skip setting twitter_image
[2020-08-15 06:38:51] INFO Skip setting twitter_title
[2020-08-15 06:38:51] INFO Skip setting twitter_description
[2020-08-15 06:38:51] INFO Skip setting default_content_visibility
[2020-08-15 06:38:51] INFO Skip setting members_allow_free_signup
[2020-08-15 06:38:51] INFO Skip setting members_from_address
[2020-08-15 06:38:51] INFO Skip setting stripe_product_name
[2020-08-15 06:38:51] INFO Skip setting stripe_secret_key
[2020-08-15 06:38:51] INFO Skip setting stripe_publishable_key
[2020-08-15 06:38:51] INFO Skip setting stripe_plans
[2020-08-15 06:38:51] INFO Skip setting stripe_connect_publishable_key
[2020-08-15 06:38:51] INFO Skip setting stripe_connect_secret_key
[2020-08-15 06:38:51] INFO Skip setting stripe_connect_livemode
[2020-08-15 06:38:51] INFO Skip setting stripe_connect_display_name
[2020-08-15 06:38:51] INFO Skip setting stripe_connect_account_id
[2020-08-15 06:38:51] INFO Skip setting portal_name
[2020-08-15 06:38:51] INFO Skip setting portal_button
[2020-08-15 06:38:51] INFO Skip setting portal_plans
[2020-08-15 06:38:51] INFO Skip setting portal_button_style
[2020-08-15 06:38:51] INFO Skip setting portal_button_icon
[2020-08-15 06:38:51] INFO Skip setting portal_button_signup_text
[2020-08-15 06:38:51] INFO Skip setting mailgun_domain
[2020-08-15 06:38:51] INFO Skip setting mailgun_api_key
[2020-08-15 06:38:51] INFO Skip setting mailgun_base_url
[2020-08-15 06:38:51] INFO Skip setting amp_gtag_id
[2020-08-15 06:38:51] INFO Skip setting shared_views
[2020-08-15 06:38:51] INFO Adding column posts.canonical_url
[2020-08-15 06:38:51] WARN No backup files found, skipping...
[2020-08-15 06:38:51] WARN Permission for browse:notification already added
[2020-08-15 06:38:51] WARN Adding permission(Browse notifications) to role(Editor)
[2020-08-15 06:38:51] WARN Permission for add:notification already added
[2020-08-15 06:38:51] WARN Adding permission(Add notifications) to role(Editor)
[2020-08-15 06:38:51] WARN Permission for destroy:notification already added
[2020-08-15 06:38:51] WARN Adding permission(Delete notifications) to role(Editor)
[2020-08-15 06:38:51] INFO Adding permission for browse:member
[2020-08-15 06:38:51] WARN Adding permission(Browse Members) to role(Administrator)
[2020-08-15 06:38:51] WARN Adding permission(Browse Members) to role(Admin Integration)
[2020-08-15 06:38:51] INFO Adding permission for read:member
[2020-08-15 06:38:51] WARN Adding permission(Read Members) to role(Administrator)
[2020-08-15 06:38:51] WARN Adding permission(Read Members) to role(Admin Integration)
[2020-08-15 06:38:51] INFO Adding permission for edit:member
[2020-08-15 06:38:51] WARN Adding permission(Edit Members) to role(Administrator)
[2020-08-15 06:38:51] WARN Adding permission(Edit Members) to role(Admin Integration)
[2020-08-15 06:38:51] INFO Adding permission for add:member
[2020-08-15 06:38:51] WARN Adding permission(Add Members) to role(Administrator)
[2020-08-15 06:38:51] WARN Adding permission(Add Members) to role(Admin Integration)
[2020-08-15 06:38:51] INFO Adding permission for destroy:member
[2020-08-15 06:38:51] WARN Adding permission(Delete Members) to role(Administrator)
[2020-08-15 06:38:51] WARN Adding permission(Delete Members) to role(Admin Integration)
[2020-08-15 06:38:51] INFO Adding "DB Backup Integration" role to roles table
[2020-08-15 06:38:51] INFO Adding permissions for the "DB Backup Integration" role
[2020-08-15 06:38:51] INFO Adding "Ghost Backup DB" integration
[2020-08-15 06:38:51] INFO Skipping posts.canonical_url subdirectory fix: no subdirectory configured
[2020-08-15 06:38:51] INFO Adding permission for backupContect:db
[2020-08-15 06:38:51] WARN Adding permission(Backup database) to role(Administrator)
[2020-08-15 06:38:51] WARN Adding permission(Backup database) to role(DB Backup Integration)
[2020-08-15 06:38:51] INFO Adding "Scheduler Integration" role to roles table
[2020-08-15 06:38:51] INFO Adding "publish" permissions fixtures for posts
[2020-08-15 06:38:51] INFO Adding "Ghost Scheduler" integration
[2020-08-15 06:38:51] WARN Adding permission(Publish posts) to role(Administrator)
[2020-08-15 06:38:51] WARN Adding permission(Publish posts) to role(Admin Integration)
[2020-08-15 06:38:51] WARN Adding permission(Publish posts) to role(Editor)
[2020-08-15 06:38:51] WARN Adding permission(Publish posts) to role(Scheduler Integration)
[2020-08-15 06:38:51] INFO Dropping members.password column
[2020-08-15 06:38:51] INFO Dropping members.name column
[2020-08-15 06:38:52] INFO Adding members.name column
[2020-08-15 06:38:52] WARN Dropping table: members_stripe_customers
[2020-08-15 06:38:52] INFO Adding table: members_stripe_customers
[2020-08-15 06:38:52] INFO Adding table: members_stripe_customers_subscriptions
[2020-08-15 06:38:52] WARN Adding members_stripe_customers.email column
[2020-08-15 06:38:52] WARN Adding members_stripe_customers.name column
[2020-08-15 06:38:52] INFO Adding members.note column
[2020-08-15 06:38:52] WARN Cannot find members subscription settings.
[2020-08-15 06:38:52] INFO Removing users.ghost_auth_access_token
[2020-08-15 06:38:52] INFO Removing users.ghost_auth_id
[2020-08-15 06:38:52] INFO Dropping table: accesstokens
[2020-08-15 06:38:52] INFO Dropping table: refreshtokens
[2020-08-15 06:38:52] INFO Dropping table: client_trusted_domains
[2020-08-15 06:38:53] INFO Dropping table: clients
[2020-08-15 06:38:53] INFO Adding table: posts_meta
[2020-08-15 06:38:53] INFO Skipping populating posts_meta table: found 0 posts with metadata
[2020-08-15 06:38:53] INFO Dropping posts.meta_title column
[2020-08-15 06:38:53] INFO Dropping posts.meta_description column
[2020-08-15 06:38:53] INFO Dropping posts.og_image column
[2020-08-15 06:38:53] INFO Dropping posts.og_title column
[2020-08-15 06:38:54] INFO Dropping posts.og_description column
[2020-08-15 06:38:54] INFO Dropping posts.twitter_image column
[2020-08-15 06:38:54] INFO Dropping posts.twitter_title column
[2020-08-15 06:38:54] INFO Dropping posts.twitter_description column
[2020-08-15 06:38:54] INFO Adding posts.type
[2020-08-15 06:38:54] INFO Updating posts, setting "type" column to "page" where "page" column is "true"
[2020-08-15 06:38:54] INFO Updating posts, setting "type" column to "post" where "page" column is "false"
[2020-08-15 06:38:54] INFO Removing posts.page
[2020-08-15 06:38:55] WARN Table labels does not exist
[2020-08-15 06:38:55] WARN Table emails does not exist
[2020-08-15 06:38:55] WARN Table emails does not exist
[2020-08-15 06:38:55] WARN Table emails does not exist
[2020-08-15 06:38:55] WARN Table emails does not exist
[2020-08-15 06:38:55] WARN Table emails does not exist
[2020-08-15 06:38:55] WARN Table emails does not exist
[2020-08-15 06:38:55] WARN Table emails does not exist
[2020-08-15 06:38:55] WARN Table emails does not exist
[2020-08-15 06:38:55] INFO Updating posts, setting '' in mobiledoc to 'null'
[2020-08-15 06:38:55] INFO Updating posts, setting '' in html to 'null'
[2020-08-15 06:38:55] INFO Updating posts, setting '' in comment_id to 'null'
[2020-08-15 06:38:55] INFO Updating posts, setting '' in plaintext to 'null'
[2020-08-15 06:38:55] INFO Updating posts, setting '' in feature_image to 'null'
[2020-08-15 06:38:55] INFO Updating posts, setting '' in locale to 'null'
[2020-08-15 06:38:55] INFO Updating posts, setting '' in updated_by to 'null'
[2020-08-15 06:38:55] INFO Updating posts, setting '' in published_by to 'null'
[2020-08-15 06:38:55] INFO Updating posts, setting '' in custom_excerpt to 'null'
[2020-08-15 06:38:55] INFO Updating posts, setting '' in codeinjection_head to 'null'
[2020-08-15 06:38:55] INFO Updating posts, setting '' in codeinjection_foot to 'null'
[2020-08-15 06:38:55] INFO Updating posts, setting '' in custom_template to 'null'
[2020-08-15 06:38:55] INFO Updating posts, setting '' in canonical_url to 'null'
[2020-08-15 06:38:55] INFO Updating posts_meta, setting '' in og_image to 'null'
[2020-08-15 06:38:55] INFO Updating posts_meta, setting '' in og_title to 'null'
[2020-08-15 06:38:55] INFO Updating posts_meta, setting '' in og_description to 'null'
[2020-08-15 06:38:55] INFO Updating posts_meta, setting '' in twitter_image to 'null'
[2020-08-15 06:38:55] INFO Updating posts_meta, setting '' in twitter_title to 'null'
[2020-08-15 06:38:55] INFO Updating posts_meta, setting '' in twitter_description to 'null'
[2020-08-15 06:38:55] INFO Updating posts_meta, setting '' in meta_title to 'null'
[2020-08-15 06:38:55] INFO Updating posts_meta, setting '' in meta_description to 'null'
[2020-08-15 06:38:55] INFO Updating posts_meta, setting '' in email_subject to 'null'
[2020-08-15 06:38:55] INFO Updating users, setting '' in profile_image to 'null'
[2020-08-15 06:38:55] INFO Updating users, setting '' in cover_image to 'null'
[2020-08-15 06:38:55] INFO Updating users, setting '' in bio to 'null'
[2020-08-15 06:38:55] INFO Updating users, setting '' in website to 'null'
[2020-08-15 06:38:55] INFO Updating users, setting '' in location to 'null'
[2020-08-15 06:38:55] INFO Updating users, setting '' in facebook to 'null'
[2020-08-15 06:38:55] INFO Updating users, setting '' in twitter to 'null'
[2020-08-15 06:38:55] INFO Updating users, setting '' in accessibility to 'null'
[2020-08-15 06:38:55] INFO Updating users, setting '' in locale to 'null'
[2020-08-15 06:38:55] INFO Updating users, setting '' in meta_title to 'null'
[2020-08-15 06:38:55] INFO Updating users, setting '' in meta_description to 'null'
[2020-08-15 06:38:55] INFO Updating users, setting '' in tour to 'null'
[2020-08-15 06:38:55] INFO Updating users, setting '' in updated_by to 'null'
[2020-08-15 06:38:55] INFO Updating roles, setting '' in description to 'null'
[2020-08-15 06:38:55] INFO Updating roles, setting '' in updated_by to 'null'
[2020-08-15 06:38:55] INFO Updating permissions, setting '' in object_id to 'null'
[2020-08-15 06:38:55] INFO Updating permissions, setting '' in updated_by to 'null'
[2020-08-15 06:38:55] INFO Updating settings, setting '' in value to 'null'
[2020-08-15 06:38:55] WARN Table 'settings' does not have column 'flags'
[2020-08-15 06:38:55] INFO Updating settings, setting '' in updated_by to 'null'
[2020-08-15 06:38:55] INFO Updating tags, setting '' in description to 'null'
[2020-08-15 06:38:55] INFO Updating tags, setting '' in feature_image to 'null'
[2020-08-15 06:38:55] INFO Updating tags, setting '' in parent_id to 'null'
[2020-08-15 06:38:55] WARN Table 'tags' does not have column 'og_image'
[2020-08-15 06:38:55] WARN Table 'tags' does not have column 'og_title'
[2020-08-15 06:38:55] WARN Table 'tags' does not have column 'og_description'
[2020-08-15 06:38:55] WARN Table 'tags' does not have column 'twitter_image'
[2020-08-15 06:38:55] WARN Table 'tags' does not have column 'twitter_title'
[2020-08-15 06:38:55] WARN Table 'tags' does not have column 'twitter_description'
[2020-08-15 06:38:55] INFO Updating tags, setting '' in meta_title to 'null'
[2020-08-15 06:38:55] INFO Updating tags, setting '' in meta_description to 'null'
[2020-08-15 06:38:55] WARN Table 'tags' does not have column 'codeinjection_head'
[2020-08-15 06:38:55] WARN Table 'tags' does not have column 'codeinjection_foot'
[2020-08-15 06:38:55] WARN Table 'tags' does not have column 'canonical_url'
[2020-08-15 06:38:55] WARN Table 'tags' does not have column 'accent_color'
[2020-08-15 06:38:55] INFO Updating tags, setting '' in updated_by to 'null'
[2020-08-15 06:38:55] INFO Updating apps, setting '' in updated_by to 'null'
[2020-08-15 06:38:55] INFO Updating app_settings, setting '' in value to 'null'
[2020-08-15 06:38:55] INFO Updating app_settings, setting '' in updated_by to 'null'
[2020-08-15 06:38:55] INFO Updating app_fields, setting '' in value to 'null'
[2020-08-15 06:38:55] INFO Updating app_fields, setting '' in updated_by to 'null'
[2020-08-15 06:38:55] INFO Updating invites, setting '' in updated_by to 'null'
[2020-08-15 06:38:55] INFO Updating webhooks, setting '' in name to 'null'
[2020-08-15 06:38:55] INFO Updating webhooks, setting '' in secret to 'null'
[2020-08-15 06:38:55] INFO Updating webhooks, setting '' in integration_id to 'null'
[2020-08-15 06:38:55] INFO Updating webhooks, setting '' in last_triggered_status to 'null'
[2020-08-15 06:38:55] INFO Updating webhooks, setting '' in last_triggered_error to 'null'
[2020-08-15 06:38:55] INFO Updating webhooks, setting '' in updated_by to 'null'
[2020-08-15 06:38:55] INFO Updating integrations, setting '' in icon_image to 'null'
[2020-08-15 06:38:55] INFO Updating integrations, setting '' in description to 'null'
[2020-08-15 06:38:55] INFO Updating integrations, setting '' in updated_by to 'null'
[2020-08-15 06:38:55] INFO Updating api_keys, setting '' in role_id to 'null'
[2020-08-15 06:38:55] INFO Updating api_keys, setting '' in integration_id to 'null'
[2020-08-15 06:38:55] INFO Updating api_keys, setting '' in last_seen_version to 'null'
[2020-08-15 06:38:55] INFO Updating api_keys, setting '' in updated_by to 'null'
[2020-08-15 06:38:55] INFO Updating mobiledoc_revisions, setting '' in mobiledoc to 'null'
[2020-08-15 06:38:55] WARN Table 'members' does not have column 'uuid'
[2020-08-15 06:38:55] INFO Updating members, setting '' in name to 'null'
[2020-08-15 06:38:55] INFO Updating members, setting '' in note to 'null'
[2020-08-15 06:38:55] WARN Table 'members' does not have column 'geolocation'
[2020-08-15 06:38:55] INFO Updating members, setting '' in updated_by to 'null'
[2020-08-15 06:38:55] INFO Updating members_stripe_customers, setting '' in name to 'null'
[2020-08-15 06:38:55] INFO Updating members_stripe_customers, setting '' in email to 'null'
[2020-08-15 06:38:55] INFO Updating members_stripe_customers, setting '' in updated_by to 'null'
[2020-08-15 06:38:55] INFO Updating members_stripe_customers_subscriptions, setting '' in default_payment_card_last4 to 'null'
[2020-08-15 06:38:55] INFO Updating members_stripe_customers_subscriptions, setting '' in updated_by to 'null'
[2020-08-15 06:38:55] INFO Updating actions, setting '' in resource_id to 'null'
[2020-08-15 06:38:55] INFO Updating actions, setting '' in context to 'null'
[2020-08-15 06:38:55] INFO Starting re-generation of posts html.
[2020-08-15 06:38:55] INFO Finished re-generation of posts html.
[2020-08-15 06:38:55] INFO Skipping populating members table: found 0 subscribers
[2020-08-15 06:38:55] INFO Dropping table: subscribers
[2020-08-15 06:38:55] INFO Updating labs setting removing subscribers (was undefined) settings members to false
[2020-08-15 06:38:55] INFO Adding posts.send_email_when_published column
[2020-08-15 06:38:55] WARN Adding posts_meta.email_subject column
[2020-08-15 06:38:55] INFO Adding permission for read:email_preview
[2020-08-15 06:38:55] INFO Adding permission for sendTestEmail:email_preview
[2020-08-15 06:38:55] INFO Adding members.subscribed
[2020-08-15 06:38:55] INFO Adding table: emails
[2020-08-15 06:38:55] INFO Adding permission for read:email
[2020-08-15 06:38:55] WARN Adding permission(Read emails) to role(Administrator)
[2020-08-15 06:38:55] WARN Adding permission(Read emails) to role(Admin Integration)
[2020-08-15 06:38:55] WARN Adding permission(Read emails) to role(Editor)
[2020-08-15 06:38:55] WARN Adding permission(Read emails) to role(Author)
[2020-08-15 06:38:55] WARN Adding permission(Read emails) to role(Contributor)
[2020-08-15 06:38:55] INFO Adding members.uuid
[2020-08-15 06:38:55] INFO Adding uuid field value to 0 members.
[2020-08-15 06:38:55] INFO Adding permission for browse:email
[2020-08-15 06:38:55] WARN Adding permission(Browse emails) to role(Administrator)
[2020-08-15 06:38:55] WARN Adding permission(Browse emails) to role(Admin Integration)
[2020-08-15 06:38:55] WARN Adding permission(Browse emails) to role(Editor)
[2020-08-15 06:38:55] INFO Adding permission for retry:email
[2020-08-15 06:38:55] WARN Adding permission(Retry emails) to role(Administrator)
[2020-08-15 06:38:55] WARN Adding permission(Retry emails) to role(Admin Integration)
[2020-08-15 06:38:55] WARN Adding permission(Retry emails) to role(Editor)
[2020-08-15 06:38:56] WARN Adding emails.error_data column
[2020-08-15 06:38:56] WARN Adding members_stripe_customers_subscriptions.cancel_at_period_end column
[2020-08-15 06:38:56] INFO Adding table: labels
[2020-08-15 06:38:56] INFO Adding table: members_labels
[2020-08-15 06:38:56] INFO Adding permission for browse:label
[2020-08-15 06:38:56] WARN Adding permission(Browse labels) to role(Administrator)
[2020-08-15 06:38:56] WARN Adding permission(Browse labels) to role(Admin Integration)
[2020-08-15 06:38:56] INFO Adding permission for read:label
[2020-08-15 06:38:56] WARN Adding permission(Read labels) to role(Administrator)
[2020-08-15 06:38:56] WARN Adding permission(Read labels) to role(Admin Integration)
[2020-08-15 06:38:56] INFO Adding permission for edit:label
[2020-08-15 06:38:56] WARN Adding permission(Edit labels) to role(Administrator)
[2020-08-15 06:38:56] WARN Adding permission(Edit labels) to role(Admin Integration)
[2020-08-15 06:38:56] INFO Adding permission for add:label
[2020-08-15 06:38:56] WARN Adding permission(Add labels) to role(Administrator)
[2020-08-15 06:38:56] WARN Adding permission(Add labels) to role(Admin Integration)
[2020-08-15 06:38:56] INFO Adding permission for destroy:label
[2020-08-15 06:38:56] WARN Adding permission(Delete labels) to role(Administrator)
[2020-08-15 06:38:56] WARN Adding permission(Delete labels) to role(Admin Integration)
[2020-08-15 06:38:56] INFO Dropping table: members_labels
[2020-08-15 06:38:56] INFO Adding table: members_labels
[2020-08-15 06:38:56] INFO Adding members.geolocation column
[2020-08-15 06:38:56] INFO Adding permission for read:member_signin_url
[2020-08-15 06:38:56] WARN Cannot find members subscription settings.
[2020-08-15 06:38:56] INFO Adding permission for read:identity
[2020-08-15 06:38:56] WARN Cannot find members_subscription_settings settings.
[2020-08-15 06:38:56] WARN Adding permission(Email preview) to role(Administrator)
[2020-08-15 06:38:56] WARN Adding permission(Email preview) to role(Admin Integration)
[2020-08-15 06:38:56] WARN Adding permission(Email preview) to role(Editor)
[2020-08-15 06:38:56] WARN Adding permission(Email preview) to role(Author)
[2020-08-15 06:38:56] WARN Adding permission(Email preview) to role(Contributor)
[2020-08-15 06:38:56] WARN Adding permission(Send test email) to role(Administrator)
[2020-08-15 06:38:56] WARN Adding permission(Send test email) to role(Admin Integration)
[2020-08-15 06:38:56] WARN Adding permission(Send test email) to role(Editor)
[2020-08-15 06:38:56] INFO Adding permission for auth:members_stripe_connect
[2020-08-15 06:38:56] WARN Cannot find members_subscription_settings settings.
[2020-08-15 06:38:56] INFO Removing force_i18n,permalinks,members_session_secret from "settings" table.
[2020-08-15 06:38:56] INFO Updating lang with value from default_locale
[2020-08-15 06:38:56] INFO Deleting default_locale
[2020-08-15 06:38:56] INFO Updating timezone with value from active_timezone
[2020-08-15 06:38:56] INFO Deleting active_timezone
[2020-08-15 06:38:56] INFO Updating codeinjection_head with value from ghost_head
[2020-08-15 06:38:56] INFO Deleting ghost_head
[2020-08-15 06:38:56] INFO Updating codeinjection_foot with value from ghost_foot
[2020-08-15 06:38:56] INFO Deleting ghost_foot
[2020-08-15 06:38:56] WARN Could not find setting brand, not updating accent_color value
[2020-08-15 06:38:56] INFO Adding settings.group column
[2020-08-15 06:38:56] INFO Adding settings.flags column
[2020-08-15 06:38:56] INFO Moving setting members_public_key from members to core
[2020-08-15 06:38:56] INFO Moving setting members_private_key from members to core
[2020-08-15 06:38:56] INFO Moving setting members_email_auth_secret from members to core
[2020-08-15 06:38:56] INFO Moving setting title from blog to site
[2020-08-15 06:38:56] INFO Moving setting description from blog to site
[2020-08-15 06:38:56] INFO Moving setting logo from blog to site
[2020-08-15 06:38:56] INFO Moving setting cover_image from blog to site
[2020-08-15 06:38:56] INFO Moving setting icon from blog to site
[2020-08-15 06:38:56] INFO Moving setting accent_color from blog to site
[2020-08-15 06:38:56] INFO Moving setting lang from blog to site
[2020-08-15 06:38:56] INFO Moving setting timezone from blog to site
[2020-08-15 06:38:56] INFO Moving setting codeinjection_head from blog to site
[2020-08-15 06:38:56] INFO Moving setting codeinjection_foot from blog to site
[2020-08-15 06:38:56] INFO Moving setting facebook from blog to site
[2020-08-15 06:38:56] INFO Moving setting twitter from blog to site
[2020-08-15 06:38:56] INFO Moving setting navigation from blog to site
[2020-08-15 06:38:56] INFO Moving setting secondary_navigation from blog to site
[2020-08-15 06:38:56] INFO Moving setting meta_title from blog to site
[2020-08-15 06:38:56] INFO Moving setting meta_description from blog to site
[2020-08-15 06:38:56] INFO Moving setting og_image from blog to site
[2020-08-15 06:38:56] INFO Moving setting og_title from blog to site
[2020-08-15 06:38:56] INFO Moving setting og_description from blog to site
[2020-08-15 06:38:56] INFO Moving setting twitter_image from blog to site
[2020-08-15 06:38:56] INFO Moving setting twitter_title from blog to site
[2020-08-15 06:38:56] INFO Moving setting twitter_description from blog to site
[2020-08-15 06:38:56] INFO Moving setting amp from blog to amp
[2020-08-15 06:38:56] INFO Moving setting labs from blog to labs
[2020-08-15 06:38:56] INFO Moving setting slack from blog to slack
[2020-08-15 06:38:56] INFO Moving setting unsplash from blog to unsplash
[2020-08-15 06:38:56] INFO Moving setting shared_views from blog to views
[2020-08-15 06:38:56] INFO Moving setting bulk_email_settings from bulk_email to email
[2020-08-15 06:38:56] INFO Adding setting db_hash to core
[2020-08-15 06:38:56] INFO Adding setting next_update_check to core
[2020-08-15 06:38:56] INFO Adding setting notifications to core
[2020-08-15 06:38:56] INFO Adding setting session_secret to core
[2020-08-15 06:38:56] INFO Adding setting theme_session_secret to core
[2020-08-15 06:38:56] INFO Adding setting ghost_public_key to core
[2020-08-15 06:38:56] INFO Adding setting ghost_private_key to core
[2020-08-15 06:38:56] INFO Adding setting active_theme to theme
[2020-08-15 06:38:56] INFO Adding setting is_private to private
[2020-08-15 06:38:56] INFO Adding setting password to private
[2020-08-15 06:38:56] INFO Adding setting public_hash to private
[2020-08-15 06:38:56] INFO Adding setting default_content_visibility to members
[2020-08-15 06:38:56] INFO Adding setting members_subscription_settings to members
[2020-08-15 06:38:56] INFO Adding setting stripe_connect_integration to members
[2020-08-15 06:38:56] INFO Adding setting portal_name to portal
[2020-08-15 06:38:56] INFO Adding setting portal_button to portal
[2020-08-15 06:38:56] INFO Adding setting portal_plans to portal
[2020-08-15 06:38:56] INFO Adding PUBLIC flag to title setting
[2020-08-15 06:38:56] INFO Adding PUBLIC flag to description setting
[2020-08-15 06:38:56] INFO Adding PUBLIC flag to logo setting
[2020-08-15 06:38:56] INFO Adding PUBLIC flag to accent_color setting
[2020-08-15 06:38:56] INFO Adding RO flag to active_theme setting
[2020-08-15 06:38:57] INFO Updating members_from_address setting group,type,flags
[2020-08-15 06:38:57] INFO Updating members_allow_free_signup setting group,type,flags
[2020-08-15 06:38:57] INFO Updating stripe_product_name setting group,type,flags
[2020-08-15 06:38:57] INFO Updating stripe_secret_key setting group,type,flags
[2020-08-15 06:38:57] INFO Updating stripe_publishable_key setting group,type,flags
[2020-08-15 06:38:57] INFO Updating stripe_plans setting group,type,flags
[2020-08-15 06:38:57] WARN Could not find members_subscription_settings - using default values
[2020-08-15 06:38:57] INFO Updating stripe_connect_publishable_key setting group,type,flags
[2020-08-15 06:38:57] INFO Updating stripe_connect_secret_key setting group,type,flags
[2020-08-15 06:38:57] INFO Updating stripe_connect_livemode setting group,type,flags
[2020-08-15 06:38:57] INFO Updating stripe_connect_display_name setting group,type,flags
[2020-08-15 06:38:57] INFO Updating stripe_connect_account_id setting group,type,flags
[2020-08-15 06:38:57] WARN Could not find stripe_connect_integration - using default values
[2020-08-15 06:38:57] INFO Updating type for setting db_hash to string
[2020-08-15 06:38:57] INFO Updating type for setting session_secret to string
[2020-08-15 06:38:57] INFO Updating type for setting theme_session_secret to string
[2020-08-15 06:38:57] INFO Updating type for setting ghost_public_key to string
[2020-08-15 06:38:57] INFO Updating type for setting ghost_private_key to string
[2020-08-15 06:38:57] INFO Updating type for setting title to string
[2020-08-15 06:38:57] INFO Updating type for setting description to string
[2020-08-15 06:38:57] INFO Updating type for setting logo to string
[2020-08-15 06:38:57] INFO Updating type for setting cover_image to string
[2020-08-15 06:38:57] INFO Updating type for setting icon to string
[2020-08-15 06:38:57] INFO Updating type for setting accent_color to string
[2020-08-15 06:38:57] INFO Updating type for setting lang to string
[2020-08-15 06:38:57] INFO Updating type for setting timezone to string
[2020-08-15 06:38:57] INFO Updating type for setting codeinjection_head to string
[2020-08-15 06:38:57] INFO Updating type for setting codeinjection_foot to string
[2020-08-15 06:38:57] INFO Updating type for setting facebook to string
[2020-08-15 06:38:57] INFO Updating type for setting twitter to string
[2020-08-15 06:38:57] INFO Updating type for setting meta_title to string
[2020-08-15 06:38:57] INFO Updating type for setting meta_description to string
[2020-08-15 06:38:57] INFO Updating type for setting og_image to string
[2020-08-15 06:38:57] INFO Updating type for setting og_title to string
[2020-08-15 06:38:57] INFO Updating type for setting og_description to string
[2020-08-15 06:38:57] INFO Updating type for setting twitter_image to string
[2020-08-15 06:38:57] INFO Updating type for setting twitter_title to string
[2020-08-15 06:38:57] INFO Updating type for setting twitter_description to string
[2020-08-15 06:38:57] INFO Updating type for setting active_theme to string
[2020-08-15 06:38:57] INFO Updating type for setting password to string
[2020-08-15 06:38:57] INFO Updating type for setting public_hash to string
[2020-08-15 06:38:57] INFO Updating type for setting members_public_key to string
[2020-08-15 06:38:57] INFO Updating type for setting members_private_key to string
[2020-08-15 06:38:57] INFO Updating type for setting members_email_auth_secret to string
[2020-08-15 06:38:57] INFO Updating type for setting default_content_visibility to string
[2020-08-15 06:38:57] INFO Updating type for setting members_from_address to string
[2020-08-15 06:38:57] INFO Updating type for setting stripe_product_name to string
[2020-08-15 06:38:57] INFO Updating type for setting stripe_secret_key to string
[2020-08-15 06:38:57] INFO Updating type for setting stripe_publishable_key to string
[2020-08-15 06:38:57] INFO Updating type for setting stripe_connect_publishable_key to string
[2020-08-15 06:38:57] INFO Updating type for setting stripe_connect_secret_key to string
[2020-08-15 06:38:57] INFO Updating type for setting stripe_connect_display_name to string
[2020-08-15 06:38:57] INFO Updating type for setting stripe_connect_account_id to string
[2020-08-15 06:38:57] INFO Updating type for setting notifications to array
[2020-08-15 06:38:57] INFO Updating type for setting navigation to array
[2020-08-15 06:38:57] INFO Updating type for setting secondary_navigation to array
[2020-08-15 06:38:57] INFO Updating type for setting slack to array
[2020-08-15 06:38:57] INFO Updating type for setting shared_views to array
[2020-08-15 06:38:57] INFO Updating type for setting portal_plans to array
[2020-08-15 06:38:57] INFO Updating type for setting stripe_plans to array
[2020-08-15 06:38:57] INFO Updating type for setting next_update_check to number
[2020-08-15 06:38:57] INFO Updating type for setting amp to boolean
[2020-08-15 06:38:57] INFO Updating type for setting is_private to boolean
[2020-08-15 06:38:57] INFO Updating type for setting members_allow_free_signup to boolean
[2020-08-15 06:38:57] INFO Updating type for setting portal_name to boolean
[2020-08-15 06:38:57] INFO Updating type for setting portal_button to boolean
[2020-08-15 06:38:57] INFO Updating type for setting stripe_connect_livemode to boolean
[2020-08-15 06:38:57] INFO Updating type for setting labs to object
[2020-08-15 06:38:57] INFO Updating type for setting unsplash to object
[2020-08-15 06:38:57] INFO Updating type for setting bulk_email_settings to object
[2020-08-15 06:38:57] WARN Error parsing bulk_email_settings JSON. Using defaults
[2020-08-15 06:38:57] INFO Updating mailgun_api_key setting's value, group, type & flags.
[2020-08-15 06:38:57] INFO Updating mailgun_domain setting's value, group, type & flags.
[2020-08-15 06:38:57] INFO Updating mailgun_base_url setting's value, group, type & flags.
[2020-08-15 06:38:57] INFO Deleting bulk_email_settings setting
[2020-08-15 06:38:57] INFO Updating portal button setting to false
[2020-08-15 06:38:57] INFO Adding tags.og_image column
[2020-08-15 06:38:57] INFO Adding tags.og_title column
[2020-08-15 06:38:57] INFO Adding tags.og_description column
[2020-08-15 06:38:57] INFO Adding tags.twitter_image column
[2020-08-15 06:38:57] INFO Adding tags.twitter_title column
[2020-08-15 06:38:57] INFO Adding tags.twitter_description column
[2020-08-15 06:38:57] INFO Adding tags.codeinjection_head column
[2020-08-15 06:38:57] INFO Adding tags.codeinjection_foot column
[2020-08-15 06:38:57] INFO Adding tags.canonical_url column
[2020-08-15 06:38:57] INFO Adding tags.accent_color column
[2020-08-15 06:38:57] INFO Updating setting portal_button_style to group portal
[2020-08-15 06:38:57] INFO Updating setting portal_button_icon to group portal
[2020-08-15 06:38:57] INFO Updating setting portal_button_signup_text to group portal
[2020-08-15 06:38:57] INFO Updating members_stripe_webhook_id & members_stripe_webhook_secret settings to group: core, type: string, flags: null
[2020-08-15 06:38:57] INFO Updating amp_gtag_id setting to amp group
[2020-08-15 06:38:57] INFO No duplicate subscriptions found
[2020-08-15 06:38:57] INFO No duplicate customers found
[2020-08-15 06:38:57] INFO No orphaned customer records found
[2020-08-15 06:38:57] INFO No orphaned subscription records found
[2020-08-15 06:38:57] WARN Skipping ON DELETE CASCADE for "members_labels_member_id_foreign" constraint - already set
[2020-08-15 06:38:57] WARN Skipping ON DELETE CASCADE for "members_labels_label_id_foreign" constraint - already set
[2020-08-15 06:38:57] WARN Skipping "members_stripe_customers_member_id_foreign" foreign key constraint creation - already exists
[2020-08-15 06:38:57] WARN Skipping "members_stripe_customers_customer_id_unique" index creation - already exists
[2020-08-15 06:38:57] INFO Adding "members_stripe_customers_subscriptions_subscription_id_unique" index
[2020-08-15 06:38:57] INFO Removing tags.og_image column
[2020-08-15 06:38:57] INFO Removing tags.og_title column
[2020-08-15 06:38:57] INFO Removing tags.og_description column
[2020-08-15 06:38:57] INFO Removing tags.twitter_image column
[2020-08-15 06:38:57] INFO Removing tags.twitter_title column
[2020-08-15 06:38:57] INFO Removing tags.twitter_description column
[2020-08-15 06:38:57] INFO Removing tags.codeinjection_head column
[2020-08-15 06:38:58] INFO Removing tags.codeinjection_foot column
[2020-08-15 06:38:58] INFO Removing tags.canonical_url column
[2020-08-15 06:38:58] INFO Removing tags.accent_color column
[2020-08-15 06:38:58] INFO Restoring bulk_email_settings setting from mailgun settings
[2020-08-15 06:38:58] INFO Deleting settings: mailgun_api_key, mailgun_domain, mailgun_base_url
[2020-08-15 06:38:58] INFO Resetting type for db_hash
[2020-08-15 06:38:58] INFO Resetting type for session_secret
[2020-08-15 06:38:58] INFO Resetting type for theme_session_secret
[2020-08-15 06:38:58] INFO Resetting type for ghost_public_key
[2020-08-15 06:38:58] INFO Resetting type for ghost_private_key
[2020-08-15 06:38:58] INFO Resetting type for title
[2020-08-15 06:38:58] INFO Resetting type for description
[2020-08-15 06:38:58] INFO Resetting type for logo
[2020-08-15 06:38:58] INFO Resetting type for cover_image
[2020-08-15 06:38:58] INFO Resetting type for icon
[2020-08-15 06:38:58] INFO Resetting type for accent_color
[2020-08-15 06:38:58] INFO Resetting type for lang
[2020-08-15 06:38:58] INFO Resetting type for timezone
[2020-08-15 06:38:58] INFO Resetting type for codeinjection_head
[2020-08-15 06:38:58] INFO Resetting type for codeinjection_foot
[2020-08-15 06:38:58] INFO Resetting type for facebook
[2020-08-15 06:38:58] INFO Resetting type for twitter
[2020-08-15 06:38:58] INFO Resetting type for meta_title
[2020-08-15 06:38:58] INFO Resetting type for meta_description
[2020-08-15 06:38:58] INFO Resetting type for og_image
[2020-08-15 06:38:58] INFO Resetting type for og_title
[2020-08-15 06:38:58] INFO Resetting type for og_description
[2020-08-15 06:38:58] INFO Resetting type for twitter_image
[2020-08-15 06:38:58] INFO Resetting type for twitter_title
[2020-08-15 06:38:58] INFO Resetting type for twitter_description
[2020-08-15 06:38:58] INFO Resetting type for active_theme
[2020-08-15 06:38:58] INFO Resetting type for password
[2020-08-15 06:38:58] INFO Resetting type for public_hash
[2020-08-15 06:38:58] INFO Resetting type for members_public_key
[2020-08-15 06:38:58] INFO Resetting type for members_private_key
[2020-08-15 06:38:58] INFO Resetting type for members_email_auth_secret
[2020-08-15 06:38:58] INFO Resetting type for default_content_visibility
[2020-08-15 06:38:58] INFO Resetting type for members_from_address
[2020-08-15 06:38:58] INFO Resetting type for stripe_product_name
[2020-08-15 06:38:58] INFO Resetting type for stripe_secret_key
[2020-08-15 06:38:58] INFO Resetting type for stripe_publishable_key
[2020-08-15 06:38:58] INFO Resetting type for stripe_connect_publishable_key
[2020-08-15 06:38:58] INFO Resetting type for stripe_connect_secret_key
[2020-08-15 06:38:58] INFO Resetting type for stripe_connect_display_name
[2020-08-15 06:38:58] INFO Resetting type for stripe_connect_account_id
[2020-08-15 06:38:58] INFO Resetting type for notifications
[2020-08-15 06:38:58] INFO Resetting type for navigation
[2020-08-15 06:38:58] INFO Resetting type for secondary_navigation
[2020-08-15 06:38:58] INFO Resetting type for slack
[2020-08-15 06:38:58] INFO Resetting type for shared_views
[2020-08-15 06:38:58] INFO Resetting type for portal_plans
[2020-08-15 06:38:58] INFO Resetting type for stripe_plans
[2020-08-15 06:38:58] INFO Resetting type for next_update_check
[2020-08-15 06:38:58] INFO Resetting type for amp
[2020-08-15 06:38:58] INFO Resetting type for is_private
[2020-08-15 06:38:58] INFO Resetting type for members_allow_free_signup
[2020-08-15 06:38:58] INFO Resetting type for portal_name
[2020-08-15 06:38:58] INFO Resetting type for portal_button
[2020-08-15 06:38:58] INFO Resetting type for stripe_connect_livemode
[2020-08-15 06:38:58] INFO Resetting type for labs
[2020-08-15 06:38:58] INFO Resetting type for unsplash
[2020-08-15 06:38:58] INFO Resetting type for bulk_email_settings
[2020-08-15 06:38:58] INFO Inserting stripe_connect_integration setting
[2020-08-15 06:38:58] INFO Deleting stripe_connect_account_id, stripe_connect_display_name, stripe_connect_livemode, stripe_connect_publishable_key, stripe_connect_secret_key settings
[2020-08-15 06:38:58] INFO Inserting members_subscription_settings setting
[2020-08-15 06:38:58] INFO Deleting members_from_address setting
[2020-08-15 06:38:58] INFO Deleting members_allow_free_signup setting
[2020-08-15 06:38:58] INFO Deleting stripe_plans setting
[2020-08-15 06:38:58] INFO Deleting stripe_product_name setting
[2020-08-15 06:38:58] INFO Deleting stripe_publishable_key setting
[2020-08-15 06:38:58] INFO Deleting stripe_secret_key setting
[2020-08-15 06:38:58] INFO Clearing all settings flags values
[2020-08-15 06:38:58] INFO Moving setting members_public_key from members to core
[2020-08-15 06:38:58] INFO Moving setting members_private_key from members to core
[2020-08-15 06:38:58] INFO Moving setting members_email_auth_secret from members to core
[2020-08-15 06:38:58] INFO Moving setting title from blog to site
[2020-08-15 06:38:58] INFO Moving setting description from blog to site
[2020-08-15 06:38:58] INFO Moving setting logo from blog to site
[2020-08-15 06:38:58] INFO Moving setting cover_image from blog to site
[2020-08-15 06:38:58] INFO Moving setting icon from blog to site
[2020-08-15 06:38:58] INFO Moving setting accent_color from blog to site
[2020-08-15 06:38:58] INFO Moving setting lang from blog to site
[2020-08-15 06:38:58] INFO Moving setting timezone from blog to site
[2020-08-15 06:38:58] INFO Moving setting codeinjection_head from blog to site
[2020-08-15 06:38:58] INFO Moving setting codeinjection_foot from blog to site
[2020-08-15 06:38:58] INFO Moving setting facebook from blog to site
[2020-08-15 06:38:58] INFO Moving setting twitter from blog to site
[2020-08-15 06:38:58] INFO Moving setting navigation from blog to site
[2020-08-15 06:38:58] INFO Moving setting secondary_navigation from blog to site
[2020-08-15 06:38:58] INFO Moving setting meta_title from blog to site
[2020-08-15 06:38:58] INFO Moving setting meta_description from blog to site
[2020-08-15 06:38:58] INFO Moving setting og_image from blog to site
[2020-08-15 06:38:58] INFO Moving setting og_title from blog to site
[2020-08-15 06:38:58] INFO Moving setting og_description from blog to site
[2020-08-15 06:38:58] INFO Moving setting twitter_image from blog to site
[2020-08-15 06:38:58] INFO Moving setting twitter_title from blog to site
[2020-08-15 06:38:58] INFO Moving setting twitter_description from blog to site
[2020-08-15 06:38:58] INFO Moving setting amp from blog to amp
[2020-08-15 06:38:58] INFO Moving setting labs from blog to labs
[2020-08-15 06:38:58] INFO Moving setting slack from blog to slack
[2020-08-15 06:38:58] INFO Moving setting unsplash from blog to unsplash
[2020-08-15 06:38:58] INFO Moving setting shared_views from blog to views
[2020-08-15 06:38:58] INFO Moving setting bulk_email_settings from bulk_email to email
[2020-08-15 06:38:58] INFO Removing settings.group column
[2020-08-15 06:38:58] INFO Removing settings.flags column
[2020-08-15 06:38:58] INFO Updating default_locale with value from lang
[2020-08-15 06:38:58] INFO Deleting default_locale
[2020-08-15 06:38:58] INFO Updating active_timezone with value from timezone
[2020-08-15 06:38:58] INFO Deleting active_timezone
[2020-08-15 06:38:58] INFO Updating ghost_head with value from codeinjection_head
[2020-08-15 06:38:58] INFO Deleting ghost_head
[2020-08-15 06:38:58] INFO Updating ghost_foot with value from codeinjection_foot
[2020-08-15 06:38:58] INFO Deleting ghost_foot
[2020-08-15 06:38:58] INFO Updating brand with value from accent_color
[2020-08-15 06:38:58] INFO Deleting brand
[2020-08-15 06:38:58] INFO Adding force_i18n, permalinks, and members_session_secret to "settings" table.
[2020-08-15 06:38:58] INFO Removing domain in fromAddress in members settings
[2020-08-15 06:38:58] INFO Removing permission for auth:members_stripe_connect
[2020-08-15 06:38:58] INFO Removing permission(Send test email) from role(Editor)
[2020-08-15 06:38:58] INFO Removing permission(Send test email) from role(Admin Integration)
[2020-08-15 06:38:58] INFO Removing permission(Send test email) from role(Administrator)
[2020-08-15 06:38:58] INFO Removing permission(Email preview) from role(Contributor)
[2020-08-15 06:38:58] INFO Removing permission(Email preview) from role(Author)
[2020-08-15 06:38:58] INFO Removing permission(Email preview) from role(Editor)
[2020-08-15 06:38:58] INFO Removing permission(Email preview) from role(Admin Integration)
[2020-08-15 06:38:58] INFO Removing permission(Email preview) from role(Administrator)
[2020-08-15 06:38:58] INFO Removing permission for read:identity
[2020-08-15 06:38:58] INFO Removing permission for read:member_signin_url
[2020-08-15 06:38:58] INFO Removing members.geolocation column
[2020-08-15 06:38:58] INFO Removing permission(Delete labels) from role(Admin Integration)
[2020-08-15 06:38:58] INFO Removing permission(Delete labels) from role(Administrator)
[2020-08-15 06:38:58] INFO Removing permission for destroy:label
[2020-08-15 06:38:58] INFO Removing permission(Add labels) from role(Admin Integration)
[2020-08-15 06:38:58] INFO Removing permission(Add labels) from role(Administrator)
[2020-08-15 06:38:58] INFO Removing permission for add:label
[2020-08-15 06:38:58] INFO Removing permission(Edit labels) from role(Admin Integration)
[2020-08-15 06:38:58] INFO Removing permission(Edit labels) from role(Administrator)
[2020-08-15 06:38:58] INFO Removing permission for edit:label
[2020-08-15 06:38:58] INFO Removing permission(Read labels) from role(Admin Integration)
[2020-08-15 06:38:58] INFO Removing permission(Read labels) from role(Administrator)
[2020-08-15 06:38:58] INFO Removing permission for read:label
[2020-08-15 06:38:58] INFO Removing permission(Browse labels) from role(Admin Integration)
[2020-08-15 06:38:58] INFO Removing permission(Browse labels) from role(Administrator)
[2020-08-15 06:38:58] INFO Removing permission for browse:label
[2020-08-15 06:38:58] INFO Dropping table: members_labels
[2020-08-15 06:38:58] INFO Dropping table: labels
[2020-08-15 06:38:58] INFO Removing members_stripe_customers_subscriptions.cancel_at_period_end column
[2020-08-15 06:38:58] INFO Removing emails.error_data column
[2020-08-15 06:38:58] INFO Removing permission(Retry emails) from role(Editor)
[2020-08-15 06:38:58] INFO Removing permission(Retry emails) from role(Admin Integration)
[2020-08-15 06:38:58] INFO Removing permission(Retry emails) from role(Administrator)
[2020-08-15 06:38:58] INFO Removing permission for retry:email
[2020-08-15 06:38:58] INFO Removing permission(Browse emails) from role(Editor)
[2020-08-15 06:38:58] INFO Removing permission(Browse emails) from role(Admin Integration)
[2020-08-15 06:38:58] INFO Removing permission(Browse emails) from role(Administrator)
[2020-08-15 06:38:58] INFO Removing permission for browse:email
[2020-08-15 06:38:58] INFO Removing members.uuid
[2020-08-15 06:38:58] INFO Removing permission(Read emails) from role(Contributor)
[2020-08-15 06:38:58] INFO Removing permission(Read emails) from role(Author)
[2020-08-15 06:38:58] INFO Removing permission(Read emails) from role(Editor)
[2020-08-15 06:38:58] INFO Removing permission(Read emails) from role(Admin Integration)
[2020-08-15 06:38:58] INFO Removing permission(Read emails) from role(Administrator)
[2020-08-15 06:38:58] INFO Removing permission for read:email
[2020-08-15 06:38:58] INFO Dropping table: emails
[2020-08-15 06:38:58] INFO Removing members.subscribed
[2020-08-15 06:38:58] INFO Removing permission for sendTestEmail:email_preview
[2020-08-15 06:38:58] INFO Removing permission for read:email_preview
[2020-08-15 06:38:58] INFO Removing posts_meta.email_subject column
[2020-08-15 06:38:58] INFO Removing posts.send_email_when_published column
[2020-08-15 06:38:58] ERROR alter table `members_stripe_customers_subscriptions` add unique `members_stripe_customers_subscriptions_subscription_id_unique`(`subscription_id`) - ER_DUP_KEYNAME: Duplicate key name 'members_stripe_customers_subscriptions_subscription_id_unique'

alter table `members_stripe_customers_subscriptions` add unique `members_stripe_customers_subscriptions_subscription_id_unique`(`subscription_id`) - ER_DUP_KEYNAME: Duplicate key name 'members_stripe_customers_subscriptions_subscription_id_unique'

{"config":{"transaction":true},"name":"05-add-member-constraints.js"}
"Error occurred while executing the following migration: 05-add-member-constraints.js"

Error ID:
    300

Error Code: 
    ER_DUP_KEYNAME

----------------------------------------

MigrationScriptError: alter table `members_stripe_customers_subscriptions` add unique `members_stripe_customers_subscriptions_subscription_id_unique`(`subscription_id`) - ER_DUP_KEYNAME: Duplicate key name 'members_stripe_customers_subscriptions_subscription_id_unique'
    at MigrationScriptError.KnexMigrateError (/tmp/ghost-bug-report/versions/3.29.0/node_modules/knex-migrator/lib/errors.js:7:26)
    at new MigrationScriptError (/tmp/ghost-bug-report/versions/3.29.0/node_modules/knex-migrator/lib/errors.js:25:26)
    at /tmp/ghost-bug-report/versions/3.29.0/node_modules/knex-migrator/lib/index.js:1055:19

Error: ER_DUP_KEYNAME: Duplicate key name 'members_stripe_customers_subscriptions_subscription_id_unique'
    at Query.Sequence._packetToError (/tmp/ghost-bug-report/versions/3.29.0/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14)
    at Query.ErrorPacket (/tmp/ghost-bug-report/versions/3.29.0/node_modules/mysql/lib/protocol/sequences/Query.js:79:18)
    at Protocol._parsePacket (/tmp/ghost-bug-report/versions/3.29.0/node_modules/mysql/lib/protocol/Protocol.js:291:23)
    at Parser._parsePacket (/tmp/ghost-bug-report/versions/3.29.0/node_modules/mysql/lib/protocol/Parser.js:433:10)
    at Parser.write (/tmp/ghost-bug-report/versions/3.29.0/node_modules/mysql/lib/protocol/Parser.js:43:10)
    at Protocol.write (/tmp/ghost-bug-report/versions/3.29.0/node_modules/mysql/lib/protocol/Protocol.js:38:16)
    at Socket. (/tmp/ghost-bug-report/versions/3.29.0/node_modules/mysql/lib/Connection.js:88:28)
    at Socket. (/tmp/ghost-bug-report/versions/3.29.0/node_modules/mysql/lib/Connection.js:526:10)
    at Socket.emit (events.js:315:20)
    at Socket.EventEmitter.emit (domain.js:483:12)
    at addChunk (_stream_readable.js:295:12)
    at readableAddChunk (_stream_readable.js:271:9)
    at Socket.Readable.push (_stream_readable.js:212:10)
    at TCP.onStreamRead (internal/stream_base_commons.js:186:23)
    --------------------
    at Protocol._enqueue (/tmp/ghost-bug-report/versions/3.29.0/node_modules/mysql/lib/protocol/Protocol.js:144:48)
    at Connection.query (/tmp/ghost-bug-report/versions/3.29.0/node_modules/mysql/lib/Connection.js:198:25)
    at /tmp/ghost-bug-report/versions/3.29.0/node_modules/knex-migrator/node_modules/knex/lib/dialects/mysql/index.js:135:18
    at Promise._execute (/tmp/ghost-bug-report/versions/3.29.0/node_modules/bluebird/js/release/debuggability.js:384:9)
    at Promise._resolveFromExecutor (/tmp/ghost-bug-report/versions/3.29.0/node_modules/bluebird/js/release/promise.js:518:18)
    at new Promise (/tmp/ghost-bug-report/versions/3.29.0/node_modules/bluebird/js/release/promise.js:103:10)
    at Client_MySQL._query (/tmp/ghost-bug-report/versions/3.29.0/node_modules/knex-migrator/node_modules/knex/lib/dialects/mysql/index.js:129:12)
    at Client_MySQL.query (/tmp/ghost-bug-report/versions/3.29.0/node_modules/knex-migrator/node_modules/knex/lib/client.js:169:17)
    at /tmp/ghost-bug-report/versions/3.29.0/node_modules/knex-migrator/node_modules/knex/lib/transaction.js:321:24
    at Promise._execute (/tmp/ghost-bug-report/versions/3.29.0/node_modules/bluebird/js/release/debuggability.js:384:9)
    at Promise._resolveFromExecutor (/tmp/ghost-bug-report/versions/3.29.0/node_modules/bluebird/js/release/promise.js:518:18)
    at new Promise (/tmp/ghost-bug-report/versions/3.29.0/node_modules/bluebird/js/release/promise.js:103:10)
    at Client_MySQL.trxClient.query (/tmp/ghost-bug-report/versions/3.29.0/node_modules/knex-migrator/node_modules/knex/lib/transaction.js:316:12)
    at Runner.query (/tmp/ghost-bug-report/versions/3.29.0/node_modules/knex-migrator/node_modules/knex/lib/runner.js:151:36)
    at Runner.queryArray (/tmp/ghost-bug-report/versions/3.29.0/node_modules/knex-migrator/node_modules/knex/lib/runner.js:243:19)
    at /tmp/ghost-bug-report/versions/3.29.0/node_modules/knex-migrator/node_modules/knex/lib/runner.js:38:25

[sooxt98]

Is there a way to force migration for specific table? Or maybe reset specific table?

[gurpreetatwal]

I'm not too sure on the specifics of how ghost does the migrations, but I was able to work around the issue by going from 2.13.1 to 3.28.0 and then going from 2.13.1 to 3.28.1

Do you have a back up of the DB prior to upgrade? If so, I would just restore that and try out the 2 step upgrade

[ErisDS]

Can the two of you both please confirm the OS and OS version of your server as well as the full details of the database type, flavour and version you are using.

I want to make it very clear, bug reports are for collaborating on getting an issue fixed and require information to be provided up front. If you just want help finding a workaround, then the forum is the appropriate place for that.

[sooxt98]

Hi @ErisDS , here's my server info
MySQL Ver 14.14 Distrib 5.7.31, for Linux (x86_64) using EditLine wrapper
Ubuntu 18.04.3 LTS (GNU/Linux 4.15.0-112-generic x86_64)

[gurpreetatwal]

Apologies on not putting up enough info, I assumed that the bug wouldn't be OS dependent.

Here's my info:

• My machine's OS: Ubuntu 18.04.5 LTS - 5.4.0-21-generic - x86_64
• MySQL version: 5.7.31 - running in docker, docker-compose.yaml below
• I also face the same issue when running ghost in docker using node:12 as the base image

mysql:
  image: mysql:5.7
  container_name: mysql
  environment:
    MYSQL_DATABASE: ghost
    MYSQL_ROOT_PASSWORD: development
  ports:
    - '3306:3306'

[ErisDS]

Critical part of the logs:

First, these are the 2.33 migrations

[2020-08-15 06:38:52] WARN Dropping table: members_stripe_customers
[2020-08-15 06:38:52] INFO Adding table: members_stripe_customers
[2020-08-15 06:38:52] INFO Adding table: members_stripe_customers_subscriptions
[2020-08-15 06:38:52] WARN Adding members_stripe_customers.email column
[2020-08-15 06:38:52] WARN Adding members_stripe_customers.name column
[2020-08-15 06:38:52] INFO Adding members.note column

Then the latest migrations

[2020-08-15 06:38:57] INFO No duplicate subscriptions found
[2020-08-15 06:38:57] INFO No duplicate customers found
[2020-08-15 06:38:57] INFO No orphaned customer records found
[2020-08-15 06:38:57] INFO No orphaned subscription records found
[2020-08-15 06:38:57] WARN Skipping ON DELETE CASCADE for "members_labels_member_id_foreign" constraint - already set
[2020-08-15 06:38:57] WARN Skipping ON DELETE CASCADE for "members_labels_label_id_foreign" constraint - already set
[2020-08-15 06:38:57] WARN Skipping "members_stripe_customers_member_id_foreign" foreign key constraint creation - already exists
[2020-08-15 06:38:57] WARN Skipping "members_stripe_customers_customer_id_unique" index creation - already exists
[2020-08-15 06:38:57] INFO Adding "members_stripe_customers_subscriptions_subscription_id_unique" index
[2020-08-15 06:38:57] INFO Removing tags.og_image column

Our code for detecting the index existing doesn't seem to work.

Also note, the migrations kick off a rollback without any messaging!

[sooxt98]

@kevinansfield hi there what should i do if i deleted that ghost_prod.members_stripe_customers_subscriptions table, i'm stuck, Is there a way to force migration for specific table? Or maybe reset specific table?

[ErisDS]

@sooxt98 for support you need to use the forum.

[sooxt98]

hi @ErisDS I have solved my problem with knex-migrator reset and manual hand migration, thanks.

[daniellockyer]

Hey @sooxt98 & @gurpreetatwal :wave: We just released 3.29.2 with a fix for this, so please update using Ghost-CLI :slightly_smiling_face: