[kronolith] I cannot write new events (HEAD version)

[Jorge Izquierdo]

Hi everybody, I´m still having problems with calendar and some other 
database features with the head version of horde. I´ve browsed my 
database tables and I see one table that is not created by the 
horde/kronolith scripts: horde_categories_seq . Where does this table 
come from???

I have also seen that the creation of the horde_category_attributes 
database does not contain any primary key statement:

  CREATE TABLE horde_category_attributes (
     category_id INT NOT NULL,
     attribute_name VARCHAR(255) NOT NULL,
     attribute_key VARCHAR(255) DEFAULT '' NOT NULL,
     attribute_value TEXT
);

Is this right? I would be very pleased if someone could send me the 
mysql scripts for database creation which works properly with horde and 
kronolith. Is neccesary to have PHP compiled with mcal support although 
I use sql driver? Why the configuration XML asks for the mcal driver 
(mstore) although I´m not using this?

Thanks for your help

Jorge




Jorge Izquierdo escribió:
> I´m getting mad with this problem. I have tested to recreate the horde 
> database with the scripts form the horde and kronolith packages and 
> nothing changed.
> 
> It seems to be obvious that there is some problem to access to save 
> events to the database, but I don´t know what i´m missing. When I 
> install horde with IMP and kronolith, is neccessary to create any group 
> or any permissions set before a user could manage his own calendar and 
> create new events?  Cna anybody send me the exact db creation scripts 
> for a MySQL server to use horde with IMP and kronolith?
> 
> I have foud another problem when trying to create a group. It show my a 
> DB Error:syntax Error, but when I go to groups (and looking on my 
> horde_catagories table I can see the group entry, but I cannot add any 
> user to it.
> 
> Any ideas of what may be happening?????
> 
> Thanks
> 
> Jorge
> 
> 
> 
> 
> 
> 
> 
> Marcus I. Ryan escribió:
> 
>> Jorge,
>>
>> I also noticed you got a "Permission Denied" error.  Have you checked
>> your database to make sure that your database user has permission to
>> add data to the tables, etc.?  You should if you ran the scripts, but
>> it's worth a check.  It might also be worth it to wipe out your
>> kronolith_events table, horde_categories table, and
>> horde_category_attributes table and rebuild them all from the
>> scripts.
>>
>> -- 
>> Marcus I. Ryan, marcus at horde.org
>> -----------------------------------------------------------------------
>>  "Love is a snowmobile racing across the tundra and then suddenly it
>>  flips over, pinning you underneath.  At night, the ice weasels come."
>>                  -- Matt Groening
>> -----------------------------------------------------------------------
>>
>>
>> Quoting Chuck Hagenbuch <chuck at horde.org>:
>>
>>
>>> Quoting Jorge Izquierdo <jizquierdo at sgi.es>:
>>>
>>>
>>>> My horde_category_attributes table is empty, what is this table
>>>
>>>
>>> for?
>>>
>>> Storing the details of shares, permissions, etc. If it's empty,
>>> something is
>>> definitely wrong.
>>>
>>>
>>>>> Because user admin is not part of the IMAP protocol.
>>>>
>>>>
>>>> I don´t know what you mean with these? Is it posible to manage
>>>
>>>
>>> groups
>>>
>>>> with any other user than the admin one? How it would be posible
>>>
>>>
>>> to
>>>
>>>> manage users if I´m using IMP with IMAP to authenticate my users.
>>>
>>>
>>> You can't manage users. You can create groups, permissions, and
>>> assign them to
>>> usernames just like with any other backend.
>>>
>>> -chuck
>>>
>>> -- 
>>> Charles Hagenbuch, <chuck at horde.org>
>>> They're just looking at a wall of meat.
>>>
>>> -- 
>>> Kronolith mailing list
>>> Frequently Asked Questions: http://horde.org/faq/
>>> To unsubscribe, mail: kronolith-unsubscribe at lists.horde.org
>>>
>>>
>>
>>
>>
>>
>>
> 
> 
>