FriendsOfFlarum Polls

luceos

datitisev we encountered this issue on Blomstra stack too. Can you perhaps split the migration of dropping the foreign and renaming the column? This is the safer approach when running fault-tolerant migrations, because bundling changes in one migration will cause the install to hang halfway without the ability to rollback or retry.

datitisev

MikeLundahl Based on luceos's recommendation, I'm currently splitting the migrations to see if this resolves some issues. I recommend you hold off until I release this version to allow for less issues in the future & whether it potentially solves your problem.

datitisev

Wlork Yeah, it's hard to make it work for everyone. It was already supposed to be using the secondary color as background for voted options, but some update broke the CSS selector. I just fixed it and tried to introduce options to make it work for more people.

MikeLundahl You can't import 1.4 data into 2.x directly. You'd have to modify the data before importing it to change from discussion_id to post_id.

Was there any more in the error regarding DROP FOREIGN? I feel like there should've been - though if it is what I think it won't be very helpful anyway.

⚠️ NOTE: Read my message datitisev before deciding to continue

You could try the following. However, since this migration was erroring, and I'm not entirely sure why, others after might as well. So again, backup beforehand. This performs the failing migration manually:

Dropping the foreign key yourself (make discussion_id not have a foreign relation)
Renaming discussion_id column to post_id

Adding a row to migrations table:

INSERT INTO
    `migrations` (`migration`, `extension`)
VALUES
    (
        '2023_07_08_000000_rename_polls_discussion_id_column',
        'fof-polls'
    );

Run php flarum migrate to run the remaining migrations

Wlork

datitisev Yeah, it's hard to make it work for everyone. It was already supposed to be using the secondary color as background for voted options, but some update broke the CSS selector. I just fixed it and tried to introduce options to make it work for more people.

Thanks, I'm waiting for the update 🙂

datitisev

Wlork Oh sorry, I don't think I was clear. I meant that update 2.1.1 fixed that not working - I don't have any more changes planned. I don't think primary color would work well for everyone since that might be too much primary.

I did forget to mention - you can change the colors easily with the following CSS:

:root {
    --poll-option-color: <color of bar when user did not vote for it>;
    --poll-option-active-color: <color of bar when user voted for it>;
}

gamehive

I see the option to include an image with the various poll choices, is there a way to include a YouTube video or TikTok video on each poll option? When you paste the TikTok video url or YouTube url it embeds the video so users can vote on videos instead of either text or images?

maxmoon

Is there a way to filter polls in a forum?

I was looking for a way to show all polls in a forum, but had no luck with tags and permissions, so I've started a Feature Request.

Please let me know if there is another way.

Walid

SO I had this problem where I couldn't activate the extensions because the tables existed already. I have imported my old PHPBB forum to Flarum using the Nitro Porter tool, include my old phpbb polls. Then I installed the fof-polls extension and activation would work because of conflicting table names (3 tables)... then to activate fof-polls and get it running with all of my old polls data, I needed to rename the imported tables (so that the ext could activate and create its own tables) and then migrate the data from the old tables to the new one. of course some other issues arose (many non compatible settings, column names etc.) and long story short I created a php script to deal with it all and decided to share it for anyone who might face the same issue : you can find it here https://github.com/WalsGit/phpbb_polls_migration (feel free to adapt it to you situation and settings of course)

yigittyzc

I want non-users to be able to vote. How do I achieve this?

clarkwinkelmann

yigittyzc this paid extension implements the feature https://discuss.flarum.org/d/30857-anonymous-guest-posting

I'm not 100% sure if it still works after all the changes that have been made to Polls in recent releases.

Winckle

In trying to use @Walid 's script I've really busted up my fof/polls installation. Do you have a guide on how to manually purge the polls extension so I can begin again?

Also @Walid you have an error on line 112 of your script. Should that be questionrather questionsas the key for the array?

datitisev

Winckle You could try disabling the extension and clicking the "Purge" (I believe that's what the button is called) button in the extension's settings to clear out the database. Otherwise, deleting the entries in migrations from fof-polls and the polls, poll_answers, and poll_votes tables (if that's what they're called, going off memory here) should do it, I think.

Walid

Winckle Hi, sorry for the late response (somehow don't know why I haven't activated email notifications for when I'm mentioned, now it's active)

I believe that you find a solution to your problem if I understood well the replies & exchanges you had since.

Also Thank you for spotting that error, I corrected it and updated the script. Fortunately, that error doesn't impact the main job of the script.

Winckle

datitisev The purge button isn't working for me. I have tried manually dropping the tables with poll in their names. I wasn't aware of the migrations table, I'll check it out now.

Winckle

datitisev That has worked thank you.

Upon re enabling the extension I don't have any permission options around polls in the permissions section of the admin centre. Meaning only admins can use the poll functionality. Any idea where this is stored so I can take a look and see if the data looks off?

datitisev

Winckle Permissions are stored in group_permissions, but that shouldn't matter. The permission grid should appear in the extension's admin panel regardless of the settings in the DB... Make sure to clear all your cache just in case.

Winckle

Ah somewhere between clearing cache and reinstalling the extension has made them appear.

Thanks so much for all your help.

ycolor

[2024-02-05 06:49:14] flarum.ERROR: PDOException: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'polls' already exists in /usr/share/nginx/html/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117 Stack trace: Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'polls' already exists in /usr/share/nginx/html/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18 Stack trace: Next Illuminate\Database\QueryException: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'polls' already exists (SQL: create tablepolls(idint unsigned not null auto_increment primary key,questionvarchar(255) not null,discussion_idint unsigned not null,user_idint unsigned null,public_polltinyint(1) not null,end_datetimestamp null,created_attimestamp null,updated_attimestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB) in /usr/share/nginx/html/flarum/vendor/illuminate/database/Connection.php:712 Stack trace: [2024-02-05 06:49:16] flarum.ERROR: PDOException: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'polls' already exists in /usr/share/nginx/html/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117 Stack trace: Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'polls' already exists in /usr/share/nginx/html/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18 Stack trace: Next Illuminate\Database\QueryException: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'polls' already exists (SQL: create tablepolls(idint unsigned not null auto_increment primary key,questionvarchar(255) not null,discussion_idint unsigned not null,user_idint unsigned null,public_polltinyint(1) not null,end_datetimestamp null,created_attimestamp null,updated_attimestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB) in /usr/share/nginx/html/flarum/vendor/illuminate/database/Connection.php:712 Stack trace: [2024-02-05 06:49:30] flarum.ERROR: PDOException: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'polls' already exists in /usr/share/nginx/html/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117 Stack trace: Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'polls' already exists in /usr/share/nginx/html/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18 Stack trace: Next Illuminate\Database\QueryException: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'polls' already exists (SQL: create tablepolls(idint unsigned not null auto_increment primary key,questionvarchar(255) not null,discussion_idint unsigned not null,user_idint unsigned null,public_polltinyint(1) not null,end_datetimestamp null,created_attimestamp null,updated_attimestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB) in /usr/share/nginx/html/flarum/vendor/illuminate/database/Connection.php:712 Stack trace:

davetodave178

ycolor Have you tried to purge the extension? See https://docs.flarum.org/extensions/#through-the-command-line-2 for more context about this.

ycolor

davetodave178 After thinking about all the ways, deleting the database or reinstalling it is the best way.

Nodeloc

Currently, when opening the homepage topic list, all topics from the Discussions table are queried to display badges, resulting in a circular query and inefficiency. May you add a field in the Discussion table called "is_poll" and update this field when saving a topic to determine if it is a poll post. This would significantly improve efficiency. Thank you.

« Previous Page Next Page »