By Jim@drupal.be on

I've copied the correct version of the taxonomy_access module under the modules directory.
I've activited the module and enabled it. Upon enabling the following errors appear:

* user warning: Table 'aces.term_access' doesn't exist query: SELECT DISTINCT(tid) FROM term_access in C:\Program Files\xamp\xampp\htdocs\aces\includes\database.mysql.inc on line 120.
* user warning: Table 'aces.term_access' doesn't exist query: SELECT DISTINCT(rid) FROM term_access in C:\Program Files\xamp\xampp\htdocs\aces\includes\database.mysql.inc on line 120.
* user warning: Table 'aces.term_access_defaults' doesn't exist query: SELECT vid FROM term_access_defaults in C:\Program Files\xamp\xampp\htdocs\aces\includes\database.mysql.inc on line 120.
* user warning: Table 'aces.term_access' doesn't exist query: SELECT tid FROM term_access where tid = 0 in C:\Program Files\xamp\xampp\htdocs\aces\includes\database.mysql.inc on line 120.
* user warning: Table 'aces.term_access' doesn't exist query: SELECT tid FROM term_access where tid=0 AND rid=1 in C:\Program Files\xamp\xampp\htdocs\aces\includes\database.mysql.inc on line 120.
* user warning: Table 'aces.term_access' doesn't exist query: INSERT INTO term_access VALUES (0, 1, 1, 0, 0, 1, 1) in C:\Program Files\xamp\xampp\htdocs\aces\includes\database.mysql.inc on line 120.
* user warning: Table 'aces.term_access' doesn't exist query: SELECT tid FROM term_access where tid=0 AND rid=2 in C:\Program Files\xamp\xampp\htdocs\aces\includes\database.mysql.inc on line 120.
* user warning: Table 'aces.term_access' doesn't exist query: INSERT INTO term_access VALUES (0, 2, 1, 0, 0, 1, 1) in C:\Program Files\xamp\xampp\htdocs\aces\includes\database.mysql.inc on line 120.
* user warning: Table 'aces.term_access' doesn't exist query: SELECT n.nid, t.rid, BIT_OR(t.grant_view) AS grant_view, BIT_OR(t.grant_update) AS grant_update, BIT_OR(t.grant_delete) AS grant_delete FROM term_node n LEFT JOIN term_access t ON n.tid = t.tid GROUP BY n.nid, t.rid in C:\Program Files\xamp\xampp\htdocs\aces\includes\database.mysql.inc on line 120.
* user warning: Table 'aces.term_access' doesn't exist query: SELECT n.nid, a.rid, a.grant_view FROM node n LEFT JOIN term_node t ON t.nid=n.nid LEFT JOIN term_access a ON a.tid = 0 WHERE t.nid IS NULL in C:\Program Files\xamp\xampp\htdocs\aces\includes\database.mysql.inc on line 120.

All pages display properly. The category permissions tab under access rules is displaying properly but the tables haven't been created. No settings are being retained. All nodes are blocked.
Please help.

⋅ Categories: Drupal 4.7.x

Comments

gollyg’s picture

gollyg commented

From memory Taxonomy access implements the new install/update function. You may need to visit the update script to run the database installation (www.yoursite.com/update.php).
This should give you a drop down box of installation/upgrade options.
I think this is correct, but I upgraded rather than installing clean. You may just need to run an sql file included with the module.
hth

Jim@drupal.be’s picture

Jim@drupal.be commented

I did it on a fresh install. The update page is not accesible because of the taxonomy_access module.
There is no sql file in the new module. The install files says the tables will be installed automaticly.
That obviously didn't happen.

EDIT: I'v loaded the SQL file for the 4.6 version of TAC and then executed the update process. Now everything seems to work ok. I due think there is need for a beter solution.

keve’s picture

keve commented

for some reason the install file did not apply mysql scripts. The neccessary tables were not created.

Please, look inside the install file. You can see MySQl (or pgsql) scripts in it.
You have to apply it manually to your database.

rgammon’s picture

rgammon commented

I've got Drupal on BlueHost ISP. I followed the install instructions in 4.7.0, didn't work as per above.

Can you please post clear directions on how to make the module work? It offers what is essential functionality for me.

Thank you.

Jim@drupal.be’s picture

Jim@drupal.be commented

The following SQL statements will install the necesary tables to use the taxonemy control.
Minor modification might be needed. The syntax I used is possebly different than yours.

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;

sisconda’s picture

sisconda commented

Thanks Jim! I had the same problem but inserting the SQL commands using phpMyAdmin fixed it for me!

gollyg’s picture

gollyg commented

You could try the new update procedure - this requires you to install the module into your directory and then go to www.mysite.com/update.php.
There should be a dropdown box for each module that uses the new install feature. It should default to the correct update - if not select each update in turn (from memory there were two).
Return to this page and repeat for the second update.
Might work? If it does it should list the changes made to your database structure.

Jim@drupal.be’s picture

Jim@drupal.be commented

I've tried that method. I've had to import the sql-file from the 4.6 version of the module. After that I was able to 'update' those tables to the new version.

But 'keve' told me to search for the sql inside the install file. And that is indeed a much quicker way.
I only had to adjust it so the syntax was a correct SQL-syntax form my phpmyadmin version.

I gues whenever he or somone els finds the time the install part could get fixed. This is a bug if I'm not mistaken.

gollyg’s picture

gollyg commented

Yeah - I was upgrading when I installed it but thought it was worth a shot. Have you reported it as a bug?

sjfarrar’s picture

sjfarrar commented

Hi all, I had the same problem as you have described above.

I have submitted a bug report, take a look and add details as you feel necessary, I also linked back to this thread.

http://drupal.org/node/64191