1. I installed the location module and then i installed the gmap module.
2. I enabled the gmap module
3. Gave access permissions & setup my api key
4. I click on Node Locations and I get the following error just above the map

user warning: Unknown column 'eid' in 'field list' query: SELECT eid, longitude, latitude FROM location WHERE (longitude!=0 OR latitude !=0) AND type='node' in /home/purple8/public_html/liva_dev/includes/database.mysql.inc on line 121.

5. I looked at the database structure via phpmyadmin and I noticed the column 'eid' is missing.

This was on a fresh install.

I noticed two things when installing the gmap module
1. when i imported the location.mysql file into my mysql database = > i received an error message indicating that the table location already existed.
2. when i enabled the location module from the admin console by clicking on the check box - it didn't apear to execute any script.

Does anyone have any suggestions on where I went wrong?

Thanks,
James

CommentFileSizeAuthor
error_message.png198.85 KBJames Dunleavy

Comments

Werdna’s picture

Werdna commented

A similar thing is happening to me. I found your post when searching for a solution. Mine is complaining about :

# user warning: Unknown column 'eid' in 'where clause' query: SELECT * FROM location WHERE eid=1 AND type='user' in /home/werdna2/public_html/drupal476/includes/database.mysql.inc on line 121.

When i create the content.

This on a test site. The map seems to embed ok though. This is on Drupal-4.7.6 with gmap-4.7.x-1.x-dev

Eric

michaelfavia’s picture

michaelfavia commented

there was a recent update in the locations module to rename field oid to eid. if you have an oid field and not an eid field you may want to consider upgrading locations module and running update.php to resolve this issue. justa suggestion. please close this issue if it resolves it for you.

stella’s picture

stella commented

I have a similar issue except it's the "lid" column that's missing. The error I get is:

user warning: Unknown column 'lid' in 'where clause' query: DELETE FROM location WHERE lid = 9 in /var/www/drupal_5.1_20070214/html/includes/database.mysqli.inc on line 151.

My "location" table in the database has the following structure:

mysql> desc location;
+--------------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+---------------------+------+-----+---------+-------+
| eid | int(10) unsigned | NO | PRI | 0 | |
| type | varchar(6) | NO | PRI | NULL | |
| name | varchar(255) | YES | | NULL | |
| street | varchar(255) | YES | | NULL | |
| additional | varchar(255) | YES | | NULL | |
| city | varchar(255) | YES | | NULL | |
| province | varchar(16) | YES | | NULL | |
| postal_code | varchar(16) | YES | | NULL | |
| country | char(2) | YES | | NULL | |
| latitude | decimal(10,6) | YES | | NULL | |
| longitude | decimal(10,6) | YES | | NULL | |
| source | tinyint(4) | YES | | 0 | |
+--------------+---------------------+------+----+---------+-------+

onesimpleman’s picture

onesimpleman commented
Assigned: Unassigned » onesimpleman

Getting the same error message.
Using the latest version of Location module and Gmap module.
Checked mysql and the fieldname is oid.

Am trying to change all instances of eid to oid and see if that works.
Regards
Onesimpleman

bdragon’s picture

bdragon commented
Status: Active » Closed (won't fix)

Missing eid: Look for oid, rename.
Missing lid: Uh, I didn't know that was possible...