[Tickets #9760] Re: QUERY FAILED: Duplicate entry 'xxx' for key 'rampage_users_user_name' INSERT INTO `rampage_users` (user_name) VALUES ('xxx')
bugs at horde.org
bugs at horde.org
Thu Mar 31 15:03:35 UTC 2011
DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.
Ticket URL: http://bugs.horde.org/ticket/9760
------------------------------------------------------------------------------
Ticket | 9760
Updated By | Klaus.Steinberger at Physik.Uni-Muenchen.DE
Summary | QUERY FAILED: Duplicate entry 'xxx' for key
| 'rampage_users_user_name' INSERT INTO `rampage_users`
| (user_name) VALUES ('xxx')
Queue | Kronolith
Version | 3.0-RC2
Type | Bug
State | Feedback
Priority | 1. Low
Milestone |
Patch |
Owners |
------------------------------------------------------------------------------
Klaus.Steinberger at Physik.Uni-Muenchen.DE (2011-03-31 15:03) wrote:
> Depends on where you installed PEAR. Could be in /usr/bin/.
> Run:
> pear list-files horde/horde
Ahh it's /usr/bin/horde-db-migrate
Ok here is the output:
[root at 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 at 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 at 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 at dmz-sv-webmail ~]#
More information about the bugs
mailing list