Jump to content
ryan

Map Marker Map

Recommended Posts

OK, guys.

I've tried to manually execute field creating SQL and what does MySQL said:

"#1214 - The used table type doesn't support FULLTEXT indexes"

All of this because of updateDatabaseSchema function in module. You just have to comment it out (I mean "$this->updateDatabaseSchema($field, $schema);" row in getDatabaseSchema)

Hope I helped to someone :)

P.S. Ryan, I think you should reupload new module version with this bug fixed.

Search tags: Table doesn't exist, mapmarker, new field

Share this post


Link to post
Share on other sites

Sorry about that guys. It turns out that it was trying to execute a query to update the schema of the DB table, before the table existed. The exception interrupted the creation of the field in the DB. I've fixed the issue and posted an update. This applies to new MapMarker fields only, no problem with existing fields (which is why I hadn't noticed). This update should also enable you to delete any fields you created that had this error (you'll want to delete it and re-create it, since it doesn't have a table).  

Regarding the "ENGINE=MYISAM" statement, that should already be getting added by the base Fieldtype.php. In your case, it probably didn't because the field creation process was getting interrupted. But I did double check to be sure:

echo "<pre>";
$ft = $modules->get('FieldtypeMapMarker')
print_r($ft->getDatabaseSchema($fields->get('map'))); 

results in:

Array
(
    [pages_id] => int UNSIGNED NOT NULL
    [data] => VARCHAR(255) NOT NULL DEFAULT ''
    [keys] => Array
        (
            [primary] => PRIMARY KEY (`pages_id`)
            [data] => FULLTEXT KEY `data` (`data`)
            [latlng] => KEY latlng (lat, lng)
            [zoom] => KEY zoom (zoom)
        )
    [xtra] => ENGINE=MyISAM DEFAULT CHARSET=utf8
    [lat] => FLOAT(10,6) NOT NULL DEFAULT 0
    [lng] => FLOAT(10,6) NOT NULL DEFAULT 0
    [status] => TINYINT NOT NULL DEFAULT 0
    [zoom] => TINYINT NOT NULL DEFAULT 0
)
 

Please let me know if you are getting a different result or still needing to specify the engine separately?

  • Like 3

Share this post


Link to post
Share on other sites

Hi,

after installing the module and while I tried to add a field I got this error:

MapMarker: Error geocoding address

Then I assumed the field to my basic-template but when I try to save the page I got this error again and the coordinates aren't saved.

I tried to search for this issue but didn't found anything, but the code where the error comes from:

https://github.com/ryancramerdesign/FieldtypeMapMarker/blob/master/MapMarker.php#L84

I'm using PW Ver. 2.3.0. and the latest Version of this module.

Any ideas?

Greets, Jens alias DV-JF 

Share this post


Link to post
Share on other sites

What address are you attempting to geocode? MapMarker does both server-side and client-side geocoding. When you type something into the address, click anywhere else (outside of the field) and the Javascript geocoder should populate the latitude/longitude. If that is successful, it won't attempt to use the server-side geocoder when you save. You can disable geocoding by checking the box that exists between the address and lat/lng fields. If you only enter latitude/longitude values (whether entering the values directly or dragging the map marker pin), then it will attempt a reverse-geocode, which means it will attempt to find the street address for the coordinates. If you are dealing with an address (or coordinates) that Google Maps doesn't recognize, you may just want to disable the geocoder by unchecking the box. But I get the impression that neither the JS or server-side geocoder is working in your case, and that perhaps Google's geocoding service is blocked for you or something?

Share this post


Link to post
Share on other sites

What address are you attempting to geocode? MapMarker does both server-side and client-side geocoding. When you type something into the address, click anywhere else (outside of the field) and the Javascript geocoder should populate the latitude/longitude.

I can't see any map. After entering a correct cityname and click outside the field nothing happens. Lat and long are blank.

But I get the impression that neither the JS or server-side geocoder is working in your case, and that perhaps Google's geocoding service is blocked for you or something?

That where my thoughts, too, so I checked via chrome if the gmaps  api is working: When I'm open the url to edit the field it there are four requests - all seems to be loaded correctly :

Request URL:http://maps.google.com/maps/api/js?sensor=false
Request Method:GET
Status Code:200 OK
Request URL:http://maps.gstatic.com/intl/de_de/mapfiles/api-3/14/1/main.js
Request Method:GET
Status Code:200 OK
Request URL:http://maps.gstatic.com/cat_js/intl/de_de/mapfiles/api-3/14/1/{common,util,stats}.js
Request Method:GET
Status Code:200 
http://maps.googleapis.com/maps/api/js/AuthenticationService.Authenticate?1shttp://example.com/verwaltung/setup/field/edit?id=112&5e1&callback=_xdc_._opu9sd&token=49333
Request Method:GET
Status Code:200

No Scripts are blocked, tested it on different browsers. Same problem when I enter the lat and long by hand.

Share this post


Link to post
Share on other sites

Is your map field collapsed? There is a known problem with the rendering embedded google maps when they are hidden on page load.

Share this post


Link to post
Share on other sites

Is your map field collapsed? There is a known problem with the rendering embedded google maps when they are hidden on page load.

No, here's a screenshot of how it looks, when I try to save the field...

post-889-0-92001800-1378190869_thumb.jpg

Share this post


Link to post
Share on other sites

Is your map field in a tab other than "content"? This is the same as having the map field collapsed. The Map needs to appear on the main "content" tab. I'm not really sure why, but Google Maps doesn't like being hidden when the page renders. 

 

No, here's a screenshot of how it looks, when I try to save the field...

Attached Thumbnails
 

There is not supposed to be a map on the screenshot you posted. I'm not sure if that's where you are looking for one to appear, but wanted to mention it just in case. Where you will see a map is in your page editor. 

Share this post


Link to post
Share on other sites

Ryan I just pushed a change to the inputMapMarker.js file on github that solves this problem.

Added this inside the InputFieldMarker function:

// added by diogo to solve the problem of maps not rendering correctly in hidden elements
// trigger a resize on the map when either the tab button or the toggle field bar are pressed
$(document).ready(function() {

    // get the tab element where this map is integrated
    $tab = $('#_' + $(map.b).closest('.InputfieldFieldsetTabOpen').attr('id'));
    // get the inputfield where this map is integrated and add the tab to the stack
    $inputFields = $(map.b).closest('.Inputfield').find('.InputfieldStateToggle').add($tab);

    $inputFields.on('click',function(){
        // give it time to open
        window.setTimeout(function(){
            google.maps.event.trigger(map,'resize');
        }, 200);
    });
});
 

I had to put it inside the function, to have the "map" variable in scope. I'm not sure how we could move it outside the function if you don't like it that way.

Also, the 200 value on the setTimeout works for me (it works above 120 but I set it to 200 to be on the safe side), but we can decide on a safer value depending on other's tests.

  • Like 3

Share this post


Link to post
Share on other sites

In hind sight, I'm looking to use this module to get the lat and longs of some address for later display in a map.

However, I have already created the address with just simple text fields like this:

address1

address2

town <- page select

county <-page select (although not needed now as towns are linked to their counties)

PostCode

The user does update these fields through the backend, but a front end template.

Firstly, I'm guess that because of this, it will have to do server side processing ad conversion of the address.

Secondly, I can't change my field types now to map marker type.

I think, in it's simplest terms, I need to get it to take all the address fields, bash them together, process them and then turn them to lat longs.

What's the easier way to do this please.

I'm fairly new and learning....

Share this post


Link to post
Share on other sites

In hind sight, I'm looking to use this module to get the lat and longs of some address for later display in a map.

However, I have already created the address with just simple text fields like this:

address1

address2

town <- page select

county <-page select (although not needed now as towns are linked to their counties)

PostCode

The user does update these fields through the backend, but a front end template.

Firstly, I'm guess that because of this, it will have to do server side processing ad conversion of the address.

Secondly, I can't change my field types now to map marker type.

I think, in it's simplest terms, I need to get it to take all the address fields, bash them together, process them and then turn them to lat longs.

What's the easier way to do this please.

I'm fairly new and learning....

I've solved this, but i'm sure not in the most efficient way.

I've added an additional field to the template called marker and when the address is posted to the original address fields, i get php to bash them together and also post them to the map marker field like this:

 $postcode = $sanitizer->text($input->post->postcode);
 $telephone = $sanitizer->text($input->post->telephone);
 $date = $sanitizer->text($input->post->date) . "12:00:00";
 $town = $sanitizer->text($input->post->town);
 $type = $sanitizer->text($input->post->type);
 $email = $sanitizer->email($input->post->email);


$message = "<blockquote> Excellent news, your sale has been listed. Click <a href=".$config->urls->root."counties>here </a> to view other listings.</blockquote> ";

$sale_category = "1108";

    $p = new Page();
    $p->template = $templates->get("listing");
    $p->parent = $pages->get(1016);
    $p->title = $title;
    $p->address1 = $address1;
    $p->address2 = $address2;
    $p->postcode = $postcode;
    $p->telephone = $telephone;
    $p->sale_category = $sale_category;
    $p->town_select = $town;
    $p->Date = $date;
    $p->email = $email;

 $full_address = " $address1 , $address2 , $postcode " ;
           $p->map->address =$full_address;
           $p->map->zoom = 18;

Share this post


Link to post
Share on other sites

I had a hell of a time getting the map to show up as well, until I realized the Google map API is not compatible with jQuery 1.9.1. I swapped in jQuery 1.7 and suddenly it's Miller time.

Share this post


Link to post
Share on other sites

Davo, what you are doing there looks about right to me. Populating the $p->map->address should trigger the Google Geocoder into action. Just make sure you have a $p->save(); somewhere in there so that the coordinates get saved. 



until I realized the Google map API is not compatible with jQuery 1.9.1

I wonder why this is the case? I wonder if it's jQuery or google maps that's polluting the other (I'm guessing Google Maps). Can it be resolved by using jQuery() rather than $(), or is it something beyond this?

Share this post


Link to post
Share on other sites
    <?php $map = $modules->get('MarkupGoogleMap');
    echo $map->render($page, 'MapMarker', array('height' => '350px'));
    ?>

results in

Error:     Call to a member function render() on a non-object

while the MapMarker field is called 'MapMarker' to keep things simple.... Why?

Share this post


Link to post
Share on other sites

Davo, what you are doing there looks about right to me. Populating the $p->map->address should trigger the Google Geocoder into action. Just make sure you have a $p->save(); somewhere in there so that the coordinates get saved. 

I wonder why this is the case? I wonder if it's jQuery or google maps that's polluting the other (I'm guessing Google Maps). Can it be resolved by using jQuery() rather than $(), or is it something beyond this?

Ryan,

Thank you so much. There is indeed a save module there and I'm really pleased the way the api is working. It's a simple project site i'm working on for listings to help me learn pw. I'm very please how much progress I can make in a very short amount of time.

Thank you.

  • Like 1

Share this post


Link to post
Share on other sites
Error:     Call to a member function render() on a non-object
while the MapMarker field is called 'MapMarker' to keep things simple.... Why?

Your $modules->get('MarkupGoogleMap'); call failed. Chances are you don't have the MarkupGoogleMap module installed or are running an old version of FieldtypeMapMarker. 

Share this post


Link to post
Share on other sites

Nevertheless I have another bothersome issue....

When I add a page with a MapMarker field I need three saves before it actually saves. When I input 'city, state, country' in the MapMarker field and click outside it, the Latitude, Longitude and Zoom fields and the map all appear. Upon save there's a geocode error and the page could not be saved. The MapMarker field is empty. When I enter 'city, state, country' again, it saves without error but without Latitude, Longitude, Zoom and map. Then the MapMarker field remembers the 'city, state, country' info. Only upon a third save (and clicking in and out of the MapMarker field once more) it saves with all info in the right fields and rendered map.

Share this post


Link to post
Share on other sites

Nevertheless I have another bothersome issue....

When I add a page with a MapMarker field I need three saves before it actually saves. When I input 'city, state, country' in the MapMarker field and click outside it, the Latitude, Longitude and Zoom fields and the map all appear. Upon save there's a geocode error and the page could not be saved. The MapMarker field is empty. When I enter 'city, state, country' again, it saves without error but without Latitude, Longitude, Zoom and map. Then the MapMarker field remembers the 'city, state, country' info. Only upon a third save (and clicking in and out of the MapMarker field once more) it saves with all info in the right fields and rendered map.

I'm no expert, but you could try doing what I did a couple of posts above. I bashed my address fields together and let it to geocoding server side.

Share this post


Link to post
Share on other sites

What address are you trying to geocode? I want to try it here just to see if there's something unique about it that might be confusing Google's geocoder. Also, when the JS geocoder runs, it should bypass the server side geocoder unless something changes about the address during the save. If that's not the behavior you are getting, let me know what browser and version you are using \.

Share this post


Link to post
Share on other sites

Trial and error. There was a conflict between two googleapis scripts 'maps/api/js' and 'maps/api/js?v=3'. Seems to work on first geocoding now.

Edit: The error is back....

Enter 'Leipzig, Sachsen, Germany' in the MapMarker address field. Lat and Lng appear automatically when clicking outside address field and the map is rendered correct. On clicking 'publish' I get:

Added page /selectlists/cities/leipzig/
Added page /selectlists/states/sachsen/
Saved Page: /places/leipzig-sachsen-germany/ (4 changes) - Cannot be published until errors are corrected
Error geocoding address

The MapMarker field, Lat and Lng entries and map have disappeared.

I re-enter 'Leipzig, Sachsen, Germany', click outside address field and everything appears again. On 'publish' I get 'Error geocoding address' again but now the MapMarker field entry is still there while Lat and Lng are zero and the map doesn't show. Below the map it says 'over query limit'.

Clicking in and out MapMarker field and publish again finally renders the map.

head_inc has

	<script type="text/javascript" src="<?php echo $config->urls->templates?>scripts/jquery-1.9.1.min.js?>"></script>
	<script type="text/javascript" src="<?php echo $config->urls->templates?>scripts/main.js?>"></script>
	<script type="text/javascript" src="<?php echo $config->urls->modules?>FieldtypeMapMarker/InputfieldMapMarker.js?v=203?>"></script>
	<script type='text/javascript' src='https://maps.googleapis.com/maps/api/js?&sensor=false'></script>

Using Firefox 24.0 on OSX 10.8.5 - ProcessWire 2.3 - MapMarker 2.0.3

Share this post


Link to post
Share on other sites

It sounds like the connection is being blocked server side via a firewall or perhaps limitations imposed on PHP's functions for security. Go ahead and grab the latest update FieldtypeMapMarker/InputfieldMapMarker 2.0.5 which should bypass the need for server-side geocoding in many cases, including yours I think. 

Share this post


Link to post
Share on other sites

Enter address 'city, state, country' in the MapMarker address field. Clicking outside and Lat, Lng and map appear. Upon publish the page is accepted without an error but the MapMarker address, Lat, Lng and map are empty. Entering address again and save publishes successfully.

Share this post


Link to post
Share on other sites

I can't duplicate that here. Are you sure you've got the latest version? Do you have the checkbox checked that is between address and latitude? Try hitting reload once or twice on the page as well, just in case something older is cached. 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • By Gadgetto
      SnipWire - Snipcart integration for ProcessWire
      Snipcart is a powerful 3rd party, developer-first HTML/JavaScript shopping cart platform. SnipWire is the missing link between Snipcart and the content management framework ProcessWire.
      With SnipWire, you can quickly turn any ProcessWire site into a Snipcart online shop. The SnipWire plugin helps you to get your store up and running in no time. Detailed knowledge of the Snipcart system is not required.
      SnipWire is free and open source licensed under Mozilla Public License 2.0! A lot of work and effort has gone into development. It would be nice if you could donate an amount to support further development:

      Status update links (inside this thread) for SnipWire development
      2020-01-21 -- Snipcart v3 - when will the new cart system be implemented? 2020-01-19 -- integrated taxes provider finished (+ very flexible shipping taxes handling) 2020-01-14 -- new date range picker, discount editor, order notifiactions, order statuses, and more ... 2019-11-15 -- orders filter, order details, download + resend invoices, refunds 2019-10-18 -- list filters, REST API improvements, new docs platform, and more ... 2019-08-08 -- dashboard interface, currency selector, managing Orders, Customers and Products, Added a WireTabs, refinded caching behavior 2019-06-15 -- taxes provider, shop templates update, multiCURL implementation, and more ... 2019-06-02 -- FieldtypeSnipWireTaxSelector 2019-05-25 -- SnipWire will be free and open source Plugin Key Features
      Fast and simple store setup Full integration of the Snipcart dashboard into the ProcessWire backend (no need to leave the ProcessWire admin area) Browse and manage orders, customers, discounts, abandoned carts, and more Process refunds and send customer notifications from within the ProcessWire backend Complete Snipcart webhooks integration (all events are hookable via ProcessWire hooks) Integrated taxes provider (which is more flexible then Snipcart own provider) Useful Links
      SnipWire in PW modules directory (alpha version only available via GitHub) SnipWire Docs (please note that the documentation is a work in progress) SnipWire @GitHub (feature requests and suggestions for improvement are welcome - I also accept pull requests) Snipcart Website  
      ---- INITIAL POST FROM 2019-05-25 ----
       
    • By d'Hinnisdaël
      Happy new year, everybody 🥬
      I've been sitting on this Dashboard module I made for a client and finally came around to cleaning it up and releasing it to the wider public. This is how it looks.
      ProcessWire Dashboard

      If anyone is interested in trying this out, please go ahead! I'd love to get some feedback on it. If this proves useful and survives some real-world testing, I'll add this to the module directory.
      Download
      You can find the latest release on Github.
      Documentation
      Check out the documentation to get started. This is where you'll find information about included panel types and configuration options.
      Custom Panels
      My goal was to make it really simple to create custom panels. The easiest way to do that is to use the panel type template and have it render a file in your templates folder. This might be enough for 80% of all use cases. For anything more complex (FormBuilder submissions? Comments? Live chat?), you can add new panel types by creating modules that extend the DashboardPanel base class. Check out the documentation on custom panels or take a look at the HelloWorld panel to get started. I'm happy to merge any user-created modules into the main repo if they might be useful to more than a few people.
       Disclaimer
      This is a pre-release version. Please treat it as such — don't install it on production sites. Just making sure 🍇
      Roadmap
      These are the things I'm looking to implement myself at some point. The wishlist is a lot longer, but those are the 80/20 items that I probably won't regret spending time on.
      Improve documentation & add examples ⚙️ Panel types Google Analytics ⚙️ Add new page  🔥 Drafts 🔥 At a glance / Page counter 404s  Layout options Render multiple tabs per panel panel groups with heading and spacing between ✅ panel wrappers as grid item (e.g. stacked notices) ✅ Admin themes support AdminThemeReno and AdminThemeDefault ✅ Shortcuts panel add a table layout with icon, title & summary ✅ Chart panel add default styles for common chart types ✅ load chart data from JS file (currently passed as PHP array) Collection panel support image columns ✅ add buttons: view all & add new ✅
    • By Robin S
      This module is inspired by and similar to the Template Stubs module. The author of that module has not been active in the PW community for several years now and parts of the code for that module didn't make sense to me, so I decided to create my own module. Auto Template Stubs has only been tested with PhpStorm because that is the IDE that I use.
      Auto Template Stubs
      Automatically creates stub files for templates when fields or fieldgroups are saved.
      Stub files are useful if you are using an IDE (e.g. PhpStorm) that provides code assistance - the stub files let the IDE know what fields exist in each template and what data type each field returns. Depending on your IDE's features you get benefits such as code completion for field names as you type, type inference, inspection, documentation, etc.
      Installation
      Install the Auto Template Stubs module.
      Configuration
      You can change the class name prefix setting in the module config if you like. It's good to use a class name prefix because it reduces the chance that the class name will clash with an existing class name.
      The directory path used to store the stub files is configurable.
      There is a checkbox to manually trigger the regeneration of all stub files if needed.
      Usage
      Add a line near the top of each of your template files to tell your IDE what stub class name to associate with the $page variable within the template file. For example, with the default class name prefix you would add the following line at the top of the home.php template file:
      /** @var tpl_home $page */ Now enjoy code completion, etc, in your IDE.

      Adding data types for non-core Fieldtype modules
      The module includes the data types returned by all the core Fieldtype modules. If you want to add data types returned by one or more non-core Fieldtype modules then you can hook the AutoTemplateStubs::getReturnTypes() method. For example, in /site/ready.php:
      // Add data types for some non-core Fieldtype modules $wire->addHookAfter('AutoTemplateStubs::getReturnTypes', function(HookEvent $event) { $extra_types = [ 'FieldtypeDecimal' => 'string', 'FieldtypeLeafletMapMarker' => 'LeafletMapMarker', 'FieldtypeRepeaterMatrix' => 'RepeaterMatrixPageArray', 'FieldtypeTable' => 'TableRows', ]; $event->return = $event->return + $extra_types; }); Credits
      Inspired by and much credit to the Template Stubs module by mindplay.dk.
       
      https://github.com/Toutouwai/AutoTemplateStubs
      https://modules.processwire.com/modules/auto-template-stubs/
    • By Mike Rockett
      Jumplinks for ProcessWire
      Release: 1.5.60
      Composer: rockett/jumplinks
      ⚠️ NOTICE: 1.5.60 is an important security patch-release for an XSS vulnerability discovered by @phlp. It's HIGHLY RECOMMENDED that all Jumplinks users update to the latest version as soon as possible.
      Jumplinks is an enhanced version of the original ProcessRedirects by Antti Peisa.
      The Process module manages your permanent and temporary redirects (we'll call these "jumplinks" from now on, unless in reference to redirects from another module), useful for when you're migrating over to ProcessWire from another system/platform. Each jumplink supports wildcards, shortening the time needed to create them.
      Unlike similar modules for other platforms, wildcards in Jumplinks are much easier to work with, as Regular Expressions are not fully exposed. Instead, parameters wrapped in curly braces are used - these are described in the documentation.
      Under Development: 2.0, to be powered by FastRoute
      As of version 1.5.0, Jumplinks requires at least ProcessWire 2.6.1 to run.
      View on GitLab
      Download via the Modules Directory
      Read the docs
      Features
      The most prominent features include:
      Basic jumplinks (from one fixed route to another) Parameter-based wildcards with "Smart" equivalents Mapping Collections (for converting ID-based routes to their named-equivalents without the need to create multiple jumplinks) Destination Selectors (for finding and redirecting to pages containing legacy location information) Timed Activation (activate and/or deactivate jumplinks at specific times) 404-Monitor (for creating jumplinks based on 404 hits) Additionally, the following features may come in handy:
      Stale jumplink management Legacy domain support for slow migrations An importer (from CSV or ProcessRedirects) Feedback & Feature Requests
      I’d love to know what you think of this module. Please provide some feedback on the module as a whole, or even regarding smaller things that make it whole. Also, please feel free to submit feature requests and their use-cases.
      Note: Features requested so far have been added to the to-do list, and will be added to 2.0, and not the current dev/master branches.
      Open Source

      Jumplinks is an open-source project, and is free to use. In fact, Jumplinks will always be open-source, and will always remain free to use. Forever. If you would like to support the development of Jumplinks, please consider making a small donation via PayPal.
      Enjoy! 🙂
    • By Robin S
      Add Image URLs
      Allows images/files to be added to Image/File fields by pasting URLs.

      Usage
      Install the Add Image URLs module.
      A "Paste URLs" button will be added to all image and file fields. Use the button to show a textarea where URLs may be pasted, one per line. Images/files are added when the page is saved.
       
      https://github.com/Toutouwai/AddImageUrls
      https://modules.processwire.com/modules/add-image-urls/
×
×
  • Create New...