[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