Ghost start fail


#1
✖ Starting Ghost
A GhostError occurred.

Message: insert into `posts` (`author_id`, `codeinjection_foot`, `codeinjection_head`, `comment_id`, `created_at`, `created_by`, `custom_excerpt`, `custom_template`, `feature_image`, `featured`, `html`, `id`, `locale`, `meta_description`, `meta_title`, `mobiledoc`, `og_description`, `og_image`, `og_title`, `page`, `plaintext`, `published_at`, `published_by`, `slug`, `status`, `title`, `twitter_description`, `twitter_image`, `twitter_title`, `updated_at`, `updated_by`, `uuid`, `visibility`) values ('5951f5fca366002ebd5dbef7', NULL, NULL, '5c666ca96f16e01139c07df8', '2019-02-15 07:39:21', 1, 'Welcome, it\'s great to have you here.\nWe know that first impressions are important, so we\'ve populated your new site with some initial getting started posts that will help you get familiar with everything in no time.', NULL, 'https://static.ghost.org/v2.0.0/images/welcome-to-ghost.jpg', false, '<p>👋 Welcome, it\'s great to have you here.</p><p>We know that first impressions are important, so we\'ve populated your new site with some initial <strong>getting started</strong> posts that will help you get familiar with everything in no time. This is the first one!</p><p><strong>A few things you should know upfront</strong>:</p><ol><li>Ghost is designed for ambitious, professional publishers who want to actively build a business around their content. That\'s who it works best for. </li><li>The entire platform can be modified and customised to suit your needs. It\'s very powerful, but does require some knowledge of code. Ghost is not necessarily a good platform for beginners or people who just want a simple personal blog. </li><li>For the best experience we recommend downloading the <a href=\"https://ghost.org/downloads/\">Ghost Desktop App</a> for your computer, which is the best way to access your Ghost site on a desktop device. </li></ol><p>Ghost is made by an independent non-profit organisation called the Ghost Foundation. We are 100% self funded by revenue from our <a href=\"https://ghost.org/pricing\">Ghost(Pro)</a> service, and every penny we make is re-invested into funding further development of free, open source technology for modern publishing.</p><p>The version of Ghost you are looking at right now would not have been made possible without generous contributions from the open source <a href=\"https://github.com/TryGhost\">community</a>.</p><h2 id=\"next-up-the-editor\">Next up, the editor</h2><p>The main thing you\'ll want to read about next is probably: <a href=\"/the-editor/\">the Ghost editor</a>. This is where the good stuff happens.</p><blockquote><em>By the way, once you\'re done reading, you can simply delete the default <strong>Ghost</strong> user from your team to remove all of these introductory posts! </em></blockquote>', '5c666ca96f16e01139c07df8', NULL, NULL, NULL, '{\"version\":\"0.3.1\",\"atoms\":[],\"cards\":[],\"markups\":[[\"strong\"],[\"a\",[\"href\",\"https://ghost.org/downloads/\"]],[\"a\",[\"href\",\"https://ghost.org/pricing\"]],[\"a\",[\"href\",\"https://github.com/TryGhost\"]],[\"a\",[\"href\",\"/the-editor/\"]],[\"em\"]],\"sections\":[[1,\"p\",[[0,[],0,\"👋 Welcome, it\'s great to have you here.\"]]],[1,\"p\",[[0,[],0,\"We know that first impressions are important, so we\'ve populated your new site with some initial \"],[0,[0],1,\"getting started\"],[0,[],0,\" posts that will help you get familiar with everything in no time. This is the first one!\"]]],[1,\"p\",[[0,[0],1,\"A few things you should know upfront\"],[0,[],0,\":\"]]],[3,\"ol\",[[[0,[],0,\"Ghost is designed for ambitious, professional publishers who want to actively build a business around their content. That\'s who it works best for. \"]],[[0,[],0,\"The entire platform can be modified and customised to suit your needs. It\'s very powerful, but does require some knowledge of code. Ghost is not necessarily a good platform for beginners or people who just want a simple personal blog. \"]],[[0,[],0,\"For the best experience we recommend downloading the \"],[0,[1],1,\"Ghost Desktop App\"],[0,[],0,\" for your computer, which is the best way to access your Ghost site on a desktop device. \"]]]],[1,\"p\",[[0,[],0,\"Ghost is made by an independent non-profit organisation called the Ghost Foundation. We are 100% self funded by revenue from our \"],[0,[2],1,\"Ghost(Pro)\"],[0,[],0,\" service, and every penny we make is re-invested into funding further development of free, open source technology for modern publishing.\"]]],[1,\"p\",[[0,[],0,\"The version of Ghost you are looking at right now would not have been made possible without generous contributions from the open source \"],[0,[3],1,\"community\"],[0,[],0,\".\"]]],[1,\"h2\",[[0,[],0,\"Next up, the editor\"]]],[1,\"p\",[[0,[],0,\"The main thing you\'ll want to read about next is probably: \"],[0,[4],1,\"the Ghost editor\"],[0,[],0,\". This is where the good stuff happens.\"]]],[1,\"blockquote\",[[0,[5],0,\"By the way, once you\'re done reading, you can simply delete the default \"],[0,[0],1,\"Ghost\"],[0,[],1,\" user from your team to remove all of these introductory posts! \"]]]]}', NULL, NULL, NULL, false, '👋 Welcome, it\'s great to have you here.\n\nWe know that first impressions are important, so we\'ve populated your new site\nwith some initial getting started  posts that will help you get familiar with\neverything in no time. This is the first one!\n\nA few things you should know upfront:\n\n 1. Ghost is designed for ambitious, professional publishers who want to\n    actively build a business around their content. That\'s who it works best\n    for. \n 2. The entire platform can be modified and customised to suit your needs. It\'s\n    very powerful, but does require some knowledge of code. Ghost is not\n    necessarily a good platform for beginners or people who just want a simple\n    personal blog. \n 3. For the best experience we recommend downloading the Ghost Desktop App\n    [https://ghost.org/downloads/]  for your computer, which is the best way to\n    access your Ghost site on a desktop device. \n\nGhost is made by an independent non-profit organisation called the Ghost\nFoundation. We are 100% self funded by revenue from our Ghost(Pro)\n[https://ghost.org/pricing]  service, and every penny we make is re-invested\ninto funding further development of free, open source technology for modern\npublishing.\n\nThe version of Ghost you are looking at right now would not have been made\npossible without generous contributions from the open source community\n[https://github.com/TryGhost].\n\nNext up, the editor\nThe main thing you\'ll want to read about next is probably: the Ghost editor\n[/the-editor/]. This is where the good stuff happens.\n\n> By the way, once you\'re done reading, you can simply delete the default Ghost \nuser from your team to remove all of these introductory posts!', '2019-02-15 07:39:27', 1, 'welcome', 'published', 'Welcome to Ghost', NULL, NULL, NULL, '2019-02-15 07:39:21', 1, 'd8e8013d-99f8-4aa8-95b1-3fa8983b92c5', 'public') - ER_TRUNCATED_WRONG_VALUE_FOR_FIELD: Incorrect string value: '\xF0\x9F\x91\x8B W...' for column 'html' at row 1
Help: Error occurred while executing the following migration: 2-create-fixtures.js
Suggestion: 

Debug Information:
    OS: Ubuntu, v18.04
    Node Version: v10.13.0
    Ghost-CLI Version: 1.9.9
    Environment: production
    Command: 'ghost setup'

and i run journalctl -u ghost_blog-callmesoul-cn -n 50

callmesoul@iZwz96uhzqta4rogvdaxupZ:/www/blog$ sudo journalctl -u ghost_blog-callmesoul-cn -n 50
-- Logs begin at Wed 2018-12-12 08:04:37 CST, end at Fri 2019-02-15 15:47:12 CST. --
Feb 15 15:39:21 iZwz96uhzqta4rogvdaxupZ node[4398]:     at Promise._settlePromise (/www/blog/versions/2.14.3/node_modules/bluebird/js/release/promise.js:569:18)
Feb 15 15:39:21 iZwz96uhzqta4rogvdaxupZ node[4398]:     at Promise._settlePromise0 (/www/blog/versions/2.14.3/node_modules/bluebird/js/release/promise.js:614:10)
Feb 15 15:39:21 iZwz96uhzqta4rogvdaxupZ node[4398]:     at Promise._settlePromises (/www/blog/versions/2.14.3/node_modules/bluebird/js/release/promise.js:690:18)
Feb 15 15:39:21 iZwz96uhzqta4rogvdaxupZ node[4398]:     at _drainQueueStep (/www/blog/versions/2.14.3/node_modules/bluebird/js/release/async.js:138:12)
Feb 15 15:39:21 iZwz96uhzqta4rogvdaxupZ node[4398]:     at _drainQueue (/www/blog/versions/2.14.3/node_modules/bluebird/js/release/async.js:131:9)
Feb 15 15:39:21 iZwz96uhzqta4rogvdaxupZ node[4398]:     at Async._drainQueues (/www/blog/versions/2.14.3/node_modules/bluebird/js/release/async.js:147:5)
Feb 15 15:39:21 iZwz96uhzqta4rogvdaxupZ node[4398]:     at Immediate.Async.drainQueues [as _onImmediate] (/www/blog/versions/2.14.3/node_modules/bluebird/js/release/async.js:17:14)
Feb 15 15:39:21 iZwz96uhzqta4rogvdaxupZ node[4398]:     at runCallback (timers.js:705:18)
Feb 15 15:39:21 iZwz96uhzqta4rogvdaxupZ node[4398]:     at tryOnImmediate (timers.js:676:5)
Feb 15 15:39:21 iZwz96uhzqta4rogvdaxupZ node[4398]:     at processImmediate (timers.js:658:5)
Feb 15 15:39:21 iZwz96uhzqta4rogvdaxupZ node[4398]: Error: ER_TRUNCATED_WRONG_VALUE_FOR_FIELD: Incorrect string value: '\xF0\x9F\x91\x8B W...' for column 'html' at row 1
Feb 15 15:39:21 iZwz96uhzqta4rogvdaxupZ node[4398]:     at Query.Sequence._packetToError (/www/blog/versions/2.14.3/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14)
Feb 15 15:39:21 iZwz96uhzqta4rogvdaxupZ node[4398]:     at Query.ErrorPacket (/www/blog/versions/2.14.3/node_modules/mysql/lib/protocol/sequences/Query.js:77:18)
Feb 15 15:39:21 iZwz96uhzqta4rogvdaxupZ node[4398]:     at Protocol._parsePacket (/www/blog/versions/2.14.3/node_modules/mysql/lib/protocol/Protocol.js:278:23)
Feb 15 15:39:21 iZwz96uhzqta4rogvdaxupZ node[4398]:     at Parser.write (/www/blog/versions/2.14.3/node_modules/mysql/lib/protocol/Parser.js:76:12)
Feb 15 15:39:21 iZwz96uhzqta4rogvdaxupZ node[4398]:     at Protocol.write (/www/blog/versions/2.14.3/node_modules/mysql/lib/protocol/Protocol.js:38:16)
Feb 15 15:39:21 iZwz96uhzqta4rogvdaxupZ node[4398]:     at Socket.<anonymous> (/www/blog/versions/2.14.3/node_modules/mysql/lib/Connection.js:91:28)
Feb 15 15:39:21 iZwz96uhzqta4rogvdaxupZ node[4398]:     at Socket.<anonymous> (/www/blog/versions/2.14.3/node_modules/mysql/lib/Connection.js:502:10)
Feb 15 15:39:21 iZwz96uhzqta4rogvdaxupZ node[4398]:     at Socket.emit (events.js:182:13)
Feb 15 15:39:21 iZwz96uhzqta4rogvdaxupZ node[4398]:     at addChunk (_stream_readable.js:283:12)
Feb 15 15:39:21 iZwz96uhzqta4rogvdaxupZ node[4398]:     at readableAddChunk (_stream_readable.js:264:11)
Feb 15 15:39:21 iZwz96uhzqta4rogvdaxupZ node[4398]:     at Socket.Readable.push (_stream_readable.js:219:10)
Feb 15 15:39:21 iZwz96uhzqta4rogvdaxupZ node[4398]:     at TCP.onStreamRead [as onread] (internal/stream_base_commons.js:94:17)
Feb 15 15:39:21 iZwz96uhzqta4rogvdaxupZ node[4398]:     --------------------
Feb 15 15:39:21 iZwz96uhzqta4rogvdaxupZ node[4398]:     at Protocol._enqueue (/www/blog/versions/2.14.3/node_modules/mysql/lib/protocol/Protocol.js:144:48)
Feb 15 15:39:21 iZwz96uhzqta4rogvdaxupZ node[4398]:     at Connection.query (/www/blog/versions/2.14.3/node_modules/mysql/lib/Connection.js:200:25)
Feb 15 15:39:21 iZwz96uhzqta4rogvdaxupZ node[4398]:     at /www/blog/versions/2.14.3/node_modules/knex-migrator/node_modules/knex/lib/dialects/mysql/index.js:144:18
Feb 15 15:39:21 iZwz96uhzqta4rogvdaxupZ node[4398]:     at Promise._execute (/www/blog/versions/2.14.3/node_modules/bluebird/js/release/debuggability.js:313:9)
Feb 15 15:39:21 iZwz96uhzqta4rogvdaxupZ node[4398]:     at Promise._resolveFromExecutor (/www/blog/versions/2.14.3/node_modules/bluebird/js/release/promise.js:483:18)
Feb 15 15:39:21 iZwz96uhzqta4rogvdaxupZ node[4398]:     at new Promise (/www/blog/versions/2.14.3/node_modules/bluebird/js/release/promise.js:79:10)
Feb 15 15:39:21 iZwz96uhzqta4rogvdaxupZ node[4398]:     at Client_MySQL._query (/www/blog/versions/2.14.3/node_modules/knex-migrator/node_modules/knex/lib/dialects/mysql/index.js:135:12)
Feb 15 15:39:21 iZwz96uhzqta4rogvdaxupZ node[4398]:     at Client_MySQL.query (/www/blog/versions/2.14.3/node_modules/knex-migrator/node_modules/knex/lib/client.js:192:17)
Feb 15 15:39:21 iZwz96uhzqta4rogvdaxupZ node[4398]:     at /www/blog/versions/2.14.3/node_modules/knex-migrator/node_modules/knex/lib/transaction.js:231:21
Feb 15 15:39:21 iZwz96uhzqta4rogvdaxupZ node[4398]:     at tryCatcher (/www/blog/versions/2.14.3/node_modules/bluebird/js/release/util.js:16:23)
Feb 15 15:39:21 iZwz96uhzqta4rogvdaxupZ node[4398]:     at Function.Promise.attempt.Promise.try (/www/blog/versions/2.14.3/node_modules/bluebird/js/release/method.js:39:29)
Feb 15 15:39:21 iZwz96uhzqta4rogvdaxupZ node[4398]:     at Client_MySQL.trxClient.query (/www/blog/versions/2.14.3/node_modules/knex-migrator/node_modules/knex/lib/transaction.js:228:33)
Feb 15 15:39:21 iZwz96uhzqta4rogvdaxupZ node[4398]:     at Runner.<anonymous> (/www/blog/versions/2.14.3/node_modules/knex-migrator/node_modules/knex/lib/runner.js:138:36)
Feb 15 15:39:21 iZwz96uhzqta4rogvdaxupZ node[4398]:     at Runner.tryCatcher (/www/blog/versions/2.14.3/node_modules/bluebird/js/release/util.js:16:23)
Feb 15 15:39:21 iZwz96uhzqta4rogvdaxupZ node[4398]:     at Runner.query (/www/blog/versions/2.14.3/node_modules/bluebird/js/release/method.js:15:34)
Feb 15 15:39:21 iZwz96uhzqta4rogvdaxupZ node[4398]:     at /www/blog/versions/2.14.3/node_modules/knex-migrator/node_modules/knex/lib/runner.js:47:21
Feb 15 15:39:21 iZwz96uhzqta4rogvdaxupZ node[4398]: 
Feb 15 15:39:21 iZwz96uhzqta4rogvdaxupZ node[4398]: [2019-02-15 07:39:21] INFO Bootstrap client was closed.
Feb 15 15:39:21 iZwz96uhzqta4rogvdaxupZ systemd[1]: Stopping Ghost systemd service for blog: blog-callmesoul-cn...
Feb 15 15:39:22 iZwz96uhzqta4rogvdaxupZ node[4398]: /home/callmesoul/.nvm/versions/node/v10.13.0/lib/node_modules/ghost-cli/lib/process-manager.js:58
Feb 15 15:39:22 iZwz96uhzqta4rogvdaxupZ node[4398]:         throw error;
Feb 15 15:39:22 iZwz96uhzqta4rogvdaxupZ node[4398]:         ^
Feb 15 15:39:22 iZwz96uhzqta4rogvdaxupZ node[4398]: [object Object]
Feb 15 15:39:22 iZwz96uhzqta4rogvdaxupZ systemd[1]: ghost_blog-callmesoul-cn.service: Main process exited, code=exited, status=1/FAILURE
Feb 15 15:39:22 iZwz96uhzqta4rogvdaxupZ systemd[1]: ghost_blog-callmesoul-cn.service: Failed with result 'exit-code'.
Feb 15 15:39:22 iZwz96uhzqta4rogvdaxupZ systemd[1]: Stopped Ghost systemd service for blog: blog-callmesoul-cn.
callmesoul@iZwz96uhzqta4rogvdaxupZ:/www/blog$ ghost doctor
✔ Checking system Node.js version
✔ Checking logged in user
✔ Ensuring user is not logged in as ghost user
✔ Checking if logged in user is directory owner
✔ Checking current folder permissions
✔ Checking operating system compatibility
✔ Checking for a MySQL installation
+ sudo systemctl is-active ghost_blog-callmesoul-cn
? Sudo Password [hidden]
+ sudo systemctl reset-failed ghost_blog-callmesoul-cn
✔ Validating config
✔ Checking folder permissions
✔ Checking file permissions
✔ Checking content folder ownership
✔ Checking memory availability

what happen?


#2

This sounds like an encoding problem.
Ghost uses utf8mb4. Have you configured anything else? Have you created the database on your own with different encoding?


#3

database is auto create.
and i seed database encoding is utf8mb4.


#4

The problem is solved

I will read a tutorial when I install mysql.
Said that the ubuntu 18.04 encoding is not utf8, so configure the following in the configuration file:
[mysqld]
collation-server = utf8_unicode_ci
init-connect=‘SET NAMES utf8’
character-set-server = utf8

when i delete them.is ok!


closed #5

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.