Finteger Ratings. A simple ratings system for Flarum.

m4v3rick

Breaks my backend:

Column not found: 1054 Unknown column 'view_count' in 'order clause' (SQL: select * from `discussions` where $
Stack trace:

Flarum info:

Flarum core 1.5.0
PHP version: 8.1.11
MySQL version: 10.3.36-MariaDB-0+deb10u2
Loaded extensions: Core, date, libxml, openssl, pcre, zlib, filter, hash, json, pcntl, Reflection, SPL, session, standard, sodium, mysqlnd, PDO, xml, calendar, ctype, curl, dom, mbstring, FFI, fileinfo, ftp, gd, gettext, iconv, exif, mysqli, pdo_mysql, Phar, posix, readline, shmop, SimpleXML, sockets, sysvmsg, sysvsem, sysvshm, tokenizer, xmlreader, xmlwriter, xsl, zip, Zend OPcache
+----------------------------------------+---------+--------+
| Flarum Extensions | | |
+----------------------------------------+---------+--------+
| ID | Version | Commit |
+----------------------------------------+---------+--------+
| flarum-flags | v1.5.0 | |
| fof-pages | 1.0.4 | |
| flarum-tags | v1.5.0 | |
| flarum-suspend | v1.5.0 | |
| flarum-approval | v1.5.0 | |
| fof-sitemap | 2.0.1 | |
| flarum-markdown | v1.5.0 | |
| afrux-forum-widgets-core | v0.1.7 | |
| fof-spamblock | 1.0.2 | |
| flarum-subscriptions | v1.5.0 | |
| fof-byobu | 1.1.7 | |
| flarum-mentions | v1.5.0 | |
| flarum-likes | v1.5.0 | |
| ziiven-daily-check-in | 0.1.6 | |
| zerosonesfun-bbcode-iframe | 1.0 | |
| webbinaro-calendar | 1.5.1 | |
| therealsujitk-gifs | v4.1.1 | |
| the-turk-flamoji | 1.0.4 | |
| sycho-move-posts | v0.1.7 | |
| nearata-internal-links-noreload | v2.1.3 | |
| justoverclock-welcomebox | 1.3.7 | |
| justoverclock-staff-members-widget | 0.1.3 | |
| justoverclock-random-post | 0.1.3 | |
| justoverclock-popular-tags | 0.1.3 | |
| justoverclock-last-tweet | 0.1.1 | |
| justoverclock-last-post-useravatar | 0.1.8 | |
| justoverclock-guestengagement | 1.0.3 | |
| justoverclock-emoticonpack | 0.1.2 | |
| justoverclock-contactme | 0.2.3 | |
| fof-username-request | 1.0.1 | |
| fof-user-directory | 1.2.3 | |
| fof-upload | 1.2.3 | |
| fof-stopforumspam | 1.2.1 | |
| fof-split | 1.1.0 | |
| fof-share-social | 1.1.0 | |
| fof-pretty-mail | 1.1.1 | |
| fof-nightmode | 1.5.0 | |
| fof-merge-discussions | 1.3.1 | |
| fof-links | 1.1.2 | |
| fof-linguist | 1.0.4 | |
| fof-ignore-users | 1.1.0 | |
| fof-forum-statistics-widget | 1.0.2 | |
| fof-formatting | 1.0.2 | |
| fof-follow-tags | 1.1.6 | |
| fof-drafts | 1.1.2 | |
| fof-disposable-emails | 1.0.0 | |
| fof-discussion-thumbnail | 1.1.0 | |
| fof-default-user-preferences | 1.1.1 | |
| fof-cookie-consent | 1.1.0 | |
| fof-bbcode-details | 1.1.0 | |
| fof-ban-ips | 1.0.2 | |
| fof-analytics | 1.1.0 | |
| flarum-sticky | v1.5.0 | |
| flarum-statistics | v1.5.0 | |
| flarum-lock | v1.5.0 | |
| flarum-lang-german | 1.4.2 | |
| flarum-lang-french | v4.1.0 | |
| flarum-lang-english | v1.5.0 | |
| flarum-emoji | v1.5.0 | |
| flarum-bbcode | v1.5.0 | |
| datlechin-discussion-overview | v0.0.1 | |
| datitisev-maintenance | 1.1.0 | |
| clarkwinkelmann-prominent-post-numbers | 1.0.0 | |
| clarkwinkelmann-composer-page | 1.0.0 | |
| clarkwinkelmann-circle-groups | 1.0.1 | |
| blomstra-usercard-stats | 0.1.2 | |
| askvortsov-moderator-warnings | v0.6.1 | |
| askvortsov-categories | v3.0.6 | |
| antoinefr-money | v1.2.0 | |
| afrux-forum-stats-widget | v0.1.1 | |
| acpl-mobile-tab | 1.1.0 | |
+----------------------------------------+---------+--------+

Sivoph

Bug fix.

-Users without Michael Belgium's Flarum Discussion Views extension have reported an 'unknown column view_count" error. Fixed composer.json to require the third-party extension for install. Sorry for the oversight on my part. 🙂

This should work for you now, @m4v3rick . Requirement has been added to OP.

Updating

composer update  finteger/ratings
php flarum migrate
php flarum cache:clear

m4v3rick

Sivoph This should work for you now, @m4v3rick . Requirement has been added to OP.

Can confirm that an error message is thrown and UI won't break anymore. But why does it need Discussion views. The extension caused some performance issues and activating "Enable footer viewlist" breaks my discussions still.

chinestroza03 it does not load me so that a rating can be made

Same problem here.
Migrate and cache. Still not working. I see the empty line beneath the header.

@Sivoph

See that post:

m4v3rick Just tried it. Still breaks the discussion but not every discussion breaks now. 2 out of 6.
I made a few checks and realized that whenever my other test user has a post inside the discussion, the refresh fails. If i delete the post it works.
Does that help?
Refresh works with the posts of the user if i disable "Enable footer viewlist".

This problem and performance issues is, why I keep it deactivated.

chinestroza03

Hello, I have installed the extension, however, it does not load me so that a rating can be made and when trying to create a discussion or general answer the error "Please enter a valid rating"

Sivoph

chinestroza03

Hello. Did you ensure to run the php flarum migrate and php flarum cache:clear in your terminal? The columns finteger_rating" should appear in Post and Discussion tables in your database. Remember that a discussion tag must already exist and be entered into the console before it will appear in the discussion/post/edit composers.

chinestroza03

Sivoph Hey, thank you very much for your quick response, the columns do exist in the two tables that you indicate. The tag was created before and put in the extension configuration

Sivoph

m4v3rick and chinestroza03

Will churn out a fix for these problems soon and axe the third party dependency. Stay tuned.

chinestroza03

Sivoph I am very awaiting your progress, thank you very much.

Sivoph

Finteger Ratings System Update. v1.16. Bug and request fix.

What's New?

-This new update changes the optional 'top ratings' bar to sort by comment_count, eliminating the need for a third-party extension that was said to be resource-exhaustive as a requirement (based off user feedback).

Bug fixes.

-Php has been amended to clear out a bug where users could not post in other discussions with the extension enabled without receiving a 'Please enter a valid rating' exception. This will now only occur in the tag/slug name specified in admin settings, when no user rating is inputted.....both in discussion composer on IndexPage and in individual posts. So users cannot create a discussion or a post without a rating in the tag specified.

Additionally, you can use Flarum's own built-in tag scoping to allow only admins to post the initial review (discussion)...and users to post subsequent reviews in posts, allowing for more control over content.

Updating

composer update finteger/ratings
php flarum migrate
php flarum cache:clear

Sivoph

Sorry for the delay, @chinestroza03 and @m4v3rick.

Sivoph

Finteger Ratings System Update. v1.18. Bug and request fix.

Proper null checks have been instituted into the javascript so extension does not crash when users go into their profiles and delete a post with a finteger rating, also in the event that finteger ratings posts are moderated and awaiting approval.

@GreXXL @chinestroza03 @m4v3rick. Sorry, all, please update if you haven't to this release.

Updating

composer update finteger/ratings
php flarum migrate
php flarum cache:clear

chinestroza03

Sivoph

Thank you very much for your time in updating the plugin, I tell you that I have applied the update, however it still does not work.

When I create a new discussion if the stars to rate appear, however it does not let me choose or mark a rating, and in the discussion that is already created it does not allow to rate it.

Greetings and again thank you very much for taking the time.

Sivoph

chinestroza03

Hello, @chinestroza03.

My apologies. I have been busy with work but it sounds like I might have to revamp the access policy and permissions. Will try to get this done this week.

Thank you.

jimmybonez

hmm...
removes all discussions from view with error:
flarum.ERROR: Error: Call to a member function contains() on null in vendor/finteger/ratings/src/Extenders/SaveRating.php:50
Stack trace:
tried everything on this thread

jimmybonez

This would be great if guests could rate any thread also imo

MrEugene

Hello,

I'm trying your extension but I've this error

Warning: Attempt to read property "finteger_rating" on array in …flarum/vendor/finteger/ratings/extend.php on line 143

Fatal error: Uncaught Laminas\HttpHandlerRunner\Exception\EmitterException: Output has been emitted previously; cannot emit response…

I've run

php flarum migrate
php flarum cache:clear

So I've watched my database and I have my two columns finteger_rating for discussions and posts table.

I've tried to comment the line (and return true) for test and error disappear (but the extension doesn't work and I cannot rate anyway).

So I'm missing something in the installation but have no clue about "what" 😅 If someone have an idea… thanks!

clarkwinkelmann

MrEugene it might just be a matter of hiding PHP warnings (the recommended choice for production). Check the display_errors directive in php.ini

While it's a good thing to fix them, PHP warnings are a common occurrence in Flarum extensions and Flarum itself, mostly due to the newer PHP versions becoming stricter and stricter. If the warnings don't lead to any logic issue, it's generally very low priority to fix. Just hide them in production and let the developer know about it.

Generally only developers should keep PHP warnings and deprecations visible on their dev setup to identify them as soon as possible. I'm still baffled at how many hosting companies don't apply the recommended production value by default.

Sivoph

Hey, all. Thanks for your patience. It will take some time for the rework and testing. My cat passed away 🙁 so I've been dealing with that. Will get to this soon, though. In the meantime please do not install this extension. Sorry for the inconvenience.

MrEugene

Sivoph Sorry for you. Take care!

Sivoph

Finteger Ratings System Update. v1.19. Multiple Bug Fixes and and UI Refinement.

Live Demo

This latest release eliminates reported bugs where user access is simply denied through error and a contains function, if null, will error out the app. The optional "top-ratings" function will no longer grab empty ratings in error. Front-end ratings display has been refined for a sharper look (in the discussion list view).

Updating

composer update finteger/ratings
php flarum migrate
php flarum cache:clear