Integrity constraint violation after update

I have the exact same message:

'Exception: SQLSTATE[23000]: Integrity constraint violation: 1052 Column \'uid\' in field list is ambiguous'
in views_plugin_query_default->execute() (line 1380 of /[mypath]/sites/all/modules/views/plugins/views_plugin_query_default.inc).

However, it occurs once, and on all regular (i.e. non-admin) pages.

Duplicate of #766382: Column 'nid' is ambiguous when using node access modules, this is core.

No, it's not although it's of the same nature.

The way I was able to remove the debug message was adding a relationship to content author in all views that used something like user: id as a field.

The adding of the relationship should really be done automatically,
but sadly if you have already another relationship which provides a user relationship this seems to fail.

Can you show an export of the view, so it's possible to reproduce it?

This is an export of the view after adding the Content: author relationship. You'll probably want to remove the relationship to recreate the error. (Basically this was a view to create something that looked like the content overview page but specific to node author.)

$view = new view;
$view->name = 'my_content';
$view->description = '';
$view->tag = '';
$view->base_table = 'node';
$view->human_name = 'Content By User';
$view->core = 7;
$view->api_version = '3.0-alpha1';
$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['access']['type'] = 'role';
$handler->display->display_options['access']['role'] = array(
2 => '2',
);
$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'] = '20';
$handler->display->display_options['pager']['options']['offset'] = '0';
$handler->display->display_options['pager']['options']['id'] = '0';
$handler->display->display_options['pager']['options']['expose']['items_per_page_options_all'] = 0;
$handler->display->display_options['style_plugin'] = 'table';
$handler->display->display_options['style_options']['columns'] = array(
'title' => 'title',
'timestamp' => 'title',
'type' => 'type',
'status' => 'status',
'edit_node' => 'edit_node',
'delete_node' => 'edit_node',
);
$handler->display->display_options['style_options']['default'] = '-1';
$handler->display->display_options['style_options']['info'] = array(
'title' => array(
'sortable' => 1,
'default_sort_order' => 'asc',
'align' => '',
'separator' => ' ',
),
'timestamp' => array(
'align' => '',
'separator' => '',
),
'type' => array(
'sortable' => 1,
'default_sort_order' => 'asc',
'align' => '',
'separator' => '',
),
'status' => array(
'sortable' => 1,
'default_sort_order' => 'asc',
'align' => '',
'separator' => '',
),
'edit_node' => array(
'align' => '',
'separator' => '  ',
),
'delete_node' => array(
'align' => '',
'separator' => '',
),
);
$handler->display->display_options['style_options']['override'] = 1;
$handler->display->display_options['style_options']['sticky'] = 0;
$handler->display->display_options['style_options']['order'] = 'desc';
$handler->display->display_options['style_options']['empty_table'] = 0;
/* Relationship: Content: Author */
$handler->display->display_options['relationships']['uid']['id'] = 'uid';
$handler->display->display_options['relationships']['uid']['table'] = 'node';
$handler->display->display_options['relationships']['uid']['field'] = 'uid';
$handler->display->display_options['relationships']['uid']['required'] = 1;
/* Field: Content: Title */
$handler->display->display_options['fields']['title']['id'] = 'title';
$handler->display->display_options['fields']['title']['table'] = 'node';
$handler->display->display_options['fields']['title']['field'] = 'title';
$handler->display->display_options['fields']['title']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['title']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['title']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['title']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['title']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['title']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['title']['alter']['trim'] = 0;
$handler->display->display_options['fields']['title']['alter']['html'] = 0;
$handler->display->display_options['fields']['title']['element_label_colon'] = 1;
$handler->display->display_options['fields']['title']['element_default_classes'] = 1;
$handler->display->display_options['fields']['title']['hide_empty'] = 0;
$handler->display->display_options['fields']['title']['empty_zero'] = 0;
$handler->display->display_options['fields']['title']['link_to_node'] = 1;
/* Field: Content: Has new content */
$handler->display->display_options['fields']['timestamp']['id'] = 'timestamp';
$handler->display->display_options['fields']['timestamp']['table'] = 'history';
$handler->display->display_options['fields']['timestamp']['field'] = 'timestamp';
$handler->display->display_options['fields']['timestamp']['label'] = '';
$handler->display->display_options['fields']['timestamp']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['timestamp']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['timestamp']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['timestamp']['alter']['external'] = 0;
$handler->display->display_options['fields']['timestamp']['alter']['replace_spaces'] = 0;
$handler->display->display_options['fields']['timestamp']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['timestamp']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['timestamp']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['timestamp']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['timestamp']['alter']['trim'] = 0;
$handler->display->display_options['fields']['timestamp']['alter']['html'] = 0;
$handler->display->display_options['fields']['timestamp']['element_label_colon'] = 0;
$handler->display->display_options['fields']['timestamp']['element_default_classes'] = 1;
$handler->display->display_options['fields']['timestamp']['hide_empty'] = 0;
$handler->display->display_options['fields']['timestamp']['empty_zero'] = 0;
$handler->display->display_options['fields']['timestamp']['link_to_node'] = 0;
/* Field: Content: Type */
$handler->display->display_options['fields']['type']['id'] = 'type';
$handler->display->display_options['fields']['type']['table'] = 'node';
$handler->display->display_options['fields']['type']['field'] = 'type';
$handler->display->display_options['fields']['type']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['type']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['type']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['type']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['type']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['type']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['type']['alter']['trim'] = 0;
$handler->display->display_options['fields']['type']['alter']['html'] = 0;
$handler->display->display_options['fields']['type']['element_label_colon'] = 1;
$handler->display->display_options['fields']['type']['element_default_classes'] = 1;
$handler->display->display_options['fields']['type']['hide_empty'] = 0;
$handler->display->display_options['fields']['type']['empty_zero'] = 0;
$handler->display->display_options['fields']['type']['link_to_node'] = 0;
$handler->display->display_options['fields']['type']['machine_name'] = 0;
/* Field: Content: Published */
$handler->display->display_options['fields']['status']['id'] = 'status';
$handler->display->display_options['fields']['status']['table'] = 'node';
$handler->display->display_options['fields']['status']['field'] = 'status';
$handler->display->display_options['fields']['status']['label'] = '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']['absolute'] = 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']['element_label_colon'] = 1;
$handler->display->display_options['fields']['status']['element_default_classes'] = 1;
$handler->display->display_options['fields']['status']['hide_empty'] = 0;
$handler->display->display_options['fields']['status']['empty_zero'] = 0;
$handler->display->display_options['fields']['status']['type'] = 'published-notpublished';
$handler->display->display_options['fields']['status']['not'] = 0;
/* Field: Content: Edit link */
$handler->display->display_options['fields']['edit_node']['id'] = 'edit_node';
$handler->display->display_options['fields']['edit_node']['table'] = 'node';
$handler->display->display_options['fields']['edit_node']['field'] = 'edit_node';
$handler->display->display_options['fields']['edit_node']['label'] = 'Operations';
$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']['absolute'] = 0;
$handler->display->display_options['fields']['edit_node']['alter']['external'] = 0;
$handler->display->display_options['fields']['edit_node']['alter']['replace_spaces'] = 0;
$handler->display->display_options['fields']['edit_node']['alter']['nl2br'] = 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;
$handler->display->display_options['fields']['edit_node']['element_label_colon'] = 0;
$handler->display->display_options['fields']['edit_node']['element_default_classes'] = 1;
$handler->display->display_options['fields']['edit_node']['hide_empty'] = 1;
$handler->display->display_options['fields']['edit_node']['empty_zero'] = 0;
/* Field: Content: Delete link */
$handler->display->display_options['fields']['delete_node']['id'] = 'delete_node';
$handler->display->display_options['fields']['delete_node']['table'] = 'node';
$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']['absolute'] = 0;
$handler->display->display_options['fields']['delete_node']['alter']['external'] = 0;
$handler->display->display_options['fields']['delete_node']['alter']['replace_spaces'] = 0;
$handler->display->display_options['fields']['delete_node']['alter']['nl2br'] = 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']['element_label_colon'] = 0;
$handler->display->display_options['fields']['delete_node']['element_default_classes'] = 1;
$handler->display->display_options['fields']['delete_node']['hide_empty'] = 1;
$handler->display->display_options['fields']['delete_node']['empty_zero'] = 0;
/* Sort criterion: Content: Updated date */
$handler->display->display_options['sorts']['changed']['id'] = 'changed';
$handler->display->display_options['sorts']['changed']['table'] = 'node';
$handler->display->display_options['sorts']['changed']['field'] = 'changed';
$handler->display->display_options['sorts']['changed']['order'] = 'DESC';
/* Contextual filter: User: Uid */
$handler->display->display_options['arguments']['uid']['id'] = 'uid';
$handler->display->display_options['arguments']['uid']['table'] = 'users';
$handler->display->display_options['arguments']['uid']['field'] = 'uid';
$handler->display->display_options['arguments']['uid']['relationship'] = 'uid';
$handler->display->display_options['arguments']['uid']['default_action'] = 'default';
$handler->display->display_options['arguments']['uid']['default_argument_type'] = 'current_user';
$handler->display->display_options['arguments']['uid']['default_argument_skip_url'] = 0;
$handler->display->display_options['arguments']['uid']['summary']['number_of_records'] = '0';
$handler->display->display_options['arguments']['uid']['summary']['format'] = 'default_summary';
$handler->display->display_options['arguments']['uid']['summary_options']['items_per_page'] = '25';
$handler->display->display_options['arguments']['uid']['break_phrase'] = 0;
$handler->display->display_options['arguments']['uid']['not'] = 0;

/* Display: My Content */
$handler = $view->new_display('panel_pane', 'My Content', 'og_my_content');
$handler->display->display_options['pane_title'] = 'OG My Content';
$handler->display->display_options['pane_category']['weight'] = '0';
$handler->display->display_options['argument_input'] = array(
'uid' => array(
'type' => 'none',
'context' => 'entity:file.description',
'context_optional' => 0,
'panel' => '0',
'fixed' => '',
'label' => 'User: Uid',
),
);

/* Display: Block */
$handler = $view->new_display('block', 'Block', 'block_1');
$handler->display->display_options['defaults']['title'] = FALSE;
$handler->display->display_options['title'] = 'My Content';
$handler->display->display_options['block_description'] = 'My Content';

/* Display: User Content */
$handler = $view->new_display('panel_pane', 'User Content', 'panel_pane_1');
$handler->display->display_options['defaults']['title'] = FALSE;
$handler->display->display_options['title'] = 'Authored Content';
$handler->display->display_options['defaults']['arguments'] = FALSE;
/* Contextual filter: User: Uid */
$handler->display->display_options['arguments']['uid']['id'] = 'uid';
$handler->display->display_options['arguments']['uid']['table'] = 'users';
$handler->display->display_options['arguments']['uid']['field'] = 'uid';
$handler->display->display_options['arguments']['uid']['relationship'] = 'uid';
$handler->display->display_options['arguments']['uid']['default_action'] = 'default';
$handler->display->display_options['arguments']['uid']['default_argument_type'] = 'current_user';
$handler->display->display_options['arguments']['uid']['default_argument_skip_url'] = 0;
$handler->display->display_options['arguments']['uid']['summary']['number_of_records'] = '0';
$handler->display->display_options['arguments']['uid']['summary']['format'] = 'default_summary';
$handler->display->display_options['arguments']['uid']['summary_options']['items_per_page'] = '25';
$handler->display->display_options['arguments']['uid']['break_phrase'] = 0;
$handler->display->display_options['arguments']['uid']['not'] = 0;
$handler->display->display_options['pane_title'] = 'User Content';
$handler->display->display_options['pane_category']['weight'] = '0';
$handler->display->display_options['argument_input'] = array(
'uid' => array(
'type' => 'context',
'context' => 'entity:user.uid',
'context_optional' => 0,
'panel' => '0',
'fixed' => '',
'label' => 'User: Uid',
),
);

Just imported it into views with the removed relationship.
If you look at the preview all worked fine. That's confusing.

Subscribe - also have this issue

@ AndrzejG & co.
Are you using some node-access module??
I can not reproduce it niether with the export (and relationship removed).

I am using Organic Groups in my installation. I'm not sure this is a bug, but it is necessary to explicitly set a relationship with Content: Author if wanting to display user fields related to a node. So - documenting that change somewhere might be good.

subscribing.
Encountering the same problem after updating.

Subscribing. I'm using flag and I'm getting this in /user/X/bookmarks page.

I'm getting a similar error when trying to display a block listing Courses on a Tutor's page using a Contextual Filter. The Tutor is listed in the Course as a Node Reference Field.

The original error is:

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'vid' in field list is ambiguous

If I add Content: Author under Relationships, the error changes to:

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'name' in field list is ambiguous

I've tried adding some other Relationships, but I don't really understand what I'm doing. I can provide more details if that would help. Does anyone have any ideas how I can solve this?

Thanks.

Richard

@UserFriendly Would you post the export? I'm trying to reproduce the issue.

@neoglez Thanks. Export attached. The particular display I'm concerned about is called "Tutor Block", but the error also appears when "Non-UK Events by Country" or "UK Events by Region" is selected in the View edit page.

This error occurred for me on a Sandbox site, so I could experiment a bit on it. I disabled every single non-core module except those in Views and Chaos tools, cleared all caches twice, and still received the error.
I'm pretty sure that my only use of Views so far has been examples from the Views tutorial at NodeOne (http://nodeone.se/blogg/taming-the-beast-learn-views-with-nodeone-0).

Found exactly where the error is for me: my implementation of a block view (but not a page view) for a 'Most Recent Articles' view that was introduced for the first time in video 2 of the tutorial. I may have played around with the filter criteria. Attached is a screenshot of this View's Admin page.

Attaching this time a screenshot of the page view, which doesn't have the error, for comparison.
[Edit] In this, you can see that the Fields are different. It appears that the Uid field for the blocks view was somehow dropped.

I created a view, added a relationship Content: Author, add field User:Name and Title. The relationship setting in the field is 'author.' Works great!

I create a another block andtry but fail to override the relationships since the second block is a little different. I accidentally -- before override was set -- deleted the Content: Author relationship in all the displays. I restored the Content: Author relationship in the master view which adds it to the block view that requires it. However, the field that was (author) User: Name is now just User: Name and the debug message shows when I try to view the page.

I click on User: Name, the relationship is set again, and save the updated field without having to do anything else. Works great.

In my case I edited a different display in the view and overrode the setting which didn't correct itself when a third display was corrected.

Here is another example. I install the Flag module which ships with the default bookmark user page. Same error. So I open the view and click on the User: Name field, hit apply and saved. Works great now!

(included the exported views before and after)

Mm, the error that i found in #24 (see pic) is of a total other nature (and it's Flag module's)
Well, just realized i'm using dev (not rc)

In general there is something wrong with the flag module from my perspective.
Perhaps it assumes that you have a node -> user implicit relationship.

#24 solved my issue (also flag's bookmark view).

I clicked on (author) User: Name (Author)

and saved again, without changing anything, and the error messages went away.

Re saving the user field did it for me aswell.

My particular problem (see above - similar, but probably not the same as this specific issue) was solved by upgrading to the latest 7.x-3.0-dev version of Views.

I did then run into this problem http://drupal.org/node/1207680 (No valid values found error message), which I solved by applying the patch from dereine.

I then encountered the error message "Integrity constraint violation: 1052 Column \'name\' in field list is ambiguous'", which I solved by removing and reapplying sort by Taxonomy term: Name.

As is often the case, I spoke too soon. Updrading to the latest 7.x-3.0-dev version of Views didn't solved my original problem, however I have managed to fix it now.

The message I was getting: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'vid' in field list is ambiguous

The key was figuring out what 'vid' was referring to. In this case it is Vocabulary ID (elsewhere in drupal it's Version ID - the revision of a node). So I tried adding Taxonomy vocabulary: Name under Fields. The error message disappeared and the Display started working properly again.

+1,
while editing view I got:

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'uid' in on clause is ambiguous

also after updating to newest views dev., but I have also updated Core, Ctools, Entity, Relation, so maybe for me it's not just Views issue.

You may need to add the Node: author relationship to your view.

I solved this problem by going into each view on the page; editing and resaving (without making any changes) every relationship, argument, or field that referenced User; and resaving the view.

Current versions:
Drupal 7.4
Ctools 1.0-beta1
Entity 1.0-beta10
OG 1.1-rc3
OG Views 1.0
Panels 3.x-dev
Profile2 1.0-beta4
RealName 1.0-rc1
Views 3.0-rc1

thank Adam S(#24) very much.
I have the same error too.When I made ​​the changes as you said, the error disappeared.

Could it be that this automatic relationship thing only works on the ui?
Just guessing....

@dereine I think there are two cases when this doesn't work. The first case is an imported view which doesn't explicitly include the relationship. The other more common instance is a view with several different displays for example a page display and a block display. If the page display is the master view and both page display and block display have content author as a field when the developer starts to edit or change information or relationships about the author while under the block edit tab, the page display content author will break. If that makes any sense.

Here is a another used with the Flag module
http://drupal.org/node/1047954

I have updated to the latest everything, tried various fixes in these posts and still get the error on the My Content tab in My Workbench:
'Exception: SQLSTATE[23000]: Integrity constraint violation: 1052 Column \'uid\' in field list is ambiguous'
in views_plugin_query_default->execute() (line 1380 of /var/web/drupal/sites/all/modules/views/plugins/views_plugin_query_default.inc).
Using:
drupal 7.8
Workbench 7.x-1.0
Workbench Access 7.x-1.0
Workbench Moderation 7.x-1.0
Views 7.x-3.0-rc1
Chaos tools 7.x-1.0-rc1
#37 Adam S seems to describe what is happening here; there is a master view and different displays, page and block.
- workbench_edited view page and block displays show no errors
- workbench_recent_content view page display shows no errors, but the block display does. I get the 'ambiguous' error along with the UNIX timestamp. Is this possibly a Workbench issue? Views issue? I can provide any other info needed.

Perhap the workbench view doesn't use an author relationship?

let's move it to workbench.

What version of Workbench are you using?

Thanks for replying. I solved it; while the workbench_recent_content block view was using a Content: Author relationship, the Fields field was "User: Name (Author)" instead of "(author) User: Name (Author)". For some reason "Content: Published (Yes)" was in the Fields section instead of the Filter Criteria section. Removing it from Fields and adding it under Filter Criteria solved my problem and the Fields section field "User: Name" used the author relationship and error disappeared.

rdrh555 Were you running an overridden version of that View?

@stevector Initially, when the first error appeared, no. I set up Workbench and had not touched any of the views.

On http://drupal.org/node/1208286, dereine wrote "Additional there is some update code involved to automatically add a relationship for the author, which works for the most people." I got that message (Views had changed my views and that I needed to save the changes, so I knew something was not right). I was not one of the 'most people' that worked for.

This occurred in a virtual machine (setting up/testing Workbench). Two days ago I began recreating the setup on our staging server; when I compared the views I found the difference. However, I am at a loss explaining how the VM view became altered. I kinda thought it happened once I became different users and created content so there would be different content for each user's My Content tab, but I did that on the current site and - no error... Thank you for replying and I'm happy to provide any other info.

Thanks for testing rdrh555. Sounds like things are working. Feel free to re-open if needed.

Resaving the User: Name field in Views worked to resolve the error for me, and I'm not using Workbench.