i updated to the May 24 location module and the location table is no longer returning any results. i copied the files over, ran the update script and now i'm getting the errors below. after i saw them, i reinstalled the module from scratch, ran the db creation scripts manually, deleted my cache and restarted apache but i still get the same error. when i google it, i see references to CCK. is there some dependency on that module? i'm not running it but it was related to the previous issue i was having.

    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''') AND (location.additional '') AND (location.street '') AND query: SELECT count(*) FROM node node LEFT JOIN location location ON node.vid = location.oid WHERE (node.status = '1') AND (node.type IN ('audio','event','page','video')) AND (location.name '') AND (location.additional '') AND (location.street '') AND (location.city '') AND (location.postal_code '') AND (location.country = 'ca') in /var/www/drupal/lpm/includes/database.mysql.inc on line 120.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''') AND (location.additional '') AND (location.street '') AND query: SELECT node.nid, node.title AS node_title, node.changed AS node_changed, location.name AS location_name, location.street AS location_street, location.additional AS location_additional, location.city AS location_city, location.province AS location_province, location.postal_code AS location_postal_code, location.country AS location_country, location.latitude AS location_latitude, location.longitude AS location_longitude FROM node node LEFT JOIN location location ON node.vid = location.oid WHERE (node.status = '1') AND (node.type IN ('audio','event','page','video')) AND (location.name '') AND (location.additional '') AND (location.street '') AND (location.city '') AND (location.p in /var/www/drupal/lpm/includes/database.mysql.inc on line 120.
    * warning: Invalid argument supplied for foreach() in /var/www/drupal/lpm/includes/form.inc on line 637.
    * warning: Invalid argument supplied for foreach() in /var/www/drupal/lpm/includes/form.inc on line 637.

Comments

karens’s picture

karens commented

Are you using location views? If so, try updating to the latest cvs of location views.

ron collins’s picture

ron collins commented

i updated to the latest cvs copy of locations (with location_views), dropped the tables, removed the reference from the system table, deleted the cache and restarted apache.

the error has changed but not much. i'm not sure what else i can tell you that might help. i'm using 4.7 views. should i be using cvs?

    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''') AND (location.street '') AND (location.postal_code '') AN query: SELECT count(*) FROM node node LEFT JOIN location location ON node.vid = location.oid WHERE (node.status = '1') AND (node.type IN ('page')) AND (location.additional '') AND (location.street '') AND (location.postal_code '') AND (location.country = 'ca') in /var/www/drupal/lpm/includes/database.mysql.inc on line 120.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''') AND (location.street '') AND (location.postal_code '') AN query: SELECT node.nid, node.title AS node_title, node.changed AS node_changed, location.name AS location_name, location.street AS location_street, location.city AS location_city, location.province AS location_province, location.postal_code AS location_postal_code, location.country AS location_country FROM node node LEFT JOIN location location ON node.vid = location.oid WHERE (node.status = '1') AND (node.type IN ('page')) AND (location.additional '') AND (location.street '') AND (location.postal_code '') AND (location.country = 'ca') ORDER BY node.title ASC LIMIT 0, 10 in /var/www/drupal/lpm/includes/database.mysql.inc on line 120.
    * warning: Invalid argument supplied for foreach() in /var/www/drupal/lpm/includes/form.inc on line 637.
    * warning: Invalid argument supplied for foreach() in /var/www/drupal/lpm/includes/form.inc on line 637.
karens’s picture

karens commented
Project: Location » Location Views
Version: 6.x-3.x-dev »

Not sure yet what is causing this. Sounds like you're using the right versions of the modules. It might be something in the cache from an earlier version.

Be sure to clear your cache. If nothing else, you can do that by going to the admin/modules page and just click on the submit button. Then go to admin/views and delete any location views you may have had there from the past in case they have any bad values in thm. Then click add on one of the default location views and recreate your view.

Then see if you still get errors.

If that doesn't do it, can you provide more info about what you are doing when you see this. Are you looking at a location view when you get this message? If so, go to admin/views and export the view and paste it in a message here so I can see if there is anything strange about the view.

What php version are you using? Are you using MYSQL? What version?

I'm also going to move this thread to the location_views issues page.

ron collins’s picture

ron collins commented
Status: Active » Fixed

deleting the view seemed to solve the problem. it's been recreated and there are no longer any errors. ya gotta love these transitions when. thanks for all the help, k.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)