Kylo Thank you for your detailed reply. And yes, I got the error Migration file should contain an array with up/down. while rolling back the migrations with php flarum migrate:reset --extension the-turk-stickiest command.

Your solution really help to solve this problem, many thanks for your help.

Thanks for the update!
I will check all that as soon as it's updated on freeflarum.

Kylo

TB54 It works when you're online, but not when you're offline (in that case, they all appear at the top):

If I understand you correctly; that's not an issue, it's a default sticky behaviour of Flarum. When you switch to the "All Sticky" mode, it'll act like you're using the bundled flarum/sticky extension.

Mmm ok, but in that case, an option to be able to avoid that (to make it behave offline the same way it does online) would be cool, of it's not too difficult to code. Because otherwise, it recreates the very same problem for what we use "stickiest": it puts a dozen of sticky threads on top of the homepage, which is problematic.

  • Kylo replied to this.

    TB54 with the latest version, if you tag stick them they won't make it to the top in the "All Discussions" list.

    • TB54 replied to this.

      Kylo with the latest version, if you tag stick them they won't make it to the top in the "All Discussions" list.

      You mean even when offline?

      • Kylo replied to this.

        Kylo It's updated in freeflarum and it works great, much more easy to configure and use with this little menu, congrats!

        For future updates, I wonder if this behavior (= a sticky-tag thread works like any other thread in the all discussion tab) should not be also the behavior of the sticky-tag threads have when they appear in their parent tag.

        For instance:

        • Let's say I have a "ARTS" tag, and inside it I have sub-tags for each art ("PAINTING", "MOVIES", "LITERATURE", etc.).
        • I put a sticky-tag thread in the "LITERATURE" tag only (for instance: "where to find books online").
        • With the recent update, I can then check the "LITERATURE" box only (the thread will appear first in the "LITERATURE" tag, hidden in "ARTS" tag", and working like any other thread in "ALL DISCUSSION" tab)
        • Or i can check the two boxes (it will then appear first in the "LITERATURE" tag, first in the "ARTS" tag", and working like any other thread in "ALL DISCUSSION" tab).

        Maybe it would be more logical than, in the parent tag (here the "ART" tag), the thread would also appear, but working like any other thread (like it does currently in "ALL DISCUSSION" tab). The result will be, when checking only the "LITERATURE" box : the thread appears first in the "LITERATURE" tag, works like any other thread in the "ARTS" tag", and works like any other thread in "ALL DISCUSSION" tab).

        It's more a question than a suggestion, because I'm not sure what option in the best.

          I'm having a problem when I try to enable the extension it turns on and off and wont stay activated.

          • Kylo replied to this.

            TB54 summing up -- you're suggesting that secondary tag stickies should also be listed in primary tags as "regular discussions". Well this can be arranged, I might add this feature on 3.0.1 👌 But I need to think about how should I implement this though, feels like maintaining this extension getting complicated on every other release 💁

            typ1k it's probably the foreign key issue.

            Kylo check if the engine for the tags table is InnoDB or not. If not, try switching that to the InnoDB then run and try activating again:

            -- make sure you have that db backup.

            DELETE FROM `migrations` WHERE `migration` = '2021_07_04_000003_set_default_settings' AND `extension` = 'the-turk-stickiest';
            php flarum migrate:reset --extension the-turk-stickiest
            DROP TABLE `discussion_sticky_tag`;
            php flarum migrate

              Kylo you're suggesting that secondary tag stickies should also be listed in primary tags as "regular discussions". Well this can be arranged, I might add this feature on 3.0.1

              this would be great! Now it is not shown on "all discussions" if there is a new post.
              Thx for the last update with this nice menu! makes it even more simple 🙂

              • Kylo replied to this.

                tom23 Now it is not shown on "all discussions" if there is a new post.

                You should be able to see them (but they won't act like a sticky) if you checked that "show tag stickies in all discussions" option from the settings?

                  5 days later

                  Bug?
                  If i change the tag of a stickiest post it does not appear anymore.

                  • Kylo replied to this.

                    Yolo is it a sticky or a tag sticky discussion? I mean, are you changing the tags of a tag stickied discussion or changing the tags of a stickied discussion? If it is a tag sticky, are you changing the discussion's tags or its tag sticky tags? Could you provide steps to reproduce?

                    Yolo okay I just saw that

                    3.0.1

                    • Fix tag stickied discussions goes missing when you change their tags.

                    Possibility of sticking for a period? Eg ;
                    Stick for 24 hours, 7days, 30 days etc?

                    • Kylo replied to this.
                      6 days later

                      Kylo
                      One may want to stick threads for a certain period, eg during popular events.

                      2 months later

                      @'Kylo', thanks for the extension!

                      Can you tell me a way to display a supersticky discussion excerpt via li class='item-excerpt'?

                      5 months later

                      It's this extension which is used on flarum.org ? Because I don't see readed sticky post topic on the main page.