CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • GoogleMaps Geocoding failed
Pages: [1] 2

Author Topic: GoogleMaps Geocoding failed  (Read 5797 times)

SemperFi

  • I post frequently
  • ***
  • Posts: 177
  • Karma: 3
  • CiviCRM version: 4.5.4
  • CMS version: Wordpress 4.0.1
  • MySQL version: MySQL 5.5.16
  • PHP version: PHP 5.3.17
GoogleMaps Geocoding failed
September 12, 2012, 02:54:34 pm
Hello !!
We cannot modify anymore the address fields, or add new adresses to a contact.
Each time we save the modifications, we receive the following message :
Quote
Sorry but we are not able to provide this at the moment.
Geocoding failed. Message from Google:
Message d'erreur détaillé
Code d'erreur: OVER_QUERY_LIMIT
Here is the error detailled message :
Code: [Select]
#0 /sites/all/modules/civicrm/CRM/Core/Error.php(293): CRM_Core_Error::backtrace()
#1 /sites/all/modules/civicrm/CRM/Utils/Geocode/Google.php(150): CRM_Core_Error::fatal("Geocoding failed. Message from Google: ", Object(SimpleXMLElement))
#2 /sites/all/modules/civicrm/CRM/Core/BAO/Address.php(406) : eval()'d code(1): CRM_Utils_Geocode_Google::format((Array:16))
#3 /sites/all/modules/civicrm/CRM/Core/BAO/Address.php(406): eval()
#4 /sites/all/modules/civicrm/CRM/Core/BAO/Address.php(155): CRM_Core_BAO_Address::fixAddress((Array:16))
#5 /sites/all/modules/civicrm/CRM/Core/BAO/Address.php(132): CRM_Core_BAO_Address::add((Array:16), TRUE)
#6 /sites/all/modules/civicrm/CRM/Core/BAO/Location.php(69): CRM_Core_BAO_Address::create((Array:117), TRUE, NULL)
#7 /sites/all/modules/civicrm/CRM/Contact/BAO/Contact.php(325): CRM_Core_BAO_Location::create((Array:117), TRUE)
#8 /sites/all/modules/civicrm/CRM/Contact/Form/Contact.php(921): CRM_Contact_BAO_Contact::create((Array:117), TRUE, FALSE, TRUE)
#9 /sites/all/modules/civicrm/CRM/Core/Form.php(246): CRM_Contact_Form_Contact->postProcess()
#10 /sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Upload.php(151): CRM_Core_Form->mainProcess()
#11 /sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Upload.php(128): CRM_Core_QuickForm_Action_Upload->realPerform(Object(CRM_Contact_Form_Contact), "upload")
#12 /sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Upload->perform(Object(CRM_Contact_Form_Contact), "upload")
#13 /sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Contact_Form_Contact), "upload")
#14 /sites/all/modules/civicrm/CRM/Core/Controller.php(289): HTML_QuickForm_Page->handle("upload")
#15 /sites/all/modules/civicrm/CRM/Utils/Wrapper.php(115): CRM_Core_Controller->run()
#16 /sites/all/modules/civicrm/CRM/Core/Invoke.php(193): CRM_Utils_Wrapper->run("CRM_Contact_Form_Contact", "Nouveau contact", (Array:1))
#17 /sites/all/modules/civicrm/drupal/civicrm.module(500): CRM_Core_Invoke::invoke((Array:3))
#18 [internal function](): civicrm_invoke("contact", "add")
#19 /includes/menu.inc(516): call_user_func_array("civicrm_invoke", (Array:2))
#20 /index.php(21): menu_execute_active_handler()
#21 {main}
Referring to the wiki page : http://wiki.civicrm.org/confluence/display/CRMDOC42/Mapping+and+Geocoding, I went to the Google Page to get a new API key => http://www.google.com/apis/maps/signup.html, but apparently the service has changed. I t no longer provides API Key.

How do I get it back to work ?
Thanks in advance

« Last Edit: September 12, 2012, 03:02:02 pm by SemperFi »

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: GoogleMaps Geocoding failed
September 13, 2012, 05:12:09 pm
Apparently your site usage is "over limit" for the Google Maps API. (https://developers.google.com/maps/documentation/javascript/usage#usage_limits) - which seems a bit surprising (they allow 25,000 map loads a day).

If you're sure that's not the issue - then it may be compatibility between the older version of Civ that you're using and the current Google API. In that case, try upgrading CiviCRM. If that's not possible, you can disable for now Geocoding from Administer > System Settings > Mapping and Geocoding. This should allow you to once again update and add addresses.
Protect your investment in CiviCRM by  becoming a Member!

SemperFi

  • I post frequently
  • ***
  • Posts: 177
  • Karma: 3
  • CiviCRM version: 4.5.4
  • CMS version: Wordpress 4.0.1
  • MySQL version: MySQL 5.5.16
  • PHP version: PHP 5.3.17
Re: GoogleMaps Geocoding failed
September 14, 2012, 12:09:55 am
Hello Dave,
Thanks for your answer. The "over limit" alert is not the issue as we didn't load 25,000 maps :)
I'm running the last 4.2.1 version of civicrm and already desactivate the Geocoding options to be able to modifiy and add addresses.
SHould I ask for a new key ?
Thanks

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: GoogleMaps Geocoding failed
September 14, 2012, 11:45:51 am
You can check the code and see if you can re-enable sending a key now that the newest version of Google's API is accepts (but doesn't require) a Maps API Console key. If so, you can request a key and see if that helps. I'm not sure why you're getting that error - unless Google is tracking based on IP range or ????
Protect your investment in CiviCRM by  becoming a Member!

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: GoogleMaps Geocoding failed
September 14, 2012, 12:05:26 pm
I've filed an issue to potentially look at re-enabling the key during our code sprints next week and following week. If you make progress on this please comment on the issue tracker: http://issues.civicrm.org/jira/browse/CRM-10820
Protect your investment in CiviCRM by  becoming a Member!

SemperFi

  • I post frequently
  • ***
  • Posts: 177
  • Karma: 3
  • CiviCRM version: 4.5.4
  • CMS version: Wordpress 4.0.1
  • MySQL version: MySQL 5.5.16
  • PHP version: PHP 5.3.17
Re: GoogleMaps Geocoding failed
September 17, 2012, 05:35:17 am
Hello
I asked for a new key (Google Maps API v3), activate the service on Google side and put the provided key (Key for browser apps) in the "Map Provider Key" field of CiviCRM without selecting any provider (this field disappear when I select Google) - same for the "Geo Provider Key" field.
It doesn't work.
I tried to select GoogleMaps for "Map provider" and "Geo provider" and I got the same issue. It seems that geocoding is not working, whereas GMaps localization has always been working.
Any idea ?
Thanks
« Last Edit: September 17, 2012, 05:51:48 am by SemperFi »

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: GoogleMaps Geocoding failed
September 17, 2012, 07:00:43 am

I suspect you will need to modify the code to add the google maps key. We eliminated this for maps api v3 when it was not required etc

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

SemperFi

  • I post frequently
  • ***
  • Posts: 177
  • Karma: 3
  • CiviCRM version: 4.5.4
  • CMS version: Wordpress 4.0.1
  • MySQL version: MySQL 5.5.16
  • PHP version: PHP 5.3.17
Re: GoogleMaps Geocoding failed
September 17, 2012, 08:35:59 am
Thanks lobo !
I understood for maps api v3 and I'm ok not to use the key.
But why isn't it working when I choose "Google" as GeoProvider and MapProvider, leaving the "key" fields blanks ?

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: GoogleMaps Geocoding failed
September 17, 2012, 12:18:11 pm

we are using google on civicrm.org for mapping and geocoding and it seems to be working fine.

sorry, cant help you out much here

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

SemperFi

  • I post frequently
  • ***
  • Posts: 177
  • Karma: 3
  • CiviCRM version: 4.5.4
  • CMS version: Wordpress 4.0.1
  • MySQL version: MySQL 5.5.16
  • PHP version: PHP 5.3.17
Re: GoogleMaps Geocoding failed
October 03, 2012, 08:20:29 am
FYI - I migrated to CiviCRM 4.2.2 and the problem seems to be solved.
Thanks

The Next Wave

  • I post occasionally
  • **
  • Posts: 111
  • Karma: -9
  • I'm just here to change the world.
  • CiviCRM version: 4.4.4
  • CMS version: Wordpress 3.8.1
  • MySQL version: 5.1.72-cll
  • PHP version: 5.4.25
Re: GoogleMaps Geocoding failed
July 04, 2013, 07:05:22 am
Settings: Parameters raw (from db settings):
geocoding=1
parse=1
start=1
end=100000
throttle=1

I get Finished execution of Geocode and Parse Addresses with result: Failure, Error message: A fatal error was triggered: Geocoding failed. Message from Google: OVER_QUERY_LIMIT

What is the query limit?
I started this to run last night- and it never seemed to complete.
It did say: Starting execution of Geocode and Parse Addresses
How long do 100,000 records take?

awasson

  • I post frequently
  • ***
  • Posts: 230
  • Karma: 7
  • Living in a world of Drupal / CiviCRM
    • My Company: Luna Design
  • CiviCRM version: Latest
  • CMS version: Drupal 6/7/8
  • MySQL version: 5.x
  • PHP version: 5.3.x
Re: GoogleMaps Geocoding failed
October 01, 2013, 06:10:35 pm
I'd like to re-open this issue. All of my CiviCRM 4.3.5 are having the same issue and there is no way they are close to the limit. I doubt that many people are actively geocoding their contacts because it's turned off in scheduled jobs but if I run the job it fails with:

Finished execution of Geocode and Parse Addresses with result: Failure, Error message: A fatal error was triggered: Geocoding failed. Message from Google: OVER_QUERY_LIMIT

Same response from three sites I've checked.

Found it in the issue queue: http://issues.civicrm.org/jira/browse/CRM-10783

« Last Edit: October 01, 2013, 06:12:36 pm by awasson »
My CiviCRM Extension Workshop: https://github.com/awasson

The Next Wave

  • I post occasionally
  • **
  • Posts: 111
  • Karma: -9
  • I'm just here to change the world.
  • CiviCRM version: 4.4.4
  • CMS version: Wordpress 3.8.1
  • MySQL version: 5.1.72-cll
  • PHP version: 5.4.25
Re: GoogleMaps Geocoding failed
October 01, 2013, 07:11:34 pm
The limit is something like 2500 addresses. We went and paid for a service to do the initial code- reimported- and then- no more problems.
Problem is- I can't remember what service it was. Paid about $100 for 100,000 addresses to be coded.

awasson

  • I post frequently
  • ***
  • Posts: 230
  • Karma: 7
  • Living in a world of Drupal / CiviCRM
    • My Company: Luna Design
  • CiviCRM version: Latest
  • CMS version: Drupal 6/7/8
  • MySQL version: 5.x
  • PHP version: 5.3.x
Re: GoogleMaps Geocoding failed
October 01, 2013, 09:27:19 pm
Thanks for the reply. I changed geocoding from Google to Yahoo and low and behold it worked. There are less than 2000 contacts to Geocode in the site I've been working on for this issue and it seems to have worked out just fine as a job for Yahoo.

The process took about 15 minutes to complete on Yahoo whereas Google threw the error immediately so I think it's probably a bug the way the GMap is being accessed somewhere.
My CiviCRM Extension Workshop: https://github.com/awasson

Luciano S.

  • I post occasionally
  • **
  • Posts: 83
  • Karma: 2
  • iXiam Team Leader
  • CiviCRM version: 4.2+ / 4.3+ / 4.4+
  • CMS version: Drupal
  • MySQL version: 5.1+ / 5.5+
  • PHP version: 5.3+ / 5.4+
Re: GoogleMaps Geocoding failed
December 13, 2013, 01:13:55 am
I'm running in the same problem in a fresh CiviCRM DB with 30.000 contacts.
I want to schedule the geocoder job to gradually parse all the contacts, but if I'm not wrong the Job has not any parameter to set the limit of the addresses to parse per execution.

I think a parameter limit (which limits the results of the sql query of addresses to parse) would be the solution
Pages: [1] 2
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • GoogleMaps Geocoding failed

This forum was archived on 2017-11-26.