TAC module version info:

taxonomy_access 6.x-1.x-dev
6.x
cpugeniusmv - July 19, 2008 - 16:38
Nightly development snapshot from CVS branch: DRUPAL-6--1
Download: taxonomy_access-6.x-1.x-dev.tar.gz
Size: 46.08 KB
md5_file hash: 66bcfad395b7a5dce0293fadf42e044e
First released: July 19, 2008 - 16:38
Last updated: August 19, 2008 - 01:12
Testing release for 6.x.

DB version info:

# mysql -V
mysql Ver 14.12 Distrib 5.0.51a, for suse-linux-gnu (i686) using readline 5.2

Warnings when enabling the module:

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ta LEFT JOIN dr_term_data td ON ta.tid = td.tid WHERE ta.tid <> 0 AND ISNULL(td.' at line 1 query: DELETE FROM dr_term_access ta LEFT JOIN dr_term_data td ON ta.tid = td.tid WHERE ta.tid <> 0 AND ISNULL(td.tid) in /srv/www/htdocs/sites/all/modules/taxonomy_access/taxonomy_access.module on line 63.

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'tad LEFT JOIN dr_vocabulary v ON tad.vid = v.vid WHERE tad.vid <> 0 AND ISNULL(v' at line 1 query: DELETE FROM dr_term_access_defaults tad LEFT JOIN dr_vocabulary v ON tad.vid = v.vid WHERE tad.vid <> 0 AND ISNULL(v.vid) in /srv/www/htdocs/sites/all/modules/taxonomy_access/taxonomy_access.module on line 64.

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ta LEFT JOIN dr_role r ON ta.rid = r.rid WHERE ISNULL(r.rid)' at line 1 query: DELETE FROM dr_term_access ta LEFT JOIN dr_role r ON ta.rid = r.rid WHERE ISNULL(r.rid) in /srv/www/htdocs/sites/all/modules/taxonomy_access/taxonomy_access.module on line 65.

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'tad LEFT JOIN dr_role r ON tad.rid = r.rid WHERE ISNULL(r.rid)' at line 1 query: DELETE FROM dr_term_access_defaults tad LEFT JOIN dr_role r ON tad.rid = r.rid WHERE ISNULL(r.rid) in /srv/www/htdocs/sites/all/modules/taxonomy_access/taxonomy_access.module on line 66.

I dont know what the problem is or how serious it is.

Comments

cpugeniusmv’s picture

cpugeniusmv commented
Assigned: Unassigned » cpugeniusmv

This is probably because of the changes I made in #296434: Error SQL postgresql.

I'll check it out.

morteni’s picture

morteni commented

Is this a serious issue?

I see that the SQL calls only do DELETEs, so it might be that the data still in MySQL does no harm?

My Drupal site seems to work fine despite this warning during installation.

-Morten

cpugeniusmv’s picture

cpugeniusmv commented

It's pretty minor. Those queries delete access control rules for vocabs and terms that had been deleted since the module was last enabled (if it ever was).

cpugeniusmv’s picture

cpugeniusmv commented
Status: Active » Fixed
Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

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