Database error: Connection failed!

[indyp]

Hi,

Having installed Roundcube 0.2.1 on my server and running okay through the tests for both IMAP and SMTP. I now get this error:

DATABASE ERROR: CONNECTION FAILED!

When I try to login.

The error log says the following.

Code Select Expand


[13-May-2009 11:06:09 -0500] DB Error: MDB2 Error: unknown error Query: _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE mdb2_statement_mysql_19a9138adaf589dbd12ad0201b48dd607ac6ad0b1 USING @0] [Native code: 1267] [Native message: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=']  in /home/myserver/domains/myserver.com/public_html/roundcube/program/include/rcube_mdb2.php on line 539 (GET /roundcube/)
[13-May-2009 12:26:31] MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement]
[Last executed query: EXECUTE mdb2_statement_mysql_1a1bb7afd61aeea011e6d8a38c413d7b58f33a520 USING @0]
[Native code: 1267]
[Native message: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=']



Can anyone help with this? please?

Thx

[JonHayes]

Hi,

Having installed Roundcube 0.2.1 on my server and running okay through the tests for both IMAP and SMTP. I now get this error:

DATABASE ERROR: CONNECTION FAILED!

When I try to login.

The error log says the following.

Code Select Expand


[13-May-2009 11:06:09 -0500] DB Error: MDB2 Error: unknown error Query: _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE mdb2_statement_mysql_19a9138adaf589dbd12ad0201b48dd607ac6ad0b1 USING @0] [Native code: 1267] [Native message: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=']  in /home/myserver/domains/myserver.com/public_html/roundcube/program/include/rcube_mdb2.php on line 539 (GET /roundcube/)
[13-May-2009 12:26:31] MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement]
[Last executed query: EXECUTE mdb2_statement_mysql_1a1bb7afd61aeea011e6d8a38c413d7b58f33a520 USING @0]
[Native code: 1267]
[Native message: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=']



Can anyone help with this? please?

Thx

restart MySQL