sql error
Posted: 13 May 2010, 21:24
when i changing my friend username to ticktock...!
THis sql eror coming
General Error
SQL ERROR [ mysql4 ]
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' [1267]
SQL
SELECT username FROM phpbb_users WHERE username_clean = 'ticktock..ǃ'
BACKTRACE
FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()
FILE: includes/functions_user.php
LINE: 1615
CALL: dbal_mysql->sql_query()
FILE:
LINE:
CALL: validate_username()
FILE: includes/functions_user.php
LINE: 1376
CALL: call_user_func_array()
FILE: includes/acp/acp_users.php
LINE: 796
CALL: validate_data()
FILE: includes/functions_module.php
LINE: 520
CALL: acp_users->main()
FILE: adm/index.php
LINE: 75
CALL: p_master->load_active()
please tell how to solve
THis sql eror coming
General Error
SQL ERROR [ mysql4 ]
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' [1267]
SQL
SELECT username FROM phpbb_users WHERE username_clean = 'ticktock..ǃ'
BACKTRACE
FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()
FILE: includes/functions_user.php
LINE: 1615
CALL: dbal_mysql->sql_query()
FILE:
LINE:
CALL: validate_username()
FILE: includes/functions_user.php
LINE: 1376
CALL: call_user_func_array()
FILE: includes/acp/acp_users.php
LINE: 796
CALL: validate_data()
FILE: includes/functions_module.php
LINE: 520
CALL: acp_users->main()
FILE: adm/index.php
LINE: 75
CALL: p_master->load_active()
please tell how to solve