dev version gives Unknown column 'nc.uid' in 'IN/ALL/ANY subquery' query error

yngens - April 20, 2008 - 01:42
Project:Content Blocker
Version:5.x-1.x-dev
Component:Code
Category:bug report
Priority:normal
Assigned:Unassigned
Status:closed
Description

user warning: Unknown column 'nc.uid' in 'IN/ALL/ANY subquery' query: SELECT nc.nid FROM blog_node_comment_statistics nc WHERE ((nc.uid NOT IN(SELECT id FROM blog_contentblocker WHERE type = 'user' AND uid = 1) OR nc.uid IS NULL)) AND ( nc.comment_count > 0 ) ORDER BY nc.last_comment_timestamp DESC LIMIT 0, 10 in /home/kgus/public_html/includes/database.mysql.inc on line 172.

#1

nedjo - April 20, 2008 - 23:05

Looks like an error in deciding which tables to alter. We need to either skip altering other than the node table or else ensure there's a join on the node table and refer to that.

#2

nedjo - April 24, 2008 - 18:41
Status:active» fixed

I applied a fix to HEAD (which for the moment is still 5.x compatible). Please test and reopen this issue if it didn't solve the problem.

#3

Anonymous (not verified) - May 8, 2008 - 18:41
Status:fixed» closed

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

 
 

Drupal is a registered trademark of Dries Buytaert.