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 |
State ⇒ Feedback
Priority ⇒ 2. Medium
Patch ⇒ No
Milestone ⇒
Queue ⇒ Kronolith
Summary ⇒ Error saving new event IE8
Type ⇒ Bug
State ⇒ Unconfirmed
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"]