sql error

Support for PhpBB3. Post here to get help with any phpBB3 related issue here
There is no support here! Only Read Access!
Forum rules
In order the get any support, you will have to do following:
1. Use a describing title!
2. Describe your problem and what happened when the problem occured
3. Tell us what version of phpBB3 you are currently using.
Else your topic may be ignored or locked!
Locked
eVoLuTiOnBOyz
BBCoder II
BBCoder II
Posts: 42
Joined: 02 Apr 2010, 14:54

sql error

Post by eVoLuTiOnBOyz »

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
cisco007
BBCoder VI
BBCoder VI
Posts: 1015
Joined: 16 Mar 2010, 18:14
Location: Don't really know!

Re: sql error

Post by cisco007 »

Locked