Hello One of the latest updates has encountered a problem. When I open the page of the author, I receive an error of 500 (https://it-data.co.ua/author/alexandr/) and I also can not log into the admin panel, I get an error (Value in [refreshtokens.id] cannot be blank. ). Who can help me fix the problem?
- URL: https://it-data.co.ua
- Version: 1.22.4
- Configuration: production/self-hosted
- Browser: Firefox
- Errors in the console:
user page
ERROR [2018-04-26 18:49:14] “GET /author/alexandr/” 500 109ms
NAME: InternalServerError
CODE: ER_BAD_FIELD_ERROR
MESSAGE: select count(distinct posts.id) as aggregate from posts where (posts.status = ‘published’ and posts.page = false) and (posts.authors = ‘alexandr’) - ER_BAD_FIELD_ERROR: Unknown column ‘posts.authors’ in ‘where clause’
level:normal
InternalServerError: select count(distinct posts.id) as aggregate from posts where (posts.status = ‘published’ and posts.page = false) and (posts.authors = ‘alexandr’) - ER_BAD_FIELD_ERROR: Unknown column ‘posts.authors’ in ‘where clause’
at new GhostError (/home/alex/web/it-data.co.ua/public_html/core/server/lib/common/errors.js:9:26)
at prepareError (/home/alex/web/it-data.co.ua/public_html/core/server/web/middleware/error-handler.js:39:19)
at Layer.handle_error (/home/alex/web/it-data.co.ua/public_html/node_modules/express/lib/router/layer.js:71:5)
at trim_prefix (/home/alex/web/it-data.co.ua/public_html/node_modules/express/lib/router/index.js:315:13)
at /home/alex/web/it-data.co.ua/public_html/node_modules/express/lib/router/index.js:284:7
at Function.process_params (/home/alex/web/it-data.co.ua/public_html/node_modules/express/lib/router/index.js:335:12)
at next (/home/alex/web/it-data.co.ua/public_html/node_modules/express/lib/router/index.js:275:10)
at Layer.handle_error (/home/alex/web/it-data.co.ua/public_html/node_modules/express/lib/router/layer.js:67:12)
at trim_prefix (/home/alex/web/it-data.co.ua/public_html/node_modules/express/lib/router/index.js:315:13)
at /home/alex/web/it-data.co.ua/public_html/node_modules/express/lib/router/index.js:284:7
at Function.process_params (/home/alex/web/it-data.co.ua/public_html/node_modules/express/lib/router/index.js:335:12)
at next (/home/alex/web/it-data.co.ua/public_html/node_modules/express/lib/router/index.js:275:10)
at /home/alex/web/it-data.co.ua/public_html/node_modules/express/lib/router/index.js:635:15
at next (/home/alex/web/it-data.co.ua/public_html/node_modules/express/lib/router/index.js:260:14)
at Layer.handle_error (/home/alex/web/it-data.co.ua/public_html/node_modules/express/lib/router/layer.js:67:12)
at trim_prefix (/home/alex/web/it-data.co.ua/public_html/node_modules/express/lib/router/index.js:315:13)
Error: ER_BAD_FIELD_ERROR: Unknown column ‘posts.authors’ in ‘where clause’
at Query.Sequence._packetToError (/home/alex/web/it-data.co.ua/public_html/node_modules/mysql/lib/protocol/sequences/Sequence.js:52:14)
at Query.ErrorPacket (/home/alex/web/it-data.co.ua/public_html/node_modules/mysql/lib/protocol/sequences/Query.js:77:18)
at Protocol._parsePacket (/home/alex/web/it-data.co.ua/public_html/node_modules/mysql/lib/protocol/Protocol.js:279:23)
at Parser.write (/home/alex/web/it-data.co.ua/public_html/node_modules/mysql/lib/protocol/Parser.js:76:12)
at Protocol.write (/home/alex/web/it-data.co.ua/public_html/node_modules/mysql/lib/protocol/Protocol.js:39:16)
at Socket. (/home/alex/web/it-data.co.ua/public_html/node_modules/mysql/lib/Connection.js:103:28)
at emitOne (events.js:96:13)
at Socket.emit (events.js:188:7)
at readableAddChunk (_stream_readable.js:176:18)
at Socket.Readable.push (_stream_readable.js:134:10)
at TCP.onread (net.js:559:20)
--------------------
at Protocol._enqueue (/home/alex/web/it-data.co.ua/public_html/node_modules/mysql/lib/protocol/Protocol.js:145:48)
at Connection.query (/home/alex/web/it-data.co.ua/public_html/node_modules/mysql/lib/Connection.js:208:25)
at /home/alex/web/it-data.co.ua/public_html/node_modules/knex/lib/dialects/mysql/index.js:152:18
at Promise._execute (/home/alex/web/it-data.co.ua/public_html/node_modules/bluebird/js/release/debuggability.js:303:9)
at Promise._resolveFromExecutor (/home/alex/web/it-data.co.ua/public_html/node_modules/bluebird/js/release/promise.js:483:18)
at new Promise (/home/alex/web/it-data.co.ua/public_html/node_modules/bluebird/js/release/promise.js:79:10)
at Client_MySQL._query (/home/alex/web/it-data.co.ua/public_html/node_modules/knex/lib/dialects/mysql/index.js:146:12)
at Client_MySQL.query (/home/alex/web/it-data.co.ua/public_html/node_modules/knex/lib/client.js:197:17)
at Runner. (/home/alex/web/it-data.co.ua/public_html/node_modules/knex/lib/runner.js:146:36)
at Runner.tryCatcher (/home/alex/web/it-data.co.ua/public_html/node_modules/bluebird/js/release/util.js:16:23)
at Runner.query (/home/alex/web/it-data.co.ua/public_html/node_modules/bluebird/js/release/method.js:15:34)
at /home/alex/web/it-data.co.ua/public_html/node_modules/knex/lib/runner.js:65:21
at tryCatcher (/home/alex/web/it-data.co.ua/public_html/node_modules/bluebird/js/release/util.js:16:23)
at /home/alex/web/it-data.co.ua/public_html/node_modules/bluebird/js/release/using.js:185:26
at tryCatcher (/home/alex/web/it-data.co.ua/public_html/node_modules/bluebird/js/release/util.js:16:23)
at Promise._settlePromiseFromHandler (/home/alex/web/it-data.co.ua/public_html/node_modules/bluebird/js/release/promise.js:512:31)
admin page
ERROR [2018-04-26 18:53:18] “POST /ghost/api/v0.1/authentication/token” 422 343ms
NAME: ValidationError
MESSAGE: Value in [refreshtokens.id] cannot be blank.
level:normal
refreshtokens.id
ValidationError: Value in [refreshtokens.id] cannot be blank.
at new ValidationError (/home/alex/web/it-data.co.ua/public_html/node_modules/ghost-ignition/lib/errors/index.js:115:23)
at each (/home/alex/web/it-data.co.ua/public_html/core/server/data/validation/index.js:203:39)
at arrayEach (/home/alex/web/it-data.co.ua/public_html/node_modules/lodash/lodash.js:537:11)
at Function.forEach (/home/alex/web/it-data.co.ua/public_html/node_modules/lodash/lodash.js:9359:14)
at Object.validateSchema (/home/alex/web/it-data.co.ua/public_html/core/server/data/validation/index.js:185:7)
at onValidate (/home/alex/web/it-data.co.ua/public_html/core/server/models/base/index.js:198:27)
at onCreating (/home/alex/web/it-data.co.ua/public_html/core/server/models/base/index.js:261:37)
at /home/alex/web/it-data.co.ua/public_html/node_modules/bookshelf/lib/base/events.js:176:25
at tryCatcher (/home/alex/web/it-data.co.ua/public_html/node_modules/bluebird/js/release/util.js:16:23)
at MappingPromiseArray._promiseFulfilled (/home/alex/web/it-data.co.ua/public_html/node_modules/bluebird/js/release/map.js:61:38)
at MappingPromiseArray.PromiseArray._iterate (/home/alex/web/it-data.co.ua/public_html/node_modules/bluebird/js/release/promise_array.js:114:31)
at MappingPromiseArray.init (/home/alex/web/it-data.co.ua/public_html/node_modules/bluebird/js/release/promise_array.js:78:10)
at MappingPromiseArray._asyncInit (/home/alex/web/it-data.co.ua/public_html/node_modules/bluebird/js/release/map.js:30:10)
at Async._drainQueue (/home/alex/web/it-data.co.ua/public_html/node_modules/bluebird/js/release/async.js:138:12)
at Async._drainQueues (/home/alex/web/it-data.co.ua/public_html/node_modules/bluebird/js/release/async.js:143:10)
at Immediate.Async.drainQueues (/home/alex/web/it-data.co.ua/public_html/node_modules/bluebird/js/release/async.js:17:14)