Latest Announcemnent
New thread

Facing a problem on DLE 9.3

Status
Not open for further replies.
X

xtone

Active Member
421
2009
4
0
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 ?
 
11 comments
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");
Click to expand...
 
Last edited:
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
 
xtone said:
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 ?
Click to expand...

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

xtone said:
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
Click to expand...

Which is your MySQL version? Are you using shared hosting or VPS?
 
=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 :(
Click to expand...

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)
Click to expand...

if you cant configure this file talk to your host and run some tests to find the problem..
 
Status
Not open for further replies.
Back
Top