By globalplayer on

I have installed GMap.module and Location.module and when I turns on "Location map" block which is provided with gmap module I got this error message:

* warning: Invalid argument supplied for foreach() in /modules/node.module on line 374.
* warning: implode(): Bad arguments. in /modules/node.module on line 378.
* 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 '' at line 1 query: SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE in /includes/database.mysql.inc on line 121.

does anybody know how to solve this? thx

⋅ Categories: Drupal 4.7.x

Comments

McGo’s picture

McGo commented

I installed both, location and gmap module and get a similar error message. The problem (after reading the .install files) ist, that location.module and gmap.module both want to create a table with the name location. The problem ist, that the structure of that table differs between the two modules.

Aren't they compatible? There only seems to be a problem mit the location.module user location feature as described in the gmap readme file....

globalplayer’s picture

globalplayer commented

location table has the same structure for gmap.module and location.module

rainer7’s picture

rainer7 commented

Hi,

i guess i am the third person having this problem.

i red in another thread (http://drupal.org/node/116599) that location table schema has changed recently? But i don't know if that is related to the problem.

rainer7’s picture

rainer7 commented

To solve this problem, specify on which pages "location map"-block should be visible. (Default is on all pages)

Do not show location-map block on all pages, for example block should be only visible on node/* pages. - error is gone

lolabean’s picture

lolabean commented

Any other thoughts.

genwolf’s picture

genwolf commented

With the location map block turned on I ma getting this error whenever I try and create any content - of whatever type.

Turning the block off makes the error go away - but specifying the pages on which the block should appear as suggested does not make it go away.

suleyman’s picture

suleyman commented

I noticed that the problem occurs on node creation pages. So displaying the location map on all but node/add/* did the trick for me. Something is still not right but I think this may be a temporary fix.