FriendsOfFlarum Gamification

[deleted]

Seem to have an error when performing php flarum migrate on one of my forums

In Connection.php line 664:

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (guruwall_discuss.#sql-1b37f_2171b, CONSTRAINTpost_votes_post_id_foreignFOREIGN KEY (post_id) REFERENCESposts(id) ON DELETE CASCADE) (SQL: alter tablepost_votesadd constraintpost_votes_post_id_foreignforeign key (post_id) referencesposts(id) on delete cascade)

In PDOStatement.php line 119:

In PDOStatement.php line 117:

Any ideas ?

Thanks

[deleted]

[deleted] any update ?

Thanks

iPurpl3x

I am making a fork of this extension because our client wants both features of fof/gamification and reflar/level-ranks.

I don't know if this would make sense to merge into the main repo...

Now I was wondering if the latest version of fof/gamification is theoretically compatible with Flarum beta 8.1 or not. The composer.json specifies that it is only compatible with beta 9 but after I changed it to beta 8.1 there apparently is no real proble. We are still using beta 8.1 because there is an issue in beta 9 that is critical for our client.

datitisev

iPurpl3x Are you asking if changing flarum/core version requirement would make sense to merge into the main repo ? If so, that can be changed.

iPurpl3x

datitisev No, I'm asking if merging fof/gamification and reflar/level-rank would make sense.

datitisev

iPurpl3x Not sure what you mean here, as Gamification and Level Rank aren't related. Do you mean a progress bar like reflar/level-rank that uses the user's ranks?

Ralkage

datitisev what I think @iPurpl3x means is that he believes they should be merged into one extension because "levelling" is considered a form of "gamification" in theory. Overall, there are a lot of neat features that could be added to this extension but it would take a tremendous amount of time and effort to implement various activities centred around gamification. But to answer your question, I believe what you just said is what he actually means,

But you and I both already agreed that Level Ranks needed a rewrite anyway, so much to be done with so little time 😪

iPurpl3x

datitisev Well that and ranking based on levels instead of points, or both : make it configurable. And for the users "points", take into account the comment_count and the post_count because. The formula that would weight the different types of activities should also be configurable if possible.
Ralkage That right, and I just think that it would make sense to abandon level-ranks and integrate its feature to gamification. But as you said that's a lot of work...

[deleted]

Can we add a feature where it would be possible to not show the current level for a particular user ? I have a bot user that posts via the API, and shouldn't have a rank displayed.

Thanks

robinodds

Veriael When enabling:
Failed to load resource: the server responded with a status of 500 (Internal Server Error)

I tested on clear installation as well.

I got the same error.
Oops! Something went wrong. Please reload the page and try again. when enabling the extension.
How can I solve it?

Ralkage

robinodds we need to know more info about your setup in order to help you troubleshoot any issues you are experiencing.

Please run php flarum info in the root directory of your Flarum installation and post the output here.

robinodds

Ralkage At the moment I have 3.1.2 reflar gamification version installed, on Flarum 8.2.
Yesterday I upgraded to Flarum beta 9 and got the Oops! error trying to activate the FoF extension. Then I ripristinate beta 8.2 with a backup.

Is it possible to update to the new FoF version, maintaining my current votes and ranks?

About php flarum info I can run it on my current beta 8.2 forum, but it says:

Parse error: syntax error, unexpected '?', expecting variable (T_VARIABLE) in .../vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php on line 24

public function __construct($dsn, $user = null, $password = null, ?array $options = null)

Ralkage

robinodds curious to know what PHP version you are running on your server? Do note that as of Beta 8 Flarum requires PHP 7.1+ 👀

datitisev

robinodds darkfox This issue is not caused by Gamification. Looks to be syntax in one of the DB packages that Flarum uses. Maybe try reinstalling dependencies ? (won't remove data in db)

robinodds Is it possible to update to the new FoF version, maintaining my current votes and ranks?

Yes

robinodds

Ralkage 7.1

darkfox

I see that I am not the only one, the extension does not work for me either. I have the other level extension installed, I'm not sure if it causes conflict. I am using php 7.3

robinodds

datitisev Maybe try reinstalling dependencies ?

How can I try this?

darkfox

datitisev I reinstalled some days ago but the Gamification Extension not work correctly.

Error in js on load profile:

AddAttributes.js:31 Uncaught TypeError: Cannot read property 'children' of null
    at o (AddAttributes.js:31)
    at AddAttributes.js:37
    at Array.forEach (<anonymous>)
    at o (AddAttributes.js:36)
    at AddAttributes.js:37
    at Array.forEach (<anonymous>)
    at o (AddAttributes.js:36)
    at AddAttributes.js:37
    at Array.forEach (<anonymous>)
    at o (AddAttributes.js:36)

luceos

Your php version on the server is lower than php 7.1.

Line 24 of PDOConnection:

public function __construct($dsn, $user = null, $password = null, ?array $options = null)

Related code ?array $options = null. Nullable method argument type hinting is available since php 7.1.

robinodds

luceos How can I check it? On my hosting (siteground) it turns out to be php 7.1 version

Ralkage

robinodds ask your hosting provider, sometimes they allow for per directly PHP version usage and the default could actually be set to version lower than 7.1 (Hostgator had this weird option for a long time).

datitisev

darkfox That looks like a legit error. Could you open an issue on GitHub @ https://github.com/FriendsOfFlarum/gamification/issues? Thanks.

« Previous Page Next Page »