By mermaid on

Hi,

I am using drupal 4.6.3.

IndexPage installed on Drupal 4.6.3. It works fine for administrator. But for 'anonymous user' and 'authenticated user' I got this message :

user error: Unknown table 'na' in where clause
query: SELECT count(type) FROM node WHERE type = "flexinode-1" AND na.grant_view = 1 AND CONCAT(na.realm, na.gid) IN ('all0','og_uid0','og_group0') in /var/www/drupal463/includes/database.mysql.inc on line 66.

I allowed them to administrate nodes, that's work. How can I fix this problem ?

Thanks for any idea.

Best Regards.

Mermaid

Comments

AL-D’s picture

AL-D commented

...but I know, that there is a huge problem with the tax_access module.

I think it should be a problem with the db_rewrite commands cause I 've the same problem when using db_rewrite in php snippets and turn the tax_access on. If I switch it off, the error vanishes without a trace!

Is there a new patch available?

Thanks a lot

AL

PS: Yes, I've also combined the tax_access with the og_module! (I know... I know... but I need them both!)

Unknown table 'na' in where clause query: SELECT count(type) FROM node WHERE type = "story" AND na.grant_view = 1 AND CONCAT(na.realm, na.gid) IN ('all0','og_uid109','og_group0','term_access2','term_access5') in /.../.../.../.../includes/database.mysql.inc on line 66.

Gabriel R.’s picture

Gabriel R. commented

I'm also using Taxonomy Access Control with Indexpage, and I also have the same error on index pages. I assumed it was due to TAC, but I'm not so sure anymore.

AL-D, are you using TAC too?

Thanks.

-- NO, don't read this signature!

jpjanze’s picture

jpjanze commented

I get the same symptoms, however, no TAC installed.....any luck with this one yet?

user error: Unknown table 'na' in where clause
query: SELECT count(type) FROM node WHERE type = "flexinode-1" AND na.grant_view = 1 AND CONCAT(na.realm, na.gid) IN ('all0') in /home/beautyca/public_html/includes/database.mysql.inc on line 66.

http://www.harostreetmedia.com

jpjanze’s picture

jpjanze commented

I have found the solution (for me anyway) in another thread. Requires a manual patch.....

http://drupal.org/node/24202

http://www.harostreetmedia.com

donkilo’s picture

donkilo commented

Yep! Totally works. Good work. Why is there a module on the 4.6.0 page that has a bug like this that makes it basically useless unless you apply the patch?

La Red Riecken

astra’s picture

astra commented

Yes, just update the php line below

$exist_type = @db_result(db_query('SELECT count(type) FROM {node} WHERE type = "'.arg(1).'"'.($access ? ' AND '.$access : '')));

with this new code:

$exist_type = @db_result(db_query('SELECT count(type) FROM {node}, {node_access} na WHERE type = "'.arg(1).'"'.($access ? ' AND '.$access : '')));

It seems that works.

ericchambers’s picture

ericchambers commented

I'm having the same problem. Does anyone have any solutions?

mermaid’s picture

mermaid commented

Hi,

I installed a new database and Taxonomy Control Access, Organic Group were not installed.

I obtained the same error message for anonymous users.

I dont know what I have to modify in the moduleIndexpage.

If someone can help, thanks.

Mermaid.

donkilo’s picture

donkilo commented

ditto

La Red Riecken