6.0.0-beta1
7/7/25

[#12274] Error saving new event IE8
Summary Error saving new event IE8
Queue Kronolith
Queue Version 4.0.4
Type Bug
State No Feedback
Priority 2. Medium
Owners
Requester peo (at) bsdlabs (dot) com
Created 05/25/2013 (4426 days ago)
Due
Updated 06/10/2013 (4410 days ago)
Assigned 05/27/2013 (4424 days ago)
Resolved 06/10/2013 (4410 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch No

History
06/10/2013 11:07:00 AM Jan Schneider State ⇒ No Feedback
 
05/27/2013 06:49:43 PM Jan Schneider Comment #2
State ⇒ Feedback
Reply to this comment
Do you get javascript errors?
05/25/2013 11:42:44 AM peo (at) bsdlabs (dot) com Comment #1
Priority ⇒ 2. Medium
Patch ⇒ No
Milestone ⇒
Queue ⇒ Kronolith
Summary ⇒ Error saving new event IE8
Type ⇒ Bug
State ⇒ Unconfirmed
Reply to this comment
H5 5.0.4
Kronolith 4.04
PostgreSQL
FreeBSD 9-STABLE
PHP 5.4.14

Tried the following versions of Windows/IE
XPsp3/IE8 en_US
W7sp1/IE8 sv_SE

How to repeat

Create a new event throws error message both on screen and in logs

If one clicks the "Map" tab before saving the event there are no errors.
We do not get this error with any other tested browser (FF, Chrome)

System:

pear-1.9.4_1
pear-Auth-1.6.4
pear-Auth_SASL-1.0.6
pear-Cache-1.5.6_1
pear-Console_Table-1.1.4
pear-Crypt_Blowfish-1.1.0.r2
pear-Date-1.4.7
pear-Date_Holidays-0.21.8
pear-Date_Holidays_EnglandWales-0.1.4
pear-Date_Holidays_Germany-0.1.2_1
pear-Date_Holidays_Norway-0.1.2
pear-Date_Holidays_Sweden-0.1.3
pear-File_Find-1.3.1
pear-File_Fstab-2.0.3
pear-HTTP_Request-1.4.4
pear-HTTP_WebDAV_Server-1.0.0.r4
pear-Horde_ActiveSync-2.3.6
pear-Horde_Alarm-2.0.4
pear-Horde_Argv-2.0.7
pear-Horde_Auth-2.0.4
pear-Horde_Autoloader-2.0.1
pear-Horde_Autoloader_Cache-2.0.1
pear-Horde_Browser-2.0.3
pear-Horde_Cache-2.0.4
pear-Horde_Cli-2.0.3
pear-Horde_Compress-2.0.3
pear-Horde_Compress_Fast-1.0.1
pear-Horde_Constraint-2.0.1
pear-Horde_Controller-2.0.1
pear-Horde_Core-2.4.3
pear-Horde_Crypt-2.1.3
pear-Horde_Crypt_Blowfish-1.0.2
pear-Horde_Data-2.0.3
pear-Horde_Date-2.0.4
pear-Horde_Date_Parser-2.0.2
pear-Horde_Db-2.0.2
pear-Horde_Editor-2.0.3
pear-Horde_Exception-2.0.3
pear-Horde_Feed-2.0.1
pear-Horde_Form-2.0.3
pear-Horde_Group-2.0.2
pear-Horde_History-2.0.2
pear-Horde_Http-2.0.2
pear-Horde_Icalendar-2.0.4
pear-Horde_Image-2.0.4
pear-Horde_Imap_Client-2.8.2
pear-Horde_Injector-2.0.1
pear-Horde_Itip-2.0.4
pear-Horde_Ldap-2.0.1
pear-Horde_ListHeaders-1.0.1
pear-Horde_Lock-2.0.2
pear-Horde_Log-2.0.1
pear-Horde_LoginTasks-2.0.2
pear-Horde_Mail-2.0.5
pear-Horde_Memcache-2.0.1
pear-Horde_Mime-2.1.1
pear-Horde_Mime_Viewer-2.0.4
pear-Horde_Nls-2.0.2
pear-Horde_Notification-2.0.1
pear-Horde_Pdf-2.0.3
pear-Horde_Perms-2.1.0
pear-Horde_Prefs-2.3.2
pear-Horde_Rdo-2.0.2
pear-Horde_Role-1.0.1
pear-Horde_Routes-2.0.2
pear-Horde_Rpc-2.0.3
pear-Horde_Secret-2.0.2
pear-Horde_Serialize-2.0.2
pear-Horde_Service_Facebook-2.0.1
pear-Horde_Service_Weather-2.0.1
pear-Horde_SessionHandler-2.0.2
pear-Horde_Share-2.0.3
pear-Horde_SpellChecker-2.1.0
pear-Horde_Stream-1.2.0
pear-Horde_Stream_Filter-2.0.1
pear-Horde_Stream_Wrapper-2.0.1
pear-Horde_Support-2.1.0
pear-Horde_SyncMl-2.0.3
pear-Horde_Template-2.0.1
pear-Horde_Text_Diff-2.0.2
pear-Horde_Text_Filter-2.1.0
pear-Horde_Text_Filter_Csstidy-2.0.1
pear-Horde_Text_Flowed-2.0.1
pear-Horde_Timezone-1.0.2
pear-Horde_Token-2.0.3
pear-Horde_Translation-2.0.1
pear-Horde_Tree-2.0.2
pear-Horde_Url-2.2.0
pear-Horde_Util-2.2.1
pear-Horde_Vfs-2.0.4
pear-Horde_View-2.0.2
pear-Horde_Xml_Element-2.0.1
pear-Horde_Xml_Wbxml-2.0.1
pear-MDB-1.3.0
pear-MDB2-2.5.0.b4
pear-MDB2_Driver_mysql-1.5.0.b4
pear-MDB2_Driver_mysqli-1.5.0.b4
pear-Mail_Mime-1.8.6_1,2
pear-Mail_mimeDecode-1.5.5
pear-Net_DNS2-1.2.5
pear-Net_LDAP-1.1.5_1
pear-Net_SMTP-1.6.1
pear-Net_Sieve-1.3.2
pear-Net_Socket-1.0.10
pear-Net_URL-1.0.15
pear-XML_Parser-1.3.4
pear-XML_Serializer-0.20.2
pear-XML_Util-1.2.1
pear-channel-horde-20120210
pecl-geoip-1.0.8
pecl-imagick-3.1.0.r2_1
pecl-lzf-1.6.2
pecl-memcache-3.0.8
pecl-pdflib-2.1.10
perl-5.12.4_5

Errors in browser:

(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}

In 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"]


Saved Queries