postgresql-server-8.2.6-0.1
openSUSE 10.3 64 bits rpm
in the postgresql.conf there
#escape_string_warning = on
It's commented but perharps would say on by default.
Standard log except perharps
log_statement = 'ddl'
Oliver Christen wrote:
> I tried here in a postgres 8.1 with the default log lev
I tried here in a postgres 8.1 with the default log level and couldnt
reproduce the notice you reported.
can you tell me which version of postgres you are using and also which log
level you have defined in postgres ?
Just a little note more
I think to make a patch for this module,
We ne
Just a little note more
I think to make a patch for this module,
We need to abstract the table name in db mode and dr_direct.
For db_direct, is there a .sql somewhere which describe the table structure ?
There's none is head documentation. nor in the default cartoweb cvs.
Bruno Friedmann wrot
Rahh I've found
This is the ligne inserted like found in pg_log.
2008-07-02 14:03:46 CEST cwdev carto_dev LOG: instruction : INSERT INTO
cw_accounting (date, info) VALUES (now(),
'general.client_version=\"1\";general.mapid=\"geojb.geojb\";general.time=\"1215000223\";general.ua=\"Mozilla/5.0
(X
well, the data comes from pretty much every parts of Cartoweb.
all line with $this->account(...) will log data.
I would say simply output in some files the sql generated in Accounting.php
and then search for \
then based on the string being included we can eventually know where it came
from.
I mean there's none of our data inside the table, only the accounting plugin is
writing to it.
After the insert, the data is filtered by postgresql so there's no \r\n inside
the table.
So I must found where the plugin take it's data, and prepare the sql.
So I would check the Accounting.php file
"user or us" ?
im sorry but I dont understand what you mean.
the sql for accounting is in cartoweb3/common/Accounting.php if thats what
you are looking for.
regards
Oliver
Thanks Oliver, i will dump the db it should be easy to find the \r\n into
the sql file.
But also we need to understan
Thanks Oliver, i will dump the db it should be easy to find the \r\n into the
sql file.
But also we need to understand where we can escape properly the string into
accounting plugin
As it is this plugin that lead to this error. And there's no "user or us" data
insert.
Oliver Christen wrote:
>
Hi
it seems to be linked to some backslashs in the data inserted into the
database, usualy when a backslash is present but no special character is
positionned after that. one usual example are file path on windows:
c:\foo\bar
it should be interesting to know what is the string that triggered
Dear CW team,
We encounter a constant log in postgresql server if we activate the accounting
plugin.
This is what we found on the pg log server ( sorry it's french LC )
2008-07-01 15:36:16 CEST cwdev carto_dev ATTENTION: utilisation non standard
d'un échappement dans une chaîne littérale au
c
10 matches
Mail list logo
