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 ?

[xtone]

please i am stuck here can anyone help me ?

[cotufa-ssdd]

=xtone]bro i've checked with the host they said my max allowed packet is 126 MB thats more then needed so what should i do now i cant post on my own site

you can also try to configure the connection timeout and the wait timeout...

its in the same file /etc/my.cnf

you have to either add the line or edit the line in the file..

connect_timeout=120
wait_timeout = 1800

If you do not have a my.cnf file, just create a new one.

Or, type the following line using the command-line:

mysql> show global variables like '%timeout%';

...which will give you a result like this:


+--------------------------+-------+
| Variable_name | Value |
+--------------------------+-------+
| connect_timeout | 5 |
| delayed_insert_timeout | 300 |
| innodb_lock_wait_timeout | 50 |
| interactive_timeout | 28800 |
| net_read_timeout | 30 |
| net_write_timeout | 60 |
| slave_net_timeout | 3600 |
| table_lock_wait_timeout | 50 |
| wait_timeout | 28800 |
+--------------------------+-------+
9 rows in set (0.00 sec)

if you cant configure this file talk to your host and run some tests to find the problem..