I really hope someone's still checking this, as this module is exactly what I've been looking for.

Clean install on Drupal 5.11, with Node Relativity module 5.x-2.4, MySQL version 5.0.41.

In admin/settings/relativity_access I get the following error:
user warning: Table 'opentopitch2.node_field' doesn't exist query: SELECT type_name AS type, nt.name AS name, nf.field_name AS field_name, nfi.label AS label from node_field nf LEFT JOIN node_field_instance nfi ON (nf.field_name = nfi.field_name) LEFT JOIN node_type nt ON nt.type = type_name WHERE nf.type = "userreference" in /Users/wilgrace/Sites/opentopitch2/includes/database.mysql.inc on line 174.

Sure enough, if I looking in my database, node_field doesn't exist as a table.

Is this a version issue, and if so is there a patch? I'd really appreciate any pointers.

thanks

Comments

mlncn’s picture

mlncn commented
Assigned: Unassigned » mlncn

Hi Wil,

This module is still being looked at. (The initial client is having a better coder than I look at it right now, so I don't want to jump into the code until getting a report-back on that.)

This error is one you can, for now, work around without a patch. Just make sure you have some content types that have some fields created (and in particular userreference fields if you want to use them for access control with this module) and there won't be any error.

Which means installing CCK. Did you have CCK installed? If not, then the bug is "CCK is currently an unlisted dependency of the Relativity Access module" (but it shouldn't have to be).

Note to self, two issues to look into here:

  1. Check for the existence of the node_field before querying so it doesn't freak out like this when there are no fields defined yet (I don't *think* this is an issue where a field has to be shared, but in any case see if there's a Drupal function that can do the job of this SQL query, looking for fields by type)
  2. Why is this query running on install at all?

benjamin, Agaric Design Collective

wilgrace’s picture

wilgrace commented

Outstanding, thank you very much - it works.

I'm seting up a site whereby a client posts a creative brief and the public pitch ideas.
- Everyone can view the briefs, the author can edit
- Everyone can post a pitch idea in response, but only the author of the brief or the author of the pitch can view the pitch

Node Relativity and Node Relativity Access Control do this perfectly and have saved the day! Go Cougars!