Unknown column 'query' in 'field list' query: _content_views_rebuild_views SELECT name, query FROM view_view ORDER BY name in ...database.mysql.inc on line 172.

The latest version of Views has no query column, so this function needs to be updated to work whether or not a query column is there. It doesn't seem there is any reason to use that column anyway, looks like the name field would be sufficient.

Comments

karens’s picture

karens commented
Status: Active » Fixed

Fix is committed.

yched’s picture

yched commented
Status: Fixed » Closed (duplicate)

Actually the whole _content_views_rebuild_views function is obsoleted by Views -dev.
See the discussion in http://drupal.org/node/126333 about when to actually update CCH -dev accordingly - actually I was planning to do it today anyway :-)

karens’s picture

karens commented

Except I'm worried that we won't know what version of Views people are using, so how do you plan to handle that? I don't think we can require a certain version of Views, or are you thinking we can?

Anyway, this seemed like a fix that wouldn't hurt anything in the meantime.

wolfderby’s picture

wolfderby commented

CCK 5.x-1.4 and CCK link 5.x-1.5

Drupal 5.1

Received same error while trying to create a cck field.
Widget checkboxes
label Type
required
multiple values
8 allowed values with (s) at end of 7

yched’s picture

yched commented

CCK 1.4 _will_ trigger this errors when used with Views 1.6 (or a pre 1.6 dev version)
If you do want Views 1.6 (still beta, with a few bugs), you have to upgrade to CCK 1.5.