Çözüldü Unicode hatası alıyorum

Baronofc · 4 Şub 2024

Merhaba, 1.5 sürümüne ait forumu 2.2.13 sürümüne güncelledik ama şu hatayı alıyoruz.

Foruma dil paketi eklenti vs yüklenirkende veritabanı hatası oluyor. Nasıl çözebiliriz?

eTiKeT™

Screenshot_2024-02-04-01-28-16-263_com.android.chrome.jpg

eTiKeT™ · 4 Şub 2024

Veri tabanınızı karakter setini utf8mb4_general_ci setine convert etmelisiniz.

Kullanım tekniği - XenForo'da EMOJI Desteği (utf8mb4 çevrimi) nasıl ayarlanır?

Xenforo'da XF-2 ile gelen ve XF-2.1 ile gelişen EMOJI sistemini kullanabilmek için veritabanınızın bunu destekliyor olması gerekiyor. Başka bir değişle veritabanınızın "utf8mb4" formatını destekliyor olması gerekiyor. Eğer bunu desteklemiyor...

xenforo.gen.tr

netr0n · 4 Şub 2024

Merhaba, sitenize baktığımda içeride bir çok hata görüyorum. Sanırım daha önce vBulletin yazılımından xenforo yazılımına geçiş yapmışsınız ama konu içlerinde hala kalıntılar var. Bunlarında temizlenmesi lazım.

Aşağıdaki eklenti ile bu kalıntıları temizletebilirsiniz.

XF 2.0 - Post Content Find / Replace 2.0.1

Eğer farklı bir forum yazılımından xenforo yazılımına geçiş yaptıysanız youtube linkleriniz çalışmayacaktır. Konulara tek tek girip düzenleme yapma şansınız var ama eğer binlerce konunuz varsa bu sizin için imkansız olabilir. Bu eklenti sayesinde...

xenforo.gen.tr

vBulletinden xenforo yazılımınına geçtikten sonra, eski linklerinizi yönlendirmediyseniz aşağıdaki konuya bakarak yönlendirebilirsiniz.

ip ucu - vBulletin'den Xenforo'ya Geçişte vbSEO Linklerini Yönlendirme

vBulletin'den Xenforo'ya geçişte eski vbulletin linklerinizi yeni xenforo linklerine yönlendirebilirsiniz. Bunun için gerekli eklenti ve açıklama burada. Default vbulletin linklerini kullandıysanız hiçbir işlem yapmanıza gerek yok eklenti...

xenforo.gen.tr

Gelelim şu anki sorununuza aşağıdaki konuya bakarak işlemlerinizi yapabilirsiniz.

Çözüldü - XF\Db\Exception: MySQL query error [1366]: Incorrect string value: '\xF0\x9F\x98\x8E'

Exception: MySQL query error [1366]: Incorrect string value: 'xF0x9Fx98x89x0A' for column 'phrase_text' at row 1 in src/XF/Db/AbstractStatement.php at line - Hata raporu örneği Bu hatanın olası nedeni; XenForo 2 versiyon ile gelen emoji...

xenforo.gen.tr

Eğer kısa yoldan halletmek isterseniz, sunucu root yetkiniz var ise cmd.php xf:convert-utf8mb4 komutu çalıştırarak hızlıca çözebilirsiniz. Bunu yapmadan önce, config.php dosyamıza aşağıdaki kodu ekleyelim. $config['fullUnicode'] = true;

Yine ek bir çözüm daha vereyim. PhpMyAdmine bağlanın veritabanınızı seçtikten sonra SQL alanından aşağıdaki sorguları çalıştırın. Hepsini aynı anda çalıştırmayın. Tek tek veya 2 -3 sorgu birden çalıştırın. Bunu yapmadan önce mutlaka veritabanı yedeğini alınız.

SQL:

ALTER TABLE xf_addon CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_addon_install_batch CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_admin CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_admin_log CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_admin_navigation CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_admin_permission CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_admin_permission_entry CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_advertising CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_advertising_position CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_api_attachment_key CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_api_key CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_api_key_scope CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_api_scope CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_approval_queue CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_attachment CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_attachment_data CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_attachment_view CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_ban_email CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_bb_code CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_bb_code_media_site CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_bookmark_item CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_bookmark_label CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_bookmark_label_use CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_captcha_log CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_captcha_question CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_category CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_change_log CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_class_extension CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_code_event CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_code_event_listener CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_connected_account_provider CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_content_spam_cache CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_content_type_field CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_conversation_master CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_conversation_message CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_conversation_recipient CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_conversation_user CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_cron_entry CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_css_cache CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_data_registry CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_deletion_log CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_draft CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_editor_dropdown CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_edit_history CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_email_bounce_log CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_email_bounce_soft CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_error_log CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_feed CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_feed_log CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_file_check CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_find_new CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_find_new_default CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_flood_check CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_forum CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_forum_field CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_forum_prefix CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_forum_prompt CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_forum_read CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_forum_watch CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_help_page CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_image_proxy CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_image_proxy_referrer CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_import_log CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_ip CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_ip_match CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_job CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_json_convert_error CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_language CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_link_forum CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_link_proxy CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_link_proxy_referrer CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_login_attempt CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_mail_queue CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_member_stat CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_moderator CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_moderator_content CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_moderator_log CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_navigation CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_navigation_type CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_news_feed CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_node CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_node_type CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_notice CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_notice_dismissed CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_oembed CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_oembed_referrer CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_option CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_option_group CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_option_group_relation CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_page CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_payment_profile CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_payment_provider CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_payment_provider_log CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_permission CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_permission_cache_content CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_permission_combination CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_permission_combination_user_group CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_permission_entry CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_permission_entry_content CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_permission_interface_group CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_phrase CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_phrase_compiled CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_phrase_map CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_poll CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_poll_response CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_poll_vote CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_post CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_profile_post CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_profile_post_comment CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_purchasable CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_purchase_request CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_reaction CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_reaction_content CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_registration_spam_cache CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_report CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_report_comment CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_route CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_route_filter CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_search CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_search_index CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_session CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_session_activity CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_session_admin CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_session_install CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_sitemap CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_smilie CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_smilie_category CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_spam_cleaner_log CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_spam_trigger_log CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_stats_daily CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_style CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_style_property CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_style_property_group CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_style_property_map CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_tag CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_tag_content CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_tag_result_cache CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_template CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_template_history CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_template_map CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_template_modification CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_template_modification_log CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_template_phrase CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_tfa_attempt CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_tfa_provider CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_thread CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_thread_field CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_thread_field_value CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_thread_prefix CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_thread_prefix_group CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_thread_prompt CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_thread_prompt_group CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_thread_read CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_thread_redirect CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_thread_reply_ban CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_thread_user_post CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_thread_view CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_thread_watch CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_tl_user_smilie CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_trophy CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_unfurl_result CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_upgrade_check CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_upgrade_job CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_upgrade_log CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_user CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_user_alert CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_user_alert_optout CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_user_authenticate CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_user_ban CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_user_change_temp CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_user_confirmation CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_user_connected_account CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_user_field CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_user_field_value CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_user_follow CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_user_group CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_user_group_change CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_user_group_promotion CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_user_group_promotion_log CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_user_group_relation CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_user_ignored CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_user_option CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_user_privacy CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_user_profile CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_user_push_optout CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_user_push_subscription CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_user_reject CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_user_remember CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_user_tfa CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_user_tfa_trusted CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_user_title_ladder CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_user_trophy CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_user_upgrade CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_user_upgrade_active CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_user_upgrade_expired CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_warning CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_warning_action CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_warning_action_trigger CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_warning_definition CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_widget CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_widget_definition CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;
ALTER TABLE xf_widget_position CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_general_ci;

Baronofc · 6 Şub 2024

Dediklerinizi uyguladık hocam.
Şimdide kullanıcı stili değişmek istediğimizde bu sorun çıkıyor.

Sizin harici bağlantı yönlendirme eklentisinin arka planını değiştirmek istediğimde de aynı hata var.

eTiKeT™

netr0n

Screenshot_2024-02-06-12-42-43-233_com.android.chrome.jpg

Apyazılım · 6 Şub 2024

Baronofc' Alıntı:
Dediklerinizi uyguladık hocam.
Şimdide kullanıcı stili değişmek istediğimizde bu sorun çıkıyor.

Sizin harici bağlantı yönlendirme eklentisinin arka planını değiştirmek istediğimde de aynı hata var.

eTiKeT™ netr0n

Ekli dosyayı görüntüle 25214

Mod_Security kapat hocam sorun çözülür

Ara

Ara

Foruma hoş geldin 👋, Ziyaretçi

Çözüldü Unicode hatası alıyorum

Baronofc

Sabit kullanıcı