[SOLVED] Howto use CGGoogleMaps - gives error

[magicpio]

Hi,

I´m unable to create a new map using CGGoogleMaps.
Most likely I make a mistake in properly setting up a map or the permissions.

Whatdid I do?
0) Using CMSMS 1.9.2
1) Installed CGGoogleMaps, CGExtensions, CGSimpleSmarty, JQueryTools; versions as of today.
2) As instructed by the module help I tried to check/set permissions, but I cannot find where. So I continued.
3) I tried to create a new map. I entered a map name. What do I enter/do I need to enter anything in the "settings->descriptions" field? I left it blank for the moment. I did not touch any of the other sections "directions", "advanced", "templates".
4) I hit "submit" and get the following error. It looks as if the database table cannot be created? Due to permission issues?

INSERT cms_module_cggooglemaps (name,owner_id,data) VALUES ('ChezPio',NULL,'a:31:{s:12:\"default_icon\";s:0:\"\";s:4:\"type\";s:6:\"hybrid\";s:5:\"width\";s:3:\"400\";s:6:\"height\";s:3:\"400\";s:12:\"nav_controls\";s:1:\"1\";s:18:\"nav_control_option\";s:7:\"DEFAULT\";s:14:\"scale_controls\";s:1:\"0\";s:9:\"sv_radius\";s:3:\"100\";s:13:\"type_controls\";s:1:\"1\";s:19:\"type_control_option\";s:7:\"DEFAULT\";s:7:\"sidebar\";s:1:\"0\";s:4:\"zoom\";s:1:\"7\";s:11:\"info_window\";s:1:\"1\";s:12:\"info_trigger\";s:5:\"click\";s:16:\"infowindow_width\";s:3:\"250\";s:17:\"infowindow_height\";s:3:\"250\";s:14:\"category_panel\";s:1:\"0\";s:10:\"directions\";s:1:\"1\";s:15:\"directions_dest\";s:6:\"WINDOW\";s:16:\"directions_units\";s:8:\"IMPERIAL\";s:6:\"sensor\";s:1:\"0\";s:14:\"zoom_encompass\";s:1:\"0\";s:14:\"combine_points\";s:1:\"0\";s:13:\"combined_icon\";s:0:\"\";s:11:\"description\";s:0:\"\";s:11:\"sv_controls\";s:1:\"0\";s:14:\"icon_selection\";s:12:\"use_category\";s:10:\"center_lat\";s:0:\"\";s:10:\"center_lon\";s:0:\"\";s:12:\"bounds_fudge\";s:0:\"\";s:19:\"point_combine_fudge\";s:0:\"\";}')
Table 'cms.cms_module_cggooglemaps' doesn't exist



Is there a step by step instruction with example more detailed than the one in the module help? Forum search has only thrown up a way to include GoogleMaps using the embed tag.

Thanks for any support.

Pio

[Kenny McCormick]

I've got the same problem with my installation.
I'm using the latest versions of the module and it's dependencies.
The CMS Made Simple version is 1.9.3, running on Windows Server 2008 R2 with Apache 2.2.17, PHP 5.3.5 and MySQL 5.5.8.

[magicpio]

In the meantime I was able to set the permissions, but the error remained the same. (I tried CMSMS 1.9.3 also and got the same error.)

Then I was adding the database manually, most likely with the wrong types (varchar, int, text), but then the error message at the
end changed to "NULL" is not a valid assignment to (to data).
I´m using XAMPP 1.7.4 btw.

Obviously ID is NULL because I am still unable to add a map. So I copy-pasted the "INSERT" query, set NULL to 1 and added that
manually to the database (via phpmyadmin).

Now I get a bunch of php errors .......

I installed my backup to revert to an unmodified database and did not further experiment ...
Now reflecting on following the {embed} method instead.

[magicpio]

I did not succeed in using CGgoogleMaps Plugin.
After some more reading in the forum I came across the extremely simple solution of using an UDT (user defined tag).

Create a new UDT (in the Admin Menu select Extensions -> User Defined Tags).
Give it a name (I called mine googlemapsudt ).
In the code section of the UDT just copy and paste the html-code, which google maps gives you after you have adjusted your map to show
with proper width height and other parameters.

My code looks like this (just a part of it):
echo '<__iframe width="790" height="500" frameborder="0" scrolling="no" marginheight="0" marginwidth="0" src="http://maps.google.com/maps?f=q&...............

On the page, where you want to show this map, just place the following code in the content section:
{googlemapsudt}

It´s as simple as that!