Kylo sweet, thank you for this, glad to see you around again 🙂

    I updated from beta version to current version flarum/sticky plugin is active but stickiest is not active

    • Kylo replied to this.

      [2021-07-04 19:20:05] flarum.ERROR: PDOException: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'is_stickiest' in /mydomain/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:112

      • Kylo replied to this.

        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