username error

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
Nutu.
Registered User
Posts: 21
Joined: Tue Feb 20, 2018 8:27 pm

username error

Post by Nutu. »

could it be solved? i want use symbols on my username on forum, but everytime i try to change this, i got that error

Code: Select all

A general error occured: General Error
» SQL ERROR [ mysql4 ]

Incorrect string value: '\xE3\x83\x84' for column 'username' at row 1 [1366]

SQL

UPDATE phpbb_chat_sessions SET username = 'Nutu ツ', user_colour = '0060FF', user_lastupdate = 1519077481, user_login = 1519077481 WHERE user_id = 27722

BACKTRACE

FILE: [ROOT]/includes/db/mysql.php
LINE: 175
CALL: dbal->sql_error()

FILE: [ROOT]/shout.php
LINE: 101
CALL: dbal_mysql->sql_query()

FILE: [ROOT]/index.php
LINE: 29
CALL: include('[ROOT]/shout.php')
could anyone helps me???
User avatar
warmweer
Jr. Extension Validator
Posts: 11234
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium
Contact:

Re: username error

Post by warmweer »

Nutu. wrote: Tue Feb 20, 2018 8:32 pm could it be solved? i want use symbols on my username on forum, but everytime i try to change this, i got that error

Code: Select all

A general error occured: General Error
» SQL ERROR [ mysql4 ]

Incorrect string value: '\xE3\x83\x84' for column 'username' at row 1 [1366]

SQL

UPDATE phpbb_chat_sessions SET username = 'Nutu ツ', user_colour = '0060FF', user_lastupdate = 1519077481, user_login = 1519077481 WHERE user_id = 27722
...
could anyone helps me???
The username Nutu ツ has non- Latin characters. Which character set are you using?

BTW this subforum =
phpBB Discussion
Do not post support requests, bug reports or feature requests.


You should post this in the correct subforum and post more info e.g. which phpBB version, etc.. (use the Support Template).
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.


Time flies like an arrow, but fruit flies like a banana.
Post Reply

Return to “[3.2.x] Support Forum”