Column not found error when posting

Ralkage

ink did you accidentally delete/drop that column from your users table in your database?

ink

Kyrne delete the PMSetup and unread_messages from the user table.

Ralkage

[deleted]

Mark73
I just followed what he said.

clarkwinkelmann

ink can you give us some insights about your forum?

Did you just install Flarum? Did you restore from a backup? Did it work previously before doing an action x?

If you're able please share the output of the php flarum info command.

EDIT: oh I see the discussion about the same issue has continued in https://discuss.flarum.org/d/24073-shout-private-messaging-for-flarum/152

ink

clarkwinkelmann I continued the discussion inhttps://discuss.flarum.org/d/24073-shout-private-messaging-for-flarum/151
and I have offered more information about this.
Thanks!

ink

jordanjay29

ink a little messy here, but I've merged your issues together.

Please stick to one venue for each support issue.

ink

jordanjay29 I am sorry for that!

ink

☹️ Something new is wrongadout FoF Moderator Notes.However, I did noting!

GET https://bbs.stkey.top/api/notes/1

{
  "errors": [
    {
      "status": "500",
      "code": "unknown",
      "detail": "InvalidArgumentException: Cannot load XML: Start tag expected, '<' not found\n in /www/wwwroot/bbs.stkey.top/vendor/s9e/text-formatter/src/Renderer.php:46\nStack trace:\n#0 /www/wwwroot/bbs.stkey.top/vendor/s9e/text-formatter/src/Renderers/PHP.php(303): s9e\\TextFormatter\\Renderer->loadXML()\n#1 /www/wwwroot/bbs.stkey.top/vendor/s9e/text-formatter/src/Renderer.php(66): s9e\\TextFormatter\\Renderers\\PHP->renderRichText()\n#2 /www/wwwroot/bbs.stkey.top/vendor/flarum/core/src/Formatter/Formatter.php(80): s9e\\TextFormatter\\Renderer->render()\n#3 /www/wwwroot/bbs.stkey.top/vendor/fof/moderator-notes/src/Api/Serializer/ModeratorNotesSerializer.php(49): Flarum\\Formatter\\Formatter->render()\n#4 /www/wwwroot/bbs.stkey.top/vendor/fof/moderator-notes/src/Api/Serializer/ModeratorNotesSerializer.php(35): FoF\\ModeratorNotes\\Api\\Serializer\\ModeratorNotesSerializer->format()\n#5 /www/wwwroot/bbs.stkey.top/vendor/flarum/core/src/Api/Serializer/AbstractSerializer.php(84): FoF\\ModeratorNotes\\Api\\Serializer\\ModeratorNotesSerializer->getDefaultAttributes()\n#6 /www/wwwroot/bbs.stkey.top/vendor/tobscure/json-api/src/Resource.php(169): Flarum\\Api\\Serializer\\AbstractSerializer->getAttributes()\n#7 /www/wwwroot/bbs.stkey.top/vendor/tobscure/json-api/src/Resource.php(75): Tobscure\\JsonApi\\Resource->getAttributes()\n#8 /www/wwwroot/bbs.stkey.top/vendor/tobscure/json-api/src/Collection.php(123): Tobscure\\JsonApi\\Resource->toArray()\n#9 [internal function]: Tobscure\\JsonApi\\Collection->Tobscure\\JsonApi\\{closure}()\n#10 /www/wwwroot/bbs.stkey.top/vendor/tobscure/json-api/src/Collection.php(124): array_map()\n#11 /www/wwwroot/bbs.stkey.top/vendor/tobscure/json-api/src/Document.php(181): Tobscure\\JsonApi\\Collection->toArray()\n#12 /www/wwwroot/bbs.stkey.top/vendor/tobscure/json-api/src/Document.php(224): Tobscure\\JsonApi\\Document->toArray()\n#13 /www/wwwroot/bbs.stkey.top/vendor/flarum/core/src/Api/JsonApiResponse.php(27): Tobscure\\JsonApi\\Document->jsonSerialize()\n#14 /www/wwwroot/bbs.stkey.top/vendor/flarum/core/src/Api/Controller/AbstractSerializeController.php(111): Flarum\\Api\\JsonApiResponse->__construct()\n#15 /www/wwwroot/bbs.stkey.top/vendor/flarum/core/src/Http/RouteHandlerFactory.php(38): Flarum\\Api\\Controller\\AbstractSerializeController->handle()\n#16 /www/wwwroot/bbs.stkey.top/vendor/flarum/core/src/Http/Middleware/DispatchRoute.php(65): Flarum\\Http\\RouteHandlerFactory->Flarum\\Http\\{closure}()\n#17 /www/wwwroot/bbs.stkey.top/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\DispatchRoute->process()\n#18 /www/wwwroot/bbs.stkey.top/vendor/flarum/core/src/Http/Middleware/SetLocale.php(50): Laminas\\Stratigility\\Next->handle()\n#19 /www/wwwroot/bbs.stkey.top/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\SetLocale->process()\n#20 /www/wwwroot/bbs.stkey.top/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(37): Laminas\\Stratigility\\Next->handle()\n#21 /www/wwwroot/bbs.stkey.top/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\CheckCsrfToken->process()\n#22 /www/wwwroot/bbs.stkey.top/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(55): Laminas\\Stratigility\\Next->handle()\n#23 /www/wwwroot/bbs.stkey.top/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\AuthenticateWithHeader->process()\n#24 /www/wwwroot/bbs.stkey.top/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(32): Laminas\\Stratigility\\Next->handle()\n#25 /www/wwwroot/bbs.stkey.top/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\AuthenticateWithSession->process()\n#26 /www/wwwroot/bbs.stkey.top/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(51): Laminas\\Stratigility\\Next->handle()\n#27 /www/wwwroot/bbs.stkey.top/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\RememberFromCookie->process()\n#28 /www/wwwroot/bbs.stkey.top/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\\Stratigility\\Next->handle()\n#29 /www/wwwroot/bbs.stkey.top/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\StartSession->process()\n#30 /www/wwwroot/bbs.stkey.top/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\\Stratigility\\Next->handle()\n#31 /www/wwwroot/bbs.stkey.top/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Api\\Middleware\\FakeHttpMethods->process()\n#32 /www/wwwroot/bbs.stkey.top/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\\Stratigility\\Next->handle()\n#33 /www/wwwroot/bbs.stkey.top/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\ParseJsonBody->process()\n#34 /www/wwwroot/bbs.stkey.top/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\\Stratigility\\Next->handle()\n#35 /www/wwwroot/bbs.stkey.top/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\HandleErrors->process()\n#36 /www/wwwroot/bbs.stkey.top/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\\Stratigility\\Next->handle()\n#37 /www/wwwroot/bbs.stkey.top/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\\Stratigility\\MiddlewarePipe->process()\n#38 /www/wwwroot/bbs.stkey.top/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\\RequestHandler->process()\n#39 /www/wwwroot/bbs.stkey.top/vendor/middlewares/base-path-router/src/BasePathRouter.php(97): Laminas\\Stratigility\\Next->handle()\n#40 /www/wwwroot/bbs.stkey.top/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\\BasePathRouter->process()\n#41 /www/wwwroot/bbs.stkey.top/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(42): Laminas\\Stratigility\\Next->handle()\n#42 /www/wwwroot/bbs.stkey.top/vendor/laminas/laminas-stratigility/src/Next.php(61): Laminas\\Stratigility\\Middleware\\OriginalMessages->process()\n#43 /www/wwwroot/bbs.stkey.top/vendor/middlewares/base-path/src/BasePath.php(53): Laminas\\Stratigility\\Next->handle()\n#44 /www/wwwroot/bbs.stkey.top/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\\BasePath->process()\n#45 /www/wwwroot/bbs.stkey.top/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\\Stratigility\\Next->handle()\n#46 /www/wwwroot/bbs.stkey.top/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(73): Laminas\\Stratigility\\MiddlewarePipe->process()\n#47 /www/wwwroot/bbs.stkey.top/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(96): Laminas\\Stratigility\\MiddlewarePipe->handle()\n#48 /www/wwwroot/bbs.stkey.top/vendor/flarum/core/src/Http/Server.php(42): Laminas\\HttpHandlerRunner\\RequestHandlerRunner->run()\n#49 /www/wwwroot/bbs.stkey.top/public/index.php(22): Flarum\\Http\\Server->listen()\n#50 {main}"
    }
  ]

}

« Previous Page