[horde] Horde 5.2.22 throws error on calendar import.
Jan Schneider
jan at horde.org
Mon Nov 5 11:47:45 UTC 2018
Looks like your Horde_Db package is outdated.
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/
More information about the horde
mailing list