Facing a problem on DLE 9.3

[xtone]

hi guys em facing a problem on my dle 9.3 site when any new guest try to register him self he get this error:

MySQL Error!
------------------------

The Error returned was:
Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'regexp'

Error Number:
1267

SELECT COUNT(*) as count FROM dle_users WHERE email = 'asldkfj@lkjasdf.com' OR LOWER(name) REGEXP '[[:<:]][a?]d[s5]f[a?][s5]df[[:>:]]' OR name = 'adsfasdf'

does anyone have any idea what this is about ?

xtone Reviewed by xtone on 26th Aug 2011. Facing a problem on DLE 9.3 hi guys em facing a problem on my dle 9.3 site when any new guest try to register him self he get this error: MySQL Error! ------------------------ The Error returned was: Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'regexp' Error Number: 1267 Rating: 5

[cotufa-ssdd]

its a problem interpreting the ?@?

so you can try to set MySQL to interpret the literal string as utf8:

mysql> SELECT SUBSTRING_INDEX(USER(),_utf8'@',1);
+------------------------------------+
| SUBSTRING_INDEX(USER(),_utf8'@',1) |
+------------------------------------+
| root |
+------------------------------------+

code:

mysql_query("SET CHARACTER SET utf8");

[Mindy]

I moved this to the correct area

Can anyone help him out...this is still having the same error

[Devils]

Help guys

[xtone]

guys need help here i cant post on my site due to this error:

MySQL Error!
------------------------

The Error returned was:
MySQL server has gone away

Error Number:
2006

and it says :
INSERT INTO dle_post

and lost of my content stuff

i dotn know why i am facing this everything was working fine 4 days before and i havent installed anything too !
any ideas

[soft2050]

^^ MYSQL Server has stopped responding
If you are having ssh access, the execute this in putty:

service mysqld restart

[NewEraCracker]

hi guys em facing a problem on my dle 9.3 site when any new guest try to register him self he get this error:

MySQL Error!
------------------------

The Error returned was:
Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'regexp'

Error Number:
1267

SELECT COUNT(*) as count FROM dle_users WHERE email = 'asldkfj@lkjasdf.com' OR LOWER(name) REGEXP '[[:<:]][a?]d[s5]f[a?][s5]df[[:>:]]' OR name = 'adsfasdf'

does anyone have any idea what this is about ?

You need to check which is the collation tables are using. Use a tool such as phpmyadmin.

guys need help here i cant post on my site due to this error:

MySQL Error!
------------------------

The Error returned was:
MySQL server has gone away

Error Number:
2006

and it says :
INSERT INTO dle_post

and lost of my content stuff

i dotn know why i am facing this everything was working fine 4 days before and i havent installed anything too !
any ideas

Which is your MySQL version? Are you using shared hosting or VPS?

[xtone]

yes i am using it and i am on shared hosting !

and my SQL version is 5.1.56

any suggestions ?

[NewEraCracker]

yes i am using it and i am on shared hosting !

and my SQL version is 5.1.56

any suggestions ?

You are crazy using DLE in shared hosting.
'nuff said.

[xtone]

please i am stuck here can anyone help me ?