Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


    Cloudron Forum

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular

    Solved Ghost updates failed, had to use a 2 week old backup

    Ghost
    ghost
    5
    13
    665
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • scooke
      scooke last edited by girish

      So during an update of Ghost there seems to be a failure with the db. Here is what I think is the pertinent section from the logs:

      Migrating database
      INFO Finished database init!
      INFO Creating database backup
      INFO Database backup written to: /app/data/content/data/website.ghost.2019-08-18-17-46-12.json
      ERROR Cannot read property 'schema' of undefined
      
      Cannot read property 'schema' of undefined
      "OuterError: insert into `integrations` (`created_at`, `created_by`, `description`, `icon_image`, `id`, `name`, `slug`, `type`, `updated_at`, `updated_by`) values ('2019-08-18 17:46:12', '1', 'Internal DB Backup integration', NULL, 'somekey', 'Ghost Backup', 'ghost-backup', 'internal', '2019-08-18 17:46:12', '1') - ER_BAD_FIELD_ERROR: Unknown column 'type' in 'field list'"

      Or is the problem some media that's been uploaded??
      Thank you for any help.

      A life lived in fear is a life half-lived

      1 Reply Last reply Reply Quote 0
      • nebulon
        nebulon Staff last edited by

        Thanks for reporting, this was actually hit quite a few times now and we have revoked the latest release. Until this is fixed, please first restore your app instance to the last version.

        1 Reply Last reply Reply Quote 0
        • V
          vjvanjungg last edited by

          Hi @scooke I just wanted to ask from your experience running Ghost on Cloudron, have you ever run into the issue “503. Site is starting up...” like this one:

          717F09BF-0A54-4981-A5E7-57B3B2617EB9.png

          How’s it going until this backup issue? I really want something a bit stable to lean on. Cloudron seems really cool. Many thanks!

          murgero scooke 2 Replies Last reply Reply Quote 0
          • murgero
            murgero App Dev @vjvanjungg last edited by

            @vjvanjungg said in Ghost updates failed, had to use a 2 week old backup:

            Hi @scooke I just wanted to ask from your experience running Ghost on Cloudron, have you ever run into the issue “503. Site is starting up...” like this one:

            How’s it going until this backup issue? I really want something a bit stable to lean on. Cloudron seems really cool. Many thanks!

            You should start your own thread, but it looks like to me the site is still trying to start up.... Let it do it's thing, it might take a few minutes on first launch.

            --
            https://urgero.org
            ~ Professional Nerd. Freelance Programmer. ~
            Matrix: @murgero:urgero.org

            V 1 Reply Last reply Reply Quote 1
            • girish
              girish Staff last edited by

              Just wanted to confirm that there does seem to be some issue with the ghost package starting with version 2.25.0. Working on a fix.

              scooke 1 Reply Last reply Reply Quote 1
              • scooke
                scooke @vjvanjungg last edited by scooke

                @vjvanjungg Hi. No, I haven't run into this. There has been only one other instance of a problem, but I can't recall what it was, but I believe it was related to Ghost versions upgrading. FWIW, the new native Ghost install and update method was super easy and convenient when I was running it on a separate VPS, but Cloudron is just so amazing in so many ways I decided to export my Ghost blogs and import them to my Cloudron VPS and host them here.

                A life lived in fear is a life half-lived

                V 1 Reply Last reply Reply Quote 1
                • scooke
                  scooke @girish last edited by

                  @girish Ok, I've restored from a backup running 2.25.0 and things are running fine. I had already done that once, but Cloudron decided to auto-update it again and it was borked. I've re-restored and everything is fine. Thank goodness for thos backups!

                  PS: How do I earn 1 reputation? This would allow me to give responses on the Forum quicker.

                  A life lived in fear is a life half-lived

                  1 Reply Last reply Reply Quote 0
                  • girish
                    girish Staff last edited by

                    @scooke For now, disable the app auto-update. Configure -> Disable update. I am working on a fix. Can you also tell me what is the ghost package version you are facing this issue? If you click the 'i' button of the app, it will show the package version.

                    scooke 1 Reply Last reply Reply Quote 0
                    • scooke
                      scooke @girish last edited by

                      @girish I'l disable auto-update. The version that works is Ghost 2.26.0 (Package v2.25.0). The version that wasn't working labelled only as Package v2.26.0 in the Backups dropdown. This looks weird since the working version is 2.26.0, but I guess there is some difference if the v is included. I recall it may have been Ghost 2.28.0, even though the latest version on https://github.com/TryGhost/Ghost/releases is 2.28.1.

                      A life lived in fear is a life half-lived

                      1 Reply Last reply Reply Quote 0
                      • V
                        vjvanjungg @murgero last edited by

                        Hey @murgero yea it did take just some seconds to start up. But the problem is the issue keeps occuring after a few hours of inactivity on the site (maybe the server is sleeping or restarting?). I thought this would just be a quick question, but another thread is a good idea.

                        1 Reply Last reply Reply Quote 1
                        • V
                          vjvanjungg @scooke last edited by

                          That’s awesome to hear @scooke Cloudron VPS seems interesting! I am looking into some DigitalOcean servers, but I guess that’s for another thread. Thanks so much for the input! Huge relief!

                          1 Reply Last reply Reply Quote 0
                          • girish
                            girish Staff last edited by

                            So, the issue is that there is a migration in Ghost 2.15 1-add-type-column-to-integrations.js that was not run for some reason. But it's there in the migrations table though. Strange.

                            1 Reply Last reply Reply Quote 0
                            • girish
                              girish Staff last edited by

                              I have pushed a fix for Ghost now.

                              1 Reply Last reply Reply Quote 1
                              • First post
                                Last post
                              Powered by NodeBB