xxwn mysql 5.7.32 can't use it. how can solve it ?

Why's that, because of the default values for blob/text? Can you provide more context.

    askvortsov For me the number of likes received is the best metric. Since this metric isn't available, number of posts and number of discussions started are also good.

      For me the top two would be

      1. Likes received
      2. Posts read

      But I like the other ones as well, I think the part about a data collection extension is also extremely interesting because other extensions could feed from it as well.

      askvortsov

      POST https://bbs.stkey.top/api/extensions/askvortsov-trust-levels

PDOException: SQLSTATE[42000]: Syntax error or access violation: 1101 BLOB, TEXT, GEOMETRY or JSON column 'ranges' can't have a default value in

      i meet some problems when i installed this extension. Can you help me? Thanks !

        ctml askvortsov What version of mysql are you using?

        darkfox I am use MariaDB 10.1.47

        https://mariadb.com/kb/en/text/

        Before MariaDB 10.2.1, BLOB and TEXT columns could not be assigned a DEFAULT value. This restriction was lifted in MariaDB 10.2.1.

        Upgrade to 10.2.1 or higher and it should work.

        What version of mysql/mariadb are you using? Looks like you'll probably need to upgrade.

        • ink replied to this.

            v0.1.2

            • Added a "likes received" criterion
            • Fixed all the default text issues, @ink you should be able to install now

            =================================================================================

            Alshain The member was formerly the moderator. When he meets the conditions during the transition to the new system, shouldn't his old status be deleted and only switch to the new status?

            Trust levels are quite flexible in that a user will be added to groups for all trust levels they are currently in. That being said, it won't remove them from groups they were added to directly by a moderator.

                askvortsov I think you didnt put it on github, can't update from v0.1.1 😉

                  Errors on edit user when Trust Levels enabled.

                  I Disabled the extension because of this errors.

                  4 days later

                  Another metric to possibly consider, fof/best-answer. How many answers has a user provided that have been marked best answer, more answers = more rep!

                  Though I don't think this extension is currently tracking totals per user. I still wonder if that should be the responsibility of each extension, or as you alluded to perhaps a data gathering extension that supports many extensions (fof based ones to maintain compatibility over versions). It seems to be a mixed bag of extensions that support this type of tracking stuff. Anywho, just some thoughts!

                    • [deleted]

                    • Post #36
                    • Edited

                    ctml this is a fantastic idea and something I'd use on my own forum

                      9 days later

                      I really like the idea of likes received and the best answers metric. I would brainstorm upon new metric ideas however never saw a full list of metrics available. Any ideas where can I find something like this?

                        @aaronlbpeterman Let's move this convo here. That's a bit odd since there's tests in place that should prevent that. Which version of the extension are you using (should be listed in the header), and can you share a screenshot of your config for the trust level in question?

                          askvortsov
                          v0.1.3 so extension is up to date

                          Screenshots:

                          Edit

                          @askvortsov @SKevo
                          Edit: I've tested it on another FF forum, still got the same result (I've got the rank even when out of boundaries). Can someone test and confirm?