user warning
toma - December 12, 2006 - 12:16
| Project: | location (API, module) |
| Version: | 4.7.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | toma |
| Status: | duplicate |
Jump to:
Description
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
#1
We have the same problem.
#2
same problem here.
#3
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?
#4
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?
#5
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.
#6
Thanks for posting. I just installed and got the same error. Disabling gmap_location till it's updated.
#7
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
#8
That worked for me to, thanks.
#9
This is a duplicate of the probem at http://drupal.org/node/101538 - marking status as such.