sql error USER

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Suggested Hosts
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
RoCkFoRdGuN
Registered User
Posts: 33
Joined: Mon Feb 05, 2007 5:28 am

sql error USER

Post by RoCkFoRdGuN »

Hi there one of my users are getting a sql error when he tries to login

so i went to his name and wanted to do some digging on whats going on

I went to user administration
found his name but got this error

_____________________________


General Error
SQL ERROR [ mysql4 ]

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

SQL

SELECT user_id FROM phpbb_users WHERE username_clean = 'ǃ3lem3ntǃ'

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: includes/acp/acp_users.php
LINE: 92
CALL: dbal_mysql->sql_query()

FILE: includes/functions_module.php
LINE: 471
CALL: acp_users->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()
_______________________________

Any ideas?
User avatar
Noxwizard
Support Team Leader
Support Team Leader
Posts: 10422
Joined: Mon Jun 27, 2005 8:41 pm
Location: Texas, USA
Name: Patrick Webster
Contact:

Re: sql error USER

Post by Noxwizard »

You need to switch the collations on your phpbb_users table from latin to utf8.
[Support Template] - [Read Before Posting] - [phpBB Knowledge Base]
Do not contact me for private support, please share the question in our forums.
RoCkFoRdGuN
Registered User
Posts: 33
Joined: Mon Feb 05, 2007 5:28 am

Re: sql error USER

Post by RoCkFoRdGuN »

Its only one user tho thats the funny thing and thats after i upgraded to phpbb3
How do i change it on phpmyadmin :"?
User avatar
Noxwizard
Support Team Leader
Support Team Leader
Posts: 10422
Joined: Mon Jun 27, 2005 8:41 pm
Location: Texas, USA
Name: Patrick Webster
Contact:

Re: sql error USER

Post by Noxwizard »

In phpMyAdmin, choose your database on the left, then choose the phpbb_users table. Then on the structure tab, find the 'username_clean' row, and click the pencil. On that page, change the 'Collation' dropdown to 'utf8_general_ci'. Click 'Save' and you're done.
[Support Template] - [Read Before Posting] - [phpBB Knowledge Base]
Do not contact me for private support, please share the question in our forums.
Locked

Return to “[3.0.x] Support Forum”