发生了一个很奇怪的问题。我帖子在板块里不显示(在所有可以显示
可以上去看看我的网站
ps :网站用了cf cdn
我在官方论坛看有同样问题解决方案 。是把fof/gamification
删掉
问题说是由这个插件的bug引起
但是问题还是没解决(已刷新php缓存
这是log文件里的
Next Illuminate\Database\QueryException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`bbs_c4at_xyz`.`bbspost_votes`, CONSTRAINT `bbspost_votes_post_id_foreign` FOREIGN KEY (`post_id`) REFERENCES `bbsposts` (`id`) ON DELETE CASCADE) (SQL: insert into `bbspost_votes` (`post_id`, `user_id`, `type`) values (6, 2, Up)) in /www/wwwroot/bbs.c4at.xyz/vendor/illuminate/database/Connection.php:664
Stack trace:
#0 /www/wwwroot/bbs.c4at.xyz/vendor/illuminate/database/Connection.php(624): Illuminate\Database\Connection->runQueryCallback('insert into `bb...', Array, Object(Closure))
#1 /www/wwwroot/bbs.c4at.xyz/vendor/illuminate/database/Connection.php(459): Illuminate\Database\Connection->run('insert into `bb...', Array, Object(Closure))
#2 /www/wwwroot/bbs.c4at.xyz/vendor/illuminate/database/Connection.php(411): Illuminate\Database\Connection->statement('insert into `bb...', Array)
#3 /www/wwwroot/bbs.c4at.xyz/vendor/illuminate/database/Query/Processors/Processor.php(32): Illuminate\Database\Connection->insert('insert into `bb...', Array)
#4 /www/wwwroot/bbs.c4at.xyz/vendor/illuminate/database/Query/Builder.php(2628): Illuminate\Database\Query\Processors\Processor->processInsertGetId(Object(Illuminate\Database\Query\Builder), 'insert into `bb...', Array, 'id')
#5 /www/wwwroot/bbs.c4at.xyz/vendor/illuminate/database/Eloquent/Builder.php(1338): Illuminate\Database\Query\Builder->insertGetId(Array, 'id')
#6 /www/wwwroot/bbs.c4at.xyz/vendor/illuminate/database/Eloquent/Model.php(823): Illuminate\Database\Eloquent\Builder->__call('insertGetId', Array)
#7 /www/wwwroot/bbs.c4at.xyz/vendor/illuminate/database/Eloquent/Model.php(788): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array)
#8 /www/wwwroot/bbs.c4at.xyz/vendor/illuminate/database/Eloquent/Model.php(651): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder))
#9 /www/wwwroot/bbs.c4at.xyz/vendor/fof/gamification/src/Listeners/EventHandlers.php(78): Illuminate\Database\Eloquent\Model->save()
#10 /www/wwwroot/bbs.c4at.xyz/vendor/illuminate/events/Dispatcher.php(360): FoF\Gamification\Listeners\EventHandlers->addVote(Object(Flarum\Post\Event\Posted))
#11 /www/wwwroot/bbs.c4at.xyz/vendor/illuminate/events/Dispatcher.php(209): Illuminate\Events\Dispatcher->Illuminate\Events\{closure}('Flarum\\Post\\Eve...', Array)
#12 /www/wwwroot/bbs.c4at.xyz/vendor/flarum/core/src/Foundation/DispatchEventsTrait.php(33): Illuminate\Events\Dispatcher->dispatch('Flarum\\Post\\Eve...')
#13 /www/wwwroot/bbs.c4at.xyz/vendor/flarum/core/src/Post/Command/PostReplyHandler.php(106): Flarum\Post\Command\PostReplyHandler->dispatchEventsFor(Object(Flarum\Post\CommentPost), Object(Flarum\User\User))
#14 /www/wwwroot/bbs.c4at.xyz/vendor/flarum/core/src/Notification/NotificationSyncer.php(156): Flarum\Post\Command\PostReplyHandler->Flarum\Post\Command\{closure}()
#15 /www/wwwroot/bbs.c4at.xyz/vendor/flarum/core/src/Post/Command/PostReplyHandler.php(107): Flarum\Notification\NotificationSyncer->onePerUser(Object(Closure))
#16 /www/wwwroot/bbs.c4at.xyz/vendor/illuminate/bus/Dispatcher.php(90): Flarum\Post\Command\PostReplyHandler->handle(Object(Flarum\Post\Command\PostReply))
#17 /www/wwwroot/bbs.c4at.xyz/vendor/illuminate/pipeline/Pipeline.php(128): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}(Object(Flarum\Post\Command\PostReply))
#18 /www/wwwroot/bbs.c4at.xyz/vendor/illuminate/pipeline/Pipeline.php(104): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Flarum\Post\Command\PostReply))
#19 /www/wwwroot/bbs.c4at.xyz/vendor/illuminate/bus/Dispatcher.php(98): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#20 /www/wwwroot/bbs.c4at.xyz/vendor/illuminate/bus/Dispatcher.php(76): Illuminate\Bus\Dispatcher->dispatchNow(Object(Flarum\Post\Command\PostReply))
#21 /www/wwwroot/bbs.c4at.xyz/vendor/flarum/core/src/Api/Controller/CreatePostController.php(73): Illuminate\Bus\Dispatcher->dispatch(Object(Flarum\Post\Command\PostReply))
#22 /www/wwwroot/bbs.c4at.xyz/vendor/flarum/core/src/Api/Controller/AbstractSerializeController.php(96): Flarum\Api\Controller\CreatePostController->data(Object(Laminas\Diactoros\ServerRequest), Object(Tobscure\JsonApi\Document))
#23 /www/wwwroot/bbs.c4at.xyz/vendor/flarum/core/src/Api/Controller/AbstractCreateController.php(22): Flarum\Api\Controller\AbstractSerializeController->handle(Object(Laminas\Diactoros\ServerRequest))
#24 /www/wwwroot/bbs.c4at.xyz/vendor/flarum/core/src/Http/RouteHandlerFactory.php(38): Flarum\Api\Controller\AbstractCreateController->handle(Object(Laminas\Diactoros\ServerRequest))
#25 /www/wwwroot/bbs.c4at.xyz/vendor/flarum/core/src/Http/Middleware/DispatchRoute.php(65): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}(Object(Laminas\Diactoros\ServerRequest), Array)
#26 /www/wwwroot/bbs.c4at.xyz/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\DispatchRoute->process(Object(Laminas\Diactoros\ServerRequest), Object(Closure))
#27 /www/wwwroot/bbs.c4at.xyz/vendor/fof/stopforumspam/src/Middleware/RegisterMiddleware.php(94): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#28 /www/wwwroot/bbs.c4at.xyz/vendor/laminas/laminas-stratigility/src/Next.php(61): FoF\StopForumSpam\Middleware\RegisterMiddleware->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#29 /www/wwwroot/bbs.c4at.xyz/vendor/flarum/core/src/Http/Middleware/SetLocale.php(50): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#30 /www/wwwroot/bbs.c4at.xyz/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\SetLocale->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#31 /www/wwwroot/bbs.c4at.xyz/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(31): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#32 /www/wwwroot/bbs.c4at.xyz/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\CheckCsrfToken->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#33 /www/wwwroot/bbs.c4at.xyz/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(55): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#34 /www/wwwroot/bbs.c4at.xyz/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\AuthenticateWithHeader->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#35 /www/wwwroot/bbs.c4at.xyz/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(32): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#36 /www/wwwroot/bbs.c4at.xyz/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\AuthenticateWithSession->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#37 /www/wwwroot/bbs.c4at.xyz/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(51): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#38 /www/wwwroot/bbs.c4at.xyz/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\RememberFromCookie->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#39 /www/wwwroot/bbs.c4at.xyz/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#40 /www/wwwroot/bbs.c4at.xyz/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\StartSession->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#41 /www/wwwroot/bbs.c4at.xyz/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#42 /www/wwwroot/bbs.c4at.xyz/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Api\Middleware\FakeHttpMethods->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#43 /www/wwwroot/bbs.c4at.xyz/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#44 /www/wwwroot/bbs.c4at.xyz/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ParseJsonBody->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#45 /www/wwwroot/bbs.c4at.xyz/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#46 /www/wwwroot/bbs.c4at.xyz/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\HandleErrors->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#47 /www/wwwroot/bbs.c4at.xyz/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#48 /www/wwwroot/bbs.c4at.xyz/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#49 /www/wwwroot/bbs.c4at.xyz/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\RequestHandler->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#50 /www/wwwroot/bbs.c4at.xyz/vendor/middlewares/base-path-router/src/BasePathRouter.php(97): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#51 /www/wwwroot/bbs.c4at.xyz/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\BasePathRouter->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#52 /www/wwwroot/bbs.c4at.xyz/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(42): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#53 /www/wwwroot/bbs.c4at.xyz/vendor/laminas/laminas-stratigility/src/Next.php(61): Laminas\Stratigility\Middleware\OriginalMessages->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#54 /www/wwwroot/bbs.c4at.xyz/vendor/middlewares/base-path/src/BasePath.php(53): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#55 /www/wwwroot/bbs.c4at.xyz/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\BasePath->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#56 /www/wwwroot/bbs.c4at.xyz/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#57 /www/wwwroot/bbs.c4at.xyz/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(73): Laminas\Stratigility\MiddlewarePipe->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\EmptyPipelineHandler))
#58 /www/wwwroot/bbs.c4at.xyz/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(96): Laminas\Stratigility\MiddlewarePipe->handle(Object(Laminas\Diactoros\ServerRequest))
#59 /www/wwwroot/bbs.c4at.xyz/vendor/flarum/core/src/Http/Server.php(42): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#60 /www/wwwroot/bbs.c4at.xyz/public/index.php(26): Flarum\Http\Server->listen()
#61 {main}
好像是mysql错误?