Re: Horde 5.2.22 throws error on calendar import.
Jan Schneider <[email protected]>
| Newsgroups | gmane.comp.horde.user |
|---|---|
| Message-ID | <[email protected]> |
pear update horde/horde_db Zitat von [email protected]: > Quoting Jan Schneider <[email protected]>: > >> 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 [email protected]: >> >>> 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@server:~$ >>> Broadcast message from systemd-journald@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@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@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@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@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: [email protected] -- Jan Schneider The Horde Project https://www.horde.org/ -- Horde mailing list Frequently Asked Questions: http://horde.org/faq/ To unsubscribe, mail: [email protected]