Syntax Error messages in PostgreSQL log

[GoogleCodeExporter]

Hi,

my postgresql log contains many error messages like
2010-06-02 23:09:48 CEST ERROR:  syntax error at or near "WHERE" at
character 86
2010-06-02 23:09:48 CEST STATEMENT:  UPDATE server SET enabled=1, tag='',
category=0, command='S', parent='0', ordre=147% WHERE rec_id='-306536636

I guess that "ordre=147%" is not correct and it should in fact be
"ordre=147", so the dps_snprintf()-statements in sql.c lines 1080 and 1090
should be changed accordingly - "ordre=%d%" probably has to be replaced by
"ordre=%d". I haven't tried that yet and don't know if maybe this behaviour
was intended, but either way postgresql doesn't like it.

Cheers,
- Daniel

Original issue reported on code.google.com by metalcae...@gmail.com on 2 Jun 2010 at 9:26

[GoogleCodeExporter]

Which version of DataparkSearch do you use ?
Obviously it's a mistype, it should be ordre=%d, and there is no such mistype in
latest snapshot of DataparkSearch.

Original comment by dp.max...@gmail.com on 5 Jun 2010 at 11:16

[GoogleCodeExporter]

Hi

I'm sorry I forgot to mention, I'm using Dataparksearch 4.53 (the latest 
release).

Cheers,
- Daniel

Original comment by metalcae...@gmail.com on 5 Jun 2010 at 1:09

[GoogleCodeExporter]

Yes, this problem exist for 4.53 release but already fixed in current snapshot 
of
4.54 version.

Thank you.

Original comment by dp.max...@gmail.com on 5 Jun 2010 at 3:42

• Changed state: Done