The Ghost importer no longer works with Ghost ver. >= 1.0

[preslavrachev]

Introduced last July, Ghost 1.0 is a not a really backwards compatible version of Ghost. Unfortunately, I happen to be running my blog on it. Since i'd like to migrate over to Jekyll, I tried using the migrator, but it failed immediately, due to the following error message:

SQLite3::SQLException: no such column: markdown (Sequel::DatabaseError)

As it turns out, the entire database schema seems to be different now. I did a quick lookup on the posts table, and these are the columns I found there:

sqlite> PRAGMA table_info(posts);
0|id|varchar(24)|1||1
1|uuid|varchar(36)|1||0
2|title|varchar(2000)|1||0
3|slug|varchar(191)|1||0
4|mobiledoc|text|0||0
5|html|text|0||0
6|amp|text|0||0
7|plaintext|text|0||0
8|feature_image|varchar(2000)|0||0
9|featured|boolean|1|'0'|0
10|page|boolean|1|'0'|0
11|status|varchar(50)|1|'draft'|0
12|locale|varchar(6)|0||0
13|visibility|varchar(50)|1|'public'|0
14|meta_title|varchar(2000)|0||0
15|meta_description|varchar(2000)|0||0
16|author_id|varchar(24)|1||0
17|created_at|datetime|1||0
18|created_by|varchar(24)|1||0
19|updated_at|datetime|0||0
20|updated_by|varchar(24)|0||0
21|published_at|datetime|0||0
22|published_by|varchar(24)|0||0
23|custom_excerpt|varchar(2000)|0||0
24|codeinjection_head|text|0||0
25|codeinjection_foot|text|0||0
26|og_image|varchar(2000)|0||0
27|og_title|varchar(300)|0||0
28|og_description|varchar(500)|0||0
29|twitter_image|varchar(2000)|0||0
30|twitter_title|varchar(300)|0||0
31|twitter_description|varchar(500)|0||0

I am just reporting this with the hope that an update of the importer gets introduced, or I will try to send a PR myself, when I have a bit more time. For now, I have no other choices left, but to migrate my posts one by one.

[preslavrachev]

TBH, I haven't tried the JSON importer. It might actually work, but I have some suspicions that even if it does, there might be some content missing.

[jekyllbot]

This issue has been automatically marked as stale because it has not been commented on for at least two months.

The resources of the Jekyll team are limited, and so we are asking for your help.

If this is a bug and you can still reproduce this error on the master branch, please reply with all of the information you have about it in order to keep the issue open.

If this is a feature request, please consider whether it can be accomplished in another way. If it cannot, please elaborate on why it is core to this project and why you feel more than 80% of users would find this beneficial.

This issue will automatically be closed in two months if no further activity occurs. Thank you for all your contributions.