[Tickets #12274] Error saving new event IE8

noreply at bugs.horde.org noreply at bugs.horde.org
Sat May 25 11:42:45 UTC 2013 

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/12274
------------------------------------------------------------------------------
  Ticket             | 12274
  Created By         | peo at bsdlabs.com
  Summary            | Error saving new event IE8
  Queue              | Kronolith
  Version            | 4.0.4
  Type               | Bug
  State              | Unconfirmed
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


peo at bsdlabs.com (2013-05-25 11:42) wrote:

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

More information about the bugs mailing list