Bug#350751: horde3: broken preferences storing in postgresql database

[Gregory Colpart]

Hello,

This bug is old, and probably fixed in new versions.
If nobody cries, I will close it soon...

Regards,
-- 
Gregory Colpart   GnuPG:4096R/B8612B5D
Evolix - Informatique et Logiciels Libres http://www.evolix.fr/



-- 
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org

Bug#350751: horde3: broken preferences storing in postgresql database

[Ola Lundqvist]

Hello

On Tue, Jan 31, 2006 at 03:59:43PM +0100, Mariusz Kruk wrote:
> Package: horde3
> Version: 3.0.4-4sarge2
> Severity: normal
> 
> 
> I have a horde3+imp4 setup on apache2+php4.
> I use LDAP to authenticate users and wanted to use postgres database to
> store users' preferences.
> Unfortunately it doesn't seem to work.
> 
> Postgres logs show entries like
> ERROR:  unterminated quoted string at or near "'r" at character 108
> STATEMENT:  INSERT INTO horde_prefs (pref_uid, pref_scope, pref_name, 
> pref_value) VALUES('kruk', 'imp', 'mail_domain', 'r
> 
> I'm using postgresql-8.0 version 8.0.3-15 at the moment.

It looks like it should be '' instead of 'r

I'll see if that is the case and then correct it.
However this will not be fixed for the sarge release as the bug is not
major enough for a sarge update.

It may even have been corrected already in the sid/etch release of the horde
framework.

Regards,

// Ola

> 
> -- System Information:
> Debian Release: 3.1
>   APT prefers testing
>   APT policy: (10, 'testing')
> Architecture: i386 (i686)
> Kernel: Linux 2.6.8-2-686
> Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)
> 
> Versions of packages horde3 depends on:
> ii  apache2  2.0.54-5next generation, scalable, 
> extenda
> ii  apache2-mpm-prefork [httpd]  2.0.54-5traditional model for Apache2
> ii  libapache-mod-php4 [phpapi-2 4:4.3.10-16 server-side, HTML-embedded 
> scripti
> ii  php4 4:4.3.10-16 server-side, HTML-embedded 
> scripti
> ii  php4-cli [phpapi-20020918]   4:4.3.10-16 command-line interpreter for the 
> p
> ii  php4-domxml  4:4.3.10-16 XMLv2 module for php4
> ii  php4-pear4:4.3.10-16 PEAR - PHP Extension and 
> Applicati
> ii  php4-pear-log1.6.0-1.1   Log module for PEAR
> 
> -- no debconf information
> 
> 

-- 
 - Ola Lundqvist ---
/  [EMAIL PROTECTED] Annebergsslingan 37  \
|  [EMAIL PROTECTED] 654 65 KARLSTAD  |
|  +46 (0)54-10 14 30  +46 (0)70-332 1551   |
|  http://www.opal.dhs.org UIN/icq: 4912500 |
\  gpg/f.p.: 7090 A92B 18FE 7994 0C36  4FE4 18A1 B1CF 0FE5 3DD9 /
 ---


-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]

Bug#350751: horde3: broken preferences storing in postgresql database

[Mariusz Kruk]

Package: horde3
Version: 3.0.4-4sarge2
Severity: normal


I have a horde3+imp4 setup on apache2+php4.
I use LDAP to authenticate users and wanted to use postgres database to
store users' preferences.
Unfortunately it doesn't seem to work.

Postgres logs show entries like
ERROR:  unterminated quoted string at or near "'r" at character 108
STATEMENT:  INSERT INTO horde_prefs (pref_uid, pref_scope, pref_name, 
pref_value) VALUES('kruk', 'imp', 'mail_domain', 'r

I'm using postgresql-8.0 version 8.0.3-15 at the moment.


-- System Information:
Debian Release: 3.1
  APT prefers testing
  APT policy: (10, 'testing')
Architecture: i386 (i686)
Kernel: Linux 2.6.8-2-686
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)

Versions of packages horde3 depends on:
ii  apache2  2.0.54-5next generation, scalable, extenda
ii  apache2-mpm-prefork [httpd]  2.0.54-5traditional model for Apache2
ii  libapache-mod-php4 [phpapi-2 4:4.3.10-16 server-side, HTML-embedded scripti
ii  php4 4:4.3.10-16 server-side, HTML-embedded scripti
ii  php4-cli [phpapi-20020918]   4:4.3.10-16 command-line interpreter for the p
ii  php4-domxml  4:4.3.10-16 XMLv2 module for php4
ii  php4-pear4:4.3.10-16 PEAR - PHP Extension and Applicati
ii  php4-pear-log1.6.0-1.1   Log module for PEAR

-- no debconf information


-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]