Hi i install the module everything work fine, when i add nodes i receive this error

user warning: Unknown column 'oid' in 'where clause' query: SELECT * FROM location WHERE oid=1 AND type='user' in /home/web/annoncemaroc/includes/database.mysql.inc on line 121.

Thanks

Comments

scriptnews’s picture

We have the same problem.

pshadow’s picture

same problem here.

pshadow’s picture

o.k. here's what I noticed. the module automatically sets up the databases. but creates a location database with eid field. the mysql file for location database has oid field. so somewhere the field got renamed? I tried delecting the location table and reinserting using the mysql file (oid version) but now I get:

Unknown column 'eid' in 'where clause' query: SELECT * FROM location WHERE eid=1 AND type='user'

anu ideas how to fix this?

pshadow’s picture

o.k. so read the oid to eid change was intended. so changed back and getting error on all pages now. I disabled gmap module and the error has stopped. looks like gmap location module reference oid?

pshadow’s picture

sorry for so many posts. just to verify this does seem to be the problem. did a replace of 'oid' to 'eid' in gmap_location module and errors are now gone and seems to be working properly. Not sure how to move this issue to gmap project maybe.

dustyd’s picture

Thanks for posting. I just installed and got the same error. Disabling gmap_location till it's updated.

toma’s picture

I change oid to eid in gmap_location.module and in location.mysql delete your location table in your database and apply the new location.mysql and it will work fine

check http://drupal.org/node/101538

dustyd’s picture

That worked for me to, thanks.

greggles’s picture

Status: Active » Closed (duplicate)

This is a duplicate of the probem at http://drupal.org/node/101538 - marking status as such.