[kronolith] last git head update constraint violation

[Michael Rubinsky]

Quoting LALOT Dominique <dom.lalot at gmail.com>:

> Mickael,
>
> Could you give me the file name where to put this trace. I don't know the
> code orgnization.

Sure. It's in content/lib/Tagger.php


>
> 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


mike

The Horde Project (www.horde.org)
mrubinsk at horde.org