I just upgraded to 4.7.0r3 from Civicspace 0.8.2

am using taxonomy access control 4.7.0. on mySQL 4.1.18 database. using phpmyadmin to update SQL. I keep getting this message:

Unknown column 't.grant_list' in 'field list' query: SELECT t.tid, d.vid, BIT_OR(t.grant_list) AS grant_list FROM term_access t INNER JOIN term_data d ON t.tid=d.tid WHERE t.rid in ('1') AND grant_list = 1 group by t.tid, d.vid in /home/thefazz/public_html/me/includes/database.mysql.inc on line 120.

btw, i have updated the database. i've looked at the term_data and term_access tables... which looks like the have been updated as per the sql text file:

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',
PRIMARY KEY (tid,rid)
) TYPE=MyISAM;

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',
PRIMARY KEY (vid,rid)
) TYPE=MyISAM;

appreciate any help here. thanks in advance.

fazz

CommentFileSizeAuthor
#5 update_screenshot.jpg37.27 KBkeve

Comments

keve’s picture

keve commented

Read Update.txt. You have to update your database.

You have to run update.php, then choose Taxonomy_access Update #2.

TheFazz’s picture

TheFazz commented

strange - i did update the database before getting the error message. and the taxonomy_access module i have is not distributed with an update script.

what tables should have been updated in order for this to work? perhaps i can check the tables and see if the update script skipped something.

keve’s picture

keve commented

check if tables: term_access, and term_access_defaults has column 'grant_list'.
If not you might have to apply update script (#2) manually, that you can find in .install file.

iamnoskcaj’s picture

iamnoskcaj commented

I had a similar problem with updating after upgrading from 4.6.X to 4.7 yesterday.

No matter what I do, the update.php never shows an option that relates to taxonomy_access. The only options there are version numbers. I just let it "choose for me" and ran the update, but it never updated my tables "term_access" or "term_access_defaults". I don't know if I should try to manually update this stuff, or what. I can't leave taxonomy_access down, as we have sensitive information that requires that kind of granular access control. I think I might enable it and just tell my users to deal with the mysql error on the front-page.

Any help would be greatly appreciated!!!!

keve’s picture

keve commented
Title: mySQL database error » Update: mySQL database error
StatusFileSize
new update_screenshot.jpg37.27 KB

I changed title.

Do you use latest module for 4.7? $ id... v 1.77?

When running update.php: (you have to enable the tac module)
Please, see screenshot, it should look like this. (see attached).

Sascha Mantscheff’s picture

Sascha Mantscheff commented

I tried to installl taxonomy_access.module version 1.77 on Drupal 4.7.0 and ran into the same problem. update.php does not show any modules for selection, and the database update from taxonomy_access.install obviously does not get executed.
After manual execution of the CREATE TABLE statements from the install file the module works, though.

keve’s picture

keve commented

Checklist:
- Enable tac module
- .install file should be in same directory as taxonomy_access.module

Please, indicate mysql/pgsql version, apache/php version.

If you cannot see, tac in update.php page, try running mysql script you can find in .install file (function taxonoym_access_update_2).

keve’s picture

keve commented

Try:
go to admin/modules page, disable and re-enable newest version of tac module.

Please, tell if any of trhese solved your problem.

keve’s picture

keve commented
Status: Active » Closed (fixed)