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

Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

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

Ghost

5

13

665

Log in to reply

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
[36mINFO[39m Finished database init!
[36mINFO[39m Creating database backup
[36mINFO[39m Database backup written to: /app/data/content/data/website.ghost.2019-08-18-17-46-12.json
[31mERROR[39m Cannot read property 'schema' of undefined
[31m
[31mCannot read property 'schema' of undefined[39m
[37m"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 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:

How’s it going until this backup issue? I really want something a bit stable to lean on. Cloudron seems really cool. Many thanks!
2 Replies Last reply
Reply Quote 0
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 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.
1 Reply Last reply
Reply Quote 1
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 @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 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.
1 Reply Last reply
Reply Quote 0
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 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 Staff last edited by

I have pushed a fix for Ghost now.
1 Reply Last reply
Reply Quote 1

1 / 1