View Issue Details

IDProjectCategoryView StatusLast Update
0001492SOGoBackend Calendarpublic2011-11-14 14:41
Reporterrnaujack Assigned Toludovic  
PrioritynormalSeveritymajorReproducibilityalways
Status resolvedResolutionfixed 
Product Version1.3.9 
Target Version1.3.10Fixed in Version1.3.10 
Summary0001492: missing quote in postgresql while inserting an apointment / task
Description

trying do insert an appointment or a task with an apostrophe like:
i' testing
results in a database error and the task isn't created in the database.
Nov 10 09:52:44 sogod [25947]: <0x0x31f8548[GCSFolder]>
ERROR(-[GCSFolder writeContent:toName:baseVersion:]): cannot insert
content : <PostgreSQL72Exception: 0x320a668> NAME:PostgreSQL72FatalError
REASON:fatal pgsql error (channel=<0x0x31daf08[PostgreSQL72Channel]:
connection=<0x0x31c7268[PGConnection]: connection=0x0x33dcb40>>):
FEHLER: Syntaxfehler bei »m«
ZEILE 7: DESCRIPTION:i\'m testing 2

i've tested it with the webclient and with thunderbird/lightning

TagsNo tags attached.

Activities

wsourdeau

wsourdeau

2011-11-11 09:05

viewer   ~0002986

Did you update sope-gdl1-postgres recently ?

rnaujack

rnaujack

2011-11-11 09:15

reporter   ~0002990

I've installed and updated with yum on centos6 and all sope49-modules are version
4.9-20111029_1664.el6.1.

Should i edit aditional config files after update from 1.3.8 to 1.3.9?

wsourdeau

wsourdeau

2011-11-11 09:18

viewer   ~0002991

You could use the nightly builds for gdl1-postgres: http://inverse.ca/downloads/SOGo/RHEL6/nightly/i386/RPMS/sope49-gdl1-postgresql-4.9-20111111_1664.el6.1.i686.rpm or http://inverse.ca/downloads/SOGo/RHEL6/nightly/x86_64/RPMS/sope49-gdl1-postgresql-4.9-20111111_1664.el6.1.x86_64.rpm

Don't update anything else.

rnaujack

rnaujack

2011-11-11 09:27

reporter   ~0002992

after yum --enablerepo=sogo-nightly-rhel6 update
service sogod restart:

created with thunderbird:
Nov 11 15:25:17 sogod [30186]: [ERROR] <0x01CD0FE8[SOGoTaskObject]:3332410e-e6a1-4226-8c49-b21bf4a5cc9b.ics> write failed: <PostgreSQL72Exception: 0x1c4a2e8> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x1c85d08[PostgreSQL72Channel]: connection=<0x0x1c863a8[PGConnection]: connection=0x0x1c864f0>>): FEHLER: Syntaxfehler bei »testing«
ZEILE 10: DESCRIPTION:i\'testing
^

wsourdeau

wsourdeau

2011-11-11 13:59

viewer   ~0002993

Which version of postgres are you using? I have been testing with 9.1 withouth problems but I guess older version might present this issue...

rnaujack

rnaujack

2011-11-14 03:22

reporter   ~0002996

update to lastet nightly 4.9-20111113_1664 did it.
I'm using CentOS 6 64-bit with postgres 9.1 (postgresql91-server.x86_64 / 9.1.1-1PGDG.rhel6)

now i can write:
i'testing
:)

ludovic

ludovic

2011-11-14 14:41

administrator   ~0003000

That has been fixed.

Issue History

Date Modified Username Field Change
2011-11-11 07:26 rnaujack New Issue
2011-11-11 09:05 wsourdeau Note Added: 0002986
2011-11-11 09:15 rnaujack Note Added: 0002990
2011-11-11 09:17 francis Target Version => 1.3.10
2011-11-11 09:18 wsourdeau Note Added: 0002991
2011-11-11 09:27 rnaujack Note Added: 0002992
2011-11-11 13:59 wsourdeau Note Added: 0002993
2011-11-14 03:22 rnaujack Note Added: 0002996
2011-11-14 14:41 ludovic Note Added: 0003000
2011-11-14 14:41 ludovic Status new => resolved
2011-11-14 14:41 ludovic Fixed in Version => 1.3.10
2011-11-14 14:41 ludovic Resolution open => fixed
2011-11-14 14:41 ludovic Assigned To => ludovic