[kronolith] Deleting event

Serge Grondin SGrondin@csbf.qc.ca
Mon, 10 Dec 2001 13:50:34 -0500


Hi,

This is the configuration I have and I droped and recreated the table.  Same
error.  In the sql script, I deleted the 'DEFAULT NOW()' because it is not
supported with MySql.

$conf['calendar']['driver'] = 'sql';
$conf['calendar']['params'] = array();
$conf['calendar']['params']['phptype'] = 'mysql';
$conf['calendar']['params']['hostspec'] = 'localhost';
$conf['calendar']['params']['username'] = 'hordemgr';
$conf['calendar']['params']['password'] = '********';
$conf['calendar']['params']['database'] = 'horde';
$conf['calendar']['params']['table'] = 'kronolith_events';

Thanks

Jan Schneider a écrit :

> Zitat von Serge Grondin <SGrondin@csbf.qc.ca>:
>
> > Hi,
> >     With the last CVS of kronolith, when I delete an event I have the
> > following error:
> >
> > object(db_error)(10) { ["error_message_prefix"]=> string(0) ""
> > ["error_prepend"]=> string(0) "" ["error_append"]=> string(0) ""
> > ["mode"]=> int(1) ["level"]=> int(1024) ["code"]=> int(-2)
> > ["message"]=>
> > string(22) "DB Error: syntax error" ["debuginfo"]=> string(0) ""
> > ["userinfo"]=> string(154) "DELETE from '.Array['table'].' WHERE
> > event_id = 2 [nativecode=You have an error in your SQL syntax near
> > ''.Array['table'].' WHERE event_id = 2' at line 1]" ["callback"]=> NULL
> > }
>
> what is in your driver array in conf.php?
>
> Jan.
>
> ::::::::::::::::::::::::::::::::::::::::
> AMMMa AG - discover your knowledge
> :::::::::::::::::::::::::::
> Detmolder Str. 25-33 :: D-33604 Bielefeld
> fon +49.521.96878-0 :: fax  +49.521.96878-20
> http://www.ammma.de
> ::::::::::::::::::::::::::::::::::::::::::::::
>
> --
> Kronolith mailing list: http://horde.org/kronolith/
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: kronolith-unsubscribe@lists.horde.org

--
Serge Grondin
Technicien en Informatique
Commission Scolaire des Bois-Francs
Tel. bur.:   (819) 758-6453, poste 2920
e-Mail bur.: SGrondin@csbf.qc.ca
e-Mail per.: sergegro@microtec.net