[Cartoweb-users] Accounting error SQL

Oliver Christen oliver.christen at camptocamp.com
Wed Jul 2 06:05:55 EDT 2008


"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
> 



More information about the Cartoweb-users mailing list