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

[scooke]

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.

[nebulon]

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.

[vjvanjungg]

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!

[murgero]

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

[girish]

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]

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

[scooke]

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

[girish]

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

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

[vjvanjungg]

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.

[vjvanjungg]

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!

[girish]

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.

[girish]

I have pushed a fix for Ghost now.