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).

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

agentrickard’s picture

Can you export the View and attach it here?

bjalford’s picture

FileSize
6.4 KB

Here's my view which is causing this issue

agentrickard’s picture

What's with all the extra \ in the file?

agentrickard’s picture

Status: Active » Needs review
FileSize
493 bytes

Try this patch.

bjalford’s picture

I 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?

agentrickard’s picture

Status: Needs review » Needs work

I 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}.

agentrickard’s picture

Status: Needs work » Fixed
FileSize
2.27 KB

Fixing in 7.x.

Status: Fixed » Closed (fixed)

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