FriendsOfFlarum Polls

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.

meihuak

only admin can vote, any other people can not vote, is there someone know what happened?

meihuak

meihuak
Flarum core: 1.8.4
PHP version: 8.1.27
MySQL version: 10.4.31-MariaDB-1:10.4.31+maria_ubu1804-log
Loaded extensions: Core, date, libxml, openssl, pcre, zlib, dom, enchant, FFI, filter, gmp, hash, json, pcntl, Reflection, SPL, session, standard, mysqlnd, PDO, readline, xml, xmlreader, xmlwriter, bcmath, bz2, calendar, ctype, curl, mbstring, fileinfo, ftp, gd, gettext, iconv, igbinary, imap, intl, exif, memcache, memcached, msgpack, mysqli, pdo_mysql, pdo_sqlite, Phar, posix, pspell, realpath_turbo, redis, shmop, SimpleXML, soap, sockets, sodium, sqlite3, swoole, sysvmsg, sysvsem, sysvshm, tidy, timezonedb, tokenizer, xmlrpc, xsl, zip, Zend OPcache
+--------------------------------+---------+--------+
| Flarum Extensions | | |
+--------------------------------+---------+--------+
| ID | Version | Commit |
+--------------------------------+---------+--------+
| flarum-flags | v1.8.0 | |
| flarum-suspend | v1.8.1 | |
| flarum-tags | v1.8.0 | |
| flarum-approval | v1.8.0 | |
| flarum-likes | v1.8.0 | |
| afrux-forum-widgets-core | v0.1.7 | |
| fof-user-directory | 1.3.2 | |
| fof-upload | 1.5.2 | |
| fof-sitemap | 2.2.0 | |
| fof-share-social | 1.1.2 | |
| fof-polls | 2.1.2 | |
| fof-links | 1.2.0 | |
| fof-disposable-emails | 1.0.0 | |
| fof-byobu | 1.3.5 | |
| flarum-subscriptions | v1.8.0 | |
| flarum-sticky | v1.8.0 | |
| flarum-statistics | v1.8.0 | |
| flarum-mentions | v1.8.2 | |
| flarum-markdown | v1.8.0 | |
| flarum-lock | v1.8.0 | |
| flarum-lang-english | v1.8.0 | |
| flarum-lang-chinese-simplified | v1.3.0 | |
| flarum-emoji | v1.8.0 | |
| flarum-bbcode | v1.8.0 | |
| datlechin-bbcode-hide-content | v0.1.5 | |
| clarkwinkelmann-mailing | 1.1.0 | |
| askvortsov-moderator-warnings | v0.6.3 | |
| antoinefr-money | v1.3.1 | |
| afrux-news-widget | v0.1.1 | |
+--------------------------------+---------+--------+
Base URL: https://veryfb.com

meihuak

I found that there is no Vote button..

meihuak

when I choose this "Allow people to vote for multiple options", the extension does not work.

if I close this, I can vote

meihuak

anyone can help me? 😭

« Previous Page Next Page »