Phpbb forum MySql collation error HELP!

So heres the deal...I've been spending a whole bunch of money on getting this forum up and running and now i really don't want to have to spend more, but unfortunately i'm having some issues with one of my users and he can't just change his name. I need his name to be the same, even if I have to delete it out and recreate it. I'm getting an error that I need fixed, the problem is when i try to go in to delete his name or figure out whats going on in the ACP of my phpbb board, i get the following error when trying to pull up his name.

General Error

SQL ERROR [ mysql4 ]

Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' [1267]


SELECT user_id FROM phpbb_users WHERE username_clean = '*the users name here*'


FILE: includes/db/[url removed, login to view]

LINE: 158

CALL: dbal->sql_error()

FILE: includes/acp/[url removed, login to view]

LINE: 92

CALL: dbal_mysql->sql_query()

FILE: includes/[url removed, login to view]

LINE: 471

CALL: acp_users->main()

FILE: adm/[url removed, login to view]

LINE: 74

CALL: p_master->load_active()

If you can fix this problem for me so his username will work or i can delete and recreate it. Please bid. I would prefer to just have his name working again, but will take what i can get.

Skills: PHP

See more: phpbb mysql collation, mysql collation phpbb, phpbb collation, mysql collation implicit, backtrace phpbb, phpbb change collation, change collation database mysql phpbb3, phpbb3 mysql collate, phpbb2 database collation, 1267 collation error, collation phpbb2 phpbb3, phphbb change collation, database collation phpbb, phbb database collation, phpbb illegal mix collations operation, custom collation mysql, phpbb3 mysql recommended collation, collation error phpbb, phpbb3 database collation, illegal mix collations phpbb3, collation phpbb2, illegal mix collations latin1_binimplicit utf8_general_cicoercible operation, phpbb collations, mysql error collate implicit, phpbb 1267

About the Employer:
( 9 reviews ) Middletown, United States

Project ID: #240408

Awarded to:


Lets get started

$30 USD in 0 days
(105 Reviews)