Tickets :: [#8768] SQL error in geo driver

01/13/2010 12:17:45 AM	CVS Commit	Comment #3	Reply to this comment
Changes have been made in Git for this ticket: Fix column names, add index on event_id to the mysql driver also. ~~Bug: 8768~~ create mode 100644 kronolith/scripts/upgrades/2009-12-11_fix_column_names.mysql.sql create mode 100644 kronolith/scripts/upgrades/2009-12-11_fix_column_names.sql http://git.horde.org/diff.php/kronolith/lib/Geo/Mysql.php?rt=horde-git&r1=bd500f2a44bf42cc138465e8600268b4217797e9&r2=fff5441b4c0d3f5bd5685837ab879283013b6371 http://git.horde.org/co.php/kronolith/scripts/upgrades/2009-12-11_fix_column_names.mysql.sql?rt=horde-git&r=fff5441b4c0d3f5bd5685837ab879283013b6371 http://git.horde.org/co.php/kronolith/scripts/upgrades/2009-12-11_fix_column_names.sql?rt=horde-git&r=fff5441b4c0d3f5bd5685837ab879283013b6371

12/12/2009 07:07:35 PM	Michael Rubinsky	State ⇒ Resolved

12/12/2009 07:07:18 PM	CVS Commit	Comment #2	Reply to this comment
Changes have been made in Git for this ticket: Fix column names, add index on event_id to the mysql driver also. ~~Bug: 8768~~ create mode 100644 kronolith/scripts/upgrades/2009-12-11_fix_column_names.mysql.sql create mode 100644 kronolith/scripts/upgrades/2009-12-11_fix_column_names.sql http://git.horde.org/diff.php/kronolith/lib/Geo/Mysql.php?rt=horde-hatchery&r1=bd500f2a44bf42cc138465e8600268b4217797e9&r2=fff5441b4c0d3f5bd5685837ab879283013b6371 http://git.horde.org/co.php/kronolith/scripts/upgrades/2009-12-11_fix_column_names.mysql.sql?rt=horde-hatchery&r=fff5441b4c0d3f5bd5685837ab879283013b6371 http://git.horde.org/co.php/kronolith/scripts/upgrades/2009-12-11_fix_column_names.sql?rt=horde-hatchery&r=fff5441b4c0d3f5bd5685837ab879283013b6371

12/11/2009 03:17:41 PM	Jan Schneider	Comment #1 Priority ⇒ 2. Medium Patch ⇒ No Milestone ⇒ Assigned to Michael Rubinsky Queue ⇒ Kronolith Summary ⇒ SQL error in geo driver Type ⇒ Bug State ⇒ Assigned	Reply to this comment
DB Error: no such field [Zeile 145 von /var/www/html/horde/horde-hatchery/kronolith/lib/Geo/Sql.php] Unfortunately no further details are being logged. This is with the non-spatial support, i.e. on pgsql instead of mysql.