I have a Drupal 5.1 site.

I've got this error message as soon as I enabled the ip_locator module. I also got the same error when I run the 'ip_update.php'.
Any help?

* user warning: You have an error in your SQL syntax near 'on (ic.country_code = c.country_code) where ic.nid='7' ' at line 8 query: SELECT c.country_code as ip_locator_country_code, c.country as ip_locator_country FROM ip_locator_node ic join ip_locator_country c on (ic.country_code = c.country_code) where ic.nid='7' in /home/bsjeon/public_html/TelematicDrumCircle/includes/database.mysql.inc on line 172.
* user warning: You have an error in your SQL syntax near 'on (ic.country_code = c.country_code) where ic.nid='7' ' at line 8 query: SELECT c.country_code as ip_locator_country_code, c.country as ip_locator_country FROM ip_locator_node ic join ip_locator_country c on (ic.country_code = c.country_code) where ic.nid='7' in /home/bsjeon/public_html/TelematicDrumCircle/includes/database.mysql.inc on line 172.

Comments

he_who_shall_not_be_named’s picture

he_who_shall_not_be_named commented
Status: Active » Fixed

Probably you must run the database update script.

he_who_shall_not_be_named’s picture

he_who_shall_not_be_named commented
Status: Fixed » Closed (fixed)

Project: » Lost & found issues

This issue’s project has disappeared. Most likely, it was a sandbox project, which can be deleted by its maintainer. See the Lost & found issues project page for more details. (The missing project ID was 179598)