Author Topic: [SOLVED] mysql error on login page  (Read 3038 times)

Offline elhijo

  • Newbie
  • *
  • Posts: 2
[SOLVED] mysql error on login page
« on: September 28, 2011, 06:21:15 PM »
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
« Last Edit: September 28, 2011, 07:00:09 PM by elhijo »

Offline elhijo

  • Newbie
  • *
  • Posts: 2
mysql error on login page
« Reply #1 on: September 28, 2011, 06:59:31 PM »
Ok,
Juste felt back to php 5.3.5, from "legal" SuSE repo.
And it works with no error.
sorry for this one,
Thanks,
David