• [deleted]

  • Post #4

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

    [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]

        • Post #7

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

            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

            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 ?

                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

                    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 ?

                        5 days later

                        Does this plug-in support voting posts with pictures?

                          5 days later

                          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.