user warning: Unknown column 'draggableviews_structure_node0.value0' in 'field list' query: SELECT COUNT(*) FROM (SELECT node_da

Hi guys, this is mostly for myself and perhaps someone else who spent over 20 hours trouble shooting this error message.

I updated to newer version of views amongst other things including admin_menu and admin_view, I spent the last 10 hours trying to hunt down error i get in almost every page:

'user warning: Unknown column 'draggableviews_structure_node0.value0' in 'field list' query: SELECT COUNT(*) FROM (SELECT node_data_field_thumbnail.field_thumbnail_fid AS node_data_field_thumbnail_field_thumbnail_fid, node_data_field_thumbnail.field_thumbnail_list AS node_data_field_thumbnail_field_thumbnail_list, '

It turns out that after updating views, (perhaps are few others that has dependencies on it), I kept getting that column error in my database. I thought I had to create new tables or change columns.

Real problem: had to enable new Views items and many other things that depended on it. After enabling, views, views ui, admin_menu, admin_views? , just about everything , error message went away.

Also gave every role permission to view the views.

Hope this will save somebody hours of trouble after I just spent the last day or so running into dead ends.

:)