Flarum's posting problems

ink

Recently, I found that every time I click the "start a discussion" button, the web page will load for a while, and then it will remind me that something is wrong. Please refresh and try again. However, when I refreshed, I found that the post had already been sent.

I have been troubled by this problem for a long time. Who can help me?

ink

Next Doctrine\DBAL\Driver\PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘152-287′ for key ‘PRIMARY’ in /www/wwwroot/www.act-forum.cc/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:123
Stack trace:

Littlegolden

Got the same error, but seems the reasons are different.
The full log file:
https://paste.ubuntu.com/p/98PCgyCzzB/

[deleted]

Looks like that's from the GEO IP extension. Do you get the same error if you disable it ?

ink

[deleted] well，i did not install the GEO IP extension

tankerkiller125

This can happen if your email is not properly setup, double check that your outgoing mail settings are correct and sending properly.

ink

E-mail? It correctly worked a few weeks ago.I do not think the problem happened in this way!

tankerkiller125

ink I was in a rush this morning, upon further reading it appears that it's a SQL issue, but I'm not exactly sure where or what could be causing it.

clarkwinkelmann

Can you copy the full error message, from the timestamp (probably one line above what you copied), and down to the backtrace (maybe 30 lines below what you copied). Also check that the timestamp matches with the time of your error (to make sure it's really the error message for the error you experienced)

Littlegolden

Littlegolden 遇到相同的错误，但原因似乎有所不同。
完整的日志文件：https :
//paste.ubuntu.com/p/98PCgyCzzB/

clarkwinkelmann Does my log error caused by the same thing with his?

clarkwinkelmann

Littlegolden it doesn't look like it is. Can you open a different support discussion for your issue ?

Yours is about a UNIQUE key. Theirs appears to be related to a PRIMARY composite key.

ink

clarkwinkelmann sorry,here

#51 /www/wwwroot/www.act-forum.cc/vendor/zendframework/zend-stratigility/src/Next.php(60): Middlewares\BasePath->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#52 /www/wwwroot/www.act-forum.cc/vendor/zendframework/zend-stratigility/src/MiddlewarePipe.php(83): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#53 /www/wwwroot/www.act-forum.cc/vendor/zendframework/zend-stratigility/src/MiddlewarePipe.php(72): Zend\Stratigility\MiddlewarePipe->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\EmptyPipelineHandler))
#54 /www/wwwroot/www.act-forum.cc/vendor/zendframework/zend-httphandlerrunner/src/RequestHandlerRunner.php(95): Zend\Stratigility\MiddlewarePipe->handle(Object(Zend\Diactoros\ServerRequest))
#55 /www/wwwroot/www.act-forum.cc/vendor/flarum/core/src/Http/Server.php(44): Zend\HttpHandlerRunner\RequestHandlerRunner->run()
#56 /www/wwwroot/www.act-forum.cc/public/index.php(22): Flarum\Http\Server->listen()
#57 {main}

Next Doctrine\DBAL\Driver\PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '152-287' for key 'PRIMARY' in /www/wwwroot/www.act-forum.cc/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:123
Stack trace:
#0 /www/wwwroot/www.act-forum.cc/vendor/illuminate/database/Connection.php(458): Doctrine\DBAL\Driver\PDOStatement->execute()
#1 /www/wwwroot/www.act-forum.cc/vendor/illuminate/database/Connection.php(657): Illuminate\Database\Connection->Illuminate\Database\{closure}('insert into `di...', Array)
#2 /www/wwwroot/www.act-forum.cc/vendor/illuminate/database/Connection.php(624): Illuminate\Database\Connection->runQueryCallback('insert into `di...', Array, Object(Closure))
#3 /www/wwwroot/www.act-forum.cc/vendor/illuminate/database/Connection.php(459): Illuminate\Database\Connection->run('insert into `di...', Array, Object(Closure))
#4 /www/wwwroot/www.act-forum.cc/vendor/illuminate/database/Connection.php(411): Illuminate\Database\Connection->statement('insert into `di...', Array)
#5 /www/wwwroot/www.act-forum.cc/vendor/illuminate/database/Query/Processors/Processor.php(32): Illuminate\Database\Connection->insert('insert into `di...', Array)
#6 /www/wwwroot/www.act-forum.cc/vendor/illuminate/database/Query/Builder.php(2628): Illuminate\Database\Query\Processors\Processor->processInsertGetId(Object(Illuminate\Database\Query\Builder), 'insert into `di...', Array, 'id')
#7 /www/wwwroot/www.act-forum.cc/vendor/illuminate/database/Eloquent/Builder.php(1338): Illuminate\Database\Query\Builder->insertGetId(Array, 'id')
#8 /www/wwwroot/www.act-forum.cc/vendor/illuminate/database/Eloquent/Model.php(823): Illuminate\Database\Eloquent\Builder->__call('insertGetId', Array)
#9 /www/wwwroot/www.act-forum.cc/vendor/illuminate/database/Eloquent/Model.php(788): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array)
#10 /www/wwwroot/www.act-forum.cc/vendor/illuminate/database/Eloquent/Model.php(651): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder))
#11 /www/wwwroot/www.act-forum.cc/vendor/flarum/core/src/Discussion/Command/ReadDiscussionHandler.php(58): Illuminate\Database\Eloquent\Model->save()
#12 /www/wwwroot/www.act-forum.cc/vendor/illuminate/bus/Dispatcher.php(90): Flarum\Discussion\Command\ReadDiscussionHandler->handle(Object(Flarum\Discussion\Command\ReadDiscussion))
#13 /www/wwwroot/www.act-forum.cc/vendor/illuminate/pipeline/Pipeline.php(128): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}(Object(Flarum\Discussion\Command\ReadDiscussion))
#14 /www/wwwroot/www.act-forum.cc/vendor/illuminate/pipeline/Pipeline.php(104): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Flarum\Discussion\Command\ReadDiscussion))
#15 /www/wwwroot/www.act-forum.cc/vendor/illuminate/bus/Dispatcher.php(98): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#16 /www/wwwroot/www.act-forum.cc/vendor/illuminate/bus/Dispatcher.php(76): Illuminate\Bus\Dispatcher->dispatchNow(Object(Flarum\Discussion\Command\ReadDiscussion))
#17 /www/wwwroot/www.act-forum.cc/vendor/flarum/core/src/Api/Controller/UpdateDiscussionController.php(58): Illuminate\Bus\Dispatcher->dispatch(Object(Flarum\Discussion\Command\ReadDiscussion))
#18 /www/wwwroot/www.act-forum.cc/vendor/flarum/core/src/Api/Controller/AbstractSerializeController.php(96): Flarum\Api\Controller\UpdateDiscussionController->data(Object(Zend\Diactoros\ServerRequest), Object(Tobscure\JsonApi\Document))
#19 /www/wwwroot/www.act-forum.cc/vendor/flarum/core/src/Http/RouteHandlerFactory.php(38): Flarum\Api\Controller\AbstractSerializeController->handle(Object(Zend\Diactoros\ServerRequest))
#20 /www/wwwroot/www.act-forum.cc/vendor/flarum/core/src/Http/Middleware/DispatchRoute.php(65): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}(Object(Zend\Diactoros\ServerRequest), Array)
#21 /www/wwwroot/www.act-forum.cc/vendor/zendframework/zend-stratigility/src/Next.php(60): Flarum\Http\Middleware\DispatchRoute->process(Object(Zend\Diactoros\ServerRequest), Object(Closure))
#22 /www/wwwroot/www.act-forum.cc/vendor/fof/terms/src/Middlewares/RegisterMiddleware.php(54): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#23 /www/wwwroot/www.act-forum.cc/vendor/zendframework/zend-stratigility/src/Next.php(60): FoF\Terms\Middlewares\RegisterMiddleware->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#24 /www/wwwroot/www.act-forum.cc/vendor/flarum/core/src/Http/Middleware/SetLocale.php(50): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#25 /www/wwwroot/www.act-forum.cc/vendor/zendframework/zend-stratigility/src/Next.php(60): Flarum\Http\Middleware\SetLocale->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#26 /www/wwwroot/www.act-forum.cc/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(31): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#27 /www/wwwroot/www.act-forum.cc/vendor/zendframework/zend-stratigility/src/Next.php(60): Flarum\Http\Middleware\CheckCsrfToken->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#28 /www/wwwroot/www.act-forum.cc/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(55): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#29 /www/wwwroot/www.act-forum.cc/vendor/zendframework/zend-stratigility/src/Next.php(60): Flarum\Http\Middleware\AuthenticateWithHeader->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#30 /www/wwwroot/www.act-forum.cc/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(32): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#31 /www/wwwroot/www.act-forum.cc/vendor/zendframework/zend-stratigility/src/Next.php(60): Flarum\Http\Middleware\AuthenticateWithSession->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#32 /www/wwwroot/www.act-forum.cc/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(51): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#33 /www/wwwroot/www.act-forum.cc/vendor/zendframework/zend-stratigility/src/Next.php(60): Flarum\Http\Middleware\RememberFromCookie->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#34 /www/wwwroot/www.act-forum.cc/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#35 /www/wwwroot/www.act-forum.cc/vendor/zendframework/zend-stratigility/src/Next.php(60): Flarum\Http\Middleware\StartSession->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#36 /www/wwwroot/www.act-forum.cc/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#37 /www/wwwroot/www.act-forum.cc/vendor/zendframework/zend-stratigility/src/Next.php(60): Flarum\Api\Middleware\FakeHttpMethods->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#38 /www/wwwroot/www.act-forum.cc/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#39 /www/wwwroot/www.act-forum.cc/vendor/zendframework/zend-stratigility/src/Next.php(60): Flarum\Http\Middleware\ParseJsonBody->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#40 /www/wwwroot/www.act-forum.cc/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#41 /www/wwwroot/www.act-forum.cc/vendor/zendframework/zend-stratigility/src/Next.php(60): Flarum\Http\Middleware\HandleErrors->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#42 /www/wwwroot/www.act-forum.cc/vendor/zendframework/zend-stratigility/src/MiddlewarePipe.php(83): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#43 /www/wwwroot/www.act-forum.cc/vendor/middlewares/request-handler/src/RequestHandler.php(84): Zend\Stratigility\MiddlewarePipe->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#44 /www/wwwroot/www.act-forum.cc/vendor/zendframework/zend-stratigility/src/Next.php(60): Middlewares\RequestHandler->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#45 /www/wwwroot/www.act-forum.cc/vendor/middlewares/base-path-router/src/BasePathRouter.php(97): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#46 /www/wwwroot/www.act-forum.cc/vendor/zendframework/zend-stratigility/src/Next.php(60): Middlewares\BasePathRouter->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#47 /www/wwwroot/www.act-forum.cc/vendor/zendframework/zend-stratigility/src/Middleware/OriginalMessages.php(41): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#48 /www/wwwroot/www.act-forum.cc/vendor/zendframework/zend-stratigility/src/Next.php(60): Zend\Stratigility\Middleware\OriginalMessages->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#49 /www/wwwroot/www.act-forum.cc/vendor/middlewares/base-path/src/BasePath.php(53): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#50 /www/wwwroot/www.act-forum.cc/vendor/zendframework/zend-stratigility/src/Next.php(60): Middlewares\BasePath->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#51 /www/wwwroot/www.act-forum.cc/vendor/zendframework/zend-stratigility/src/MiddlewarePipe.php(83): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#52 /www/wwwroot/www.act-forum.cc/vendor/zendframework/zend-stratigility/src/MiddlewarePipe.php(72): Zend\Stratigility\MiddlewarePipe->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\EmptyPipelineHandler))
#53 /www/wwwroot/www.act-forum.cc/vendor/zendframework/zend-httphandlerrunner/src/RequestHandlerRunner.php(95): Zend\Stratigility\MiddlewarePipe->handle(Object(Zend\Diactoros\ServerRequest))
#54 /www/wwwroot/www.act-forum.cc/vendor/flarum/core/src/Http/Server.php(44): Zend\HttpHandlerRunner\RequestHandlerRunner->run()