I just tried to update, because of a security issue and saw these:
Any ideas?

 user warning: Unknown column 'core' in 'field list' query: UPDATE views_view SET name = 'order_management', description = 'Order lmanagement', tag = 'order management', base_table = 'uc_orders', core = 0 WHERE vid = 13 in E:\Inetpub\wwwroot\Drupal_Moodle\sites\all\modules\views\includes\view.inc on line 1760.
    user warning: Unknown column 'core' in 'field list' query: UPDATE views_view SET name = 'admin_content', description = 'Emulates the Drupal content administration page.', tag = '', base_table = 'node', core = 0 WHERE vid = 14 in E:\Inetpub\wwwroot\Drupal_Moodle\sites\all\modules\views\includes\view.inc on line 1760.
    user warning: Unknown column 'core' in 'field list' query: UPDATE views_view SET name = 'admin_users', description = 'Emulates the Drupal user administration page.', tag = '', base_table = 'users', core = 0 WHERE vid = 15 in E:\Inetpub\wwwroot\Drupal_Moodle\sites\all\modules\views\includes\view.inc on line 1760.

Here is my update log messages too:

views module
Update #6010

ALTER TABLE {views_view} DROP view_php
ALTER TABLE {views_view} DROP is_cacheable

Update #6011

UPDATE {blocks} SET cache = -1 WHERE module = 'views' AND delta LIKE '-exp-%'

Update #6013

ALTER TABLE {views_view} ADD `core` INT DEFAULT 0

Comments

goose2000’s picture

goose2000 commented
Priority: Normal » Major

I should add that I was updating from:

6.x-2.12 to 6.x-2.14

So, looks like :

Update #6013
ALTER TABLE {views_view} ADD `core` INT DEFAULT 0

Had a hard time, as there is no column 'core' in views_view, within 6.x-2.12 apparently.

Checked - no column 'core' in table 'views_view'

So when was 'core' added?

Setting to Major as I think this would be pretty bad for sites and there is a pending red alert
"Security update required! Views 6.x-2.12" - a lot of people probably already tried to update.

dawehner’s picture

dawehner
Primary language German
commented
Status: Active » Postponed (maintainer needs more info)

Well core got added between 6.x-2.11/12 and 6.x-2.14 so running update.php should actually help to fix it.

goose2000’s picture

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

Hey, I re-tried again today with the new 2.16 package and it went through with flying green color! Setting to fixed.

THANK YOU - I do appreciate your time and the views module...

Updates came back:

The following queries were executed
views module
Update #6010

ALTER TABLE {views_view} DROP view_php
ALTER TABLE {views_view} DROP is_cacheable

Update #6011

UPDATE {blocks} SET cache = -1 WHERE module = 'views' AND delta LIKE '-exp-%'

Update #6013

ALTER TABLE {views_view} ADD `core` INT DEFAULT 0

ronline’s picture

ronline commented
Version: 6.x-2.14 » 6.x-2.16

In my case is the sql query is not being executed during upgrading to 2.16 .

When I've tried to create a view, I end up with :
warning: Unknown column 'core' in 'field list' query: INSERT INTO views_view (name, description, tag, base_table, core) VALUES ('front_media', 'Front media', '', 'node', 6) in /home/www/sites/all/modules/views/includes/view.inc on line 1775.

To fix the issue I've had to run two sql queries from Update #6011 and Update #6013.

SQL code:
UPDATE `blocks` SET cache = -1 WHERE module = 'views' AND delta LIKE '-exp-%';
ALTER TABLE `views_view` ADD `core` INT DEFAULT 0;

Status: Fixed » Closed (fixed)

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