Author Topic: Database error: Connection failed!  (Read 5105 times)

Offline indyp

  • Newbie
  • *
  • Posts: 1
Database error: Connection failed!
« on: May 13, 2009, 06:58:38 PM »
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]

[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

Offline JonHayes

  • Newbie
  • *
  • Posts: 2
Database error: Connection failed!
« Reply #1 on: June 23, 2009, 10:57:39 PM »
Quote from: indyp;19003
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]

[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