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.

CommentFileSizeAuthor
domain_adv.module.patch650 bytesjsobiecki

Comments

theoracleprodigy’s picture

theoracleprodigy commented

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.

jsobiecki’s picture

jsobiecki commented

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

pedrosp’s picture

pedrosp
Location Madrid, Spain
commented

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

Encarte’s picture

Encarte commented
Priority: Normal » Major