Download & Extend

Domain adv causes SQL errors in views pages with exposed filters

Project:Domain Access Advanced
Version:6.x-1.0-rc1
Component:Code
Category:bug report
Priority:major
Assigned:Unassigned
Status:active
Issue tags:domain_adv, views

Issue Summary

When module domain advance is enabled, some SQL errors can happen in views pages with exposed filters.
If vaildation of exposed filter fails, view pass empty query through hook_db_rewrite_sql mechanism. Domain adv ignores fact, that this query
is empty and adds additional where and join fragments to empty query. As result, hook_db_rewrite_sql generates bad SQL code. Execution of this code causes SQL errors. As simple solution, I tried to add addtional check (query is empty or not) to domain_adv_db_rewrite_sql() function. After modification this function doesn't modify empty queries and it solves problems with exposed filters in views pages.

AttachmentSize
domain_adv.module.patch650 bytes

Comments

#1

Without this patch the front page views do not work.

With this patch there are still search results coming back from all the other domains but the front page views work.

This module is desperately needed too bad its in development.

#2

@sandy.girl,

Thank you for confirmation.
To be honest, we have dropped domain advanced module at our project and now we are using multiple node access patch (http://drupal.org/node/196922).

#3

Has this patch been committed to the current release or dev ?
Thanks !

#4

Priority:normal» major