Fatal Error in Domain Content When trying to administer affiliated content [#1366212]

When clicking "Content assigned to all affiliates" I get the following errors

Notice: Undefined variable: base_alias in domain_alter_node_query() (line 3307 of /var/www/rocdocs/html/sites/all/modules/domain/domain.module).
Notice: Undefined variable: base_alias in domain_alter_node_query() (line 3312 of /var/www/rocdocs/html/sites/all/modules/domain/domain.module).
PDOException: 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 '= 'node') )OR (.entity_type <> 'node') )) subquery' at line 2: SELECT COUNT(*) AS expression FROM (SELECT DISTINCT n.nid AS nid, 1 AS expression FROM {node} n INNER JOIN {node_access} na ON na.nid = n.nid WHERE (( (na.gid = :db_condition_placeholder_0) AND (na.realm = :db_condition_placeholder_1) )OR( (na.gid = :db_condition_placeholder_2) AND (na.realm = :db_condition_placeholder_3) )OR( (na.gid = :db_condition_placeholder_4) AND (na.realm = :db_condition_placeholder_5) ))AND (na.grant_view >= :db_condition_placeholder_6) AND(( (.entity_type = :db_condition_placeholder_7) )OR (.entity_type <> :db_condition_placeholder_8) )) subquery; Array ( [:db_condition_placeholder_0] => 0 [:db_condition_placeholder_1] => all [:db_condition_placeholder_2] => 0 [:db_condition_placeholder_3] => domain_site [:db_condition_placeholder_4] => 1 [:db_condition_placeholder_5] => domain_id [:db_condition_placeholder_6] => 1 [:db_condition_placeholder_7] => node [:db_condition_placeholder_8] => node ) in PagerDefault->execute() (line 74 of /var/www/rocdocs/html/includes/pager.inc).

Comment	File	Size	Author
#8	1366212-domain-content-fail-7x2.patch	2.22 KB	agentrickard
#4	1366212-domain-content-fail.patch	2.12 KB	agentrickard

Comments

Comment #1

agentrickard

he/him

English

Georgia (US)

commented 9 December 2011 at 21:43

Confirmed. Sigh.

Comment #2

agentrickard

he/him

English

Georgia (US)

commented 9 December 2011 at 21:45

I was afraid of that. Changed the called function and didn't find any code referencing it.

Comment #3

agentrickard

he/him

English

Georgia (US)

commented 9 December 2011 at 21:47

This was caused by #1359570: Restrict node views for admins fails on taxonomy pages.

Comment #4

agentrickard

he/him

English

Georgia (US)

commented 9 December 2011 at 21:53

Status:

Active

» Needs review

Status	File	Size
new	1366212-domain-content-fail.patch	2.12 KB

Here's a fix. This also affects 7.x.2.

Comment #5

podarok

🇺🇦 he/him/his

Ukrainian

Ukraine

commented 12 December 2011 at 21:49

Status:

Needs review

» Reviewed & tested by the community

#4 work for me
500+ domains

/admin/domain/content/all accessable
/admin/domain/content/501 accessable too

looks like working for me

root@pubuntu:/var/www/multisite/public_html/sites/all/modules/domain# drush pml | grep domain
 Domain Access Domain Access (domain)                      Enabled 7.x-3.0        
 Domain Access Domain Alias (domain_alias)                 Enabled 7.x-3.0        
 Domain Access Domain Blocks (domain_blocks)               Enabled 7.x-2.0        
 Domain Access Domain Configuration (domain_conf)          Enabled 7.x-3.0        
 Domain Access Domain Content (domain_content)             Enabled 7.x-3.0        
 Domain Access Domain Content Types (domain_content_types) Enabled 7.x-1.0-beta1  
 Domain Access Domain Ctools (domain_ctools)               Enabled 7.x-1.3        
 Domain Access Domain Menu Access (domain_menu_access)     Enabled 7.x-1.0-rc1    
 Domain Access Domain Navigation (domain_nav)              Enabled 7.x-3.0        
 Domain Access Domain Path (domain_path)                   Enabled 7.x-1.0-beta3  
 Domain Access Domain Settings (domain_settings)           Enabled 7.x-3.0        
 Domain Access Domain Source (domain_source)               Enabled 7.x-3.0        
 Domain Access Domain Strict (domain_strict)               Enabled 7.x-3.0        
 Domain Access Domain Taxonomy (domain_taxonomy)           Enabled 7.x-3.x-dev    
 Domain Access Domain Theme (domain_theme)                 Enabled 7.x-3.0        
 Domain Access Domain Views (domain_views)                 Enabled 7.x-1.4        
 XML sitemap   XML sitemap domain (domain_xmlsitemap)      Enabled 7.x-1.0-beta2

RTBC ?