DB Error when clicking on....Blog Subscriptions

[Kihon Kata]

DB Error when clicking on....Blog Subscriptions

I tried to repair the table, but to NO avail.

Any ideas?


Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT SQL_CALC_FOUND_ROWS blog_user.entries, comments, lastblog, lastblogid, lastblogtitle, blog_user.title, blog_subscribeuser.type, blog_user.ratingnum, blog_user.ratingtotal,
user.username, user.userid, options_ignore, options_buddy, options_everyone, ignored.relationid AS ignoreid, buddy.relationid AS buddyid
FROM blog_subscribeuser AS blog_subscribeuser
INNER JOIN user AS user ON (user.userid = blog_subscribeuser.bloguserid)
LEFT JOIN blog_user AS blog_user ON (blog_user.bloguserid = blog_subscribeuser.bloguserid)
LEFT JOIN userlist AS buddy ON (buddy.userid = user.userid AND buddy.relationid = 14465 AND buddy.type = 'buddy')
LEFT JOIN userlist AS ignored ON (ignored.userid = user.userid AND ignored.relationid = 14465 AND ignored.type = 'ignore')
WHERE blog_subscribeuser.userid = 14465
ORDER BY blog_user.lastblog DESC
LIMIT 0, 30;

MySQL Error : Column 'comments' in field list is ambiguous
Error Number : 1052
Date : Thursday, August 30th 2007 @ 05:37:17 PM
Script : http://www.XXXXXXXX.com/forums/blog_subscription.php?do=userlist (http://www.XXXXXXX.com/forums/blog_subscription.php?do=userlist)
Referrer : http://www.XXXXXXX.com/forums/blog_usercp.php (http://www.XXXXXX.com/forums/blog_usercp.php)
IP Address : 142.162.206.166
Username : XXXXX
Classname : vB_Database

[Kihon Kata]

Ack, I see that there is a thread going already on this. Many others having same issue