PHP 5.3.5
MySQL 5.1.54
Drupal 7.9

Hi I'm new to Domain Access and I have an issue
I've set up a localhost running on apache on ubuntu.
I've set 2 Virtual hosts up
example.com
example.es

These both point to the same Drupal installation. I know they work as I have accessed them without Domain Access running.
example.com is the main default domain in Domain Access. example.com works without issue. Domain access seems to be working without problem in the admin area.
example.es however comes up with this error.

Exception: Query tagged for node access but there is no nid. Add foreign keys to node.nid in schema to fix. in _node_query_node_access_alter() (line 3216 of /home/james/www/xxxxxxxxxxx/modules/node/node.module).

Any help would be appreciated. Sorry if this is an issue that has come up before, I did do a thorough search but couldn't find anything.

Thanks
James

Comments

agentrickard’s picture

agentrickard
he/him
Primary language English
Location Georgia (US)
commented
Status: Active » Postponed (maintainer needs more info)

That would be a core issue. What query or page generates this error?

DrupalChimp’s picture

DrupalChimp commented

Thanks for the quick reply.

Absolutely all pages give this error.

Thanks

agentrickard’s picture

agentrickard
he/him
Primary language English
Location Georgia (US)
commented

Can you use Devel module or similar to figure out what the actual query string is?

romaingar’s picture

romaingar commented

Hi,
I've got the same error, did you find the reason ?
thanks.

agentrickard’s picture

agentrickard
he/him
Primary language English
Location Georgia (US)
commented

I saw something like this recently, and it was caused by the Domain Access Advanced module, which I don't support.

Are you using that?

agentrickard’s picture

agentrickard
he/him
Primary language English
Location Georgia (US)
commented

And we still need to know _which_ query this is.

romaingar’s picture

romaingar commented

thanks for your help, unfortunately i have to disable the module because i have no time to investigate further. but i didn't use domain access advanced on my project, but workbench access... maybe it's not compatible...
the error comes with anonymous users, do you have a simple way to display queries on this context ?
bye

agentrickard’s picture

agentrickard
he/him
Primary language English
Location Georgia (US)
commented
Status: Postponed (maintainer needs more info) » Closed (cannot reproduce)

Enable DEVEL module and give anonymous users permission to view Devel messages. Then enable Devel's query logging.

Drupal 7.9 is insecure. You need to update your codebase.

Workbench Access does not use query alters. And this error is coming from core, not DA.

Please re-file an issue when you have more information.