I get the following error when using the domain editor id as an argument:
PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'domain_editor.realm' in 'where clause': SELECT COUNT(*) AS expression FROM (SELECT 1 AS expression FROM {users} users LEFT JOIN {profile} profile_users ON users.uid = profile_users.uid LEFT JOIN {domain_editor} domain_editor ON users.uid = domain_editor.uid LEFT JOIN {domain} domain_domain_editor ON domain_editor.domain_id = domain_domain_editor.domain_id WHERE (( (domain_editor.domain_id = :db_condition_placeholder_0) AND (domain_editor.realm = :db_condition_placeholder_1) ))) subquery; Array ( [:db_condition_placeholder_0] => LotteriesDirect [:db_condition_placeholder_1] => domain_id ) in views_plugin_pager->execute_count_query() (line 140 of /Applications/XAMPP/xamppfiles/htdocs/lot/sites/all/modules/views/plugins/views_plugin_pager.inc).
Comment | File | Size | Author |
---|---|---|---|
#7 | 1090618-query.patch | 2.27 KB | agentrickard |
#4 | 1090618-domain-views-arg.patch | 493 bytes | agentrickard |
#2 | domain_view.txt | 6.4 KB | bjalford |
Comments
Comment #1
agentrickardCan you export the View and attach it here?
Comment #2
bjalford CreditAttribution: bjalford commentedHere's my view which is causing this issue
Comment #3
agentrickardWhat's with all the extra \ in the file?
Comment #4
agentrickardTry this patch.
Comment #5
bjalford CreditAttribution: bjalford commentedI converted from rdf to txt. My bad.
That patch fixed it. That was fast!
On the summary page, it used to show the domain name and now it shows the domain id which I guess aligns with the argument. Is it possible to out the site names?
Comment #6
agentrickardI suspect that is a new feature request. The problem you reported was caused by using the wrong argument handler.
The above patch was a quick fix, however, and we might be able to fix the more complex handler to get the behavior back.
Look in domain_views_handler_argument_domain_access_gid.inc, which might need to be cloned and refactored to work for {domain_editor}.
Comment #7
agentrickardFixing in 7.x.