[horde] Horde 5.2.22 throws error on calendar import.
michael at michaelzfreeman.org
michael at michaelzfreeman.org
Sun Oct 28 16:22:28 UTC 2018
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...', Array, 'event')#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
More information about the horde
mailing list