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.
