<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-2" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
it was not fixed in 4.10.1. I do not know about 4.10.2. If you get a
chance to test it, I would like to know if it works. Anyway, I suggest
that you first try changing ServerMapquery.php and check, if this fixes
your error.<br>
<br>
Regards,<br>
Dirk<br>
<br>
<br>
<br>
WochteR wrote:
<blockquote cite="mid:131.110-23139-1749403002-1178785271@seznam.cz"
type="cite">
<pre wrap="">Thank you.
Thus, specification of my versions:
POSTGIS="1.1.0" GEOS="2.2.3-CAPI-1.1.1" PROJ="Rel. 4.5.0, 22 Oct 2006" USE_STATS
But, it seems it is mapserver bug as wrote Dirk.
Will it be better to use latest version of mapserver?
4.10.2 (2007-05-07)
or change the code in
coreplugins\mapquery\server\ServerMapquery.php ?
What is better solution?
wochter
</pre>
<blockquote type="cite">
<pre wrap="">------------ Pôvodná správa ------------
Od: Jacolin Yves <a class="moz-txt-link-rfc2396E" href="mailto:yjacolin@free.fr"><yjacolin@free.fr></a>
Predmet: Re: [Cartoweb-users] calling id_recenter from search plugin
Dátum: 10.5.2007 10:10:16
----------------------------------------
Hi,
You can try this :
psql -d <YourDataBase> -U postgres -c "SELECT postgis_full_version()"
To get your postgis version.
Y.
Le Thursday 10 May 2007 09:41:54 WochteR, vous avez écrit :
</pre>
<blockquote type="cite">
<pre wrap="">Thanx folks,
I have installed:
MapServer version 4.8.1
And I dont know how to check version of postgis.
What version of mapserver and postgis have I install to eliminate this bug?
The last version of mapserver is: 4.10.2 (2007-05-07)
and postgis: [2007/01/11]
Thanx
wochter
</pre>
<blockquote type="cite">
<pre wrap="">------------ Pôvodná správa ------------
Od: Dirk Jesko <a class="moz-txt-link-rfc2396E" href="mailto:ml.dje@geocontent.de"><ml.dje@geocontent.de></a>
Predmet: Re: [Cartoweb-users] calling id_recenter from search plugin
Dátum: 10.5.2007 08:51:38
----------------------------------------
Hi,
sounds like the same problem I had. If it is the same, it is a bug in
mapserver version 4.10 and possibly some 4.8. Have a look at the
attached ServerMapquery.php. I added some quotes in line 179 which
solved the problem. Try changing your
coreplugins\mapquery\server\ServerMapquery.php.
Regards,
Dirk
WochteR wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Hi,
I have troubles with recentering an object.
Plugin search works fine, but when I clicked on result I obtain this
issue:
Failure
Class : SoapFaultWrapper
Message : MapServer error: Error in msDrawMap(): Failed to draw layer
named
</pre>
</blockquote>
<pre wrap="">'zastavba'.
</pre>
<blockquote type="cite">
<pre wrap="">Error in prepare_database(): Error executing POSTGIS DECLARE (the
actual
</pre>
</blockquote>
<pre wrap="">query) statement: 'DECLARE mycursor BINARY CURSOR FOR SELECT
vyznamnost::text,gid::text,asbinary(force_collection(force_2d(the_geom)),
'NDR'),gid::text from kzarovce_zastavba WHERE (gid = 'gid IN (620)') and
(the_geom && setSRID( 'BOX3D(-469330.214285714 -1273120,-464958.785714286
-1270060)'::BOX3D,find_srid('','kzarovce_zastavba','the_geom') ))'
</pre>
<blockquote type="cite">
<pre wrap="">Postgresql reports the error as 'ERROR: invalid input syntax for
integer:
</pre>
</blockquote>
<pre wrap="">"gid IN (620)"
</pre>
<blockquote type="cite">
<pre wrap="">'
More Help:
Error with POSTGIS data variable. You specified '<check your .map
file>'. Standard ways of specifiying are :
(1) 'geometry_column from geometry_table'
(2) 'geometry_column from (<sub query>) as foo using unique <column
name>
</pre>
</blockquote>
<pre wrap="">using SRID=<srid#>'
</pre>
<blockquote type="cite">
<pre wrap="">Make sure you put in the 'using unique <column name>' and 'using
SRID=#'
</pre>
</blockquote>
<pre wrap="">clauses in.
</pre>
<blockquote type="cite">
<pre wrap="">--------------------------
It is very mysterious, because on my laptop it works good.
This issue is displayed from server where I moved working cartoweb
project. Need I change anything in php.ini or something else?
I don't know what to do...
Thanx for advice
wochter
_______________________________________________
Cartoweb-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Cartoweb-users@lists.maptools.org">Cartoweb-users@lists.maptools.org</a>
<a class="moz-txt-link-freetext" href="http://lists.maptools.org/mailman/listinfo/cartoweb-users">http://lists.maptools.org/mailman/listinfo/cartoweb-users</a>
</pre>
</blockquote>
</blockquote>
<pre wrap="">_______________________________________________
Cartoweb-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Cartoweb-users@lists.maptools.org">Cartoweb-users@lists.maptools.org</a>
<a class="moz-txt-link-freetext" href="http://lists.maptools.org/mailman/listinfo/cartoweb-users">http://lists.maptools.org/mailman/listinfo/cartoweb-users</a>
</pre>
</blockquote>
<pre wrap="">
--
Yves Jacolin
---
<a class="moz-txt-link-freetext" href="http://softlibre.gloobe.org">http://softlibre.gloobe.org</a>
_______________________________________________
Cartoweb-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Cartoweb-users@lists.maptools.org">Cartoweb-users@lists.maptools.org</a>
<a class="moz-txt-link-freetext" href="http://lists.maptools.org/mailman/listinfo/cartoweb-users">http://lists.maptools.org/mailman/listinfo/cartoweb-users</a>
</pre>
</blockquote>
<pre wrap=""><!---->
_______________________________________________
Cartoweb-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Cartoweb-users@lists.maptools.org">Cartoweb-users@lists.maptools.org</a>
<a class="moz-txt-link-freetext" href="http://lists.maptools.org/mailman/listinfo/cartoweb-users">http://lists.maptools.org/mailman/listinfo/cartoweb-users</a>
</pre>
</blockquote>
</body>
</html>