[kronolith] last git head update constraint violation
LALOT Dominique
dom.lalot at gmail.com
Fri Feb 25 08:37:20 UTC 2011
Mickael,
Could you give me the file name where to put this trace. I don't know the
code orgnization.
Thanks
Dom
2011/2/24 Michael Rubinsky <mrubinsk at horde.org>
>
> Quoting Jan Schneider <jan at horde.org>:
>
> Zitat von Michael Rubinsky <mrubinsk at horde.org>:
>>
>>
>>> Quoting LALOT Dominique <dom.lalot at gmail.com>:
>>>
>>> Hello Mickael,
>>>>
>>>> using the db_migrate --debug
>>>> it produces:
>>>>
>>>> INSERT INTO `rampage_tagged` (user_id, object_id, tag_id, created)
>>>> VALUES (22,4789,13,'2011-02-24T15:34:46')
>>>> 2011-02-24T15:34:46+01:00 DEBUG: SQL
>>>> INSERT INTO `rampage_tagged` (user_id, object_id, tag_id, created)
>>>> VALUES (22,4789,13,'2011-02-24T15:34:46')
>>>> 2011-02-24T15:34:46+01:00 DEBUG: SQL (0.0002s)
>>>> SELECT object_id, object_name FROM `rampage_objects` WHERE
>>>> object_name
>>>> IN ('20070502100506.1y1yia5ws0n4 at webmel.univ.fr') AND type_id =
>>>> 2
>>>> 2011-02-24T15:34:46+01:00 DEBUG: SQL (0.0001s)
>>>> SELECT user_id, user_name FROM `rampage_users` WHERE user_name IN
>>>> ('bourdin')
>>>> 2011-02-24T15:34:46+01:00 DEBUG: SQL (0.0001s)
>>>> SELECT tag_id, tag_name FROM `rampage_tags` WHERE tag_name IN
>>>> ('Priv▒')
>>>> 2011-02-24T15:34:46+01:00 ERR: SQL QUERY FAILED: SQLSTATE[23000]:
>>>> Integrity
>>>> constraint violation: 1062 Duplicate entry '14-4790-9' for key 'PRIMARY'
>>>>
>>>
>>> Is 14-4709-9 one of your categories or tag names?
>>>
>>
>> Looks like the primary ID of rampage_tagged, which is a composite key. So
>> this would be user_id 14, object_id 4790, tag_id 9.
>>
>
> Ok. If that's the case, Content_Tagger is supposed to ignore this
> exception. See Content_Tagger::tag() lines 118 - 124. Can you put a
> var_dump($e); right before the continue statement on line 122 and see what
> information that provides? Maybe Horde_Db is not catching this and throwing
> a Horde_Db_Exception?
>
>
> mike
>
> The Horde Project (www.horde.org)
> mrubinsk at horde.org
> --
> Kronolith mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: kronolith-unsubscribe at lists.horde.org
>
--
Dominique LALOT
Ingénieur Systèmes et Réseaux
http://annuaire.univmed.fr/showuser.php?uid=lalot
More information about the kronolith
mailing list