[kronolith] Unable to insert anything

[Kevin M. Myer]

Hi Sergio,

I just walked through this exact problem on my install.  It turns out that
somewhere along the line, my horde user lost or was never granted privileges to
make changes to the horde database.  Look in the horde/scripts/db directory and
find the "master" sql script for your install.  Find the part that relates to
the horde user access and run that portion from the command line.  For my
install (MySQL), it would look something like this:

mysql mysql (-u <user> -p, if needed)

You should get the mysql command prompt, then enter:

REPLACE INTO db (host, db, user, select_priv, insert_priv, update_priv,
                 delete_priv, create_priv, drop_priv)
    VALUES (
        'localhost',
        'horde',
        'horde',
        'Y', 'Y', 'Y', 'Y',
        'Y', 'Y'
    );
FLUSH PRIVILEGES;

There are some databases that are autocreated if they don't exist - they all
appear to end in *_seq and I had to manually create some of them. 
horde_categories_seq was one of them - I can send you the SQL for that if it
doesn't get created.

After I had made those changes, the undefined index error went away.

Kevin


> ----- Message from scaredda at tiscali.it ---------
>     Date: Fri, 7 Feb 2003 17:38:09 +0100
>     From: Sergio Caredda <scaredda at tiscali.it>
> Reply-To: Sergio Caredda <scaredda at tiscali.it>
>  Subject: [kronolith] Unable to insert anything
>       To: kronolith at lists.horde.org
> 
> I have just installed a brand new cvs version of
> Hord+IMP+Turba+Kronolith+Nag
> 
> When I access the calendar, I get the following line on top of the calendar:
> 
>     Notice: Undefined offset: 1 in
> /home/virtual/site46/fst/var/www/html/webmail/kronolith/lib/Kronolith.php on
> line 1002
> 
> 
> Plus, whenever I try to insert a new meeting, I get a blank page with the
> following error. Any clue why?
> 
> Fatal error: Call to undefined function: haspermission() in
> /home/virtual/site46/fst/var/www/html/webmail/kronolith/lib/Event.php on
> line 237
> 
> I am working on a sql base version, since do not have mcal acces.
> 
> Thanx for your help!
> 
> 
> 
> 
> --
> Kronolith mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: kronolith-unsubscribe at lists.horde.org
> 
> 
> 
> ----- End message from scaredda at tiscali.it -----



-- 
Kevin M. Myer
Systems Administrator
Lancaster-Lebanon Intermediate Unit 13
(717) 560-6140