user warning: Table 'location_instance' doesn't exist query: SELECT lid FROM location_instance WHERE uid = 1 in /home/dreinull/includes/database.mysql.inc on line 172.

Does anyone know what to do?

greetings
Jonas

Comments

bdragon’s picture

bdragon commented

Error after, or error during?

Is there currently a location_instance table in your database?

jonas28’s picture

jonas28 commented

The errormessage is shown after update.php

And there is no location_instance table in my database

bdragon’s picture

bdragon commented

In that case, could you talk to me in #drupal on IRC? (http://drupal.org/irc)

bdragon’s picture

bdragon commented

How sure are you about the non-existence of the table? I recently noticed that I was running the query in a way that it wasn't being listed on the queries performed screen, but it should still have happened...

jonas28’s picture

jonas28 commented

Now i tried the new version of location and upgraded from to 5.x-2.7 to 5.x-3.0-test3. Now there is a location_instance table in my database. But i get another errormessage when i view my "gmap-views":

user warning: Unknown column 'location.eid' in 'on clause' query: SELECT DISTINCT(node.nid), node.type AS node_type, node.title AS node_title, node.changed AS node_changed, location.latitude AS location_latitude, location.longitude AS location_longitude, node.type AS gmap_node_type FROM node node LEFT JOIN og_ancestry og_ancestry ON node.nid = og_ancestry.nid LEFT JOIN location location ON node.vid = location.eid WHERE (node.type IN ('notiz')) AND (og_ancestry.group_nid = 634) in .../includes/database.mysql.inc on line 172.

bdragon’s picture

bdragon commented

Looks like a view is still attempting to use the old tables. Resave your views?

bdragon’s picture

bdragon commented
Status: Active » Postponed (maintainer needs more info)

Awating feedback on whether that fixed it or not.

yesct’s picture

yesct commented
Status: Postponed (maintainer needs more info) » Closed (fixed)

this has been opened for a while waiting on more info. I'll mark this as closed, but if the original poster still needs help, just reply with more info and change the status back to active. :)