Running Drupal 5
PHP 4 (Drupal keeps resetting to php4 when I try to set it to php5???)
Site in question: http://www.rock-band-t-shirts.com/
I have no idea how to interpret this error or where to begin fixing it. It only occurs when I turn on the Advanced Profile Kit module. (I have it turned off right now)
user warning: Unknown table 'users' in group statement query: SELECT count( DISTINCT(node.nid)) AS num_nodes, node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp_last_comment_timestamp, node.type AS node_type, node.title AS node_title, node.changed AS node_changed, node_comment_statistics.comment_count AS node_comment_statistics_comment_count, node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp FROM node node LEFT JOIN comments comments ON node.nid = comments.nid AND comments.uid = '2' INNER JOIN buddylist baj_node_buddylist ON node.uid = baj_node_buddylist.buddy LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid WHERE (node.status = '1') AND (node.type IN ('usernode')) AND (node.uid = '2' OR comments.uid = '2') GROUP BY users.name, node_comment_statistics_last_comment_timestamp_last_comment_timestamp ORDER BY node_comment_st in /nfs/c01/h09/mnt/5120/domains/drupal/includes/database.mysql.inc on line 174.
Any help would be greatly appreciated,
Ralph
Comments
.
Since we've already determined the query isn't in APK, I suspect it's something else in your panel page. Try poking around in there and see if there's a custom pane that has the bad query.
Michelle