[horde] Horde 5.2.22 throws error on calendar import.
michael at michaelzfreeman.org
michael at michaelzfreeman.org
Mon Nov 5 12:39:01 UTC 2018
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
More information about the horde
mailing list