Click-sorting by source URL or redirect URL is broken, because the views handlers for these fields are broken. Patch is attached -the fix is to simply use the parent query method.

The error is:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unknown' in 'order clause'

Query
SELECT redirect.rid AS rid, redirect.source AS redirect_source, redirect.source_options AS redirect_source_options, redirect.redirect AS redirect_redirect, redirect.redirect_options AS redirect_redirect_options, redirect.language AS redirect_language, redirect.count AS redirect_count, redirect.access AS redirect_access, users.name AS users_name, users.uid AS users_uid
FROM
{redirect} redirect
LEFT JOIN {users} users ON redirect.uid = users.uid
WHERE (( (redirect.type IN ('redirect')) ))
ORDER BY unknown ASC
LIMIT 25 OFFSET 0

CommentFileSizeAuthor
redirect-views.patch1.23 KBmfb

Comments

René-Marc Simard’s picture

Status: Needs review » Reviewed & tested by the community

Thanks, that worked! I stumbled on this problem while trying to override the redirect interface with views. Clicking on column sort generated the above error, and your patch fixed it.

Dave Reid queued redirect-views.patch for re-testing.

  • Dave Reid committed 7404e83 on 7.x-1.x authored by mfb
    Issue #2135575 by mfb, René-Marc Simard: Fixed Views handlers for source...
dave reid’s picture

Status: Reviewed & tested by the community » Fixed

Committed to 7.x-1.x. Thanks!

Status: Fixed » Closed (fixed)

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