I got the following error on the update.php follow-up page and some of my views are broken

Notice: Undefined index: entity type in views_handler_field_entity->init() (line 38 of /home/billboar/public_html/bcf2/sites/all/modules/views/handlers/views_handler_field_entity.inc)

In addition I am seeing the following message attached to my broken views

Debug:
'Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column \'field_data_field_event_venue.nid\' in \'on clause\''
in views_plugin_query_default->execute() (line 1386 of /home/billboar/public_html/bcf2/sites/all/modules/views/plugins/views_plugin_query_default.inc).

CommentFileSizeAuthor
#18 cz_featured_slider.zip3.07 KBAnonymous (not verified)
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

dawehner’s picture

Status: Active » Postponed (maintainer needs more info)

Do you use node reference?

MrPaulDriver’s picture

Indeed, I do

dawehner’s picture

Status: Postponed (maintainer needs more info) » Fixed

Update nodereference.

dawehner’s picture

There are so many issues here, with the same problem.

Abilnet’s picture

Status: Fixed » Active

I had the same error after upgrading to RC3 and running update.php:

Notice: Undefined index: entity type in views_handler_field_entity->init() (line 38 of /home/xxxxxx/domains/xxxxxxxx.com/public_html/sites/all/modules/views/handlers/views_handler_field_entity.inc).

Edit: Not using node reference.

MrPaulDriver’s picture

I take it you mean the complete References module.

7.x-2.0-beta3 to 7.x-2.0-dev

MrPaulDriver’s picture

Fixed for me. Updating the References module to 7.x-2.x-dev did the trick.

As well as running update.php, I also had to clear the cache before the errors cleared

Thank you dereine

dawehner’s picture

Status: Active » Fixed

Update status.

epsilon1983’s picture

Status: Fixed » Active

Wait, wait, but what about for those of us not using Reference/nodereference? Do I need to install Reference in order to fix this error?

ldedecker’s picture

I agree with espilon1983 i do not have reference installed.

Also, for my updates i'm usually using drush and after using it, drush automatically restore initial project.
When updating on my own, i have same kind of problems as described earlier.

May be i should update some other modules, but i assume drush is updating everything that is required.

Also, from comments it is said we need to update reference from beta to dev version, which surprises me as i thought dev is supposed to be less tested than dev ?

Through drush i've tried to see why it is restoring backup but i don't see any usefull information in log

Thanks.

dawehner’s picture

Maybe there is another module which implements the views api wrong. What kind of relationship do you have on the buggy views?

bojanz’s picture

Also, if you're using Commerce together with Views 7.x-3.0-RC3, it's probably best to use 7.x-1.x-dev (until Commerce 1.1 gets tagged, which should be any day now).

macman91’s picture

Notice: Undefined index: entity type in views_handler_field_entity->init() (line 38 of /home/w4835/public_html/billy/sites/all/modules/views/handlers/views_handler_field_entity.inc).
Notice: Undefined index: entity type in views_handler_field_entity->init()

Error after updating from 7.x-3.0-rc1 to rc3

Note not using reference either!

Anyone know whats causing it?

ldedecker’s picture

After restoring prev version and database, clearing cachen reinstalling manually and clearing cache again, finally no more error with rc3, seems ok for me even if i'm not completely sure

I don't know why drush was refusing the update.

I'm using commerce, may be is there something with it.

bojanz’s picture

Without providing a views export, there's no way for us to tell you what might be causing it. Keep that in mind.

Anonymous’s picture

Same error, not using Node Reference (I do have the latest dev version installed, but disabled), didn't appear to break anything.

dawehner’s picture

You know it would be DEFINITIVE helpful if you could provide an export of the view. Additional you would do me a favor if it's a view you can import on any site.

Anonymous’s picture

FileSize
3.07 KB

Here's an export of my view.

ñull’s picture

Also, if you're using Commerce together with Views 7.x-3.0-RC3, it's probably best to use 7.x-1.x-dev (until Commerce 1.1 gets tagged, which should be any day now).

Meaning....? views rc3 will crash commerce? And commerce dev will fix it? Is that based on experience?

dawehner’s picture

Well if bojanz says this you should follow him :)

rhiss’s picture

Reverting to 7.x-3.0-rc1 solved it, but i also didnt update the references module...

bojanz’s picture

Meaning....? views rc3 will crash commerce? And commerce dev will fix it? Is that based on experience?

Commerce 1.0 was made to work with Views RC1.
Commerce 1.1 (current 7.x-1.x-dev) is being made to work with Views RC3.

Right now Commerce works best with Views RC1, cause there's a query access bug that breaks some views when not viewed as an admin user with Views RC3.
So, for production Commerce sites, updating Views is not recommended. I would like to fix this bug today if possible, just need to catch a few people online ;)
There's are Views patches that can fix the problem at #1222324: Fix query access control on relationships (comments), but the current consensus seems to be to try and fix this at the Commerce side.

So, right now you can you use Commerce 7.x-1.x-dev with any Views version. However, soon we'll be committing patches that require Views RC3, leading to Commerce 1.1 that requires Views RC3.

BrightBold’s picture

I got this error on two different sites after running update.php even with the latest dev of References (10-10). As far as I can tell it's not causing any problems — my views using references seem fine.

dusov’s picture

error on the update.php
and problem with Views content panes (ctools): Theme key "panels_onecol" not found.

alexiscott’s picture

This error message cold be related, as it's also a missing column with the .nid suffix.

Running 7.9 I'm getting this error in one of my views displays after the views upgrade: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'field_data_field_exhibition.nid' in 'on clause'

I tried upgrading references (node references), as well as ctools, and views slideshow, but it did not seem to make any difference - same error.

dawehner’s picture

@arcX
Are you sure you updated references to the dev version and cleared the cache?

guillaumev’s picture

Same issue as arcX here, besides that I had 2 debug messages (the same ones) appearing. I updated references and now one of them is gone, but the other one remains.

What's strange though is that I have, in the same view, a Block display and a Page display, displaying exactly the same data in the same way. After updating References, in the Page display, everything is fine, while in the Block display, the error is still there...

guillaumev’s picture

Never mind, the issue was coming from a custom module of mine implementing hook_field_views_data that I needed to update.

For arcX: find the module responsible for your field_data_field_exhibition and, in this module, look for the function implementing hook_field_views_data. Then, do as in this commit http://drupalcode.org/project/references.git/blobdiff/80e59efe2a0a56ed8b... to fix the error...

alexiscott’s picture

I'm good too: as dereine points out, and maybe I missed in the thread, it needs to be the dev version, and not the beta3 version that I was using.

Thanks for the help, and thanks too to guillaumev for his explanation, of what is going on under the hood.

bojanz’s picture

Category: bug » support
Status: Active » Fixed

Okay, looks like we're good then.

BrightBold’s picture

Status: Fixed » Active

Hmm. I just got this error again on a site that didn't have References installed. So it does sound like there's another module that may be causing the same problem.

I went through all the views trying to see if any were broken and the only error I can find is a missing style plugin and a broken/missing handler error (that appears to be on the "delete" link) on a view called admin_user_user. Unfortunately, I don't know where this view came from (maybe someone here does? It seems to duplicate the People List view but with a Drupal-6-style path; I don't seem to have it on any of my other Drupal 7 sites) nor can I confirm whether it was broken before the upgrade. But here's an export:

$view = new view;
$view->name = 'admin_user_user';
$view->description = 'List, add, and edit users.';
$view->tag = 'admin';
$view->base_table = 'users';
$view->human_name = '';
$view->core = 0;
$view->api_version = '3.0';
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */

/* Display: Defaults */
$handler = $view->new_display('default', 'Defaults', 'default');
$handler->display->display_options['title'] = 'Users';
$handler->display->display_options['use_ajax'] = TRUE;
$handler->display->display_options['access']['type'] = 'perm';
$handler->display->display_options['access']['perm'] = 'administer users';
$handler->display->display_options['cache']['type'] = 'none';
$handler->display->display_options['query']['type'] = 'views_query';
$handler->display->display_options['query']['options']['query_comment'] = FALSE;
$handler->display->display_options['exposed_form']['type'] = 'basic';
$handler->display->display_options['pager']['type'] = 'full';
$handler->display->display_options['pager']['options']['items_per_page'] = 50;
/* Field: User: Name */
$handler->display->display_options['fields']['name']['id'] = 'name';
$handler->display->display_options['fields']['name']['table'] = 'users';
$handler->display->display_options['fields']['name']['field'] = 'name';
$handler->display->display_options['fields']['name']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['name']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['name']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['name']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['name']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['name']['alter']['trim'] = 0;
$handler->display->display_options['fields']['name']['alter']['html'] = 0;
$handler->display->display_options['fields']['name']['link_to_user'] = 1;
$handler->display->display_options['fields']['name']['overwrite_anonymous'] = 0;
/* Field: User: Active */
$handler->display->display_options['fields']['status']['id'] = 'status';
$handler->display->display_options['fields']['status']['table'] = 'users';
$handler->display->display_options['fields']['status']['field'] = 'status';
$handler->display->display_options['fields']['status']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['status']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['status']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['status']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['status']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['status']['alter']['trim'] = 0;
$handler->display->display_options['fields']['status']['alter']['html'] = 0;
$handler->display->display_options['fields']['status']['not'] = 0;
/* Field: User: Roles */
$handler->display->display_options['fields']['rid']['id'] = 'rid';
$handler->display->display_options['fields']['rid']['table'] = 'users_roles';
$handler->display->display_options['fields']['rid']['field'] = 'rid';
$handler->display->display_options['fields']['rid']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['rid']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['rid']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['rid']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['rid']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['rid']['alter']['trim'] = 0;
$handler->display->display_options['fields']['rid']['alter']['html'] = 0;
$handler->display->display_options['fields']['rid']['type'] = 'ul';
/* Field: User: Created date */
$handler->display->display_options['fields']['created']['id'] = 'created';
$handler->display->display_options['fields']['created']['table'] = 'users';
$handler->display->display_options['fields']['created']['field'] = 'created';
$handler->display->display_options['fields']['created']['label'] = 'Member for';
$handler->display->display_options['fields']['created']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['created']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['created']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['created']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['created']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['created']['alter']['trim'] = 0;
$handler->display->display_options['fields']['created']['alter']['html'] = 0;
$handler->display->display_options['fields']['created']['date_format'] = 'time ago';
/* Field: User: Last access */
$handler->display->display_options['fields']['access']['id'] = 'access';
$handler->display->display_options['fields']['access']['table'] = 'users';
$handler->display->display_options['fields']['access']['field'] = 'access';
$handler->display->display_options['fields']['access']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['access']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['access']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['access']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['access']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['access']['alter']['trim'] = 0;
$handler->display->display_options['fields']['access']['alter']['html'] = 0;
$handler->display->display_options['fields']['access']['date_format'] = 'time ago';
/* Field: User: Edit link */
$handler->display->display_options['fields']['edit_node']['id'] = 'edit_node';
$handler->display->display_options['fields']['edit_node']['table'] = 'users';
$handler->display->display_options['fields']['edit_node']['field'] = 'edit_node';
$handler->display->display_options['fields']['edit_node']['label'] = '';
$handler->display->display_options['fields']['edit_node']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['edit_node']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['edit_node']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['edit_node']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['edit_node']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['edit_node']['alter']['trim'] = 0;
$handler->display->display_options['fields']['edit_node']['alter']['html'] = 0;
/* Field: Broken/missing handler */
$handler->display->display_options['fields']['delete_node']['id'] = 'delete_node';
$handler->display->display_options['fields']['delete_node']['table'] = 'users';
$handler->display->display_options['fields']['delete_node']['field'] = 'delete_node';
$handler->display->display_options['fields']['delete_node']['label'] = '';
$handler->display->display_options['fields']['delete_node']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['delete_node']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['delete_node']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['delete_node']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['delete_node']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['delete_node']['alter']['trim'] = 0;
$handler->display->display_options['fields']['delete_node']['alter']['html'] = 0;
$handler->display->display_options['fields']['delete_node']['hide_empty'] = 0;
$handler->display->display_options['fields']['delete_node']['empty_zero'] = 0;
/* Sort criterion: User: Created date */
$handler->display->display_options['sorts']['created']['id'] = 'created';
$handler->display->display_options['sorts']['created']['table'] = 'users';
$handler->display->display_options['sorts']['created']['field'] = 'created';
$handler->display->display_options['sorts']['created']['order'] = 'DESC';
/* Filter criterion: User: Name */
$handler->display->display_options['filters']['uid']['id'] = 'uid';
$handler->display->display_options['filters']['uid']['table'] = 'users';
$handler->display->display_options['filters']['uid']['field'] = 'uid';
$handler->display->display_options['filters']['uid']['value'] = '';
$handler->display->display_options['filters']['uid']['exposed'] = TRUE;
$handler->display->display_options['filters']['uid']['expose']['operator_id'] = 'uid_op';
$handler->display->display_options['filters']['uid']['expose']['label'] = 'Name';
$handler->display->display_options['filters']['uid']['expose']['operator'] = 'uid_op';
$handler->display->display_options['filters']['uid']['expose']['identifier'] = 'name';
$handler->display->display_options['filters']['uid']['expose']['required'] = FALSE;
$handler->display->display_options['filters']['uid']['expose']['remember'] = 1;
$handler->display->display_options['filters']['uid']['expose']['reduce'] = 0;
/* Filter criterion: User: Active */
$handler->display->display_options['filters']['status']['id'] = 'status';
$handler->display->display_options['filters']['status']['table'] = 'users';
$handler->display->display_options['filters']['status']['field'] = 'status';
$handler->display->display_options['filters']['status']['value'] = 'All';
$handler->display->display_options['filters']['status']['exposed'] = TRUE;
$handler->display->display_options['filters']['status']['expose']['label'] = 'Active';
$handler->display->display_options['filters']['status']['expose']['identifier'] = 'status';
$handler->display->display_options['filters']['status']['expose']['required'] = FALSE;
$handler->display->display_options['filters']['status']['expose']['remember'] = 1;
/* Filter criterion: User: Roles */
$handler->display->display_options['filters']['rid']['id'] = 'rid';
$handler->display->display_options['filters']['rid']['table'] = 'users_roles';
$handler->display->display_options['filters']['rid']['field'] = 'rid';
$handler->display->display_options['filters']['rid']['operator'] = 'and';
$handler->display->display_options['filters']['rid']['exposed'] = TRUE;
$handler->display->display_options['filters']['rid']['expose']['operator_id'] = 'rid_op';
$handler->display->display_options['filters']['rid']['expose']['label'] = 'Roles';
$handler->display->display_options['filters']['rid']['expose']['operator'] = 'rid_op';
$handler->display->display_options['filters']['rid']['expose']['identifier'] = 'rid';
$handler->display->display_options['filters']['rid']['expose']['required'] = FALSE;
$handler->display->display_options['filters']['rid']['expose']['remember'] = 1;
$handler->display->display_options['filters']['rid']['expose']['reduce'] = 0;
$handler->display->display_options['filters']['rid']['reduce_duplicates'] = 0;

/* Display: System */
$handler = $view->new_display('system', 'System', 'system_1');
$handler->display->display_options['path'] = 'admin/user/user';
$translatables['admin_user_user'] = array(
  t('Defaults'),
  t('Users'),
  t('more'),
  t('Apply'),
  t('Reset'),
  t('Sort by'),
  t('Asc'),
  t('Desc'),
  t('Items per page'),
  t('- All -'),
  t('Offset'),
  t('Name'),
  t('Active'),
  t('Roles'),
  t('Member for'),
  t('Last access'),
  t('System'),
);

If you think it's related and there's anything I can do to help track down its source, let me know.

bojanz’s picture

Status: Active » Fixed

That view comes from the admin_views module that is bundled with Admin menu.
You have an old version, which explains the problem with the missing style plugin (it's looking for pre-May 29th VBO).

BrightBold’s picture

Aah thanks, that explains it. I will update.

Status: Fixed » Closed (fixed)

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