I am working on a site that recently had the views module upgraded from 6.x-2.1 directly to 6.x-2.16. Everything seemed fine and all views displayed correctly. We have now discovered that we cannot save any new views. When we create a view and click save, the message says the view is saved, but a page not found error is displayed when it tires to reload the page and the view does not show up in the list of views. I read an another issue for a different version number with the same problem and one of the comments in that issue reads "Here is the reason for this problem: 6012 is missed in 6.x-2.x" http://drupal.org/node/1127872#comment-4516196. I checked on my updates.php page and it does list 6011 and 6013, but there is no 6012 in the list. Is that the problem? If so, what do we need to do to get that update? We do have a database backup from before the update, but it is from a month ago before views was upgraded and content has been added since.

CommentFileSizeAuthor
#2 view-not-saved-2.png94.62 KBnrackleff

Comments

dawehner’s picture

Maybe clearing the cache does fix the issue for you. I really can't imagine how this happens.

It's fine that there is no 6012, because this was an easy way to still have the same update functions in 6.x-3.x

nrackleff’s picture

StatusFileSize
new94.62 KB

Thank you for the quick replay. I just tired clearing the cache and creating another view, but it is not fixed. I am able to create the view in the Views UI. I can preview it and see that it is getting data. When I click save, I see the message saying it is saved, but it's returns a page not found error when it tries to reload for editing so it is not getting saved. I've attached a screenshot of this.

nrackleff’s picture

I just checked the log entries and found this message:
Unknown column 'core' in 'field list' query: INSERT INTO views_view (name, description, tag, base_table, core) VALUES ('oaktree_test', 'oaktree test 3', '', 'node', 6) in /home/mhcoorg/public_html/sites/all/modules/views/includes/view.inc on line 1775.

dawehner’s picture

Interesting this should exist with running views_update_6013. Maybe try to run it manually again.

nrackleff’s picture

That took care of it. Thanks so much for your help. We are back in business. :-)

nrackleff’s picture

Status: Active » Closed (fixed)
dawehner’s picture

Status: Closed (fixed) » Fixed

Cool

dawehner’s picture

That's a perfect example what happens if people provide good information :)!
One small "detail" can be important.

Status: Fixed » Closed (fixed)

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