[kronolith] adding an invitation to calendar results in DB error / reusing event_ids as a primary key

[Daniel Eckl]

Hmm, okay, then you have another problem with the same symptom then the
problem I described.

Sorry, got no more clues...

Daniel

Zitat von Bernhard Erdmann <be at berdmann.de>:

> Daniel Eckl wrote:
>> Hi Bernhard!
>>
>> You didn't update the mysql tables through some horde changes.
>>
>> Look at the sql generation scripts and compare the data type of the
>> event_id field with that in your database.
>
>
> Hi Daniel,
>
> the table definitions are the same both in the database and in
> Kronolith's sql script:
>
> -- $Horde: kronolith/scripts/drivers/kronolith.sql,v 1.14 2004/03/12
> 03:23:44 chuck Exp $
>
> CREATE TABLE kronolith_events (
>      event_id VARCHAR(32) NOT NULL,
>      calendar_id VARCHAR(255) NOT NULL,
>      event_creator_id VARCHAR(255) NOT NULL,
>      event_description TEXT,
>      event_location TEXT,
>      event_status INT DEFAULT 0,
>      event_attendees TEXT,
>      event_keywords TEXT,
>      event_exceptions TEXT,
>      event_title VARCHAR(80),
>      event_category VARCHAR(80),
>      event_recurtype VARCHAR(11) DEFAULT 0,
>      event_recurinterval VARCHAR(11),
>      event_recurdays VARCHAR(11),
>      event_recurenddate DATETIME,
>      event_start DATETIME,
>      event_end DATETIME,
>      event_alarm INT DEFAULT 0,
>      event_modified INT NOT NULL,
>
>      PRIMARY KEY (event_id)
> );
> [...]
>
>
> excerpt from mysqldump:
>
> [...]
> -- Table structure for table 'kronolith_events'
> --
>
> DROP TABLE IF EXISTS kronolith_events;
> CREATE TABLE kronolith_events (
>    event_id varchar(32) NOT NULL default '',
>    calendar_id varchar(255) NOT NULL default '',
>    event_creator_id varchar(255) NOT NULL default '',
>    event_description text,
>    event_location text,
>    event_status int(11) default '0',
>    event_attendees text,
>    event_keywords text,
>    event_exceptions text,
>    event_title varchar(80) default NULL,
>    event_category varchar(80) default NULL,
>    event_recurtype varchar(11) default '0',
>    event_recurinterval varchar(11) default NULL,
>    event_recurdays varchar(11) default NULL,
>    event_recurenddate datetime default NULL,
>    event_start datetime default NULL,
>    event_end datetime default NULL,
>    event_alarm int(11) default '0',
>    event_modified int(11) NOT NULL default '0',
>    PRIMARY KEY  (event_id),
>    KEY kronolith_calendar_idx (calendar_id)
> ) TYPE=MyISAM;
> [...]
>
> --
> Kronolith mailing list - Join the hunt: http://horde.org/bounties/#kronolith
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: kronolith-unsubscribe at lists.horde.org