Unknown module Causing SQL Failure

Thanks, we are indeed using Webform Report. I will look in that direction.

JimBullington is correct. I said we use Webform Report, but as it turns out we use Webform Report on an older D6 site, not on any of the D7 sites.

However, I do not believe this is coming from the node module...I searched through the code in the D7 node module and there is only one instance where that module querys the node_comment_statistics table... to get the count of comments.

$comments = db_query('SELECT comment_count FROM {node_comment_statistics} WHERE nid = :nid', array('nid' => $node->nid))->fetchField();

At this point I am thinking this must be a dynamically generated query from a module like views that pulls the table names and parameters from the db. That would explain why my searches through the code do not show any query that includes node_comment_statistics aliased to 'nc' (everyone aliases it to 'ncs').

I have been digging through Views with no luck so far. I was just hoping someone might recognize the purpose of this query and that would help pinpoint where I need to focus working on a fix.

Thank you Pancho and neRok for your thoughts.

And this is where it starts getting weird. I made sure webform_report was not in our D7 modules directory. Then I grepped for webform_report recursively in both drupal7/modules and drupal7/includes and that text does not exist anywhere in the code as far as egrep is concerned.

So the term 'webform_report' MUST be coming from a db query field and the only dynamic query generator I know of that we use is Views.

I have already done a lot of looking in views, with no luck so far. But I will continue looking.

I was also thinking, is this something that Drupal's db abstraction layer should look for or possibly even fix? I mean, it IS a straightforward rule that ALL fields in a ORDER BY must also be in the SELECT list, no?

Good points Pancho and I agree with you.

We are running Debian, so I expanded the grep to look at everything in the /usr/share/drupal7/* dir, including and specifically /usr/share/drupal7/sites/*. Nothing about webform_report anywhere.

I also just finished talking with our site editor that builds all our dynamic views. He agrees that a view that specifically excludes the node type webform_report would stand out, especially since we do not have D7 webform_report installed. He does not recall ever excluding webform_report in any view....but he is going back to take a look.

The sites in question (FanMail.com and CollegeEducation411.com) are new enough that they are not very big yet. So there is a fairly small number of views to examine. He is checking them all and so far has not seen webform_report mentioned anywhere.

Now, we DO use webform on both of these sites. It seems unlikely to me that a module developer outside of webform is going to go to the trouble of writing a view that excludes the webform_report node type. So I am now looking at every query that webform does to see if any bear any resemblance to our problem SQL query. FWIW, webform does only one DISTINCT query which obviously does not match and nowhere do they try to orderBy anything resembling a timestamp.