After upgrading from 5.x-2.7 to 5.x-3.0-test3 I am receiving the following warning:

user warning: Unknown column 'location.eid' in 'on clause' query: SELECT count(node.nid) FROM node node LEFT JOIN event event ON node.nid = event.nid LEFT JOIN location location ON node.vid = location.eid WHERE (node.status = '1') AND (node.type IN ('event')) AND (event.event_end > (1222565009 + 0)) in ~/includes/database.mysql.inc on line 172.

user warning: Unknown column 'location.eid' in 'on clause' query: SELECT node.nid, event.event_start AS event_event_start, event.event_end AS event_event_end, event.timezone AS event_timezone, node.title AS node_title, node.changed AS node_changed, location.name AS location_name FROM node node LEFT JOIN event event ON node.nid = event.nid LEFT JOIN location location ON node.vid = location.eid WHERE (node.status = '1') AND (node.type IN ('event')) AND (event.event_end > (1222565009 + 0)) ORDER BY event_event_start ASC LIMIT 0, 200 in ~/includes/database.mysql.inc on line 172.

What can I do to correct this issue?

Comments

bdragon’s picture

bdragon commented

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

fm’s picture

fm commented

I'm not sure what you mean. Could you expound? Which views?

bdragon’s picture

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

Well, some sort of view on your site with the fields event: start, event: end, event: timezone, node: title, node: changed, and location: name. Does this ring a bell?

functions’s picture

functions commented

I'm experiencing this same warning. I have the views module installed, but have not enabled any views yet. Currently the only page that displays the warning is the 'Manage Fields' tab of a custom content type that had locations enabled before the module update.

The url displaying the warning is: {domain}/admin/content/types/{content-type}/fields

bdragon’s picture

bdragon commented

@functions:

What modules do you have enabled?

functions’s picture

functions commented

@bdragon

These modules are installed, plus the required core of course:
Administration Menu
CCK Blocks
CCK Extras
CCK Fieldgroup Tabs
CCK GoogleMap Address
Computed Field
Content
Content Copy
Content Templates
EMail
Fieldgroup
Form Markup
Link
Location CCK
Phone - CCK
Text
Zipcode - CCK
Color
Comment
Menu
Path
Search
Statistics
Taxonomy
Upload
Database Administration
Node Import
Hierarchy
xHierarchy
Javascript tools
Tabs
GMap
GMap CCK Field
GMap Location
GMap Macro Builder
GMap Taxonomy Markers
GMap Views Integration
Location
Location Add Another
Location QuickGeocode
Location Search
Location Views
Find URL Alias
Global Redirect
Menu Per Role
Meta tags
Page Title
Pathauto
Poormanscron
Safe HTML
Taxonomy CSV import
Theme Settings API
Token
Update status
Tagadelic
System info
Bonus: grid view
Bonus: Views Export
Views
Views Fast Search - Node type rankings
Views FastSearch
Views RSS
Views Theme Wizard
Views UI
Fivestar
Fivestar Comments
Simple Review
Voting API
------

The warning also displays when I perform a node import (once for each node imported) plus this warning also: # warning: Invalid argument supplied for foreach() in /var/www/vhosts/domain.com/httpdocs/sites/all/modules/location/location.module on line 1701.

On url: {domain}/admin/content/node_import

thanks.

functions’s picture

functions commented

It seemed to be an issue with the Hierarchy module. Disabled that module and that resolved the issue for me.

bdragon’s picture

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

OK, considering fixed then.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.

ron collins’s picture

ron collins commented

delete from cache_views; solved this problem for me.