Closed (duplicate)
Project:
Location
Version:
4.7.x-1.x-dev
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Reporter:
Created:
12 Dec 2006 at 12:16 UTC
Updated:
2 Jan 2007 at 03:12 UTC
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
Comment #1
scriptnews commentedWe have the same problem.
Comment #2
pshadow commentedsame problem here.
Comment #3
pshadow commentedo.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?
Comment #4
pshadow commentedo.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?
Comment #5
pshadow commentedsorry 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.
Comment #6
dustyd commentedThanks for posting. I just installed and got the same error. Disabling gmap_location till it's updated.
Comment #7
toma commentedI 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
Comment #8
dustyd commentedThat worked for me to, thanks.
Comment #9
gregglesThis is a duplicate of the probem at http://drupal.org/node/101538 - marking status as such.