By somebodysysop on

Got Drupal-4.7.0 up and running. Went through setup without a hitch. Added some pages and blogs. Taxonomy_Access-4.7.0 only outside module that I just now have installed and activated. Now, I get this and a series of similar warnings when trying to create Containers or Forums:

user warning: Table 'drupal.term_access_defaults' doesn't exist query: SELECT * FROM term_access_defaults WHERE vid='1' AND rid='1' in /var/www/html/doadance/drupal/includes/database.mysql.inc on line 120.

All the warnings indicate that the tables "term_access" and "term_access_defaults" do not exist.

The only similar threads I found in a forum search related to errors on updating, but I began with Drupal-4.7.0.

I didn't know if the Taxonomy_Access was the cause since I hadn't tried to create forums before, so I deactivated, disabled then re-enabled and re-activated Taxonomy_Access with the same results.

What do I do to correct this?

Thanks.

-ron

p.s. These are all the errors:

user warning: Table 'drupal.term_access_defaults' doesn't exist query: SELECT * FROM term_access_defaults WHERE vid='1' AND rid='1' in /var/www/html/doadance/drupal/includes/database.mysql.inc on line 120.
user warning: Table 'drupal.term_access' doesn't exist query: DELETE FROM term_access WHERE tid='7' AND rid='1' in /var/www/html/doadance/drupal/includes/database.mysql.inc on line 120.
user warning: Table 'drupal.term_access' doesn't exist query: INSERT INTO term_access VALUES ('7', '1', 0, 0, 0, 0, 0) in /var/www/html/doadance/drupal/includes/database.mysql.inc on line 120.
user warning: Table 'drupal.term_access_defaults' doesn't exist query: SELECT * FROM term_access_defaults WHERE vid='1' AND rid='2' in /var/www/html/doadance/drupal/includes/database.mysql.inc on line 120.
user warning: Table 'drupal.term_access' doesn't exist query: DELETE FROM term_access WHERE tid='7' AND rid='2' in /var/www/html/doadance/drupal/includes/database.mysql.inc on line 120.
user warning: Table 'drupal.term_access' doesn't exist query: INSERT INTO term_access VALUES ('7', '2', 0, 0, 0, 0, 0) in /var/www/html/doadance/drupal/includes/database.mysql.inc on line 120.

⋅ Categories: Drupal 4.7.x

Comments

somebodysysop’s picture

somebodysysop commented

Sorry. If I could have deleted the original post, I would have. Seems I didn't search for "term_access". I found that somehow the taxonomy_access-4.7.0 install did not create the correct tables and thus the errors. I found a solution to do this manually using the following script:

DROP TABLE IF EXISTS term_access;
CREATE TABLE term_access (
tid int(10) unsigned NOT NULL default '0',
rid int(10) unsigned NOT NULL default '0',
grant_view tinyint(1) unsigned NOT NULL default '0',
grant_update tinyint(1) unsigned NOT NULL default '0',
grant_delete tinyint(1) unsigned NOT NULL default '0',
grant_create tinyint(1) unsigned NOT NULL default '0',
grant_list tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (tid,rid)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS term_access_defaults;
CREATE TABLE term_access_defaults (
vid int(10) unsigned NOT NULL default '0',
rid int(10) unsigned NOT NULL default '0',
grant_view tinyint(1) unsigned NOT NULL default '0',
grant_update tinyint(1) unsigned NOT NULL default '0',
grant_delete tinyint(1) unsigned NOT NULL default '0',
grant_create tinyint(1) unsigned NOT NULL default '0',
grant_list tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (vid,rid)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Thanks.

-ron