[Cartoweb-users] Accounting error SQL

[Oliver Christen]

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.

Sylvain is not available at the moment.

regards
Oliver

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 if I found something.

Perharps Sylvain has a more precise id ?


Oliver Christen wrote:
> "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 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 that
>>> postgres notice, maybe you can log that too ?
>>>
>>> that's all I can say based on the message
>>>
>>> regards
>>> Oliver
>>>
>>>> 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
>>>> caractère 55
>>>> 2008-07-01 15:36:16 CEST cwdev carto_dev ASTUCE :  Utilisez la syntaxe
>>>> de la chaîne d'échappement pour les échappements,
>>>> c'est-à-dire E'\r\n'.
>>>>
>>>> I've try to see where it could be in the source but doesn't found
>>>> someting.
>>>>
>>>> If you could drive me where to search.
>>>>
>>>> -- 
>>>>
>>>>     Bruno Friedmann
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> Cartoweb-users mailing list
>>>> Cartoweb-users at lists.maptools.org
>>>> http://lists.maptools.org/mailman/listinfo/cartoweb-users
>>>>
>>>
>>
>>
>> -- 
>>
>>     Bruno Friedmann
>>
>> Ioda-Net Sàrl   - www.ioda-net.ch
>>  2830 Vellerat - Switzerland
>>
>>  Tél : ++41 32 435 7171
>>  Fax : ++41 32 435 7172
>>  gsm : ++41 78 802 6760
>>
>> C'est Facile et Cool d'Évoluer en ligne : www.cfcel.com
>>
>>
>> _______________________________________________
>> Cartoweb-users mailing list
>> Cartoweb-users at lists.maptools.org
>> http://lists.maptools.org/mailman/listinfo/cartoweb-users
>>
>


-- 

     Bruno Friedmann

Ioda-Net Sàrl   - www.ioda-net.ch
  2830 Vellerat - Switzerland

  Tél : ++41 32 435 7171
  Fax : ++41 32 435 7172
  gsm : ++41 78 802 6760

C'est Facile et Cool d'Évoluer en ligne : www.cfcel.com