[Cartoweb-users] Accounting error SQL

[Bruno Friedmann]

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