Unknown column 'field_ult_gamedate_value' [#1461794]

When I go to league/1/games I get the following error.

    user warning: Unknown column 'field_ult_gamedate_value' in 'field list' query: SELECT node.nid AS nid, node.title AS node_title, field_ult_gamedate_value AS unknown FROM node node WHERE node.type in ('ult_game') ORDER BY unknown ASC LIMIT 0, 20 in /Users/denniscohn/Sites/league/sites/all/modules/views/includes/view.inc on line 810.
    user warning: Unknown column 'field_ult_gamedate_value' in 'field list' query: SELECT node.nid AS nid, node.title AS node_title, field_ult_gamedate_value AS unknown FROM node node WHERE node.type in ('ult_game') ORDER BY unknown DESC LIMIT 0, 10 in /Users/denniscohn/Sites/league/sites/all/modules/views/includes/view.inc on line 810.
    user warning: Unknown column 'field_ult_gamedate_value' in 'field list' query: SELECT node.nid AS nid, node.title AS node_title, field_ult_gamedate_value AS unknown FROM node node WHERE node.type in ('ult_gameresult') ORDER BY unknown DESC LIMIT 0, 10 in /Users/denniscohn/Sites/league/sites/all/modules/views/includes/view.inc on line 810.

Please fix

Comments

Comment #1

jthorson CreditAttribution: jthorson commented 3 March 2012 at 05:55

This page is provided via a view, as opposed to in code, so the fix is most likely going to require updating the offending view. Based on the 'unknown' keyword in those error messages, I'm speculating that either the views or cck import was not 100% successful, and/or has been modified.

That particular page contains three views ... so it's hard to tell which would be the offending view based solely on the error message. The error that's being thrown because Views is looking for field_ult_gamedate_value in the 'node' table instead of the proper cck tables.

If you could provide a cck export of your 'ult_game' content type, I can try and compare it to the default to see where the difference lies.

Comment #2

hitman007 CreditAttribution: hitman007 commented 10 April 2012 at 12:21

Had the very same issue but found that by uninstalling the ULT modules and deleting the folder from modules and then installing it from scratch sorted this out.