Opened 8 years ago

Closed 8 years ago

#1334954 closed Bugs (Fixed)

DB Error: already exists

Reported by: yayel2 Owned by: roundcube
Priority: 5 Milestone:
Component: Database Version: None
Severity: Keywords:
Cc:

Description

Hi

Cannot login to roundecubemail: redirected to the login form again 
with the following errors:

Warning: fopen(./logs/errors) [function.fopen]: failed to open 
stream: No such file or directory in /usr/home/www/roundcubemail/
program/include/bugs.inc on line 67
DB Error in /usr/home/www/roundcubemail/program/include/
rcube_db.inc (129): DB Error: already exists

Warning: fopen(./logs/errors) [function.fopen]: failed to open 
stream: No such file or directory in /usr/home/www/roundcubemail/
program/include/bugs.inc on line 67
DB Error in /usr/home/www/roundcubemail/program/include/
rcube_db.inc (204): DB Error: already exists Query: INSERT INTO 
session (sess_id, vars, ip, created, changed) VALUES 
('909400d47c6d7c68334024f6e8ca06f8b9cc7e59', 'client_id|s:
40:"909400d47c6d7c68334024f6e8ca06f8b9cc7e59";user_lang|s:
2:"en";auth_time|i:1129995283;auth|s:
40:"2a74c43174bf6c443a5e37467b7346a5ddba57a9";task|s:
4:"mail";', '82.66.216.116', NOW(), NOW())


Using:
- today's CVS
- latest PHP5
- courier-imap-3.0.2,1
- latest MySQL 4.0
- FreeBSD 4.8

$ ls -la logs/errors 
-rw-rw-rw-  1 www  www  226 12 oct 20:21 logs/errors


Any idea ?

Change History (1)

comment:1 Changed 8 years ago by roundcube

  • Status changed from assigned to closed
Logged In: YES 
user_id=1262041

This is because some PHP configurations use a 160-bit hash
for session ids. RoundCube only supported 128-bit hashes.
Just set the sess_id column in your database to varchar(40)
This is now fixed in CVS
Note: See TracTickets for help on using tickets.