FriendsOfFlarum Best Answer

SergKuprin

У меня после установки, появилось большое расстояние над ответом и под ответом. Как исправить ?

After installation, I had a long distance above the answer and below the answer. How to fix it?

IanM

1.4.0 1.4.1

feat: Use tag pickers to configure BA enabled tags & reminders
fix: unable to unset best answer on PHP 8.3

FriendsOfFlarum/best-answer88

Upgrading

composer require fof/best-answer:"*"
php flarum migrate
php flarum cache:clear

Litalino

Update Good

SergKuprin

Please help me how to solve this problem?
If I delete the extension then everything is fine
scr

TeamF

[deleted]

Hello. There has been an error for a long time that the best news is displayed incorrectly. The nickname as was not adopted and instead it says [deleted]

I link a topic here and added a screenshot. After refresh the Name is shown.
Example : https://discuss.flarum.org/d/33880-how-to-setup-mail-service

davetodave178

TeamF I think the problem you described is not specific to fof/best-answer but an issue in general. See flarum/issue-archive237 for more information about it.

TeamF

@clarkwinkelmann we are hosted by Freeflarm / @SKevo My Site is linked in my Profile. Feel free to Join. The error also occurs here at discuss. (see sceenshot + link)
i use Linux with Firefox & Bravebrower

nxmndr

Hari
I think it should indeed affect all discussions if no tag is selected, like Hari says.

Consequently the Solved/Unsolved filter should appear on the front page as well.

ycolor

Unable to open

!Flarum core: 1.8.5
PHP version: 8.3.2-1+0_20240120.16+debian12₁.gbpb43448
MySQL version: 11.2.2-MariaDB-1:11.2.2+maria_deb12-log
Loaded extensions: Core, date, libxml, openssl, pcre, zlib, filter, hash, json, pcntl, random, Reflection, SPL, session, standard, sodium, mysqlnd, PDO, xml, apcu, bcmath, calendar, ctype, curl, dom, mbstring, FFI, fileinfo, ftp, gd, gettext, iconv, igbinary, imagick, intl, exif, memcache, msgpack, mysqli, pdo_mysql, Phar, posix, readline, redis, shmop, SimpleXML, soap, sockets, sysvmsg, sysvsem, sysvshm, tokenizer, xmlreader, xmlrpc, xmlwriter, xsl, zip, memcached, Zend OPcache
+--------------------------------+---------+--------+
| Flarum Extensions | | |
+--------------------------------+---------+--------+
| ID | Version | Commit |
+--------------------------------+---------+--------+
| flarum-flags | v1.8.0 | |
| flarum-tags | v1.8.0 | |
| flarum-approval | v1.8.1 | |
| flarum-suspend | v1.8.1 | |
| v17development-seo | v1.8.0 | |
| flarum-sticky | v1.8.0 | |
| flarum-lock | v1.8.0 | |
| fof-pages | 1.0.8 | |
| flarum-mentions | v1.8.3 | |
| flarum-subscriptions | v1.8.0 | |
| fof-byobu | 1.3.5 | |
| fof-oauth | 1.6.6 | |
| v17development-blog | v0.7.7 | |
| the-turk-flamoji | 1.0.4 | |
| sycho-private-facade | v0.1.15 | |
| nodeloc-telegram | 0.3 | |
| nearata-tags-color-generator | v2.3.0 | |
| fof-user-directory | 1.3.3 | |
| fof-user-bio | 1.3.2 | |
| fof-upload | 1.5.4 | |
| fof-split | 1.1.1 | |
| fof-sitemap | 2.2.1 | |
| fof-share-social | 1.2.0 | |
| fof-polls | 2.1.2 | |
| fof-links | 1.2.2 | |
| fof-html-errors | 1.1.2 | |
| fof-formatting | 1.0.3 | |
| fof-follow-tags | 1.2.2 | |
| fof-drafts | 1.2.10 | |
| fof-anti-spam | 1.1.2 | |
| fof-analytics | 1.1.0 | |
| flarum-statistics | v1.8.0 | |
| flarum-pusher | v1.8.0 | |
| flarum-nicknames | v1.8.0 | |
| flarum-markdown | v1.8.0 | |
| flarum-likes | v1.8.0 | |
| flarum-extension-manager | v1.0.1 | |
| flarum-emoji | v1.8.0 | |
| flarum-bbcode | v1.8.0 | |
| blomstra-oauth-apple | 0.1.3 | |
| acpl-mobile-tab | 1.4.1 | |
+--------------------------------+---------+--------+!<

#49 /usr/share/nginx/html/flarum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\InjectActorReference->process() #50 /usr/share/nginx/html/flarum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle() #51 /usr/share/nginx/html/flarum/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process() #52 /usr/share/nginx/html/flarum/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\RequestHandler->process() #53 /usr/share/nginx/html/flarum/vendor/middlewares/base-path-router/src/BasePathRouter.php(99): Laminas\Stratigility\Next->handle() #54 /usr/share/nginx/html/flarum/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\BasePathRouter->process() #55 /usr/share/nginx/html/flarum/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(36): Laminas\Stratigility\Next->handle() #56 /usr/share/nginx/html/flarum/vendor/laminas/laminas-stratigility/src/Next.php(49): Laminas\Stratigility\Middleware\OriginalMessages->process() #57 /usr/share/nginx/html/flarum/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle() #58 /usr/share/nginx/html/flarum/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\BasePath->process() #59 /usr/share/nginx/html/flarum/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle() #60 /usr/share/nginx/html/flarum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ProcessIp->process() #61 /usr/share/nginx/html/flarum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle() #62 /usr/share/nginx/html/flarum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(64): Laminas\Stratigility\MiddlewarePipe->process() #63 /usr/share/nginx/html/flarum/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(73): Laminas\Stratigility\MiddlewarePipe->handle() #64 /usr/share/nginx/html/flarum/vendor/flarum/core/src/Http/Server.php(45): Laminas\HttpHandlerRunner\RequestHandlerRunner->run() #65 /usr/share/nginx/html/flarum/public/index.php(26): Flarum\Http\Server->listen() #66 {main}

luceos

ycolor the trace you shared starts at line #49. Please copy all lines starting at #1 and the non numbered line above the first one.

ycolor

[2024-02-04 03:09:01] flarum.ERROR: Exception: Unable to create lockable file: /usr/share/nginx/html/flarum/storage/cache/e2/5f/e25fdbdbfc702162470775d667128db888381695. Please ensure you have permission to create files in this location. in /usr/share/nginx/html/flarum/vendor/illuminate/filesystem/LockableFile.php:73 [2024-02-04 03:10:01] flarum.ERROR: Exception: Unable to create lockable file: /usr/share/nginx/html/flarum/storage/cache/e2/5f/e25fdbdbfc702162470775d667128db888381695. Please ensure you have permission to create files in this location. in /usr/share/nginx/html/flarum/vendor/illuminate/filesystem/LockableFile.php:73 [2024-02-04 03:11:01] flarum.ERROR: Exception: Unable to create lockable file: /usr/share/nginx/html/flarum/storage/cache/e2/5f/e25fdbdbfc702162470775d667128db888381695. Please ensure you have permission to create files in this location. in /usr/share/nginx/html/flarum/vendor/illuminate/filesystem/LockableFile.php:73 [2024-02-04 03:12:02] flarum.ERROR: Exception: Unable to create lockable file: /usr/share/nginx/html/flarum/storage/cache/e2/5f/e25fdbdbfc702162470775d667128db888381695. Please ensure you have permission to create files in this location. in /usr/share/nginx/html/flarum/vendor/illuminate/filesystem/LockableFile.php:73 [2024-02-04 03:13:01] flarum.ERROR: Exception: Unable to create lockable file: /usr/share/nginx/html/flarum/storage/cache/e2/5f/e25fdbdbfc702162470775d667128db888381695. Please ensure you have permission to create files in this location. in /usr/share/nginx/html/flarum/vendor/illuminate/filesystem/LockableFile.php:73 [2024-02-04 03:14:01] flarum.ERROR: Exception: Unable to create lockable file: /usr/share/nginx/html/flarum/storage/cache/e2/5f/e25fdbdbfc702162470775d667128db888381695. Please ensure you have permission to create files in this location. in /usr/share/nginx/html/flarum/vendor/illuminate/filesystem/LockableFile.php:73 [2024-02-04 03:15:01] flarum.ERROR: Exception: Unable to create lockable file: /usr/share/nginx/html/flarum/storage/cache/e2/5f/e25fdbdbfc702162470775d667128db888381695. Please ensure you have permission to create files in this location. in /usr/share/nginx/html/flarum/vendor/illuminate/filesystem/LockableFile.php:73 [2024-02-04 03:16:01] flarum.ERROR: Exception: Unable to create lockable file: /usr/share/nginx/html/flarum/storage/cache/e2/5f/e25fdbdbfc702162470775d667128db888381695. Please ensure you have permission to create files in this location. in /usr/share/nginx/html/flarum/vendor/illuminate/filesystem/LockableFile.php:73 [2024-02-04 03:17:01] flarum.ERROR: Exception: Unable to create lockable file: /usr/share/nginx/html/flarum/storage/cache/e2/5f/e25fdbdbfc702162470775d667128db888381695. Please ensure you have permission to create files in this location. in /usr/share/nginx/html/flarum/vendor/illuminate/filesystem/LockableFile.php:73 [2024-02-04 03:18:02] flarum.ERROR: Exception: Unable to create lockable file: /usr/share/nginx/html/flarum/storage/cache/e2/5f/e25fdbdbfc702162470775d667128db888381695. Please ensure you have permission to create files in this location. in /usr/share/nginx/html/flarum/vendor/illuminate/filesystem/LockableFile.php:73 [2024-02-04 03:19:01] flarum.ERROR: Exception: Unable to create lockable file: /usr/share/nginx/html/flarum/storage/cache/e2/5f/e25fdbdbfc702162470775d667128db888381695. Please ensure you have permission to create files in this location. in /usr/share/nginx/html/flarum/vendor/illuminate/filesystem/LockableFile.php:73 [2024-02-04 03:20:01] flarum.ERROR: Exception: Unable to create lockable file: /usr/share/nginx/html/flarum/storage/cache/e2/5f/e25fdbdbfc702162470775d667128db888381695. Please ensure you have permission to create files in this location. in /usr/share/nginx/html/flarum/vendor/illuminate/filesystem/LockableFile.php:73 [2024-02-04 04:06:29] flarum.ERROR: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'posts_ip_address_index' in /usr/share/nginx/html/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117 Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'posts_ip_address_index' in /usr/share/nginx/html/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18 Next Illuminate\Database\QueryException: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'posts_ip_address_index' (SQL: alter tablepostsadd indexposts_ip_address_index(ip_address)) in /usr/share/nginx/html/flarum/vendor/illuminate/database/Connection.php:712 [2024-02-04 04:08:35] flarum.ERROR: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'posts_ip_address_index' in /usr/share/nginx/html/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117 [2024-02-04 04:20:44] flarum.ERROR: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'posts_ip_address_index' in /usr/share/nginx/html/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117 [2024-02-04 04:44:25] flarum.ERROR: PDOException: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'is_qna' in /usr/share/nginx/html/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117 Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'is_qna' in /usr/share/nginx/html/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18 Next Illuminate\Database\QueryException: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'is_qna' (SQL: alter tabletagsaddis_qnatinyint(1) not null default '0') in /usr/share/nginx/html/flarum/vendor/illuminate/database/Connection.php:712 [2024-02-04 04:51:07] flarum.ERROR: PDOException: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'is_qna' in /usr/share/nginx/html/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117 [2024-02-04 05:02:01] flarum.ERROR: Exception: Unable to create lockable file: /usr/share/nginx/html/flarum/storage/cache/e2/5f/e25fdbdbfc702162470775d667128db888381695. Please ensure you have permission to create files in this location. in /usr/share/nginx/html/flarum/vendor/illuminate/filesystem/LockableFile.php:73 [2024-02-04 05:03:02] flarum.ERROR: Exception: Unable to create lockable file: /usr/share/nginx/html/flarum/storage/cache/e2/5f/e25fdbdbfc702162470775d667128db888381695. Please ensure you have permission to create files in this location. in /usr/share/nginx/html/flarum/vendor/illuminate/filesystem/LockableFile.php:73 [2024-02-04 05:04:01] flarum.ERROR: Exception: Unable to create lockable file: /usr/share/nginx/html/flarum/storage/cache/e2/5f/e25fdbdbfc702162470775d667128db888381695. Please ensure you have permission to create files in this location. in /usr/share/nginx/html/flarum/vendor/illuminate/filesystem/LockableFile.php:73 [2024-02-04 05:05:01] flarum.ERROR: Exception: Unable to create lockable file: /usr/share/nginx/html/flarum/storage/cache/e2/5f/e25fdbdbfc702162470775d667128db888381695. Please ensure you have permission to create files in this location. in /usr/share/nginx/html/flarum/vendor/illuminate/filesystem/LockableFile.php:73 [2024-02-04 05:06:01] flarum.ERROR: Exception: Unable to create lockable file: /usr/share/nginx/html/flarum/storage/cache/e2/5f/e25fdbdbfc702162470775d667128db888381695. Please ensure you have permission to create files in this location. in /usr/share/nginx/html/flarum/vendor/illuminate/filesystem/LockableFile.php:73 [2024-02-04 05:07:01] flarum.ERROR: Exception: Unable to create lockable file: /usr/share/nginx/html/flarum/storage/cache/e2/5f/e25fdbdbfc702162470775d667128db888381695. Please ensure you have permission to create files in this location. in /usr/share/nginx/html/flarum/vendor/illuminate/filesystem/LockableFile.php:73 [2024-02-04 05:08:01] flarum.ERROR: Exception: Unable to create lockable file: /usr/share/nginx/html/flarum/storage/cache/e2/5f/e25fdbdbfc702162470775d667128db888381695. Please ensure you have permission to create files in this location. in /usr/share/nginx/html/flarum/vendor/illuminate/filesystem/LockableFile.php:73 [2024-02-04 05:09:02] flarum.ERROR: Exception: Unable to create lockable file: /usr/share/nginx/html/flarum/storage/cache/e2/5f/e25fdbdbfc702162470775d667128db888381695. Please ensure you have permission to create files in this location. in /usr/share/nginx/html/flarum/vendor/illuminate/filesystem/LockableFile.php:73 [2024-02-04 05:10:01] flarum.ERROR: Exception: Unable to create lockable file: /usr/share/nginx/html/flarum/storage/cache/e2/5f/e25fdbdbfc702162470775d667128db888381695. Please ensure you have permission to create files in this location. in /usr/share/nginx/html/flarum/vendor/illuminate/filesystem/LockableFile.php:73 [2024-02-04 05:11:01] flarum.ERROR: Exception: Unable to create lockable file: /usr/share/nginx/html/flarum/storage/cache/e2/5f/e25fdbdbfc702162470775d667128db888381695. Please ensure you have permission to create files in this location. in /usr/share/nginx/html/flarum/vendor/illuminate/filesystem/LockableFile.php:73 [2024-02-04 05:12:01] flarum.ERROR: Exception: Unable to create lockable file: /usr/share/nginx/html/flarum/storage/cache/e2/5f/e25fdbdbfc702162470775d667128db888381695. Please ensure you have permission to create files in this location. in /usr/share/nginx/html/flarum/vendor/illuminate/filesystem/LockableFile.php:73 [2024-02-04 05:13:01] flarum.ERROR: Exception: Unable to create lockable file: /usr/share/nginx/html/flarum/storage/cache/e2/5f/e25fdbdbfc702162470775d667128db888381695. Please ensure you have permission to create files in this location. in /usr/share/nginx/html/flarum/vendor/illuminate/filesystem/LockableFile.php:73 [2024-02-04 05:14:01] flarum.ERROR: Exception: Unable to create lockable file: /usr/share/nginx/html/flarum/storage/cache/e2/5f/e25fdbdbfc702162470775d667128db888381695. Please ensure you have permission to create files in this location. in /usr/share/nginx/html/flarum/vendor/illuminate/filesystem/LockableFile.php:73 [2024-02-04 05:14:57] flarum.ERROR: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'posts_ip_address_index' in /usr/share/nginx/html/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117 [2024-02-04 05:16:22] flarum.ERROR: PDOException: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'is_qna' in /usr/share/nginx/html/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117 [2024-02-04 05:24:44] flarum.ERROR: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'best_answer_post_id' in 'field list' in /usr/share/nginx/html/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:82 Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'best_answer_post_id' in 'field list' in /usr/share/nginx/html/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18 Next Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'best_answer_post_id' in 'field list' (SQL: updatediscussionssetbest_answer_post_id= ? where not exists (select 1 frompostswhereid=best_answer_post_id)) in /usr/share/nginx/html/flarum/vendor/illuminate/database/Connection.php:712 [2024-02-04 05:33:58] flarum.ERROR: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'best_answer_post_id' in 'field list' in /usr/share/nginx/html/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:82 [2024-02-04 05:36:34] flarum.ERROR: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'best_answer_post_id' in 'field list' in /usr/share/nginx/html/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:82 [2024-02-04 05:42:41] flarum.ERROR: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'best_answer_post_id' in 'field list' in /usr/share/nginx/html/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:82 [2024-02-04 05:44:59] flarum.ERROR: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'best_answer_post_id' in 'field list' in /usr/share/nginx/html/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:82 [2024-02-04 05:49:00] flarum.ERROR: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'best_answer_post_id' in 'field list' in /usr/share/nginx/html/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:82 [2024-02-04 05:51:14] flarum.ERROR: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'best_answer_post_id' in 'field list' in /usr/share/nginx/html/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:82 [2024-02-04 05:51:15] flarum.ERROR: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'best_answer_post_id' in 'field list' in /usr/share/nginx/html/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:82 [2024-02-04 05:51:17] flarum.ERROR: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'best_answer_post_id' in 'field list' in /usr/share/nginx/html/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:82

luceos

ycolor well something is definitely wrong with your installation. It seems the site runs under a different user than the user that owns the storage (and all child) directory. You need to fix that asap.

ycolor

luceos

It's not a permissions or cache issue
If it’s a permissions issue, then I’ve installed so many plug-ins, why are there no problems?
My user permissions have been checked and there are no problems

This is the latest bug log, not a permissions issue

[2024-02-04 14:07:29] flarum.ERROR: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'best_answer_post_id' in 'field list' in /usr/share/nginx/html/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:82 Stack trace: Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'best_answer_post_id' in 'field list' in /usr/share/nginx/html/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18 Stack trace: Next Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'best_answer_post_id' in 'field list' (SQL: updatediscussionssetbest_answer_post_id= ? where not exists (select 1 frompostswhereid=best_answer_post_id)) in /usr/share/nginx/html/flarum/vendor/illuminate/database/Connection.php:712 Stack trace: [2024-02-04 14:07:30] flarum.ERROR: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'best_answer_post_id' in 'field list' in /usr/share/nginx/html/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:82 Stack trace: Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'best_answer_post_id' in 'field list' in /usr/share/nginx/html/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18 Stack trace: Next Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'best_answer_post_id' in 'field list' (SQL: updatediscussionssetbest_answer_post_id= ? where not exists (select 1 frompostswhereid=best_answer_post_id)) in /usr/share/nginx/html/flarum/vendor/illuminate/database/Connection.php:712 Stack trace: [2024-02-04 14:07:32] flarum.ERROR: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'best_answer_post_id' in 'field list' in /usr/share/nginx/html/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:82 Stack trace: Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'best_answer_post_id' in 'field list' in /usr/share/nginx/html/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18 Stack trace: Next Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'best_answer_post_id' in 'field list' (SQL: updatediscussionssetbest_answer_post_id= ? where not exists (select 1 frompostswhereid=best_answer_post_id)) in /usr/share/nginx/html/flarum/vendor/illuminate/database/Connection.php:712 Stack trace: [2024-02-04 14:07:33] flarum.ERROR: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'best_answer_post_id' in 'field list' in /usr/share/nginx/html/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:82 Stack trace: Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'best_answer_post_id' in 'field list' in /usr/share/nginx/html/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18 Stack trace: Next Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'best_answer_post_id' in 'field list' (SQL: updatediscussionssetbest_answer_post_id= ? where not exists (select 1 frompostswhereid=best_answer_post_id)) in /usr/share/nginx/html/flarum/vendor/illuminate/database/Connection.php:712 Stack trace: [2024-02-04 14:07:35] flarum.ERROR: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'best_answer_post_id' in 'field list' in /usr/share/nginx/html/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:82 Stack trace: Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'best_answer_post_id' in 'field list' in /usr/share/nginx/html/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18 Stack trace: Next Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'best_answer_post_id' in 'field list' (SQL: updatediscussionssetbest_answer_post_id= ? where not exists (select 1 frompostswhereid=best_answer_post_id)) in /usr/share/nginx/html/flarum/vendor/illuminate/database/Connection.php:712 Stack trace:

luceos

ycolor this error is caused by a missing database change, run php flarum migrate

ycolor

luceos

Unable to find FoF Best Answer

Migrating Flarum... Nothing to migrate. Migrating extension: flarum-flags Nothing to migrate. Migrating extension: flarum-tags Nothing to migrate. Migrating extension: flarum-approval Nothing to migrate. Migrating extension: flarum-suspend Nothing to migrate. Migrating extension: flarum-sticky Nothing to migrate. Migrating extension: flarum-lock Nothing to migrate. Migrating extension: fof-pages Nothing to migrate. Migrating extension: flarum-mentions Nothing to migrate. Migrating extension: flarum-subscriptions Nothing to migrate. Migrating extension: fof-byobu Nothing to migrate. Migrating extension: fof-oauth Nothing to migrate. Migrating extension: v17development-blog Nothing to migrate. Migrating extension: the-turk-flamoji Nothing to migrate. Migrating extension: nearata-tags-color-generator Nothing to migrate. Migrating extension: fof-user-directory Nothing to migrate. Migrating extension: fof-user-bio Nothing to migrate. Migrating extension: fof-upload Nothing to migrate. Migrating extension: fof-sitemap Nothing to migrate. Migrating extension: fof-share-social Nothing to migrate. Migrating extension: fof-polls Nothing to migrate. Migrating extension: fof-links Nothing to migrate. Migrating extension: fof-follow-tags Nothing to migrate. Migrating extension: fof-drafts Nothing to migrate. Migrating extension: fof-anti-spam Nothing to migrate. Migrating extension: fof-analytics Nothing to migrate. Migrating extension: flarum-nicknames Nothing to migrate. Migrating extension: flarum-markdown Nothing to migrate. Migrating extension: flarum-likes Nothing to migrate. Migrating extension: flarum-extension-manager Nothing to migrate. Migrating extension: flarum-emoji Nothing to migrate. Migrating extension: askvortsov-categories Nothing to migrate. DONE.

luceos

ycolor best answer is not enabled? So when does this error occur? Seeing you have opcache make sure to restart the queue and webserver when you install, remove, enable or disable extensions.

ycolor

luceos

FoF Ban IPs
FoF Best Answer

These two extensions cannot be started after they are successfully installed.

sudo systemctl restart php8.3-fpm.service
sudo systemctl restart nginx.service
sudo systemctl restart maridb.service

IanM

1.4.2

feat: solution/best answer search by @IanM in FriendsOfFlarum/best-answer90
feat: revamp settings UI by @IanM in FriendsOfFlarum/best-answer91

Screenshots

Full Changelog: FriendsOfFlarum/best-answer1.4.1 → 1.4.2

Trc4

I accidentally activated “Alternative layout" activated. Now they are displayed in the first post. After deactivating + clearing cache, unfortunately it is still the same. What is the reason for this?

I use FreeFlarum

tolgaaaltas

Hi everyone,
I don't know how many people need this but I think it might be useful. As you know, Best Answer extension has adds automatic tags when you select a reply as best answer. I'm using it in my support forum. I've secondart tags like support, ongoing and solved. It's helpful to users to define and understant to process. These tags are useful for users to follow the support process. Best Answer can add tags to discussions, what about remove tag and automatic lock discussion options?

In my status, when I marked a reply as best answer I need to remove ongoing tag and locked everytime. I don't think these features should necessarily be added to the Best Answer extension, but I think they could be useful if added. Because when a reply is marked as Best Answer, it usually does not receive any more answers, and it makes sense to lock it to avoid confusion. If the extension can add tags, why can't it remove them?

I'm curious about your opinions, too. Like I said, I don't think it necessarily has to happen. Ultimately, this depends on the initiative of the FoF team. But it made sense to me.

« Previous Page Next Page »