Tickets :: Comment on [#12274] Error saving new event IE8

* Your Email Address
* Spam protection	Enter the letters below: . .. . .\ /._. \|__\|\| \| \| >< \| \| \|\|___\|/\\|/ \_\|_
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"] > >
Attachment
Watch this ticket

Saved Queries