SQL error when trying to change the workbench_recent_content view [#1222492]

When trying to change the workbench_recent_content view I get the following messages and errors. The first message appears right away after you click the 'edit' view button, and it gets repeated when clicking the Block Display. Also then the second message and the error appear.

Messages:
* This view has been automatically updated to fix missing relationships. While this View should continue to work, you should verify that the automatic updates are correct and save this view.
* 1311018683

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

Modules used:

Ctools 7.x-1.0-beta1
Views: 7.x-3.0-rc1
Workbench: 7.x-1.0-beta6
Workbench Moderation: 7.x-1.0-beta7

All tested on a fresh Drupal install with only these modules installed.

Also when viewing the My Workbench - My Content tab the 'Content I've edited' is visible, but when clicking the 'Content I've Edited' sub tab the view is empty.

Comments

Comment #1

stevector

he/him

CreditAttribution: stevector commented 19 July 2011 at 16:14

A change on the latest Views release: http://drupal.org/node/1192186

Implicit relationships to users, comments and taxonomy have been removed. For Views that were using these implicit relationships, it will attempt to fix your views for you. These fixes are pretty good but you should verify that they are correct. If you are wondering why you no longer have access to "User: Name" when using a node view, it is because you now must add the "Node: Author" relationship. Likewise with taxonomy terms. While this seems more difficult at first glance, in the end it will be much better because it reduces user confusion about where fields are getting their data from.

I think we just need to adjust and re-export this View.

Comment #2

stevector

he/him

CreditAttribution: stevector commented 19 July 2011 at 16:16

Project:	Workbench Moderation	» Workbench
Version:	7.x-1.0-beta7	» 7.x-1.x-dev

Well, probably all the exported Views that ship with Workbench modules will need to be checked. I'm moving this issue to the Workbench queue because the View mentioned is not in Workbench Moderation.