Blog Subscriptions ERROR

[ang2el]

When my user click on

Blog Control Panel - Blog Subscriptions (http://www.MYSITE.com/forums/blog_subscription.php?do=userlist) then following error appears


Database error


The MYSITExyz database has encountered a problem.Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the www.MYSITExyz.com (http://www.MYSITExyz.com) home page, then try to open another page.
Click the Back button to try another link.The www.MYSITExyz.com (http://www.MYSITExyz.com) forum technical staff have been notified of the error, though you may contact them if the problem persists.
We apologise for any inconvenience.




How to solve this? this error appear with blog owner and none owner both.

[Steve Machol]

We need to see the real error message. Right-click on the error page and go to View/Source. Then copy-n-paste the error message here.

[PitchouneN64ngc]

Maybe a duplicate of this: http://www.vbulletin.com/forum/showthread.php?t=241285

[FBJunkie]

And which there is apparently a fix (http://www.vbulletin.com/forum/showpost.php?p=1413294&postcount=13), if this is the same error, which I have not tested yet with the same database error I get.

[ang2el]

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 = 2008 AND buddy.type = 'buddy')
LEFT JOIN userlist AS ignored ON (ignored.userid = user.userid AND ignored.relationid = 2008 AND ignored.type = 'ignore')
WHERE blog_subscribeuser.userid = 2008 AND ((options_ignore & 1 AND ignored.relationid IS NOT NULL) OR (options_buddy & 1 AND buddy.relationid IS NOT NULL) OR (options_everyone & 1 AND (options_buddy & 1 OR buddy.relationid IS NULL) AND (options_ignore & 1 OR ignored.relationid IS NULL)))
ORDER BY blog_user.lastblog DESC
LIMIT 0, 20;

MySQL Error : Column 'comments' in field list is ambiguous
Error Number : 1052
Date : Thursday, August 30th 2007 @ 06:28:28 PM
Script : http://www.mysitexyz.com/forums/blog_subscription.php?do=userlist
Referrer : http://www.mysitexyz.com/forums/blog_usercp.php
IP Address : xxxx.xxx.xxx.x
Username : xxxxxx
Classname : vB_Database

[Steve Machol]

See the link in post #4.

[ang2el]

:) that fixed my problem.....

Well just out of curiosity, where was the problem? Will this be fixed in future issues?

[Steve Machol]

As Freddie said in that other thread this is caused by an add-on that added an extra 'comments' field to the database.

[PitchouneN64ngc]

As Freddie said in that other thread this is caused by an add-on that added an extra 'comments' field to the database.
The best is to know what modifications have the users which this problem to identify the modification in cause.