[Tickets #10608] SQL insert query fails for table horde_locks - lock_owner column too small

[bugs at horde.org]

BITTE NICHT AUF DIESE NACHRICHT ANTWORTEN. NACHRICHTEN AN DIESE  
E-MAIL-ADRESSE WERDEN NICHT GELESEN.

Ticket-URL: http://bugs.horde.org/ticket/10608
------------------------------------------------------------------------------
  Ticket           | 10608
  Erstellt Von     | tkrah at fachschaft.imn.htwk-leipzig.de
  Zusammenfassung  | SQL insert query fails for table  horde_locks -
                   | lock_owner column too small
  Warteschlange    | Horde Base
  Version          | 4.0.9
  Typ              | Bug
  Status           | Unconfirmed
  Priorität        | 2. Medium
  Milestone        |
  Patch            |
  Zuständige       |
------------------------------------------------------------------------------


tkrah at fachschaft.imn.htwk-leipzig.de (2011-10-04 12:25) hat geschrieben:

This is what the logs tell me - the lock_owner field is too small (32  
characters) to be used for long user names - 32 is not that long if  
virtual hosting is done and the auth name is the email address:



Oct  4 13:27:45 mail HORDE: [horde] SQL QUERY FAILED: SQLSTATE[22001]:  
String data, right truncated: 7 ERROR:  value too long for type  
character varying(32)  #012#011INSERT INTO horde_locks (lock_id,  
lock_owner, lock_scope,#012#011  lock_principal,  
lock_origin_timestamp, lock_update_timestamp,#012#011   
lock_expiry_timestamp, lock_type) VALUES#012#011   
('4e8aedb1-50d4-4fd2-9589-44ed4e2ff3e2',#012#011   
'langer.benutzername at software-friends.de', 'horde_auth',#012#011   
'login:langer.benutzername at software-friends.de', 1317727665,  
1317727665,#012#011  1317727965, 1) [pid 17645 on line 810 of  
"/usr/share/php/Horde/Db/Adapter/Base.php"]
Oct  4 13:27:45 mail HORDE: [horde] SQLSTATE[22001]: String data,  
right truncated: 7 ERROR:  value too long for type character  
varying(32) [pid 17645 on line 254 of  
"/usr/share/php/Horde/Auth/Base.php"]