Summary |
QUERY FAILED: Duplicate entry 'xxx' for key 'rampage_users_user_name' INSERT INTO `rampage_users` (user_name) VALUES ('xxx') |
Queue |
Kronolith |
Queue Version |
3.0-RC2 |
Type |
Bug |
State |
Resolved |
Priority |
1. Low |
Owners |
mrubinsk (at) horde (dot) org |
Requester |
Klaus.Steinberger (at) physik (dot) uni-muenchen (dot) de |
Created |
03/31/2011 (5208 days ago) |
Due |
|
Updated |
11/03/2014 (3895 days ago) |
Assigned |
04/01/2011 (5207 days ago) |
Resolved |
04/06/2011 (5202 days ago) |
Github Issue Link |
|
Github Pull Request |
|
Milestone |
|
Patch |
No |
case-insensitive.
and you want to correct this, Horde provides a preauthenticate hook
(see horde/config/hooks.php.dist) to change the case to whatever you
prefer. An example for precisely this use case is provided.
'DAVID' and also as 'david', once I updated the column
event_creator_id in the kronolith_events table so it was all the
same the upgrade worked fine after. I also had same problem with
turba.
case-insensitive.
Ive just had this problem where in the past someone had logged in as
'DAVID' and also as 'david', once I updated the column
event_creator_id in the kronolith_events table so it was all the same
the upgrade worked fine after. I also had same problem with turba.
and with existing tag info present.
State ⇒ Feedback
and with existing tag info present.
Can you:
in content/lib/Users/Manager.php after line 72 add:
Horde::debug($sql);
Horde::debug($this->_db->selectAll($sql));
and then after line 79 add:
Horde::debug($userName);
the results will be placed in a file named 'horde_debug.txt' in your
temporary directory. Then please post the results here.
State ⇒ Assigned
Run:
pear list-files horde/horde
Ok here is the output:
[root@dmz-sv-webmail ~]# horde-db-migrate --debug kronolith
[ INFO ] Migrating DB up.
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0026s)
SHOW TABLES
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0019s)
SHOW TABLES
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0003s)
SELECT version FROM kronolith_schema_info
[ INFO ] Current kronolith schema version: 17
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0004s)
SELECT type_id, type_name FROM `rampage_types` WHERE type_name IN
('calendar','event')
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0018s)
SHOW TABLES
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0006s)
SELECT version FROM kronolith_schema_info
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0013s)
SHOW TABLES
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0003s)
SELECT version FROM kronolith_schema_info
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0013s)
SHOW TABLES
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0003s)
SELECT version FROM kronolith_schema_info
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0013s)
SHOW TABLES
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0002s)
SELECT version FROM kronolith_schema_info
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0014s)
SHOW TABLES
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0001s)
SELECT version FROM kronolith_schema_info
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0012s)
SHOW TABLES
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0001s)
SELECT version FROM kronolith_schema_info
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0016s)
SHOW TABLES
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0002s)
SELECT version FROM kronolith_schema_info
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0019s)
SHOW TABLES
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0002s)
SELECT version FROM kronolith_schema_info
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0019s)
SHOW TABLES
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0002s)
SELECT version FROM kronolith_schema_info
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0019s)
SHOW TABLES
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0003s)
SELECT version FROM kronolith_schema_info
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0019s)
SHOW TABLES
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0002s)
SELECT version FROM kronolith_schema_info
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0019s)
SHOW TABLES
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0003s)
SELECT version FROM kronolith_schema_info
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0019s)
SHOW TABLES
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0002s)
SELECT version FROM kronolith_schema_info
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0019s)
SHOW TABLES
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0002s)
SELECT version FROM kronolith_schema_info
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0020s)
SHOW TABLES
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0003s)
SELECT version FROM kronolith_schema_info
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0019s)
SHOW TABLES
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0002s)
SELECT version FROM kronolith_schema_info
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0019s)
SHOW TABLES
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0002s)
SELECT version FROM kronolith_schema_info
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0019s)
SHOW TABLES
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0002s)
SELECT version FROM kronolith_schema_info
Migrating to KronolithUpgradeCategoriesToTags (18)
== 18 KronolithUpgradeCategoriesToTags: migrating
=============================
== 18 KronolithUpgradeCategoriesToTags: Migrating event categories to
tags. ===
-- select(SELECT event_uid, event_category, event_creator_id,
calendar_id FROM kronolith_events)
-> 0.0005s
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0418s)
SELECT event_uid, event_category, event_creator_id, calendar_id FROM
kronolith_events
-- getOption(charset)
-> 0.0000s
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0004s)
SELECT object_id, object_name FROM `rampage_objects` WHERE object_name
IN ('20060423181823.1qybe4lucog0@www.physik.uni-muenchen.de') AND
type_id = 2
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0004s)
SELECT user_id, user_name FROM `rampage_users` WHERE user_name IN
('xxx')
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0005s)
SELECT * FROM kronolith_sharesng WHERE share_name = 'xxx'
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0002s)
SELECT * FROM kronolith_sharesng_users WHERE share_id = '65'
-- getOption(charset)
-> 0.0000s
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0005s)
SELECT object_id, object_name FROM `rampage_objects` WHERE object_name
IN ('20060423181823.1qybe4lucog0@www.physik.uni-muenchen.de') AND
type_id = 2
2011-03-31T17:01:10+02:00 DEBUG: SQL (0.0002s)
SELECT user_id, user_name FROM `rampage_users` WHERE user_name IN
('xxx')
2011-03-31T17:01:10+02:00 DEBUG: SQL QUERY FAILED: Duplicate entry
'xxx' for key 'rampage_users_user_name'
INSERT INTO `rampage_users` (user_name) VALUES ('xxx')
2011-03-31T17:01:10+02:00 DEBUG: SQL
INSERT INTO `rampage_users` (user_name) VALUES ('xxx')
QUERY FAILED: Duplicate entry 'xxx' for key 'rampage_users_user_name'
INSERT INTO `rampage_users` (user_name) VALUES ('Kaspar.Graf')
[root@dmz-sv-webmail ~]#
Run:
pear list-files horde/horde
./horde/bin/db_migrate --debug kronolith
State ⇒ Feedback
./horde/bin/db_migrate --debug kronolith
Patch ⇒ No
State ⇒ Unconfirmed
Milestone ⇒
Queue ⇒ Kronolith
Summary ⇒ QUERY FAILED: Duplicate entry 'xxx' for key 'rampage_users_user_name' INSERT INTO `rampage_users` (user_name) VALUES ('xxx')
Type ⇒ Bug
Priority ⇒ 1. Low
Update the DB Schema to horde 4.
Any tables worked except the schema for kronolith, where I got this error:
QUERY FAILED: Duplicate entry 'xxx' for key 'rampage_users_user_name'
INSERT INTO `rampage_users` (user_name) VALUES ('xxx')
(I replaced the real username by xxx).