Icy Phoenix

     
 

Problem With Character Encoding In Custom Fields

Category: Profile
Version Icy Phoenix 2.0 Beta (PHP 5.x - MySQL 5.x)
Description
m740
Mon 09 Jan, 2012 10:46
By having a custom field in the profile with accents to make an upgrade fails to show the post.

ICY 2.0 Beta 2 upgrade from 1.3.27.80


Code: [Hide] [Select]
SQL ERROR [ mysql4 ]

Invalid utf8 character string: 'versi\xF3n_de_fw' [1300]

SQL

SELECT u.username, u.user_id, u.user_active, u.user_mask, u.user_color, u.user_posts, u.user_from, u.user_from_flag, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_skype, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_rank2, u.user_rank3, u.user_rank4, u.user_rank5, u.user_sig, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, u.user_allow_viewonline, u.user_session_time, u.user_warnings, u.user_level, u.user_birthday, u.user_next_birthday_greeting, u.user_gender, u.user_personal_pics_count, u.user_style, u.user_lang, u.equipo, u.firmware, u.versi�n_de_fw, u.swap, u.disco_duro, u.ct_miserable_user, p.*, t.topic_poster, t.title_compl_infos FROM phpbb_posts p, phpbb_users u, phpbb_topics t WHERE p.topic_id = 14433 AND t.topic_id = p.topic_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15

BACKTRACE

FILE: includes/db/mysql.php
LINE: 295
CALL: sql_db->sql_error()

FILE: viewtopic.php
LINE: 655
CALL: sql_db->sql_query()
Reply
Mighty Gorgon
Sun 13 May, 2012 11:38
You should never use special characters for DB fields!

I will add a conversion for special chars...
Details Assigned To: Mighty Gorgon
Priority: Very Low
Status: Not A Bug
Fixed: Yes
 




 

  cron