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 |
Jump to:
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
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
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
Automatically closed -- issue fixed for two weeks with no activity.