[kronolith] Mysql DB Syntax Error

Tyler Giddings tgiddings at us.cyberscience.com
Tue Aug 5 16:58:35 UTC 2008


I noticed the following error in the logs:

> Aug 05 08:07:58 HORDE [error] [kronolith] DB Error: syntax error: SELECT event_id, event_uid, calendar_id, event_description, event_location, event_private, event_status, event_attendees, event_keywords, event_title, event_category, event_recurcount, event_recurtype, event_recurenddate, event_recurinterval, event_recurdays, event_start, event_end, event_alarm, event_modified, event_exceptions, event_creator_id FROM kronolith_events WHERE event_uid = ? AND calendar_id IN (?) [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '? AND calendar_id IN (?)' at line 1] [pid 5923 on line 431 of "/usr/share/horde3/kronolith/lib/Driver/sql.php"]
> Aug 05 08:07:58 HORDE [error] [kronolith] DB Error: syntax error: SELECT event_id, event_uid, calendar_id, event_description, event_location, event_private, event_status, event_attendees, event_keywords, event_title, event_category, event_recurcount, event_recurtype, event_recurenddate, event_recurinterval, event_recurdays, event_start, event_end, event_alarm, event_modified, event_exceptions, event_creator_id FROM kronolith_events WHERE event_uid = ? AND calendar_id IN (?) [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '? AND calendar_id IN (?)' at line 1] [pid 5923 on line 431 of "/usr/share/horde3/kronolith/lib/Driver/sql.php"]

I ran the SQL command directly but removed the WHERE clause and the sql 
worked fine. My configuration for Kronolith is using the SQL driver with 
Horde Defaults. The horde configuration is using the MySQLi driver.

Is this a configuration error? I'll post additional config files if needed.

Thanks,

Tyler Giddings

Horde DB config:

> $conf['sql']['username'] = 'horde';
> $conf['sql']['password'] = 'horde';
> $conf['sql']['protocol'] = 'unix';
> $conf['sql']['database'] = 'horde';
> $conf['sql']['charset'] = 'iso-8859-1';
> $conf['sql']['splitread'] = false;
> $conf['sql']['phptype'] = 'mysqli';


Kronolith config:

> $conf['calendar']['params']['table'] = 'kronolith_events';
> $conf['calendar']['params']['driverconfig'] = 'horde';
> $conf['calendar']['driver'] = 'sql';
> $conf['storage']['default_domain'] = 'us.cyberscience.com';
> $conf['storage']['params']['table'] = 'kronolith_storage';
> $conf['storage']['params']['driverconfig'] = 'horde';
> $conf['storage']['driver'] = 'sql';
> $conf['metadata']['keywords'] = true;
> $conf['reminder']['server_name'] = 'localhost';
> $conf['reminder']['from_addr'] = 'root at us.cyberscience.com';
> $conf['autoshare']['shareperms'] = 'none';
> $conf['holidays']['enable'] = true;
> $conf['menu']['print'] = true;
> $conf['menu']['import_export'] = true;
> $conf['menu']['apps'] = array();




More information about the kronolith mailing list