[horde] Horde 5.2.22 throws error on calendar import.

Mon Nov 5 12:45:32 UTC 2018

pear update horde/horde_db

Zitat von michael at michaelzfreeman.org:

> Quoting Jan Schneider <jan at horde.org>:
>
>> Looks like your Horde_Db package is outdated.
>
> OK, thanks. How do I go about updating that ?
>
> I actually ended up using an Android app to copy across events from  
> a synced Google calendar into the default phone calendar which then  
> synced to Horde.
>
> Michael
>
>>
>> Zitat von michael at michaelzfreeman.org:
>>
>>> Hi,
>>>
>>> I validated the vcalendar (ics) file and it passed apart from  
>>> description fields being too long. I truncated those but still got  
>>> the error. I did cut down the the file to a few records. It is a  
>>> large calendar file. That smaller file did import OK but I can't  
>>> see yet where the error creeps in with the full file. As I said I  
>>> used the validator at https://icalendar.org/validator.html ..
>>>
>>> Here are the errors that Horde throws along with some server info  
>>> from "test.php" later on.
>>>
>>> michaelzfreeman at server:~$
>>> Broadcast message from systemd-journald at server (Sun 2018-10-28  
>>> 09:23:49 EDT):
>>>
>>> HORDE[7387]: [kronolith] exception 'Horde_Db_Exception' with  
>>> message 'Parameter count mismatch, expecting 1, got 0' in  
>>> /usr/share/php/Horde/Db/Adapter/Base.php:789
>>> Stack trace:
>>> #0 /usr/share/php/Horde/Db/Adapter/Base.php(822):  
>>> Horde_Db_Adapter_Base->_replaceParameters('SELECT object_i...',  
>>> Array, true)
>>> #1 /usr/share/php/Horde/Db/Adapter/Pdo/Base.php(240):  
>>> Horde_Db_Adapter_Base->_logInfo('SELECT object_i...', Array, NULL,  
>>> 4.1007995605469E-05)
>>> #2 /usr/share/php/Horde/Db/Adapter/Pdo/Base.php(109):  
>>> Horde_Db_Adapter_Pdo_Base->execute('SELECT object_i...', NULL, NULL)
>>> #3  
>>> /var/www/clients/client1/web4/web/content/lib/Objects/Manager.php(179):  
>>> Horde_Db_Adapter_Pdo_Base->selectAll('SELECT object_i...')
>>> #4 /var/www/clients/client1/web4/web/content/lib/Tagger.php(835):  
>>> Content_Objects_Manager->ensureObjects('http://www.time...', 2)
>>> #5 /var/www/clients/client1/web4/web/content/lib/Tagger.php(170):  
>>> Content_Tagger->_ensureObject(Array)
>>> #6 /usr/share/php/Horde/Core/Tagger.php(201):  
>>> Content_Tagger->removeTagFromObject(Array, Array)
>>> #7 /usr/share/php/Horde/Core/Tagger.php(247):  
>>> Horde_Core_Tagger->untag('http://www.time...', Array, 'event')
>>> #8  
>>> /var/www/clients/client1/web4/web/kronolith/lib/Driver.php(607):  
>>> Horde_Core_Tagger->replaceTags('http://www.time...', Array,  
>>> 'michael at michael...', 'event')
>>> #9  
>>> /var/www/clients/client1/web4/web/kronolith/lib/Driver/Sql.php(651):  
>>> Kronolith_Driver->_updateTags(Object(Kronolith_Event_Sql))
>>> #10  
>>> /var/www/clients/client1/web4/web/kronolith/lib/Driver.php(370):  
>>> Kronolith_Driver_Sql->_updateEvent(Object(Kronolith_Event_Sql))
>>> #11  
>>> /var/www/clients/client1/web4/web/kronolith/lib/Event.php(648):  
>>> Kronolith_Driver->saveEvent(Object(Kronolith_Event_Sql))
>>> #12  
>>> /var/www/clients/client1/web4/web/kronolith/lib/Icalendar/Handler/Base.php(103):  
>>> Kronolith_Event->save()
>>> #13  
>>> /var/www/clients/client1/web4/web/kronolith/lib/Icalendar/Handler/Base.php(64):  
>>> Kronolith_Icalendar_Handler_Base->_process()
>>> #14 /var/www/clients/client1/web4/web/kronolith/data.php(203):  
>>> Kronolith_Icalendar_Handler_Base->process()
>>> #15 {main}
>>>
>>> Next exception 'Content_Exception' with message 'Parameter count  
>>> mismatch, expecting 1, got 0' in  
>>> /var/www/clients/client1/web4/web/content/lib/Objects/Manager.php:194
>>> Stack trace:
>>> #0 /var/www/clients/client1/web4/web/content/lib/Tagger.php(835):  
>>> Content_Objects_Manager->ensureObjects('http://www.time...', 2)
>>> #1 /var/www/clients/client1/web4/web/content/lib/Tagger.php(170):  
>>> Content_Tagger->_ensureObject(Array)
>>> #2 /usr/share/php/Horde/Core/Tagger.php(201):  
>>> Content_Tagger->removeTagFromObject(Array, Array)
>>> #3 /usr/share/php/Horde/Core/Tagger.php(247):  
>>> Horde_Core_Tagger->untag('http://www.time...', Array, 'event')
>>> #4  
>>> /var/www/clients/client1/web4/web/kronolith/lib/Driver.php(607):  
>>> Horde_Core_Tagger->replaceTags('http://www.time...', Array,  
>>> 'michael at michael...', 'event')
>>> #5  
>>> /var/www/clients/client1/web4/web/kronolith/lib/Driver/Sql.php(651):  
>>> Kronolith_Driver->_updateTags(Object(Kronolith_Event_Sql))
>>> #6  
>>> /var/www/clients/client1/web4/web/kronolith/lib/Driver.php(370):  
>>> Kronolith_Driver_Sql->_updateEvent(Object(Kronolith_Event_Sql))
>>> #7 /var/www/clients/client1/web4/web/kronolith/lib/Event.php(648):  
>>> Kronolith_Driver->saveEvent(Object(Kronolith_Event_Sql))
>>> #8  
>>> /var/www/clients/client1/web4/web/kronolith/lib/Icalendar/Handler/Base.php(103):  
>>> Kronolith_Event->save()
>>> #9  
>>> /var/www/clients/client1/web4/web/kronolith/lib/Icalendar/Handler/Base.php(64):  
>>> Kronolith_Icalendar_Handler_Base->_process()
>>> #10 /var/www/clients/client1/web4/web/kronolith/data.php(203):  
>>> Kronolith_Icalendar_Handler_Base->process()
>>> #11 {main} [pid 7387 on line 203 of "/usr/share/php/Horde/Core/Tagger.php"]
>>>
>>>
>>> Message from syslogd at server at Oct 28 09:23:49 ...
>>> HORDE: [kronolith] exception 'Horde_Db_Exception' with message  
>>> 'Parameter count mismatch, expecting 1, got 0' in  
>>> /usr/share/php/Horde/Db/Adapter/Base.php:789#012Stack trace:#012#0  
>>> /usr/share/php/Horde/Db/Adapter/Base.php(822):  
>>> Horde_Db_Adapter_Base->_replaceParameters('SELECT object_i...',  
>>> Array, true)#012#1  
>>> /usr/share/php/Horde/Db/Adapter/Pdo/Base.php(240):  
>>> Horde_Db_Adapter_Base->_logInfo('SELECT object_i...', Array, NULL,  
>>> 4.1007995605469E-05)#012#2  
>>> /usr/share/php/Horde/Db/Adapter/Pdo/Base.php(109):  
>>> Horde_Db_Adapter_Pdo_Base->execute('SELECT object_i...', NULL,  
>>> NULL)#012#3  
>>> /var/www/clients/client1/web4/web/content/lib/Objects/Manager.php(179):  
>>> Horde_Db_Adapter_Pdo_Base->selectAll('SELECT object_i...')#012#4  
>>> /var/www/clients/client1/web4/web/content/lib/Tagger.php(835):  
>>> Content_Objects_Manager->ensureObjects('http://www.time...',  
>>> 2)#012#5  
>>> /var/www/clients/client1/web4/web/content/lib/Tagger.php(170):  
>>> Content_Tagger->_ensureObject(Array)#012#6  
>>> /usr/share/php/Horde/Core/Tagger.php(201):  
>>> Content_Tagger->removeTagFromObject(Array, Array)#012#7  
>>> /usr/share/php/Horde/Core/Tagger.php(247):  
>>> Horde_Core_Tagger->untag('http://www.time...', Array,  
>>> 'event')#012#8  
>>> /var/www/clients/client1/web4/web/kronolith/lib/Driver.php(607):  
>>> Horde_Core_Tagger->replaceTags('http://www.time...', Array,  
>>> 'michael at michael...', 'event')#012#9  
>>> /var/www/clients/client1/web4/web/kronolith/lib/Driver/Sql.php(651):  
>>> Kronolith_Driver->_updateTags(Object(Kronolith_Event_Sql))#012#10  
>>> /var/www/clients/client1/web4/web/kronolith/lib/Driver.php(370):  
>>> Kronolith_Driver_Sql->_updateEvent(Object(Kronolith_Event_Sql))#012#11  
>>> /var/www/clients/client1/web4/web/kronolith/lib/Event.php(648):  
>>> Kronolith_Driver->saveEvent(Object(Kronolith_Event_Sql))#012#12  
>>> /var/www/clients/client1/web4/web/kronolith/lib/Icalendar/Handler/Base.php(103): Kronolith_Event->save()#012#13 /var/www/clients/client1/web4/web/kronolith/lib/Icalendar/Handler/Base.php(64): Kronolith_Icalendar_Handler_Base->_process()#012#14 /var/www/clients/client1/web4/web/kronolith/data.php(203): Kronolith_Icalendar_Handler_Base->process()#012#15 {main}#012#012Next exception 'Content_Exception' with message 'Parameter count mismatch, expecting 1, got 0' in /var/www/clients/client1/web4/web/content/lib/Objects/Manager.php:194#012Stack trace:#012#0 /var/www/clients/client1/web4/web/content/lib/Tagger.php(835): Content_Objects_Manager->ensureObjects('http://www.time...', 2)#012#1 /var/www/clients/client1/web4/web/content/lib/Tagger.php(170): Content_Tagger->_ensureObject(Array)#012#2 /usr/share/php/Horde/Core/Tagger.php(201): Content_Tagger->removeTagFromObject(Array, Array)#012#3 /usr/share/php/Horde/Core/Tagger.php(247): Horde_Core_Tagger->untag('http://www.time...', 

>>> Arra
>>> y, 'even
>>> t')#012#4 /var/www/clients/client
>>>
>>>
>>>
>>> Horde Version
>>>
>>>   5.2.20
>>>
>>> Horde Applications
>>>
>>>   Agora [Forums]: unknown
>
>>>   Ansel [Photos]: unknown
>>>   Chora [Version Control]: unknown
>>>   Content: 2.0.6
>>>   Gollem [File Manager]: H5 (3.0.12) (run tests)
>>>   Hermes [Time Tracking]: unknown
>>>   Imp [Mail]: H5 (6.2.22) (run tests)
>>>   Ingo [Filters]: H5 (3.2.16) (run tests)
>>>   Jonah [News]: unknown
>>>   Klutz [Comics]: unknown
>>>   Kolab [Kolab]: unknown
>>>   Kronolith [Calendar]: H5 (4.2.25) (run tests)
>>>   Luxor [X-Ref]: unknown
>>>   Mnemo [Notes]: H5 (4.2.14)
>>>   Nag [Tasks]: H5 (4.2.19)
>>>   Passwd [Password]: unknown
>>>   Sam [Spam]: unknown
>>>   Sesha [Inventory]: unknown
>>>   Timeobjects: 2.1.4
>>>   Trean [Bookmarks]: H5 (1.1.9)
>>>   Turba [Address Book]: H5 (4.2.23) (run tests)
>>>   Ulaform [Forms]: unknown
>>>   Vilma [Mail Admin]: unknown
>>>   Whups [Tickets]: unknown
>>>   Wicked [Wiki]: unknown
>>>
>>> PHP Version
>>>
>>>   View phpinfo() screen
>>>   View loaded extensions
>>>   PHP Version: 5.6.38-2+0~20181015120829.6+stretch~1.gbp567807
>>>   PHP Major Version: 5.6
>>>   PHP Minor Version: 38
>>>   PHP Subminor Version: 2+0~20181015120829.6+stretch~1.gbp567807
>>>   PHP Version Classification: release
>>>   You are running a supported version of PHP.
>>>
>>> PHP Module Capabilities
>>>
>>>   Ctype Support: Yes
>>>   DOM XML Support: Yes
>>>   MIME Magic Support (fileinfo): Yes
>>>   MIME Magic Support (fileinfo) - Configuration: Yes
>>>   FTP Support: Yes
>>>   GD Support: No
>>>   Horde will use the GD extension to perform manipulations on  
>>> image data (compile PHP with --with-gd). It is recommended to use  
>>> the PECL imagick library instead over this extension.
>>>   Gettext Support: Yes
>>>   GeoIP Support (PECL extension): No
>>>   Horde can optionally use the GeoIP extension to provide faster  
>>> country name lookups.
>>>   Hash Support: Yes
>>>   LZ4/LZF Compression Support (PECL extension): No
>>>   If the horde_lz4 or lzf PECL extensions are available, Horde can  
>>> perform real-time compression on cached data to optimize storage  
>>> resources. It is recommended to use horde_lz4, as its compression  
>>> speed is twice as fast as the lzf extension's.
>>>   Iconv Support: Yes
>>>   GNU Iconv Support: Yes
>>>   Internationalization Support: No
>>>   Horde requires the intl extension to handle Internationalized  
>>> Domain Names. Compile PHP with --enable-intl.
>>>   Imagick (PECL extension): Yes
>>>   JSON Support: Yes
>>>   LDAP Support: No
>>>   LDAP support is only required if you want to use an LDAP server  
>>> for anything like authentication, address books, or preference  
>>> storage. Compile PHP with --with-ldap to activate the extension.
>>>   Mbstring Support: Yes
>>>   Memcached Support (PECL extension): Yes
>>>   MongoDB support (PECL extension): No
>>>   If you want to use the MongoDB NoSQL database backend, you must  
>>> install the mongo(db) extension.
>>>   MySQL Support: Yes
>>>   OpenSSL Support: Yes
>>>   PAM Support (PECL extension): No
>>>   The PAM PECL extension is required to allow PAM authentication  
>>> to be used.
>>>   PDO: Yes
>>>   PostgreSQL Support: No
>>>   The PostgreSQL extension is only required if you want to use a  
>>> PostgreSQL database server for data storage.
>>>   Session Support: Yes
>>>   SimpleXML support: Yes
>>>   Tidy support: No
>>>   The tidy PHP extension is used to sanitize HTML data. Compile  
>>> PHP with --with-tidy to activate the extension.
>>>   XML Parser support: Yes
>>>   Zlib Support: Yes
>>>
>>> Miscellaneous PHP Settings
>>>
>>>   allow_url_include disabled: Yes
>>>   magic_quotes_runtime disabled: Yes
>>>   magic_quotes_sybase disabled: Yes
>>>   memory_limit value: 128M
>>>   register_globals disabled: Yes
>>>   safe_mode disabled: Yes
>>>   session.auto_start disabled: Yes
>>>   session.gc_divisor value: 1000
>>>   PHP automatically garbage collects old session information, as  
>>> long as this setting (and session.gc_probability) are set to  
>>> non-zero. It is recommended that this value be "10000" or higher  
>>> (see docs/INSTALL).
>>>   session.gc_probability value: 0
>>>   PHP automatically garbage collects old session information, as  
>>> long as this setting (and session.gc_divisor) are set to non-zero.  
>>> It is recommended that this value be "1". Some distributions may  
>>> implement the garbage collection externally through a cronjob  
>>> though.
>>>   session.use_trans_sid disabled: Yes
>>>   tidy.clean_output disabled: Yes
>>>   zlib.output_compression disabled: Yes
>>>
>>> Required Configuration Files
>>>
>>>   Cannot find PHP command-line binary on your system. Syntax  
>>> checking of configuration files is disabled.
>>>   config/conf.php: Yes
>>>
>>> PHP Sessions
>>>
>>>   Session counter: 15 [refresh the page to increment the counter]
>>>   To unregister the session: click here
>>>
>>> PEAR
>>>
>>>   PEAR Search Path (PHP's include_path):   
>>> /var/www/clients/client1/web4/web/lib:/var/www/clients/client1/web4/web/lib:.:/usr/share/php
>>>   PEAR: Yes
>>>   File_Fstab: No
>>>   Horde requires the File_Fstab package if using the localhost  
>>> driver for the Accounts block.
>>>   Net_DNS2: Yes
>>>   Services_Weather: No
>>>   Services_Weather is used by the METAR weather applet/block on  
>>> the portal page.
>>>   Predis\Client: No
>>>   The Predis library is only needed if you are using a Redis  
>>> server as a hash table backend for caching or sessions. This  
>>> library is provided by the pear.nrk.io PEAR channel.
>>>
>>> File Uploads
>>>
>>>   file_uploads enabled: Yes
>>>   upload_tmp_dir: /var/www/clients/client1/web4/tmp
>>>   upload_max_filesize: 2M
>>>   post_max_size: 8M
>>>   This value should be several times the expect largest upload  
>>> size (notwithstanding any upload limits present in an  
>>> application). Any upload that exceeds this size will cause any  
>>> state information sent along with the uploaded data to be lost.  
>>> This is a PHP limitation and can not be worked around.
>>>
>>> Local File Permissions
>>>
>>>   Is /var/www/clients/client1/web4/web/lib/../static writable by  
>>> the web server user (web4)? Yes
>>>   Is tmpdir /var/www/clients/client1/web4/tmp writable by the web  
>>> server user (web4)? Yes
>>>
>>> Imagick
>>>
>>>   Imagick compiled against current ImageMagick version: Yes
>>>
>>>
>>>
>>> Kronolith Version
>>>
>>>   H5 (4.2.25)
>>>
>>> PHP Version
>>>
>>>   View phpinfo() screen
>>>   View loaded extensions
>>>   PHP Version: 5.6.38-2+0~20181015120829.6+stretch~1.gbp567807
>>>   PHP Major Version: 5.6
>>>   PHP Minor Version: 38
>>>   PHP Subminor Version: 2+0~20181015120829.6+stretch~1.gbp567807
>>>   PHP Version Classification: release
>>>   You are running a supported version of PHP.
>>>
>>> Required Configuration Files
>>>
>>>   Cannot find PHP command-line binary on your system. Syntax  
>>> checking of configuration files is disabled.
>>>   config/conf.php: Yes
>>>   config/prefs.php: Yes
>>>
>>> PHP Sessions
>>>
>>>   Session counter: 14 [refresh the page to increment the counter]
>>>   To unregister the session: click here
>>>
>>> PEAR
>>>
>>>   PEAR Search Path (PHP's include_path):   
>>> /var/www/clients/client1/web4/web/lib:/var/www/clients/client1/web4/web/lib:.:/usr/share/php
>>>   PEAR: Yes
>>>   Date: Yes
>>>   Date_Holidays: No
>>>   Date_Holidays can be used to calculate and display national  
>>> and/or religious holidays.
>>>
>>> Return to Main Horde Test Page
>>>
>>> ---
>>>
>>> Michael Freeman
>>
>>
>>
>> -- 
>> Jan Schneider
>> The Horde Project
>> https://www.horde.org/
>>
>> -- 
>> Horde mailing list
>> Frequently Asked Questions: http://horde.org/faq/
>> To unsubscribe, mail: horde-unsubscribe at lists.horde.org

-- 
Jan Schneider
The Horde Project
https://www.horde.org/