FriendsOfFlarum Gamification

brian85

Kyrne Yes a setting would be ideal. 👍
[update]
Could I simply add a condition in SaveVotesToDatabase line 105 in order to check that the user id is not the id of the current user ? => https://github.com/FriendsOfFlarum/gamification/blob/3656f5c7bd0ad624ecbcea036f61c8ea93659332/src/Listeners/SaveVotesToDatabase.php#L105

OK I ask you for a quick fix, is this ok for you in SaveVotesToDatabase
public function vote($post, $isDownvoted, $isUpvoted, $actor, $user) { if($user->id !== $actor->id){
I save only if the user id don't equal the actor id

Thanks for your help.

brian85

brian85 hello my quick workaround seems to work 👍

Aleram

[deleted] Just added

[deleted]

Aleram That's odd. The same CSS works for me

StephanMhl

Im getting

Next Doctrine\DBAL\Driver\PDOException: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'last_vote_time' in /www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:119

if i want to active the extension. Do i need to delete this column manually?

[deleted]

StephanMhl Yes, you'll need to manually drop it - did you have the extension installed before ?

StephanMhl

[deleted] not that I'd remember it.

StephanMhl

activation works now. But i cannot convert my old likes
[2019-10-10 15:32:12] production.ERROR: Error: Call to a member function increment() on null in /www/html/vendor/fof/gamification/src/Gamification.php:123

[deleted]

StephanMhl Hmmm... Which version of MariaDB are you using ? (or perhaps MySQL)

[deleted]

StephanMhl Did you also run php flarum migrate from the SSH console ?

StephanMhl

im using a docker container from
https://github.com/tiredofit/docker-flarum
with mariaDB 10.3.9

i now look for a way to call flarum migrate 🙂

[deleted]

StephanMhl DB version should be ok

StephanMhl

[deleted]
Ok did the migration. but nothing changed.
It still tells me "Your likes are now being converted." Even after rebbot the whole flarum container

[deleted]

StephanMhl Yes, I had this also. Do you have the likes extension installed also ? If so, disable it

StephanMhl

ive disabled it before installing this extension. its still disabled

StephanMhl

Is there a way to start the convertion again?

datitisev

StephanMhl Try deleting the fof-gamification.convertedLikes key from the settings table in the DB.

StephanMhl

Thanks.
But still get the error, directly after starting the convertion :
production.ERROR: Error: Call to a member function increment() on null in /www/html/vendor/fof/gamification/src/Gamification.php:123

datitisev

StephanMhl That error seems to be because a post doesn't have an existing discussion... not sure why that would be, but a check could be added before increasing the votes.

StephanMhl

Is there any way to find this lonely post, to solve my problem?
Edit. i looked in to the database and every post has an discussion ID

datitisev

StephanMhl Looks to be from discussions that you've deleted permanently. I was trying to fix a bug with flags a few minutes ago, and saw that posts remain existing even after their discussion is permanently deleted.

There's definitely a query you can run to delete posts that don't have a discussion (see here) but I'm not good with SQL, so can't really help much there, sorry.

« Previous Page Next Page »