[ms4w-users] the errors of the error log file

[Ilias Petrou]

The sql command executed normally (I think) and showed
the first line of the cities table:


0;0;0;1;1;580;"êëåéþ";300;1000;"01010000207B7F0000000000807CF21A414A0C028B0D9D5041"

 (êëåéù is the name of the city.IN LESVOS island in
greece) 

I copied the part  of the errors file that is about
12:35 the time that I  reloaded FIST with the
public.cities

I also deleted everything about coast ( MAPFILE AND
SITE    CONFIG FILE) in order to concentrate to one
LAYER.

[Tue Mar 21 12:35:20 2006] [error] [client 127.0.0.1]
PHP Warning:  Invalid argument supplied for foreach()
in
C:\\ms4w\\apps\\fist\\htdocs\\classes\\fistConfiguration_class.php
on line 508
[Tue Mar 21 12:35:21 2006] [error] [client 127.0.0.1]
File does not exist: C:/ms4w/Apache/htdocs/favicon.ico
[Tue Mar 21 12:35:21 2006] [error] [client 127.0.0.1]
File does not exist: C:/ms4w/Apache/htdocs/favicon.ico
[Tue Mar 21 12:35:21 2006] [error] [client 127.0.0.1]
File does not exist: C:/ms4w/Apache/htdocs/favicon.ico
[Tue Mar 21 12:35:21 2006] [error] [client 127.0.0.1]
File does not exist: C:/ms4w/Apache/htdocs/favicon.ico
[Tue Mar 21 12:35:21 2006] [error] [client 127.0.0.1]
File does not exist: C:/ms4w/Apache/htdocs/favicon.ico
[Tue Mar 21 12:35:21 2006] [error] [client 127.0.0.1]
File does not exist: C:/ms4w/Apache/htdocs/favicon.ico
[Tue Mar 21 12:35:21 2006] [error] [client 127.0.0.1]
File does not exist: C:/ms4w/Apache/htdocs/favicon.ico
[Tue Mar 21 12:35:21 2006] [error] [client 127.0.0.1]
File does not exist: C:/ms4w/Apache/htdocs/favicon.ico
[Tue Mar 21 12:35:22 2006] [error] [client 127.0.0.1]
File does not exist: C:/ms4w/Apache/htdocs/favicon.ico
[Tue Mar 21 12:35:22 2006] [error] [client 127.0.0.1]
File does not exist: C:/ms4w/Apache/htdocs/favicon.ico
[Tue Mar 21 12:35:22 2006] [error] [client 127.0.0.1]
Directory index forbidden by rule:
C:/ms4w/apps/fist/htdocs/, referer:
http://localhost/fist/fistMap.php?width=724&height=546&cmd=initialrender
[Tue Mar 21 12:35:22 2006] [error] [client 127.0.0.1]
PHP Warning:  [MapServer Error]: prepare_database():
Error executing POSTGIS DECLARE (the actual query)
statement: 'DECLARE mycursor BINARY CURSOR FOR SELECT
cities_::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),OID::text
from public.cities WHERE the_geom &&
setSRID('BOX3D(393378.861924835
4306847.90554,471506.138075165 4365767.09446)'::BOX3D,
find_srid('','public.cities','the_geom') )' <br><br>,
referer: http://localhost/fist/fistMap.php
[Tue Mar 21 12:35:23 2006] [error] [client 127.0.0.1]
, referer: http://localhost/fist/fistMap.php
[Tue Mar 21 12:35:23 2006] [error] [client 127.0.0.1]
Postgresql reports the error as 'ERROR:  column "oid"
does not exist, referer:
http://localhost/fist/fistMap.php
[Tue Mar 21 12:35:23 2006] [error] [client 127.0.0.1]
'<br><br>, referer: http://localhost/fist/fistMap.php
[Tue Mar 21 12:35:23 2006] [error] [client 127.0.0.1]
, referer: http://localhost/fist/fistMap.php
[Tue Mar 21 12:35:23 2006] [error] [client 127.0.0.1]
More Help:<br><br>, referer:
http://localhost/fist/fistMap.php
[Tue Mar 21 12:35:23 2006] [error] [client 127.0.0.1]
, referer: http://localhost/fist/fistMap.php
[Tue Mar 21 12:35:23 2006] [error] [client 127.0.0.1]
Error with POSTGIS data variable. You specified
'&lt;check your .map file&gt;'.<br>, referer:
http://localhost/fist/fistMap.php
[Tue Mar 21 12:35:23 2006] [error] [client 127.0.0.1]
Standard ways of specifiying are : <br>, referer:
http://localhost/fist/fistMap.php
[Tue Mar 21 12:35:23 2006] [error] [client 127.0.0.1]
(1) 'geometry_column from geometry_table' <br>,
referer: http://localhost/fist/fistMap.php
[Tue Mar 21 12:35:23 2006] [error] [client 127.0.0.1]
(2) 'geometry_column from (&lt;sub query&gt;) as foo
using unique &lt;column name&gt; using
SRID=&lt;srid#&gt;' <br><br>, referer:
http://localhost/fist/fistMap.php
[Tue Mar 21 12:35:23 2006] [error] [client 127.0.0.1]
Directory index forbidden by rule:
C:/ms4w/apps/fist/htdocs/, referer:
http://localhost/fist/fistMap.php?width=724&height=546&cmd=initialrender
[Tue Mar 21 12:35:23 2006] [error] [client 127.0.0.1]
, referer: http://localhost/fist/fistMap.php
[Tue Mar 21 12:35:23 2006] [error] [client 127.0.0.1]
Make sure you put in the 'using unique  &lt;column
name&gt;' and 'using SRID=#' clauses in., referer:
http://localhost/fist/fistMap.php
[Tue Mar 21 12:35:23 2006] [error] [client 127.0.0.1]
, referer: http://localhost/fist/fistMap.php
[Tue Mar 21 12:35:23 2006] [error] [client 127.0.0.1]
<br><br>For more help, please see
http://postgis.refractions.net/documentation/ ,
referer: http://localhost/fist/fistMap.php
[Tue Mar 21 12:35:23 2006] [error] [client 127.0.0.1]
, referer: http://localhost/fist/fistMap.php
[Tue Mar 21 12:35:23 2006] [error] [client 127.0.0.1]
<br><br>Mappostgis.c - version of Jan 23/2004.,
referer: http://localhost/fist/fistMap.php
[Tue Mar 21 12:35:24 2006] [error] [client 127.0.0.1]
, referer: http://localhost/fist/fistMap.php
[Tue Mar 21 12:35:24 2006] [error] [client 127.0.0.1] 
in
C:\\ms4w\\apps\\fist\\htdocs\\classes\\fistUMinnMapserverMap_class.php
on line 610, referer:
http://localhost/fist/fistMap.php
[Tue Mar 21 12:35:24 2006] [error] [client 127.0.0.1]
File does not exist: C:/ms4w/Apache/htdocs/favicon.ico
[Tue Mar 21 12:35:24 2006] [error] [client 127.0.0.1]
File does not exist: C:/ms4w/Apache/htdocs/favicon.ico




__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com