[Cartoweb-users] recentering syntax-error?

[bram]

Yep! I use version 4.8.1, so I downgraded to 4.6 and everything  works 
fine. This bug would be fixed in the next  mapserver-version to come, I 
read. One more question: how should I rewrite the plugin in order to 
make a search on individual files like shapes or a gml-file? Could I 
find an example somewhere?     


Pierre GIRAUD schreef:

> I imagine you're using a 4.8.x version of mapserver and the problem 
> you encountered is due to a Mapserver bug.
> http://mapserver.gis.umn.edu/bugs/show_bug.cgi?id=1629
>
> If your cartoweb application is hosted on a Debian system, you just 
> have to update the mapscript package with the new patched version 
> proposed by camptocamp.
> http://cartoweb.org/doc/cw3.2/xhtml/appendix.debian_mapserver.html
>
> Regards
>
> Pierre GIRAUD
>
>
>
> bram2006 wrote:
>
>> I tried to resolve the problem by modifying the demoPlugins-project 
>> step by step. I did not change any code. Below is a part of the 
>> mapfile in which I changed the airport layer from a shape into a 
>> postgistable. This postgislayer can be displayed correctly, the  
>> search on aeroportnames works fine, but when recentering there is a 
>> mapservererror. Mapserver takes the 'id_attribute_string' in the 
>> WHERE-clause but the syntax isn't correct. I could'nt figure out 
>> where and how mapserver is told to take this value. Has anyone 
>> succeeded in using a postgislayer together with the 
>> demoLocation-plugin? When I use the aerofacp.shp everything works fine.
>>
>> I also turned magic-quotes on in php.ini, but no result.
>> Bram
>>
>>  LAYER
>>    NAME "airport"
>>    TYPE POINT
>> #  DATA "aerofacp"
>>    TEMPLATE "ttt"
>>    CONNECTIONTYPE POSTGIS
>>    CONNECTION "dbname=demo_plugins host=localhost user=www-data 
>> password=1234 port=5432"
>>    DATA "the_geom from airport as foo using unique ID using SRID=-1"
>>    METADATA
>>      "exported_values" "recenter_name_string,id_attribute_string"
>>      "recenter_name_string" "NAM"
>>      "id_attribute_string" "OGC_FID|string"
>>      "query_returned_attributes" "NAM"
>>    END
>>
>> errorreport:
>>
>> Class : SoapFaultWrapper
>> Message : Mapserver error: Error in msDrawMap(): Failed to draw layer 
>> named 'airport'.
>> Error in prepare_database(): Error executing POSTGIS DECLARE (the 
>> actual query) statement: 'DECLARE mycursor BINARY CURSOR FOR SELECT 
>> OGC_FID::text,NAM::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),ID::text 
>> from airport as foo WHERE (OGC_FID = 'OGC_FID in ('42')') and 
>> (the_geom && setSRID( 'BOX3D(881945.695862477 
>> 5122071.74000373,1040695.61013752 5233196.67999627)'::BOX3D,-1) )' 
>> Postgresql reports the error as 'ERROR:  syntax error at or near "42" 
>> at character 180
>> '
>>
>> ....
>>
>> Backtrace:
>>
>> file: 222 - 
>> C:\wamp06\www\cartoweb3\coreplugins\images\server\ServerImages.php
>> call: ServerContext->checkMsErrors()
>>
>> file: 305 - C:\wamp06\www\cartoweb3\server\Cartoserver.php
>> call: ServerImages->drawMainmap(Object(Images))
>>
>> file: 337 - C:\wamp06\www\cartoweb3\server\Cartoserver.php
>> call: Cartoserver->doGetMap(Object(MapRequest))
>>
>> Alexandre Saunier schreef:
>>
>>> Hello,
>>>
>>> well it seems that Postgres does not appreciate the non-escaped 
>>> quotes in "name = 'name in ('Belgium')'".
>>> I assume that "Belgium" is the recentering query string or something?
>>>
>>> I don't know where this part of the SQL query is built but try to 
>>> addslash() the incoming querystring in your plugin. There's a 
>>> built-in static method available in CW for that: Utils::addslashes() 
>>> => it adds slashes in front of quotes if it as detected that PHP 
>>> magic_quotes are off.
>>>
>>> Anyway your WHERE clause is kinda weird, isn't it? There's probably 
>>> too many "name" in it...
>>>
>>> AS
>>>
>>> bram wrote:
>>>
>>>> Hi list,
>>>>
>>>> I used the demoLocation plugin from the demoPlugins-project in 
>>>> myproject, which  goes fine. But  when  I choose  an item to 
>>>> recenter on  a syntax error occurs.  I  can't imagine there still 
>>>> is a bug somewhere in a script so obviously I'm making a mistake 
>>>> somewhere. I tried other id_attributes_string & string/value 
>>>> combinations. Who knows what's going wrong?
>>>>
>>>> Part of the mapfile:
>>>>
>>>>  CONNECTIONTYPE POSTGIS
>>>>  CONNECTION "dbname=edit_db host=localhost user=www-data 
>>>> password=a123 port=5432"
>>>>  DATA "the_geom from (select the_geom, area, gid, name, oid from 
>>>> countries where name < 'C') as foo2 using unique oid using SRID=-1"
>>>>  METADATA
>>>>        "exported_values" "recenter_name_string,id_attribute_string"
>>>>        "recenter_name_string" "name"
>>>>        "id_attribute_string" "name|string"
>>>>        "query_returned_attributes" "name area"
>>>>
>>>>
>>>> Errorreport:
>>>>
>>>> Error in prepare_database(): Error executing POSTGIS DECLARE (the 
>>>> actual query) statement: 'DECLARE mycursor BINARY CURSOR FOR SELECT 
>>>> name::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),oid::text 
>>>> from (select the_geom, area, gid, name, oid from countries where 
>>>> name < 'C') as foo2 WHERE (name = 'name in ('Belgium')') and 
>>>> (the_geom && setSRID( 'BOX3D(-2843979.38207143 
>>>> -1361319.536,2888428.68507143 2651366.111)'::BOX3D,-1) )' 
>>>> Postgresql reports the error as 'ERROR:  syntax error at or near 
>>>> "Belgium" at character 227
>>>> '
>>>>
>>>> Thanks for help!
>>>>
>>>> Bram
>>>>  
>>>> _______________________________________________
>>>> Cartoweb-users mailing list
>>>> Cartoweb-users at lists.maptools.org
>>>> http://lists.maptools.org/mailman/listinfo/cartoweb-users
>>>
>>>
>>>
>>>
>>
>> _______________________________________________
>> Cartoweb-users mailing list
>> Cartoweb-users at lists.maptools.org
>> http://lists.maptools.org/mailman/listinfo/cartoweb-users
>
>
>
>