GMAP (R2) Delete Map

Brandon Plewe
Joined: 26 Apr 2007

GMAP (R2) Delete Map

Posted:17 May 2007 (15:09 UTC)
using bitweaver R2 beta 3/14, GMAP 4/6, Windows 2003 Server, PostGres 8

When I try to delete a map, I get several WSOD's showing SQL syntax errors in bitgmap.php (getTilelayers, getCopyrights, getMarkers). Not sure what the problem is (a database compatibility issue perhaps), but I fixed it by converting the raw joins to INNER JOINS, for example (from getTilelayers):
$query = "SELECT gtl.*, gtk.*
FROM `".BIT_DB_PREFIX."gmaps_tilelayers_keychain` gtk
INNER JOIN `".BIT_DB_PREFIX."gmaps_sets_keychain` gsk on (gtk.`maptype_id` = gsk.`set_id`)
INNER JOIN `".BIT_DB_PREFIX."gmaps_tilelayers` gtl ON ( gtl.`tilelayer_id` = gtk.`tilelayer_id` )
WHERE gsk.`gmap_id` = ? AND gsk.`set_type` = ?";

hope this helps
Will
Joined: 28 Sep 2005

Re: GMAP (R2) Delete Map

Posted:06 Jun 2007 (15:32 UTC)
not sure either - but since gmap is just in alpha I have been tearing up the schema with some impunity. its possible you need to reinstall the package to get it to work. latest version is working for all those parts on a clean install.

Just a word to the wise even though I have made this point on the gmap package already - this package is in early development and big structural changes are still happening - dont build anything you care about with it at this point. But it is fun to test drive.
Will
Joined: 28 Sep 2005

Re: GMAP (R2) Delete Map

Posted:06 Jun 2007 (15:34 UTC)
actually I need to double check delete - thanks for mentioning it!
  Page 1 of 1  1