Re: Horde 5.2.22 throws error on calendar import.
Jan Schneider <[email protected]>
| Newsgroups | gmane.comp.horde.user |
|---|---|
| Message-ID | <[email protected]> |
Looks like your Horde_Db package is outdated. 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]