mysql error 42000

Get help from the community here.

Moderator: Developers

ale.ab
Posts: 11
Joined: Wed Nov 19, 2014 7:10 am

mysql error 42000

Postby ale.ab » Fri Apr 13, 2018 1:51 pm

Hello,
i have an installation of Group-Office ( version 6.1.111 ) from last year.
i never had problems .

today i need to create a new user, but i receive this error

Code: Select all

SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8_bin' is not valid for CHARACTER SET 'utf8mb4'
strange behavior is that, user was created in table. but when i try to login i receive same error

Code: Select all

SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8_bin' is not valid for CHARACTER SET 'utf8mb4'

how i can resolve this?

the server is normal centos 7 64bit ( with cpanel )
php + mysql

thank you in advance

Alessandro
ale.ab
Posts: 11
Joined: Wed Nov 19, 2014 7:10 am

Re: mysql error 42000

Postby ale.ab » Fri Apr 20, 2018 3:03 pm

nobody can help me?

thank you
ale.ab
Posts: 11
Joined: Wed Nov 19, 2014 7:10 am

Re: mysql error 42000

Postby ale.ab » Tue Apr 24, 2018 2:51 pm

maybe is a problem of mysql server?

thank you
peter_stirnberg
Posts: 279
Joined: Tue Dec 13, 2005 7:57 am

Re: mysql error 42000

Postby peter_stirnberg » Wed Apr 25, 2018 5:55 am

ale.ab wrote: Fri Apr 13, 2018 1:51 pm Hello,
i have an installation of Group-Office ( version 6.1.111 ) from last year.
i never had problems .

today i need to create a new user, but i receive this error

Code: Select all

SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8_bin' is not valid for CHARACTER SET 'utf8mb4'
strange behavior is that, user was created in table. but when i try to login i receive same error

Code: Select all

SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8_bin' is not valid for CHARACTER SET 'utf8mb4'
First of all I suggest to update GO to the latest stable version in 6.1 branch which is 6.1.139

See changelog from 03-11-2016
- Fix utf8 problem, db will be converted to to utf8mb4_unicode_ci v2
ale.ab
Posts: 11
Joined: Wed Nov 19, 2014 7:10 am

Re: mysql error 42000

Postby ale.ab » Thu Jun 07, 2018 4:57 pm

thank you

i solve after upgrade

thank you again

Who is online

Users browsing this forum: No registered users and 4 guests

cron