Error 500 - problem with .htaccess

clarkwinkelmann · Aug 21, 2023

JakubSvec disable PHP warnings in production. See your web host management console or edit php.ini directly

JJakubSvec · Aug 28, 2023

Unfortunately it didn't help me. In addition, the error also started to appear in the user's detail. Could this be related to Flarum being installed locally and then moved to the server?

clarkwinkelmann · Aug 29, 2023

JakubSvec if the error message is still the same, then the fix was not done properly in php.ini

Make sure you edit the correct php.ini (there is one for each installed PHP version and one for command line and webserver). If in doubt, you can make the fix in all of them.

If you can't locate the config file or apply the changes permanently, consult your web hosting documentation or contact their support.

Iiguannaweb · Mar 1, 2024

Yesterday I tried to solve this issue, I can confirm it's not about show errors... I have other server working without problem, but this error got me crazy... can we give us a better explanation about search a solution?

Iiguannaweb · Mar 1, 2024

Can you test the error here: https://foro.atlasfloragaditana-sghn.com/d/1-prueba

luceos · Mar 1, 2024

Your site seems to do some weird things as it generates a bin file when hitting the api. This points to a misconfiguration on the server.

Iiguannaweb · Mar 1, 2024

luceos Hi, but everything works ok, anything with api/post is broken, read a post or in profile load profile posts... how I can fix this... i don't see errors, and in other exact server is working good

For example this call: https://foro.atlasfloragaditana-sghn.com/api/discussions/1-prueba?bySlug=true&page%5Bnear%5D=0 give error 500

luceos · Mar 1, 2024

iguannaweb yes all api calls give a 500.. You need to check the log files, see https://docs.flarum.org/troubleshoot

Iiguannaweb · Mar 1, 2024

Show this error

PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(partition by flarum_post_mentions_post.mentions_post_id order by `created_a' at line 1 in /vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:82

Iiguannaweb · Mar 1, 2024

it could be the dash on the domain?

luceos · Mar 1, 2024

iguannaweb can you post the output of php flarum info?

Iiguannaweb · Mar 1, 2024

Flarum core: 1.8.5
PHP version: 8.3.3
MySQL version: 10.1.48-MariaDB-0ubuntu0.18.04.1
Loaded extensions: Core, date, libxml, openssl, pcre, zlib, bz2, calendar, ctype, hash, filter, ftp, gettext, gmp, json, iconv, SPL, pcntl, random, readline, Reflection, session, standard, mbstring, SimpleXML, sockets, tokenizer, xml, mysqlnd, bcmath, curl, dba, dom, enchant, fileinfo, gd, imagick, imap, intl, ldap, exif, mysqli, odbc, PDO, pdo_mysql, PDO_ODBC, pdo_pgsql, pdo_sqlite, pgsql, Phar, posix, pspell, redis, soap, sodium, sqlite3, sysvmsg, sysvsem, sysvshm, tidy, xmlreader, xmlwriter, xsl, zip, Zend OPcache
+--------------------------+---------+--------+
| Flarum Extensions | | |
+--------------------------+---------+--------+
| ID | Version | Commit |
+--------------------------+---------+--------+
| flarum-flags | v1.8.0 | |
| flarum-approval | v1.8.1 | |
| flarum-tags | v1.8.0 | |
| flarum-suspend | v1.8.1 | |
| flarum-subscriptions | v1.8.0 | |
| flarum-sticky | v1.8.0 | |
| flarum-statistics | v1.8.0 | |
| flarum-mentions | v1.8.3 | |
| flarum-markdown | v1.8.0 | |
| flarum-lock | v1.8.0 | |
| flarum-likes | v1.8.0 | |
| flarum-lang-english | v1.8.0 | |
| flarum-extension-manager | v1.0.3 | |
| flarum-emoji | v1.8.0 | |
| flarum-bbcode | v1.8.0 | |
+--------------------------+---------+--------+
Base URL: #####
Installation path: /var/www/vhosts/#####/#####
Queue driver: sync
Session driver: file
Mail driver: mail
Debug mode: off

luceos · Mar 1, 2024

iguannaweb can you copy more of this trace, although I assume this is core, seeing more lines of the log file would help trace the issue a little better.

Iiguannaweb · Mar 1, 2024

This is what is shown on debug

GET https://#####/api/discussions/2-hola

PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(partition by flarum_post_mentions_post.mentions_post_id order by `created_a' at line 1 in /var/www/vhosts/####/foro.####/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:82
Stack trace:
#0 /var/www/vhosts/####/foro.####/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(82): PDO->prepare()
#1 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Connection.php(368): Doctrine\DBAL\Driver\PDOConnection->prepare()
#2 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Connection.php(705): Illuminate\Database\Connection->Illuminate\Database{closure}()
#3 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback()
#4 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Connection.php(376): Illuminate\Database\Connection->run()
#5 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Query/Builder.php(2414): Illuminate\Database\Connection->select()
#6 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Query/Builder.php(2402): Illuminate\Database\Query\Builder->runSelect()
#7 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Query/Builder.php(2936): Illuminate\Database\Query\Builder->Illuminate\Database\Query{closure}()
#8 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Query/Builder.php(2403): Illuminate\Database\Query\Builder->onceWithColumns()
#9 /var/www/vhosts/####/foro.####/vendor/staudenmeir/eloquent-eager-limit/src/Builder.php(40): Illuminate\Database\Query\Builder->get()
#10 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Eloquent/Builder.php(625): Staudenmeir\EloquentEagerLimit\Builder->get()
#11 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Eloquent/Relations/BelongsToMany.php(807): Illuminate\Database\Eloquent\Builder->getModels()
#12 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Eloquent/Relations/Relation.php(160): Illuminate\Database\Eloquent\Relations\BelongsToMany->get()
#13 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Eloquent/Builder.php(673): Illuminate\Database\Eloquent\Relations\Relation->getEager()
#14 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Eloquent/Builder.php(642): Illuminate\Database\Eloquent\Builder->eagerLoadRelation()
#15 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Eloquent/Collection.php(60): Illuminate\Database\Eloquent\Builder->eagerLoadRelations()
#16 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Eloquent/Collection.php(231): Illuminate\Database\Eloquent\Collection->load()
#17 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Eloquent/Collection.php(206): Illuminate\Database\Eloquent\Collection->loadMissingRelation()
#18 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Api/Controller/AbstractSerializeController.php(246): Illuminate\Database\Eloquent\Collection->loadMissing()
#19 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Api/Controller/ShowDiscussionController.php(195): Flarum\Api\Controller\AbstractSerializeController->loadRelations()
#20 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Api/Controller/ShowDiscussionController.php(123): Flarum\Api\Controller\ShowDiscussionController->loadPosts()
#21 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Api/Controller/ShowDiscussionController.php(101): Flarum\Api\Controller\ShowDiscussionController->includePosts()
#22 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Api/Controller/AbstractSerializeController.php(116): Flarum\Api\Controller\ShowDiscussionController->data()
#23 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\AbstractSerializeController->handle()
#24 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http{closure}()
#25 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ExecuteRoute->process()
#26 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#27 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Api\Middleware\ThrottleApi->process()
#28 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(36): Laminas\Stratigility\Next->handle()
#29 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\CheckCsrfToken->process()
#30 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(69): Laminas\Stratigility\Next->handle()
#31 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ResolveRoute->process()
#32 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#33 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\SetLocale->process()
#34 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(58): Laminas\Stratigility\Next->handle()
#35 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\AuthenticateWithHeader->process()
#36 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle()
#37 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\AuthenticateWithSession->process()
#38 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle()
#39 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\RememberFromCookie->process()
#40 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#41 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\StartSession->process()
#42 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\Stratigility\Next->handle()
#43 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Api\Middleware\FakeHttpMethods->process()
#44 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle()
#45 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ParseJsonBody->process()
#46 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#47 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\HandleErrors->process()
#48 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle()
#49 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\InjectActorReference->process()
#50 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#51 /var/www/vhosts/####/foro.####/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process()
#52 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\RequestHandler->process()
#53 /var/www/vhosts/####/foro.####/vendor/middlewares/base-path-router/src/BasePathRouter.php(101): Laminas\Stratigility\Next->handle()
#54 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\BasePathRouter->process()
#55 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(36): Laminas\Stratigility\Next->handle()
#56 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Laminas\Stratigility\Middleware\OriginalMessages->process()
#57 /var/www/vhosts/####/foro.####/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle()
#58 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\BasePath->process()
#59 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle()
#60 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ProcessIp->process()
#61 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#62 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(64): Laminas\Stratigility\MiddlewarePipe->process()
#63 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(73): Laminas\Stratigility\MiddlewarePipe->handle()
#64 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Http/Server.php(45): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#65 /var/www/vhosts/####/foro.####/public/index.php(26): Flarum\Http\Server->listen()
#66 {main}

Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(partition by flarum_post_mentions_post.mentions_post_id order by `created_a' at line 1 in /var/www/vhosts/####/foro.####/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /var/www/vhosts/####/foro.####/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(87): Doctrine\DBAL\Driver\PDO\Exception::new()
#1 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Connection.php(368): Doctrine\DBAL\Driver\PDOConnection->prepare()
#2 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Connection.php(705): Illuminate\Database\Connection->Illuminate\Database{closure}()
#3 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback()
#4 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Connection.php(376): Illuminate\Database\Connection->run()
#5 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Query/Builder.php(2414): Illuminate\Database\Connection->select()
#6 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Query/Builder.php(2402): Illuminate\Database\Query\Builder->runSelect()
#7 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Query/Builder.php(2936): Illuminate\Database\Query\Builder->Illuminate\Database\Query{closure}()
#8 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Query/Builder.php(2403): Illuminate\Database\Query\Builder->onceWithColumns()
#9 /var/www/vhosts/####/foro.####/vendor/staudenmeir/eloquent-eager-limit/src/Builder.php(40): Illuminate\Database\Query\Builder->get()
#10 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Eloquent/Builder.php(625): Staudenmeir\EloquentEagerLimit\Builder->get()
#11 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Eloquent/Relations/BelongsToMany.php(807): Illuminate\Database\Eloquent\Builder->getModels()
#12 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Eloquent/Relations/Relation.php(160): Illuminate\Database\Eloquent\Relations\BelongsToMany->get()
#13 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Eloquent/Builder.php(673): Illuminate\Database\Eloquent\Relations\Relation->getEager()
#14 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Eloquent/Builder.php(642): Illuminate\Database\Eloquent\Builder->eagerLoadRelation()
#15 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Eloquent/Collection.php(60): Illuminate\Database\Eloquent\Builder->eagerLoadRelations()
#16 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Eloquent/Collection.php(231): Illuminate\Database\Eloquent\Collection->load()
#17 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Eloquent/Collection.php(206): Illuminate\Database\Eloquent\Collection->loadMissingRelation()
#18 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Api/Controller/AbstractSerializeController.php(246): Illuminate\Database\Eloquent\Collection->loadMissing()
#19 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Api/Controller/ShowDiscussionController.php(195): Flarum\Api\Controller\AbstractSerializeController->loadRelations()
#20 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Api/Controller/ShowDiscussionController.php(123): Flarum\Api\Controller\ShowDiscussionController->loadPosts()
#21 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Api/Controller/ShowDiscussionController.php(101): Flarum\Api\Controller\ShowDiscussionController->includePosts()
#22 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Api/Controller/AbstractSerializeController.php(116): Flarum\Api\Controller\ShowDiscussionController->data()
#23 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\AbstractSerializeController->handle()
#24 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http{closure}()
#25 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ExecuteRoute->process()
#26 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#27 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Api\Middleware\ThrottleApi->process()
#28 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(36): Laminas\Stratigility\Next->handle()
#29 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\CheckCsrfToken->process()
#30 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(69): Laminas\Stratigility\Next->handle()
#31 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ResolveRoute->process()
#32 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#33 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\SetLocale->process()
#34 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(58): Laminas\Stratigility\Next->handle()
#35 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\AuthenticateWithHeader->process()
#36 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle()
#37 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\AuthenticateWithSession->process()
#38 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle()
#39 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\RememberFromCookie->process()
#40 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#41 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\StartSession->process()
#42 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\Stratigility\Next->handle()
#43 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Api\Middleware\FakeHttpMethods->process()
#44 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle()
#45 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ParseJsonBody->process()
#46 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#47 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\HandleErrors->process()
#48 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle()
#49 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\InjectActorReference->process()
#50 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#51 /var/www/vhosts/####/foro.####/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process()
#52 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\RequestHandler->process()
#53 /var/www/vhosts/####/foro.####/vendor/middlewares/base-path-router/src/BasePathRouter.php(101): Laminas\Stratigility\Next->handle()
#54 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\BasePathRouter->process()
#55 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(36): Laminas\Stratigility\Next->handle()
#56 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Laminas\Stratigility\Middleware\OriginalMessages->process()
#57 /var/www/vhosts/####/foro.####/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle()
#58 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\BasePath->process()
#59 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle()
#60 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ProcessIp->process()
#61 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#62 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(64): Laminas\Stratigility\MiddlewarePipe->process()
#63 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(73): Laminas\Stratigility\MiddlewarePipe->handle()
#64 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Http/Server.php(45): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#65 /var/www/vhosts/####/foro.####/public/index.php(26): Flarum\Http\Server->listen()
#66 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(partition by flarum_post_mentions_post.mentions_post_id order by created_a' at line 1 (SQL: select * from (selectflarum_posts.*,flarum_post_mentions_post.mentions_post_idaspivot_mentions_post_id,flarum_post_mentions_post.post_idaspivot_post_id, row_number() over (partition byflarum_post_mentions_post.mentions_post_idorder bycreated_atasc) as laravel_row fromflarum_postsinner joinflarum_post_mentions_postonflarum_posts.id=flarum_post_mentions_post.post_idwhereflarum_post_mentions_post.mentions_post_idin (2) and exists (select 1 fromflarum_discussionswhereflarum_discussions.id=flarum_posts.discussion_idand (flarum_discussions.idnot in (selectdiscussion_idfromflarum_discussion_tagwheretag_idnot in (selectflarum_tags.idfromflarum_tagswhere (flarum_tags.idin (selectflarum_perm_tags.idfromflarum_tagsasflarum_perm_tags) and (flarum_tags.parent_idin (selectflarum_perm_tags.idfromflarum_tagsasflarum_perm_tags) orflarum_tags.parent_idis null))))) and (flarum_discussions.is_private= 0 or (((flarum_discussions.is_approved= 0))))) and (flarum_posts.is_private= 0 or (((flarum_posts.is_approved= 0)))) andtype` in (discussionTagged, discussionStickied, discussionLocked, comment, discussionRenamed)) as laravel_table where laravel_row <= 4 order by laravel_row) in /var/www/vhosts/####/foro.####/vendor/illuminate/database/Connection.php:712
Stack trace:
#0 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Connection.php(376): Illuminate\Database\Connection->run()
#2 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Query/Builder.php(2414): Illuminate\Database\Connection->select()
#3 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Query/Builder.php(2402): Illuminate\Database\Query\Builder->runSelect()
#4 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Query/Builder.php(2936): Illuminate\Database\Query\Builder->Illuminate\Database\Query{closure}()
#5 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Query/Builder.php(2403): Illuminate\Database\Query\Builder->onceWithColumns()
#6 /var/www/vhosts/####/foro.####/vendor/staudenmeir/eloquent-eager-limit/src/Builder.php(40): Illuminate\Database\Query\Builder->get()
#7 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Eloquent/Builder.php(625): Staudenmeir\EloquentEagerLimit\Builder->get()
#8 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Eloquent/Relations/BelongsToMany.php(807): Illuminate\Database\Eloquent\Builder->getModels()
#9 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Eloquent/Relations/Relation.php(160): Illuminate\Database\Eloquent\Relations\BelongsToMany->get()
#10 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Eloquent/Builder.php(673): Illuminate\Database\Eloquent\Relations\Relation->getEager()
#11 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Eloquent/Builder.php(642): Illuminate\Database\Eloquent\Builder->eagerLoadRelation()
#12 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Eloquent/Collection.php(60): Illuminate\Database\Eloquent\Builder->eagerLoadRelations()
#13 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Eloquent/Collection.php(231): Illuminate\Database\Eloquent\Collection->load()
#14 /var/www/vhosts/####/foro.####/vendor/illuminate/database/Eloquent/Collection.php(206): Illuminate\Database\Eloquent\Collection->loadMissingRelation()
#15 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Api/Controller/AbstractSerializeController.php(246): Illuminate\Database\Eloquent\Collection->loadMissing()
#16 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Api/Controller/ShowDiscussionController.php(195): Flarum\Api\Controller\AbstractSerializeController->loadRelations()
#17 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Api/Controller/ShowDiscussionController.php(123): Flarum\Api\Controller\ShowDiscussionController->loadPosts()
#18 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Api/Controller/ShowDiscussionController.php(101): Flarum\Api\Controller\ShowDiscussionController->includePosts()
#19 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Api/Controller/AbstractSerializeController.php(116): Flarum\Api\Controller\ShowDiscussionController->data()
#20 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\AbstractSerializeController->handle()
#21 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http{closure}()
#22 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ExecuteRoute->process()
#23 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#24 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Api\Middleware\ThrottleApi->process()
#25 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(36): Laminas\Stratigility\Next->handle()
#26 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\CheckCsrfToken->process()
#27 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(69): Laminas\Stratigility\Next->handle()
#28 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ResolveRoute->process()
#29 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#30 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\SetLocale->process()
#31 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(58): Laminas\Stratigility\Next->handle()
#32 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\AuthenticateWithHeader->process()
#33 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle()
#34 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\AuthenticateWithSession->process()
#35 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle()
#36 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\RememberFromCookie->process()
#37 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#38 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\StartSession->process()
#39 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\Stratigility\Next->handle()
#40 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Api\Middleware\FakeHttpMethods->process()
#41 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle()
#42 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ParseJsonBody->process()
#43 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#44 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\HandleErrors->process()
#45 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle()
#46 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\InjectActorReference->process()
#47 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#48 /var/www/vhosts/####/foro.####/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process()
#49 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\RequestHandler->process()
#50 /var/www/vhosts/####/foro.####/vendor/middlewares/base-path-router/src/BasePathRouter.php(101): Laminas\Stratigility\Next->handle()
#51 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\BasePathRouter->process()
#52 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(36): Laminas\Stratigility\Next->handle()
#53 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Laminas\Stratigility\Middleware\OriginalMessages->process()
#54 /var/www/vhosts/####/foro.####/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle()
#55 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\BasePath->process()
#56 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle()
#57 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ProcessIp->process()
#58 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#59 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(64): Laminas\Stratigility\MiddlewarePipe->process()
#60 /var/www/vhosts/####/foro.####/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(73): Laminas\Stratigility\MiddlewarePipe->handle()
#61 /var/www/vhosts/####/foro.####/vendor/flarum/core/src/Http/Server.php(45): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#62 /var/www/vhosts/####/foro.####/public/index.php(26): Flarum\Http\Server->listen()
#63 {main}

Iiguannaweb · Mar 1, 2024

anything? I tried somethings:

Edited htaccess
revised permissions
tried with apache or nginx
tried php 8.0 8.1 8.2 and 8.3
tried delete vendors and install again
tried reinstall flarum

Could by any configuration needed in mysql/mariadb server?

Iiguannaweb · Mar 1, 2024

Finaly, I decided to use other server where I know it's working... but don't know why it's not working.

SychO · Mar 2, 2024

the issue is very likely the used mariadb version. it's lower than needed

Iiguannaweb · Mar 2, 2024

But my mariadb version is 10.1.48-MariaDB-0ubuntu0.18.04.1 isnt it ok?