Error 500 - problem with .htaccess

JJakubSvec · Aug 19, 2023

Hello everyone, my webhosting does not allow composer to be used in any way, so I used option of installing Flarum with composer on localhost and after configuring, I transferred it to FTP. Flarum worked perfectly on localhost, but after opening the website popped up error 500. Subsequently, I learned from the support that flarum in .htaccess uses a directives not allowed by my hosting, for example Options -MultiViews. Any chance to fix this? Flarum is, in my opinion, the only good system for clear and modern forums (unlike phpBB) and I have not found any suitable alternative. Thanks

luceos · Aug 19, 2023

JakubSvec try removing those lines that are not allowed by the server, you can also ask your webhosting provider for assistance on this; our htaccess instructions aren't really that unusual.

JJakubSvec · Aug 19, 2023

Thank you for answer. I've been trying to find the bug all day and finally just put Options -MultiViews in the #.

Thank you very much

JJakubSvec · Aug 21, 2023

Hello again,

I got the Flarum up and running, unfortunately there was a new problem that could be related to the solution to the previous problem (disabling Options -MultiViews in .htaccess). If I create a new post (Test), I am redirected to http://website.xy/public/d/4-test from the start page. However, this page cannot be loaded, the text "Oops! Something went wrong. Please reload the page and try again." appears here. After refreshing the page, PHP error messages will appear (look at the picture).

after click from main page

after refreshing

Wouldn't anyone know? Thanks...

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.