Taxonomy Access with multiple sites still not working

After more research, I saw this thread: http://drupal.org/node/89776

With removing:

$return['distinct'] = 1 

from the node_db_rewrite_sql function in node.module the User Warning is gone!!
But the taxonomy access is also permitted now to everybody!! so this is a needed peace of code maybe...
Please help.

The error is only when Taxonomy Access activated, deactivating Taxonomy Access resolves the issue, so can't it be within Taxonomy Access than?

Thanks for your quick reply,

greetings,
Martijn

Hi,

Off course are the exact lines not in the code. But with the devel module installed I found something.
The log says:

ms # where query
0.27 1 eval SELECT n.title, DISTINCT(n.nid) FROM GR_node n INNER JOIN GR_term_node tn ON n.nid = tn.nid WHERE
tn.tid = 114 AND n.nid != 232 LIMIT 5

I filtered it down to the .fitler module, but then I don't understand what to do.
Is a filter wrong, is the api not ok?

Thanks in advance,
greetings,
Martijn

I am trying the following now:
I have a Master site and a slave site.
Make the following tables site-dependend by placing this code in settings.php from the slave-site:

$db_prefix = 'GR_';
$db_name = 'SUR_';
$db_prefix = array(
'default'   => 'GR_',
'access' => $db_name,
'accesslog' => $db_name,
'node_access' => $db_name,
'cache' => $db_name,
'permission' => $db_name,
'term_access' => $db_name,
'term_access_defaults' => $db_name,
);

The idea is that because of this the access to content can be depended on the site which the settings.php refers to.

But it is not working.
The master-site access is ok and easy to install through Taxonomy Access Control.
The slave-site is showing all content no matter which terms I tell the Taxonomy Access Control from the slave-site to have access to (the radio buttons, Allow, Ignore Deny).
The settings of Taxonomy Access Control are nicely shown in the slave-site TAC table, but the access is granted without using this I think.

I saw TAC-module has a dependency with Node_access table, so this table I also prefix for every slave-site.
Is this the way to handle this?
Please help getting taxonomy access and node access right for master and slave site.
I don't want all the master-content also shown on the slave-site, thats my goal!

Thanks in advance,
greetings,
Martijn

Hi Keve,

I think I got it working with the smallest manual steps...
I have installed the Taxonomy Access Module and The Nodeaccess module.
I use one site as Master-site in which the content is being typed in.
I use ONLY above tables as site-specific in settings.php.

When a node is submit it first will only be available in the node_access table from the Master site.
But know comes the magic!!.. when in the slave-site on Nodeaccess settings page only the [SAVE GRANTS] is clicked..the node_access table from the slave-site will have the new node number included!!
After this the same trick is being played with the Taxonomy Access Control.
(The Taxonomy Access need off course to be set to the correct values for the Terms)
Then only you need to click on [SAVE CATEGORY PERMISSIONS]
Now the slave-site have the correct access rules for the new node!!

Greetings,
Martijn