Hi,
I've done a fresh new 0.6 install, but I had the same problem with 0.5.3.
It's running on an OpenSuSE 11.4 with php 5.3.8
Both roundcube and dovecot run on the same host.
Here is the error message:
DB Error in /srv/www/htdocs/roundcube/program/include/rcube_mdb2.php (713): MDB2 Error: constraint violation Query: _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE mdb2_statement_mysql_24e439f67ca1bf498df3ba581fcb72d935105e903 USING @0, @1, @2] [Native code: 1062] [Native message: Duplicate entry 'uomgkkavetoqac4qumq6t2itqj0vh2uprblcjun8' for key 'PRIMARY']
It appears on the login page, before I even try to login.
If I try to login I have this error message:
DB Error in /srv/www/htdocs/roundcube/program/include/rcube_mdb2.php (713): MDB2 Error: constraint violation Query: _doQuery: [Error message: Could not execute statement] [Last executed query: INSERT INTO session (sess_id, vars, ip, created, changed) VALUES ('6fuer7ve3t76oth9v7i1eh9pee80katc4f80rc9hmpllv6v8c5c1', 'dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs=', '87.0xxx', '2011-09-29 00:09:32', '2011-09-29 00:09:32')] [Native code: 1062] [Native message: Duplicate entry '6fuer7ve3t76oth9v7i1eh9pee80katc4f80rc9h' for key 'PRIMARY']
Login didn't works, but I can see that connection is successful in my dovecot server logs.
In logs/session:
[29-Sep-2011 00:09:32 +0200]: Aborted session 6fuer7ve3t76oth9v7i1eh9pee80katc4f80rc9hmpllv6v8c5c1; no valid session data found
In logs/userlogins:
[29-Sep-2011 00:09:32 +0200]: Successful login for elhijo@host (ID: 1) from 87.0xxx in session 6fuer7ve3t76oth9v7i1eh9pee80katc4f80rc9hmpllv6v8c5c1
I've installed almost the same configuration on an Ubuntu host without a problem...
Any help is welcomed.
Thanks,
David