[kronolith] Internet Explorer issue

Per olof Ljungmark peo at intersonic.se
Mon May 20 09:33:34 UTC 2013


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')


More information about the kronolith mailing list