APK error: user warning: Unknown table 'users' in group statement query:...
Drupal 5.16
APK
Anyone have any ideas about this error on the user profile page.
user warning: Unknown table 'users' in group statement query: SELECT count(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_statistics_la in /nfs/c01/h09/mnt/5120/domains/drupal/includes/database.mysql.inc on line 174.
I don't even know where to begin.
Thanks,
Ralph
.
It looks like you have a mixture of prefixed and non prefixed tables. Possibly the query is forggetting the brackets on some of the tables? That query isn't part of APK. It looks like something that counts the number of nodes posted by buddies of the user maybe? Not sure... It's hard to read that mass of SQL.
Michelle
---
I'm looking for folks to help me out by posting in my Coulee Region forums. You don't need to live in the area; there's plenty of general forums. But please, no Drupal support questions. :)
I turned off Buddy list
I turned off Buddy list but, that did nothing. Have any idea as to where to start?
Thanks,
Ralph
Ralph Manis
Infinitee Designs
http://www.infinitee-designs.com/
http://www.infiniteewebdesign.com/
http://www.rock-band-t-shirts.com/
Grep?
If you know how to use grep, you can search for the query. Just look for the very begining as the rest would be dynamically inserted.
Other that, no idea. The query doesn't look familiar.
Michelle
---
I'm looking for folks to help me out by posting in my Coulee Region forums. You don't need to live in the area; there's plenty of general forums. But please, no Drupal support questions. :)
Don't know about "grep" but,
Could it be that I am using "Buddylist 2" instead of "Buddylist"?
Don't know about "grep" but, I will research it.
Thanks again,
Ralph
PS you can disregard the similar post in APK issues.
Ralph Manis
Infinitee Designs
http://www.infinitee-designs.com/
http://www.infiniteewebdesign.com/
http://www.rock-band-t-shirts.com/
.
Depends what you're trying to do with Buddylist. APK works with Buddylist 1, not 2, but that query isn't part of APK so it's hard to say if it would make any difference.
Michelle
---
I'm looking for folks to help me out by posting in my Coulee Region forums. You don't need to live in the area; there's plenty of general forums. But please, no Drupal support questions. :)
Error has expanded!
I logged in as another user and got this on my profile page... expanded admin profile error above:
Anyone have any ideas on how to rectify this?
Ralph Manis
Infinitee Designs
http://www.infinitee-designs.com/
http://www.infiniteewebdesign.com/
http://www.rock-band-t-shirts.com/
Same error
It's the same problem. It's just got more to it because node access is kicking in.
Michelle
---
I'm looking for folks to help me out by posting in my Coulee Region forums. You don't need to live in the area; there's plenty of general forums. But please, no Drupal support questions. :)