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.
tolgaaaltas eklentinin içinde locale
klasörünün altına tr.yml
olarak eklediğim dosya eklentiyi çevirmedi. Bu konuda bir değişiklik mi yapıldı, bilginiz var mı? Bir de bu sürümde flarum/sticky
eklentisinin dil anahtarlarına atıfta bulunmuştum, umarım birbirlerine girip İngilizce’de kalmazlar.