Hi Luis,<br><br>Thanks for your thoughts - unfortunately it didn't make any difference (anyway logically it shouldn't anyway because they're all in EPSG 27700 and use OIDs as the unique column).<br><br>Interestingly it's very intermittent - I couldn't get the error to occur at all yesterday. I've now created the layers afresh in PostGIS from an entirely different procedure, and it's happening again.
<br><br>It could also be the nature of the layers - I've now filtered out a number of zero length line features, and there may be other topographical errors.<br><br>Cheers,<br>Roland.<br><br><br><br><div><span class="gmail_quote">
On 13/07/06, <b class="gmail_sendername">Luis Treviņo</b> <<a href="mailto:ltrevinoh@gmail.com">ltrevinoh@gmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div><div>Roland,</div>
<div> </div>
<div>Try this on your DATA stmt:</div>
<div> </div>
<div>DATA "<font face="Courier New">geometry from background <font size="2">as foo using unique <gid> using srid=<your srid>"</font></font></div>
<div><font face="Courier New" size="2">just replace the <gid> name with your oid column and put the number of the srid you're using.</font></div>
<div><font face="Courier New" size="2">Hope this helps.</font></div>
<div><font face="Courier New" size="2"></font> </div>
<div><font face="Courier New" size="2">Regards,</font></div>
<div><font face="Courier New" size="2">Luis</font></div>
<div><br><br> </div>
<div><span class="gmail_quote">2006/7/13, Roland Martin <<a href="mailto:roland.w.martin@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">roland.w.martin@gmail.com</a>>:</span>
</div><div><span class="e" id="q_10c685cdd0bcacb6_1"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0px 0px 0px 0.8ex; padding-left: 1ex;">
<div>Hi Luis,<br><br>Thanks for your reply. I don't think that's the problem, but here are some excerpts nonetheless:<br><br><br><span style="font-family: courier new,monospace;"><br> LAYER # this one works
<br> NAME "Contours"<br> GROUP "Height"<br> STATUS OFF<br> CONNECTIONTYPE postgis<br> CONNECTION "dbname=lba user=postgres password=postgres"<br> DATA "geom from height_data"
<br> TYPE LINE<br> LABELITEM "height"<br> CLASS<br> EXPRESSION ('[layer_name]' = 'C900LX000')<br> COLOR 204 51 0<br> LABEL<br> FONT sans<br> SIZE small<br> COLOR 100 100 100
<br> OUTLINECOLOR 255 255 255<br> POSITION auto<br> ANTIALIAS false<br> END<br> END<br> END<br><br> LAYER # this one doesn't<br> NAME "Background Drawing"
<br> GROUP "CAD Drawings"<br> STATUS OFF<br> CONNECTIONTYPE postgis<br> CONNECTION "dbname=lba user=postgres password=postgres"<br> DATA "geometry from background"<br> TYPE LINE
<br> CLASS<br> COLOR 51 102 0<br> END<br> END<br><br></span>The geometry column names are different because I generated the tables from 2 different sources - but that shouldn't make any difference...<br><br>Cheers,
<br> </div>
<div><span>Roland.</span></div>
<div><span><br><br><br><br>
<div><span class="gmail_quote">On 13/07/06, <b class="gmail_sendername">Luis Treviņo</b> <<a href="mailto:ltrevinoh@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">ltrevinoh@gmail.com
</a>> wrote:</span>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
<div>Roland:</div>
<div> </div>
<div>Could be the "DATA" sql statement on your map file. It would be easier if you can show part of your map file that involves the postgis layer.</div>
<div> </div>
<div>Regards,</div>
<div>Luis<br><br> </div>
<div><span class="gmail_quote">2006/7/12, Roland Martin <<a href="mailto:roland.w.martin@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">roland.w.martin@gmail.com</a>>:</span> </div>
<div><span>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0px 0px 0px 0.8ex; padding-left: 1ex;">
<div>OK, this is probably yet another stupid query to which I should know the answer... however, I'm on a roll here.<br><br>I've got an application which is intermittently (i.e. most of the time, but not always) throwing a 500 Internal Server Error. The application is almost a direct clone of another which does not exhibit the same error.
<br><br>I've spent most of the afternoon trying to figure out why this might be, and as far as I can tell, it's something to do with the PostGIS database which holds most of the data. If I remove all the PostGIS layers, it seems to work fine (although interestingly doesn't work if they're all in the map file but turned off - does MapScript try to load the layers regardless?)
<br><br>The database contains converted CAD (DWG) data with typically stupid contents (meaningless fields, escape characters, etc). I wondered if it might be to do with the sizes of the tables (>30 000 records in each), but dissolving them doesn't seem to have made much difference. At the moment I'm leaning towards thinking it may be because of the aforementioned escape characters (looking down the tables, a number just contain the entry " which might upset things; others start with an asterisk). However, some of the tables causing the issue don't contain anything nearly as nasty.
<br><br>The error is being thrown on loading the map; approximately 80-90% of the time.<br><br>Also of interest may be the following gunk from the error logs:<br>[Wed Jul 12 16:29:11 2006] [error] [client x] Premature end of script headers:
php-cgi.exe, referer: <a href="http://x/lbia_dev/" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://x/lbia_dev/</a><br>[Wed Jul 12 16:51:08 2006] [error] [client x] Premature end of script headers:
php-cgi.exe, referer: <a href="http://x/lbia_dev/" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://x/lbia_dev/ </a><br>(etc)<br><br>Anyone have any thoughts on this?<br><br>Ta,<br>Roland.<br>
<br><br>MS4W 2.0<br>MapServer 4.8.3<br>Chameleon for MS4W 2.4<br>PgSQL 8.1<br>etc 1.0<br> </div>
<div><span><br clear="all"><br>-- <br>Please note my new email address. Use other addresses at your peril. </span></div></blockquote></span></div>
<div></div><br> </div></blockquote></div><br><br clear="all"><br>-- <br>Please note my new email address. Use other addresses at your peril. </span></div></blockquote></span></div><div></div><br>
</div></blockquote></div><br><br clear="all"><br>-- <br>Please note my new email address. Use other addresses at your peril.