[mapserver-users] MySQL Join

[Jeff McKenna]

Hello Mike,

This news won't help you, but when I was testing and documenting 
MapServer joins I ran into the same mapserv crash with MySQL 5.1.49 on 
Windows (see the bottom of http://www.mapserver.org/mapfile/join.html); 
but at the time I assumed I was doing something wrong with MySQL.  Or it 
is possible that there is a problem here.  Do others have this same 
problem?  If yes, then we should file a MapServer ticket with a small 
test case.

-jeff


-- 
Jeff McKenna
MapServer Consulting and Training Services
http://www.gatewaygeomatics.com/




On 11-02-18 2:50 PM, Michael Neimeyer wrote:
> Hello all -
>
> I am trying to do a Join from a shapefile to a MySQL table but I am
> getting an internal error.  I am not interested in any spatial
> reference, I just want to link up the shapefile to the MySQL table to
> reference data for the identify service.  One thing I noticed is the
> templates for the JOIN are not being recognized so that might be causing
> an issue.  I don't need to use the JOIN templates as I plan on defining
> the columns in the Metadata reference.
>
> Any idea why the JOIN might not be working for MySQL?  Is there a
> certain version of MySQL that is needed for MapServer?
>
> Thanks for your help!
>
>
> Mike
>