After a Views update (and probably also core) - if you edit the Blogs view created by Debut Blog, it'll tell you this:

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.

Saving it, gives you this error when viewing a blog post with the Recent Author Posts block attached:

Debug:
'Exception: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'= \'98\' ) ))) subquery\' at line 2'
in views_plugin_query_default->execute() (line 1380 of .../sites/all/modules/views/plugins/views_plugin_query_default.inc).

I picked this up, while looking up the error:

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've, however, looked around and noticed that no one gets the error I get - they mostly seem to get access violations on UID while I get a wrong syntax error. No idea how to fix this.

Comments

trillex’s picture

Just to clarify, it worked fine before I edited and saved it.

nedjo’s picture

Status: Active » Fixed

Fixed in that display and also in the user profile page display.

Status: Fixed » Closed (fixed)

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

Anonymous’s picture

Issue summary: View changes

Wrong formatting