[kronolith] Strangeness with Horde 4 and Kronolith

[Claudio Prono]

Il 03/05/2011 14.35, Jan Schneider ha scritto:
>
> Zitat von Claudio Prono <claudio.prono at atpss.net>:
>
>> Hello all,
>>
>> I am testing the upgrade from Horde 3 to Horde 4, and i have a strange
>> behaviour with Kronolith.
>>
>> I use Funambol Mozilla Sync to sync the Calendaries with Thunderbird. It
>> works very well with Horde 3, but now, the sync fails, and if i see the
>> logs of horde, i see a large list of this:
>>
>> HORDE: HORDE [kronolith] QUERY FAILED: Duplicate entry '0' for key 1
>> INSERT INTO horde_histories (object_uid, history_ts, history_who,
>> history_desc, history_action, history_extra) VALUES
>> ('kronolith:claudio at mediaservice.net:20100309165601.1324416576996rv5 at webmail.mediaservice.net',
>>
>> 1304425353, 'claudio at mediaservice.net', NULL, 'modify', NULL) [pid 8124
>> on line 154 of "/usr/share/php5/PEAR/Horde/History/Sql.php"]
>>
>> It seems to try to insert every value with the object_uid = "0" and not
>> a progressive number. I have tried also to empty the table Horde
>> Histories, and it insert a row, with object_uid = "0" and all the others
>> produce the error of Duplicate Entry.....
>
> Are you sure that your database scheme for Horde_History isn't out of
> date (check configuration screen)?
>
> Jan.
>
Very strange, is the database scheme is wrong. But the check
configuration screen tell me is all ok. The problem is into the
history_id object, the extra option auto_increment is not set. I have
set this by hand, and now works.

But... i have another problem now.

When i sync, i have this error into the logs:

2011-05-03T15:19:07+02:00 DEBUG: HORDE [kronolith] SQL  (0.0005s)
        SELECT event_id, event_uid, calendar_id, event_description,
          event_location, event_private, event_status, event_attendees,
          event_title, event_recurcount, event_url, event_recurtype,
          event_recurenddate, event_recurinterval, event_recurdays,
event_start,
          event_end, event_allday, event_alarm, event_alarm_methods,
          event_modified, event_exceptions, event_creator_id,
event_resources,
          event_baseid, event_exceptionoriginaldate FROM
kronolith_events WHERE
          event_uid =
         
'20110503124426.awmOSANRg2JNv9yKCmoRMCA at webmail.mediaservice.net' [pid
10760 on line 783 of "/usr/share/php5/PEAR/Horde/Db/Adapter/Base.php"]
2011-05-03T15:19:07+02:00 EMERG: HORDE [horde]
20110503124426.awmOSANRg2JNv9yKCmoRMCA at webmail.mediaservice.net not
found [pid 10760 on line 484 of
"/srv/www/horde.new/horde/kronolith/lib/Driver/Sql.php"]
2011-05-03T15:19:07+02:00 DEBUG:  1. Horde_Rpc_Syncml->getResponse()
/srv/www/horde.new/horde/rpc.php:128
 2. Horde_SyncMl_ContentHandler->process()
/usr/share/php5/PEAR/Horde/Rpc/Syncml.php:52
 3. xml_parse() /usr/share/php5/PEAR/Horde/SyncMl/ContentHandler.php:131
 4. Horde_SyncMl_ContentHandler->_endElement()
 5. Horde_SyncMl_ContentHandler->endElement()
/usr/share/php5/PEAR/Horde/SyncMl/ContentHandler.php:217
 6. Horde_SyncMl_ContentHandler->handleCommand()
/usr/share/php5/PEAR/Horde/SyncMl/ContentHandler.php:304
 7. Horde_SyncMl_Command_Sync->handleCommand()
/usr/share/php5/PEAR/Horde/SyncMl/ContentHandler.php:434
 8. Horde_SyncMl_Sync->handleClientSyncItem()
/usr/share/php5/PEAR/Horde/SyncMl/Command/Sync.php:306
 9. Horde_SyncMl_Backend_Horde->replaceEntry()
/usr/share/php5/PEAR/Horde/SyncMl/Sync.php:310
10. Horde_Registry->call()
/usr/share/php5/PEAR/Horde/SyncMl/Backend/Horde.php:404
11. Horde_Registry->callByPackage()
/usr/share/php5/PEAR/Horde/Registry.php:958
12. call_user_func_array() /usr/share/php5/PEAR/Horde/Registry.php:999
13. Kronolith_Api->replace()
14. Kronolith_Driver_Sql->getByUID()
/srv/www/horde.new/horde/kronolith/lib/Api.php:940

And the Funambol plugin exits with error code -1. What can be wrong now?

The sctructure of horde_history now is the following:

 desc horde_histories;
+----------------+--------------+------+-----+---------+----------------+
| Field          | Type         | Null | Key | Default | Extra          |
+----------------+--------------+------+-----+---------+----------------+
| history_id     | int(10)      | NO   | PRI | NULL    | auto_increment |
| object_uid     | varchar(255) | NO   | MUL | NULL    |                |
| history_action | varchar(32)  | NO   | MUL | NULL    |                |
| history_ts     | int(11)      | NO   | MUL | NULL    |                |
| history_desc   | longtext     | YES  |     | NULL    |                |
| history_who    | varchar(255) | YES  |     | NULL    |                |
| history_extra  | longtext     | YES  |     | NULL    |                |
+----------------+--------------+------+-----+---------+----------------+
7 rows in set (0.00 sec)

Any hint ?


 

-- 
--------------------------------------------------------------------------------
Claudio Prono                         OPST
System Developer               
                                      Gsm: +39-349-54.33.258
@PSS Srl                              Tel: +39-011-32.72.100
Via San Bernardino, 17                Fax: +39-011-32.46.497
10141 Torino - ITALY                  http://atpss.net/disclaimer
--------------------------------------------------------------------------------
PGP Key - http://keys.atpss.net/c_prono.asc