FriendsOfFlarum Polls

[deleted]

Despite following the steps listed here, I get the below error message in the log

[2019-07-04 12:25:14] production.ERROR: UnexpectedValueException: [fof/polls] Please run the latest migration(s) of reflar/polls before enabling this extension. in /home/inoculrn/discuss.guruwall.com/vendor/fof/polls/src/Migrations/AbstractMigration.php:36

atroxiic

Hello,

I seem to be having a problem with the installation of this polls plugin.

Looking at the logs it appeared that I have to run the latest migration of reflar/polls (similar to [deleted]) to which I did before installing fof/polls. Despite that, I still get the same error. Trying to enable reflar/polls before doing the migrate also appears to not work and throws me database exceptions.

Next Illuminate\Database\QueryException: SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'gxg_poll_votes_user_id_foreign'; check that column/key exists (SQL: alter tablegxg_poll_votesdrop foreign keygxg_poll_votes_user_id_foreign) in /var/www/siteurl/forum/vendor/illuminate/database/Connection.php:664

Any help is appreciated.

Addendum: reflar/polls don't appear to be migrated despite running php flarum migrate.

Migrating Flarum... Nothing to migrate. Migrating extension: flarum-approval Nothing to migrate. Migrating extension: extiverse-bazaar Nothing to migrate. Migrating extension: michaelbelgium-discussion-views Nothing to migrate. Migrating extension: flarum-emoji Nothing to migrate. Migrating extension: fof-byobu Nothing to migrate. Migrating extension: fof-links Nothing to migrate. Migrating extension: fof-reactions Nothing to migrate. Migrating extension: fof-socialprofile Nothing to migrate. Migrating extension: fof-user-directory Nothing to migrate. Migrating extension: flarum-likes Nothing to migrate. Migrating extension: flarum-lock Nothing to migrate. Migrating extension: flarum-mentions Nothing to migrate. Migrating extension: reflar-doorman Nothing to migrate. Migrating extension: reflar-webhooks Nothing to migrate. Migrating extension: flarum-sticky Nothing to migrate. Migrating extension: flarum-subscriptions Nothing to migrate. Migrating extension: flarum-suspend Nothing to migrate. Migrating extension: flarum-tags Nothing to migrate. Migrating extension: flagrow-upload Nothing to migrate. Migrating extension: flarum-flags Nothing to migrate. Publishing assets... DONE.

[deleted]

Ok, fixed the first part, and now have the below

[2019-07-04 12:31:03] production.ERROR: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (inoculrn_phenomlab.#sql-1c30_1621e3, CONSTRAINTpolls_discussion_id_foreignFOREIGN KEY (discussion_id) REFERENCESdiscussions(id) ON DELETE CASCADE) in /home/inoculrn/discuss.guruwall.com/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117

datitisev

[deleted] Does that error occur when trying to enable the extension ? If so, it might be an issue with one of the discussions being deleted that kept the discussion id in the DB 🤔.

[deleted]

datitisev Yes

[deleted]

datitisev Any way around this issue ? I can't enable the extension currently.

datitisev

[deleted] Try updating to 0.1.1

datitisev

0.1.1

Updated migrations to fix issues when migrating from reflar/polls
- Delete polls whose discussions no longer exist
- Set poll user ids to null if the user no longer exists
- Delete poll options whose poll no longer exist
- Delete poll votes whose user or poll no longer exist

Updating

composer update fof/polls

[deleted]

datitisev works 🙂
Thanks

tolgaaaltas

I guess it's not compatible with version 9. I can't vote.

datitisev

tolgaaaltas I think I made a mistake when rewriting this, because right now you can only vote by clicking the checkbox.

Though if that is not what you are talking about, can you elaborate on your issue ?

tolgaaaltas

datitisev It's not the problem for me. When i click checkbox, i got this error message on board: The requested resource could not be found.*
*Translated from Turkish

datitisev

tolgaaaltas Hm, that could be caused by another extension. Do you have flagrow/split installed ? If not, could you post the output of php flarum info ?

tolgaaaltas

datitisev Sure:

datitisev

tolgaaaltas Uninstall flagrow/split and install fof/split.

tolgaaaltas

datitisev Thank you for reply. It's solved. 🙂

NeilM

Does this plug-in support voting posts with pictures?

tolgaaaltas

NeilM No, just words.

NeilM

tolgaaaltas Oh, well, can you choose more than one option?

tolgaaaltas

NeilM sadly, there is no option for that.

NeilM

tolgaaaltas Okay, thank you