Açıklama:
ACP Announcement Centre isimli MOD'da Türkçe Karakter içeren Duyurular gönderilmeye çalışıldığında alınan Incorrect string value: hatasının çözümüdür.
Hata Önizlemesi:
-----
Aşağıdaki SQL sorgularını sırayla sorgulatınız. Tümüyle sorgulatmanız durumunda hata alabilirsiniz.
1)
2)
3)
4)
5)
6)
7)
8)
9)
10)
11)
12)
ACP Announcement Centre isimli MOD'da Türkçe Karakter içeren Duyurular gönderilmeye çalışıldığında alınan Incorrect string value: hatasının çözümüdür.
Hata Önizlemesi:
Kod:
Genel Hata
SQL ERROR [ mysql4 ]
Incorrect string value: '\xC4\xB0 Pan...' for column 'announcement_text' at row 1 [1366]
SQL
UPDATE phpbb_announcement_centre SET announcement_enable_guests = 1, announcement_show = 0, announcement_show_birthdays = 0, announcement_birthday_avatar = 0, announcement_title = 'Site Duyurulari', announcement_text = '[size=150:1w848f0c][color=#00BF00:1w848f0c]Metin2-RoCKSTaR DUYURU MERKEZİ Panelimiz kurulmuştur.[/color:1w848f0c][/size:1w848f0c]', announcement_text_bbcode_uid = '1w848f0c', announcement_text_bbcode_bitfield = 'Rg==', announcement_text_bbcode_options = 7, announcement_draft = '[size=150:18qpzq7d][color=#00BF00:18qpzq7d]Metin2-RoCKSTaR DUYURU MERKEZİ Panelimiz kurulmuştur.[/color:18qpzq7d][/size:18qpzq7d]', announcement_draft_bbcode_uid = '18qpzq7d', announcement_draft_bbcode_bitfield = 'Rg==', announcement_draft_bbcode_options = 7, announcement_title_guests = 'Ziyaretçi Duyurulari', announcement_text_guests = '[color=green:je350ztt][b:je350ztt]Guest Announcements[/b:je350ztt][/color:je350ztt] can be seen here!! <!-- s:wink: --><img src=\"{SMILIES_PATH}/icon_e_wink.gif\" alt=\":wink:\" title=\"Göz Kırpıyor\" /><!-- s:wink: -->', announcement_text_guests_bbcode_uid = 'je350ztt', announcement_text_guests_bbcode_bitfield = 'Qg==', announcement_text_guests_bbcode_options = 7, announcement_show_group = '9,7,8,5,4,2'
BACKTRACE
FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()
FILE: includes/acp/acp_announcements_centre.php
LINE: 99
CALL: dbal_mysql->sql_query()
FILE: includes/functions_module.php
LINE: 471
CALL: acp_announcements_centre->main()
FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()
-----
Aşağıdaki SQL sorgularını sırayla sorgulatınız. Tümüyle sorgulatmanız durumunda hata alabilirsiniz.
1)
Kod:
ALTER TABLE `phpbb_announcement_centre` CHANGE `announcement_draft` `announcement_draft` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL
2)
Kod:
ALTER TABLE `phpbb_announcement_centre` CHANGE `announcement_draft_bbcode_uid` `announcement_draft_bbcode_uid` VARCHAR( 8 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL
3)
Kod:
ALTER TABLE `phpbb_announcement_centre` CHANGE `announcement_draft_bbcode_bitfield` `announcement_draft_bbcode_bitfield` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL
4)
Kod:
ALTER TABLE `phpbb_announcement_centre` CHANGE `announcement_text` `announcement_text` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL
5)
Kod:
ALTER TABLE `phpbb_announcement_centre` CHANGE `announcement_text_bbcode_uid` `announcement_text_bbcode_uid` VARCHAR( 8 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL
6)
Kod:
ALTER TABLE `phpbb_announcement_centre` CHANGE `announcement_text_bbcode_bitfield` `announcement_text_bbcode_bitfield` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL
7)
Kod:
ALTER TABLE `phpbb_announcement_centre` CHANGE `announcement_text_guests` `announcement_text_guests` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL
8)
Kod:
ALTER TABLE `phpbb_announcement_centre` CHANGE `announcement_text_guests_bbcode_uid` `announcement_text_guests_bbcode_uid` VARCHAR( 8 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '0'
9)
Kod:
ALTER TABLE `phpbb_announcement_centre` CHANGE `announcement_text_guests_bbcode_bitfield` `announcement_text_guests_bbcode_bitfield` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '0'
10)
Kod:
ALTER TABLE `phpbb_announcement_centre` CHANGE `announcement_title` `announcement_title` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL
11)
Kod:
ALTER TABLE `phpbb_announcement_centre` CHANGE `announcement_title_guests` `announcement_title_guests` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL
12)
Kod:
ALTER TABLE `phpbb_announcement_centre` CHANGE `announcement_show_group` `announcement_show_group` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL