Kylo
This problem occurs because I am on shared hosting. If I delete the is_stickiest line from the database, the problem seems to be fixed, but before trying it, what is your opinion?

  • Kylo replied to this.

      czayorijinal I think you've skipped the php flarum migrate:reset --extension the-turk-stickiest command.

      czayorijinal This problem occurs because I am on shared hosting.

      yeah, that explains. Run:

      # Drop indexes
ALTER TABLE `discussions` DROP INDEX `discussions_is_stickier_created_at_index`, DROP INDEX `discussions_is_stickiest_created_at_index`, DROP INDEX `discussions_is_tagsticky_created_at_index`, DROP INDEX `discussions_stickiest_last_posted_at`;

# Drop columns
ALTER TABLE `discussions` DROP COLUMN `is_stickier`, DROP COLUMN `is_stickiest`, DROP COLUMN `is_tagSticky`;

# Remove unused permission
DELETE FROM `group_permission` WHERE `permission` = 'discussion.stickiest';

# Remove default setting
DELETE FROM `settings` WHERE `key` = 'the-turk-stickiest.badge_icon';

      then try to activate the extension again.

            #1091 - Can't DROP 'discussions_is_stickier_created_at_index'; check that column/key exists
            What is the reason for such an error?

            Kylo ok i solved the problem, it's not happening because i use fl_ prefix in my tables

              Loving this extension 🙂

              If I had one request it would be to apply a class for SuperSticky and TagSticky to the DiscussionListItem so I can style them differently and make them stand out a little more. Unless of course there is some css wizard here that can style parent based on a child having the badge.

                ctml good idea, done (you can't select parents in CSS btw).

                2.0.2

                • Add Stickiest-stickyItem, Stickiest-tagStickyItem, Stickiest-stickiestItem classes for discussion list items.
                    8 days later

                    I hope that Stickist has more flexible permission configuration (for example, to give a moderator the right to sticky on a certain tag) and make it no longer need to go through the original "Sticky" extension

                      5 days later

                      Silverteal Done.

                      p

                      2.0.3

                      • Separate permissions for tag sticky / stickiest discussions.

                      Don't forget to run php flarum migrate after updating.

                          7 days later

                          Kylo Thanks for this wonderful extension, it works great except tag stickies don't show up in All Discussions even when there's an update with a reply

                              HD3D that's the correct behaviour of this extension. It's stated in usage in first post.

                                a month later

                                How could i miss this extension, is what the community was searching for a long long long time.

                                Thanks for building this! 👍️

                                2 months later
                                5 months later

                                would be great if possible to choose on which tag to stick as "tag stick" and not automatically take the first tag from selection 🙂 is it possible?

                                • TB54 replied to this.
                                  23 days later

                                  Hello, glad to find this extension, which is very helpful !

                                  hereistheme would be great if possible to choose on which tag to stick as "tag stick" and not automatically take the first tag from selection 🙂 is it possible?

                                  ... in fact I came here to ask if this would be possible too. Like many, I use sticky post as a guideline for each sub-tags.

                                  For instance, I'm trying to do a cinema theory forum: I have a main tag "Cinema history", in which I have a sub-tag for each period ("Classical cinema", "Modern cinema"...), and for each of them I have a sticky tag detailing what decades/movement/directors is concerned by it.

                                  But if I click on "cinema history" (the main tag), I therefore have all the 5 sticky of my sub tags displayed together at the top of the list before any discussion, which is problematic.

                                  HD3D Kylo Thanks for this wonderful extension, it works great except tag stickies don't show up in All Discussions even when there's an update with a reply

                                  I would also find that interesting, if it's a possible option to implement. Sometimes, sticky and there rules are a base for discussion.

                                      I've couple of questions for these feature requests:

                                      1. Should tag stickies stick to top in "All Discussions" list when they have unread replies or behave like a regular discussion?

                                      If it's the first one, then you're just looking for "Sticky" discussion (as in bundled extension). If it's the latter, I think I can make this optionable.

                                      1. Do you want to hide secondary tagged stickies from primary tag listings or stick them to top of the primary tag listing when they have unread replies or want them to behave like a regular discussion in the said listing?

                                        Kylo Should tag stickies stick to top in "All Discussions" list when they have unread replies or behave like a regular discussion?

                                        Is it possible if accessing a tag or sub-tag and then "tag stick" a post to show it as sticky on that tag only? No matter if there are more tags selected for that discussion.

                                        As i understand now it sticks on all selected tags for that discussion, right ?

                                        On primary tags tree i have "Cars" and more sub tags like "Cars -> F1" , how do i stick a post for "F1" sub tag only and not showing it sticky on "Cars" tag too ? I think i miss understand how both sticky extensions works.

                                        thanks!

                                        • Kylo replied to this.

                                            hereistheme this brings up the second question

                                            Kylo Do you want to hide secondary tagged stickies from primary tag listings or stick them to top of the primary tag listing when they have unread replies or want them to behave like a regular discussion in the said listing?