[pkg-horde] Bug#653876: DB Error: syntax error [pid 13471 on line 214 of "/usr/share/horde3/lib/Horde/Prefs/sql.php"

[Rainer Dorsch]

Package: horde3
Version: 3.3.8+debian0-2
Severity: normal


I have trouble configuring the Preference System with the sql backend. Essentially the preferences are not saved and each time default preferences are used.

In the horde3.log I entries like

Dec 31 21:40:02 HORDE [error] [horde] Failed checking prefs for Administrator: DB Error: syntax error [pid 1423 on line 214 of "/usr/share/horde3/lib/Horde/Prefs/sql.php"]
Dec 31 21:41:35 HORDE [error] [horde] Failed checking prefs for rd: DB Error: syntax error [pid 13476 on line 214 of "/usr/share/horde3/lib/Horde/Prefs/sql.php"]
Dec 31 21:45:01 HORDE [error] [horde] Failed checking prefs for Administrator: DB Error: syntax error [pid 3879 on line 214 of "/usr/share/horde3/lib/Horde/Prefs/sql.php"]
Dec 31 21:46:37 HORDE [error] [horde] Failed checking prefs for rd: DB Error: syntax error [pid 13471 on line 214 of "/usr/share/horde3/lib/Horde/Prefs/sql.php"]
Dec 31 21:47:17 HORDE [error] [horde] Failed checking prefs for rd: DB Error: syntax error [pid 16213 on line 214 of "/usr/share/horde3/lib/Horde/Prefs/sql.php"]
Dec 31 21:47:22 HORDE [error] [horde] Failed checking prefs for rd: DB Error: syntax error [pid 16213 on line 214 of "/usr/share/horde3/lib/Horde/Prefs/sql.php"]
Dec 31 21:47:47 HORDE [error] [horde] Failed checking prefs for rd: DB Error: syntax error [pid 13472 on line 214 of "/usr/share/horde3/lib/Horde/Prefs/sql.php"]


-- System Information:
Debian Release: 6.0.3
  APT prefers stable
  APT policy: (500, 'stable')
Architecture: i386 (i686)

Kernel: Linux 2.6.18-028stab092.1 (SMP w/2 CPU cores)
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)
Shell: /bin/sh linked to /bin/bash

Versions of packages horde3 depends on:
ii  apache2                2.2.16-6+squeeze4 Apache HTTP Server metapackage
ii  apache2-mpm-prefork [h 2.2.16-6+squeeze4 Apache HTTP Server - traditional n
ii  libapache2-mod-php5    5.3.3-7+squeeze3  server-side, HTML-embedded scripti
ii  libjs-scriptaculous    1.8.3-1           JavaScript library for dynamic web
ii  php-log                1.12.0-1          log module for PEAR
ii  php-mail               1.2.0-2           PHP PEAR module for sending email
ii  php-mail-mime          1.8.0-2           PHP PEAR module for creating MIME 
ii  php5-gd                5.3.3-7+squeeze3  GD module for php5
ii  php5-mcrypt            5.3.3-7+squeeze3  MCrypt module for php5

Versions of packages horde3 recommends:
ii  fckeditor               1:2.6.6-1        rich text format javascript web ed
ii  locales                 2.11.2-10        Embedded GNU C Library: National L
ii  logrotate               3.7.8-6          Log rotation utility
ii  php-date                1.4.7-1          PHP PEAR module for date and time 
ii  php-db                  1.7.13-2         PHP PEAR Database Abstraction Laye
ii  php-file                1.3.0-1          PHP Pear modules for common file a
ii  php-mdb2                2.5.0b2-1        PHP PEAR module to provide a commo
ii  php-mdb2-driver-mysql   1.5.0b2-1        PHP PEAR module to provide a MySQL
ii  php-services-weather    1.4.2-2          acts as an interface to various on
ii  php5-cli                5.3.3-7+squeeze3 command-line interpreter for the p
ii  php5-mysql              5.3.3-7+squeeze3 MySQL module for php5
ii  tinymce2                2.1.3-1          platform independent web based Jav

Versions of packages horde3 suggests:
pn  chora2                <none>             (no description available)
pn  enscript              <none>             (no description available)
ii  gettext               0.18.1.1-3         GNU Internationalization utilities
pn  gollem                <none>             (no description available)
ii  imp4                  4.3.7+debian0-2.1  webmail component for horde framew
pn  kronolith2            <none>             (no description available)
ii  libgeoip1             1.4.7~beta6+dfsg-1 A non-DNS IP-to-country resolver l
pn  libwpd-tools          <none>             (no description available)
pn  mnemo2                <none>             (no description available)
pn  php-net-imap          <none>             (no description available)
pn  php5-auth-pam         <none>             (no description available)
ii  php5-common [php5-mha 5.3.3-7+squeeze3   Common files for packages built fr
pn  ppthtml               <none>             (no description available)
pn  rpm                   <none>             (no description available)
pn  source-highlight      <none>             (no description available)
pn  turba2                <none>             (no description available)
pn  unrtf                 <none>             (no description available)
pn  webcpp                <none>             (no description available)
pn  wv                    <none>             (no description available)
pn  xlhtml                <none>             (no description available)

-- Configuration Files:
/etc/horde/horde3/.htaccess [Errno 13] Permission denied: u'/etc/horde/horde3/.htaccess'
/etc/horde/horde3/conf.php [Errno 13] Permission denied: u'/etc/horde/horde3/conf.php'
/etc/horde/horde3/conf.xml [Errno 13] Permission denied: u'/etc/horde/horde3/conf.xml'
/etc/horde/horde3/hooks.php [Errno 13] Permission denied: u'/etc/horde/horde3/hooks.php'
/etc/horde/horde3/mime_drivers.php [Errno 13] Permission denied: u'/etc/horde/horde3/mime_drivers.php'
/etc/horde/horde3/motd.php [Errno 13] Permission denied: u'/etc/horde/horde3/motd.php'
/etc/horde/horde3/nls.php [Errno 13] Permission denied: u'/etc/horde/horde3/nls.php'
/etc/horde/horde3/prefs.php [Errno 13] Permission denied: u'/etc/horde/horde3/prefs.php'
/etc/horde/horde3/registry.d/README [Errno 13] Permission denied: u'/etc/horde/horde3/registry.d/README'
/etc/horde/horde3/registry.php [Errno 13] Permission denied: u'/etc/horde/horde3/registry.php'

-- no debconf information