FriendsOfFlarum Best Answer

datitisev

0.1.1

Fix issue when adding foreign key constraints for post & user if they no longer exist (thanks [deleted])

Updating

composer require fof/best-answer

datitisev

[deleted] Try 0.1.1, should fix it.

[deleted]

datitisev Sadly, no

Next Illuminate\Database\QueryException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '3-discussion.selectBestAnswerOwnDiscussion' for key 'PRIMARY' (SQL: update `group_permission` set `permission` = discussion.selectBestAnswerOwnDiscussion where `permission` = discussion.selectBestAnswer) in /var/www/vhosts/infosecforge.io/discuss.infosecforge.io/vendor/illuminate/database/Connection.php:664
Stack trace:
#0 /var/www/vhosts/infosecforge.io/discuss.infosecforge.io/vendor/illuminate/database/Connection.php(624): Illuminate\Database\Connection->runQueryCallback('update `group_p...', Array, Object(Closure))
#1 /var/www/vhosts/infosecforge.io/discuss.infosecforge.io/vendor/illuminate/database/Connection.php(490): Illuminate\Database\Connection->run('update `group_p...', Array, Object(Closure))
#2 /var/www/vhosts/infosecforge.io/discuss.infosecforge.io/vendor/illuminate/database/Connection.php(423): Illuminate\Database\Connection->affectingStatement('update `group_p...', Array)
#3 /var/www/vhosts/infosecforge.io/discuss.infosecforge.io/vendor/illuminate/database/Query/Builder.php(2659): Illuminate\Database\Connection->update('update `group_p...', Array)
#4 /var/www/vhosts/infosecforge.io/discuss.infosecforge.io/vendor/reflar/recache/src/Database/QueryBuilder.php(112): Illuminate\Database\Query\Builder->update(Array)
#5 /var/www/vhosts/infosecforge.io/discuss.infosecforge.io/vendor/illuminate/database/Eloquent/Builder.php(818): Reflar\ReCache\Database\QueryBuilder->update(Array)
#6 /var/www/vhosts/infosecforge.io/discuss.infosecforge.io/vendor/fof/best-answer/migrations/2019_11_04_000003_migrate_extension_settings.php(32): Illuminate\Database\Eloquent\Builder->update(Array)
...

Performed uninstall then re-enable, and got this

[2019-11-05 20:21:51] production.ERROR: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '3-discussion.selectBestAnswerOwnDiscussion' for key 'PRIMARY' in /var/www/vhosts/infosecforge.io/discuss.infosecforge.io/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117
Stack trace:
#0 /var/www/vhosts/infosecforge.io/discuss.infosecforge.io/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(117): PDOStatement->execute(NULL)
#1 /var/www/vhosts/infosecforge.io/discuss.infosecforge.io/vendor/illuminate/database/Connection.php(483): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /var/www/vhosts/infosecforge.io/discuss.infosecforge.io/vendor/illuminate/database/Connection.php(657): Illuminate\Database\Connection->Illuminate\Database\{closure}('update `group_p...', Array)
#3 /var/www/vhosts/infosecforge.io/discuss.infosecforge.io/vendor/illuminate/database/Connection.php(624): Illuminate\Database\Connection->runQueryCallback('update `group_p...', Array, Object(Closure))
#4 /var/www/vhosts/infosecforge.io/discuss.infosecforge.io/vendor/illuminate/database/Connection.php(490): Illuminate\Database\Connection->run('update `group_p...', Array, Object(Closure))
#5 /var/www/vhosts/infosecforge.io/discuss.infosecforge.io/vendor/illuminate/database/Connection.php(423): Illuminate\Database\Connection->affectingStatement('update `group_p...', Array)
#6 /var/www/vhosts/infosecforge.io/discuss.infosecforge.io/vendor/illuminate/database/Query/Builder.php(2659): Illuminate\Database\Connection->update('update `group_p...', Array)
#7 /var/www/vhosts/infosecforge.io/discuss.infosecforge.io/vendor/reflar/recache/src/Database/QueryBuilder.php(112): Illuminate\Database\Query\Builder->update(Array)
#8 /var/www/vhosts/infosecforge.io/discuss.infosecforge.io/vendor/illuminate/database/Eloquent/Builder.php(818): Reflar\ReCache\Database\QueryBuilder->update(Array)
#9 /var/www/vhosts/infosecforge.io/discuss.infosecforge.io/vendor/fof/best-answer/migrations/2019_11_04_000003_migrate_extension_settings.php(32): Illuminate\Database\Eloquent\Builder->update(Array)
...

Bishwas-py

datitisev Only admins are allowed to select Best Answer. Those users who asked the questions aren't allowed to select Best Answers. I have given the screenshot of my settings there. Have a look.

datitisev

[deleted] Ah, I thought it'd check for the permissions. I'll fix it now.

When you say "uninstall", is that clicking the "uninstall" button in the extensions page? I hope you know that that rolls back the extension's migrations - removing the extension's data in the DB.

datitisev

0.1.2

Fix issue with duplicate permissions in DB when migration
- should fix [deleted]

Updating

composer require fof/best-answer

[deleted]

datitisev When you say "uninstall", is that clicking the "uninstall" button in the extensions page? I hope you know that that rolls back all migrations - removing the extension's data in the DB.

Yes - nothing worth keeping at present.

luceos

datitisev should fix mcutting

You go fix him 😅

[deleted]

luceos works great. I'll consider myself "fixed"...

[deleted]

Thanks @datitisev 😃

datitisev

0.1.4

0.1.3 Remove CSS rule that causes issues with reflar/level-ranks
Fix issues with IE in admin area

Updating

composer require fof/best-answer

therealsujitk

Is it possible to somehow link a tag to discussions marked answered? I would like to have a Solved/Answered tag having all the answered discussions.

luceos

therealsujitk not easily with the current code; we could dispatch an Event so that you can listen to that and do some logic for your Flarum specifically.

therealsujitk

When this extension is used with dark mode, the font colour inside the best answer block is still black. This needs to be fixed.

Wadera

Clicking into Remove the current best answer works only till page refresh. Looks like action isn't push to database and it's displayed only on web browser 🙁

I can mark best answer on different post, but I can't remove best answer

danielunited

Wadera I noticed a while back that I couldn't remove best answer if another user replied to it.

Wadera

danielunited I've tried to trick the system and mark last message on discussion as the best one and then try to remove it, but without luck 🙁

datitisev

Wadera Which version are you on? I think that's one of the issues I fixed when bringing best answer into

Wadera

datitisev https://discuss.flarum.org/d/22643-admin-password-stop-working-after-logou/3
| wiwatsrt-best-answer | v0.2.4 | |

datitisev

Wadera That's not the FriendsOfFlarum version, which this thread is for. Please install the fof version using the commands in the first post of the discussion. Your issue should be fixed then.

Wadera

datitisev thank you for pointing out. I will replace it for the only proper one 😉
FoF plugins are great! Thank you very much for hard work! Few coffees on the way from me!