Question DB error with member conversation

[cionfs]

Hi,
I've received a lot of this message

Database error in  1210:

Invalid SQL:

                                        SELECT userid
                                        FROM vb_user
                                        WHERE username REGEXP "^(&[\#\da-z]*;|[^a-z\d])*[cгc]l[aюабцдеЮАБЦДЕ]([uызшэЫЗШЭ╣]|u|ф|Ф)d[iлмноЛМНО][oрстужьРСТУЖЬ](&[\#\da-z]*;|[^a-z\d])*(&[\#\da-z]*;|[^a-z\d])*$"
                                        LIMIT 1;

MySQL Error   : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'regexp'
Error Number  : 1267
Request Date  : Monday, October 27th 2014 @ 02:14:46 PM
Error Date    : Monday, October 27th 2014 @ 02:14:46 PM
Script        : http://www.cionfs.it/forum/members/claudio--with-aprania.html
Referrer      :
IP Address    : **
Username      : N/A
Classname     : DBSEO_Database
MySQL Version :

How can I solve?

 

[Fillip H.]

This means your database tables are not using the same character set. Update all columns in all tables, all tables, and the database itself to be the same character set.

Contact your host if you don't know how to achieve this.

 

[cionfs]

Hi,
all the table have latin1_swedish_ci charset.

 

[cionfs]

Solved.
The problem was the user_id.
I had

members/[user_name]-with-[visitor_name].html

I've changed with

members/[user_name]-[user_id]-with-[visitor_name][visitor_id].html

And I've solved.

 

[Fillip H.]

Glad you got it working