Süper Sabit
- Düzenlendi
Hocam paylaşımlı hostinge aktardığım için dediğiniz komutu çalıştırma şansım yok ancak eklentiyi kapattığımda sorun düzeliyor logs kaydını göndermeyi deneyeceğin biraz bekler misiniz
Next Illuminate\Database\QueryException: SQLSTATE[42000]: Syntax error or access violation: 1235 This version of MySQL doesn’t yet support ‘nesting of unions at the right-hand side’ (SQL: (select fl_discussions
.* from fl_discussions
where (fl_discussions
.id
not in (select discussion_id
from fl_discussion_tag
where tag_id
not in (select fl_tags
.id
from fl_tags
where (fl_tags
.id
in (select fl_perm_tags
.id
from fl_tags
as fl_perm_tags
) and (fl_tags
.parent_id
in (select fl_perm_tags
.id
from fl_tags
as fl_perm_tags
) or fl_tags
.parent_id
is null))))) and (fl_discussions
.is_private
= 0 or (((fl_discussions
.is_approved
= 0)))) and fl_discussions
.id
not in (select discussion_id
from fl_discussion_tag
where 0 = 1) and is_tagSticky
= 0 and not exists (select 1 from fl_discussion_user
where fl_discussions
.id
= discussion_id
and user_id
= 1 and subscription
= ignore) order by last_posted_at
desc limit 21) union (select fl_discussions
.* from fl_discussions
where (fl_discussions
.id
not in (select discussion_id
from fl_discussion_tag
where tag_id
not in (select fl_tags
.id
from fl_tags
where (fl_tags
.id
in (select fl_perm_tags
.id
from fl_tags
as fl_perm_tags
) and (fl_tags
.parent_id
in (select fl_perm_tags
.id
from fl_tags
as fl_perm_tags
) or fl_tags
.parent_id
is null))))) and (fl_discussions
.is_private
= 0 or (((fl_discussions
.is_approved
= 0)))) and fl_discussions
.id
not in (select discussion_id
from fl_discussion_tag
where 0 = 1) and is_tagSticky
= 0 and is_stickier
= 1 limit 21) union ((select fl_discussions
.* from fl_discussions
where (fl_discussions
.id
not in (select discussion_id
from fl_discussion_tag
where tag_id
not in (select fl_tags
.id
from fl_tags
where (fl_tags
.id
in (select fl_perm_tags
.id
from fl_tags
as fl_perm_tags
) and (fl_tags
.parent_id
in (select fl_perm_tags
.id
from fl_tags
as fl_perm_tags
) or fl_tags
.parent_id
is null))))) and (fl_discussions
.is_private
= 0 or (((fl_discussions
.is_approved
= 0)))) and fl_discussions
.id
not in (select discussion_id
from fl_discussion_tag
where 0 = 1) and is_tagSticky
= 0 and is_stickiest
= 1 limit 21) union (select fl_discussions
.* from fl_discussions
where (fl_discussions
.id
not in (select discussion_id
from fl_discussion_tag
where tag_id
not in (select fl_tags
.id
from fl_tags
where (fl_tags
.id
in (select fl_perm_tags
.id
from fl_tags
as fl_perm_tags
) and (fl_tags
.parent_id
in (select fl_perm_tags
.id
from fl_tags
as fl_perm_tags
) or fl_tags
.parent_id
is null))))) and (fl_discussions
.is_private
= 0 or (((fl_discussions
.is_approved
= 0)))) and fl_discussions
.id
not in (select discussion_id
from fl_discussion_tag
where 0 = 1) and is_tagSticky
= 0 and is_stickier
= 1 limit 21))
order by
is_stickiest
desc, is_stickier and not exists
(select 1 from fl_discussion_user
as fl_sticky
where fl_sticky
.discussion_id
= id
and fl_sticky
.user_id
= 1 and fl_sticky
.last_read_post_number
>= last_post_number
) and last_posted_at > 0 desc, last_posted_at
desc limit 21) in /home/czayonli/banasor.web.tr/vendor/illuminate/database/Connection.php:692
Loglarda stickiest ile ilgili tek kısım bu hocam Kylo
2.0.1 (Stabil)
Betadan güncelleyenler için;
php flarum migrate:reset --extension the-turk-stickiest
composer remove the-turk/flarum-stickiest
composer require the-turk/flarum-stickiest:^2.0.1
php flarum cache:clear
Artık flarum/sticky
eklentisine bağımlı çalıştığından güncelleme yapanların arada bir yerde composer require flarum/sticky
komutunun çalıştırılması gerekiyor, yazmayı unutmuşum
php flarum migrate:reset --extension the-turk-stickiest
composer remove the-turk/flarum-stickiest
composer require flarum/sticky
composer require the-turk/flarum-stickiest:^2.0.1
php flarum cache:clear
tolgaaaltas FlarumTR’de eklentiyi kurdum hocam.
tolgaaaltas 1.0.4.0 te kalmışız. Güncelleyeceğim.