| Summary | SQL insert query fails for table horde_locks - lock_owner column too small |
| Queue | Horde Base |
| Queue Version | 4.0.9 |
| Type | Bug |
| State | Resolved |
| Priority | 2. Medium |
| Owners | jan (at) horde (dot) org |
| Requester | tkrah (at) fachschaft (dot) imn (dot) htwk-leipzig (dot) de |
| Created | 10/04/2011 (5021 days ago) |
| Due | 10/05/2011 (5020 days ago) |
| Updated | 10/10/2011 (5015 days ago) |
| Assigned | |
| Resolved | 10/10/2011 (5015 days ago) |
| Github Issue Link | |
| Github Pull Request | |
| Milestone | |
| Patch | No |
State ⇒ Resolved
[jan] Expand width of lock_owner column (
Bug #10608).2 files changed, 31 insertions(+), 5 deletions(-)
http://git.horde.org/horde-git/-/commit/bed0a54d000ff787ec5a179f9c0c4fa13e144b5c
Priority ⇒ 2. Medium
Patch ⇒ No
Milestone ⇒
Queue ⇒ Horde Base
Due ⇒ 10/05/2011
Summary ⇒ SQL insert query fails for table horde_locks - lock_owner column too small
Type ⇒ Bug
State ⇒ Unconfirmed
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@software-friends.de', 'horde_auth',#012#011
'login:langer.benutzername@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"]