I'm using Drupal 5. Desperately seeking help for the following issue and error

Table 'xxx_drpl1.node_privacy_byrole' doesn't exist query: SELECT gid, grant_view, grant_update, grant_delete FROM node_privacy_byrole WHERE nid = 14 AND realm = 'node_privacy_byrole_role' in /home/xxx/public_html/ADR/includes/database.mysql.inc on line 172

Comments

deekayen’s picture

deekayen commented
Status: Active » Fixed

You managed to somehow not install the module correctly. You should disable and uninstall the module, then reactivate it to get the table automatically added, or execute the following query on your database:

CREATE TABLE node_privacy_byrole (
        nid int(10) unsigned NOT NULL default '0',
        gid int(10) unsigned NOT NULL default '0',
        realm varchar(255) NOT NULL default '',
        grant_view tinyint(3) unsigned NOT NULL default '0',
        grant_update tinyint(3) unsigned NOT NULL default '0',
        grant_delete tinyint(3) unsigned NOT NULL default '0',
        PRIMARY KEY  (nid,gid,realm));

Be sure you also have a node_privacy_byrole.install file in your directory for node_privacy_byrole, since that's the file that has your missing table schema.

alphadawg’s picture

alphadawg commented

Thank you very much. Everything seems to be working after the reinstall.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.