[kronolith] Internet Explorer issue

[Jan Schneider]

Zitat von Per olof Ljungmark <peo at intersonic.se>:

> Anyone out there using IE8 with success? We seems to have an issue when
> saving a new event.
>
> H5, Kronolith 4.04
> PostgreSQL
>
> The event *is* saved but scares the users of course...
>
> The following error is displayed in the browser when "Save" is clicked:
>
> (60): Horde_Db_Adapter_Base->execute('INSERT into kro...', Array) #2
> /usr/local/www/horde/kronolith/lib/Driver/Sql.php(698):
> Kronolith_Geo_Sql->setLocation('Bktx_Mb3yIwzWyu...', Array) #3
> /usr/local/www/horde/kronolith/lib/Driver.php(356):
> Kronolith_Driver_Sql->_addEvent(Object(Kronolith_Event_Sql)) #4
> /usr/local/www/horde/kronolith/lib/Event.php(583):
> Kronolith_Driver->saveEvent(Object(Kronolith_Event_Sql)) #5
> /usr/local/www/horde/kronolith/lib/Ajax/Application/Handler.php(1428):
> Kronolith_Event->save() #6
> /usr/local/www/horde/kronolith/lib/Ajax/Application/Handler.php(311):
> Kronolith_Ajax_Application_Handler->_saveEvent(Object(Kronolith_Event_Sql))
> #7 [internal function]: Kronolith_Ajax_Application_Handler->saveEvent()
> #8 /usr/local/share/pear/Horde/Core/Ajax/Application.php(155):
> call_user_func(Array) #9 /usr/local/www/horde/services/ajax.php(56):
> Horde_Core_Ajax_Application->doAction() #10 {main} Next exception
> 'Horde_Db_Exception' with message 'SQLSTATE[22P02]: Invalid text
> representation: 7 ERROR: invalid input syntax for integer: "null" LINE
> 1: ...lon, event_zoom, event_id) VALUES('null', 'null', 'null', 'B... ^'
> in /usr/local/share/pear/Horde/Db/Adapter/Base.php:555 Stack trace: #0
> /usr/local/www/horde/kronolith/lib/Geo/Sql.php(60):
> Horde_Db_Adapter_Base->execute('INSERT into kro...', Array) #1
> /usr/local/www/horde/kronolith/lib/Driver/Sql.php(698):
> Kronolith_Geo_Sql->setLocation('Bktx_Mb3yIwzWyu...', Array) #2
> /usr/local/www/horde/kronolith/lib/Driver.php(356):
> Kronolith_Driver_Sql->_addEvent(Object(Kronolith_Event_Sql)) #3
> /usr/local/www/horde/kronolith/lib/Event.php(583):
> Kronolith_Driver->saveEvent(Object(Kronolith_Event_Sql)) #4
> /usr/local/www/horde/kronolith/lib/Ajax/Application/Handler.php(1428):
> Kronolith_Event->save() #5
> /usr/local/www/horde/kronolith/lib/Ajax/Application/Handler.php(311):
> Kronolith_Ajax_Application_Handler->_saveEvent(Object(Kronolith_Event_Sql))
> #6 [internal function]: Kronolith_Ajax_Application_Handler->saveEvent()
> #7 /usr/local/share/pear/Horde/Core/Ajax/Application.php(155):
> call_user_func(Array) #8 /usr/local/www/horde/services/ajax.php(56):
> Horde_Core_Ajax_Application->doAction() #9 {main}
>
>
> This recorded in the horde.log:
>
> May 20 11:06:19 webmail HORDE: [kronolith] SQL QUERY FAILED:
> SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input
> syntax for integer: "null" LINE 1: ...lon, event_zoom, event_id)
> VALUES('null', 'null', 'null', 'F...
>                           ^     INSERT into kronolith_events_geo
> (event_lat, event_lon, event_zoom,       event_id) VALUES('null',
> 'null', 'null', 'F1SM0hW7gOSHTqlzUs2BUw1') [pid 97676 on line 815 of
> "/usr/local/share/pear/Horde/Db/Adapter/Base.php"]
> peo
>
> PGSQL:
>
> postgres[98547]: [2-1] ERROR:  invalid input syntax for integer: "null"
> at character 102
> postgres[98547]: [2-2] STATEMENT:  INSERT into kronolith_events_geo
> (event_lat, event_lon, event_zoom, event_id) VALUES('null', 'null',
> 'null', 'Bktx_Mb3yIwzWyu8dQIvmQ1')

And this only happens with IE8? Doesn't make much sense to me, but  
please create a bug ticket anyway.
-- 
Jan Schneider
The Horde Project
http://www.horde.org/