[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