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


  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse

Cloudron Forum

Apps | Demo | Docs | Install

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

Scheduled Pinned Locked Moved Solved Ghost
ghost
13 Posts 5 Posters 683 Views
    • 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.
  • scookeS Offline
    scookeS Offline
    scooke
    wrote on last edited by girish
    #1

    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
    0
  • nebulonN Offline
    nebulonN Offline
    nebulon Staff
    wrote on last edited by
    #2

    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
    0
  • V Offline
    V Offline
    vjvanjungg
    wrote on last edited by
    #3

    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!

    murgeroM scookeS 2 Replies Last reply
    0
  • murgeroM Offline
    murgeroM Offline
    murgero App Dev
    replied to vjvanjungg on last edited by
    #4

    @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
    1
  • girishG Do not disturb
    girishG Do not disturb
    girish Staff
    wrote on last edited by
    #5

    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.

    scookeS 1 Reply Last reply
    1
  • scookeS Offline
    scookeS Offline
    scooke
    replied to vjvanjungg on last edited by scooke
    #6

    @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
    1
  • scookeS Offline
    scookeS Offline
    scooke
    replied to girish on last edited by
    #7

    @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
    0
  • girishG Do not disturb
    girishG Do not disturb
    girish Staff
    wrote on last edited by
    #8

    @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.

    scookeS 1 Reply Last reply
    0
  • scookeS Offline
    scookeS Offline
    scooke
    replied to girish on last edited by
    #9

    @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
    0
  • V Offline
    V Offline
    vjvanjungg
    replied to murgero on last edited by
    #10

    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
    1
  • V Offline
    V Offline
    vjvanjungg
    replied to scooke on last edited by
    #11

    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
    0
  • girishG Do not disturb
    girishG Do not disturb
    girish Staff
    wrote on last edited by
    #12

    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
    0
  • girishG Do not disturb
    girishG Do not disturb
    girish Staff
    wrote on last edited by
    #13

    I have pushed a fix for Ghost now.

    1 Reply Last reply
    1

  • Login

  • Don't have an account? Register

  • Login or register to search.
  • First post
    Last post
0
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Login

  • Don't have an account? Register

  • Login or register to search.