Error when hitting the Blog Subscriptions Button

**Zachery** · Wed 29 Aug '07, 9:16am

In config.php try setting $config['Database']['force_sql_mode'] = false;
to $config['Database']['force_sql_mode'] = true;

**Freddie Bingham** · Wed 29 Aug '07, 9:20am

You probably have a comments field in the user table from a hack. You'll need to remove it or rename it.

**Diggazz** · Wed 29 Aug '07, 9:33am

Thanks

Zachery - that had no effect

Freddie - I will investigate this tomorrow as its 2.30 am here

thank you both for your prompt response

**Marty1970** · Wed 29 Aug '07, 12:09pm

I have the same error, but I'm confused @Freddie Bingham post, file blog_subscriptions.php requests this "comments" information :

line 429

PHP Code:


SELECT SQL_CALC_FOUND_ROWS blog_user.entries, comments, lastblog,

What exactly did you mean ?

**Zachery** · Wed 29 Aug '07, 3:44pm

Do you have another comments table/row in your database?

**Marty1970** · Thu 30 Aug '07, 12:43am

File product-vbblog.xml creates this "comments" row on the blog_user table.

Code:

CREATE TABLE " . TABLE_PREFIX . "[B]blog_user[/B] (
        bloguserid INT UNSIGNED NOT NULL DEFAULT '0',
        title VARCHAR(255) NOT NULL DEFAULT '',
        description MEDIUMTEXT NOT NULL,
        allowsmilie SMALLINT UNSIGNED NOT NULL DEFAULT '1',
        options INT UNSIGNED NOT NULL DEFAULT '0',
        viewoption ENUM('all','only','except') NOT NULL DEFAULT 'all',
        [COLOR=Red][B]comments[/B][/COLOR] INT UNSIGNED NOT NULL DEFAULT '0',
        lastblog INT UNSIGNED NOT NULL DEFAULT '0',
        lastblogid INT UNSIGNED NOT NULL DEFAULT '0',
        lastblogtitle VARCHAR(255) NOT NULL DEFAULT '',
        lastcomment INT UNSIGNED NOT NULL DEFAULT '0',
        lastcommenter VARCHAR(100) NOT NULL DEFAULT '',
        lastblogtextid INT UNSIGNED NOT NULL DEFAULT '0',
        entries INT UNSIGNED NOT NULL DEFAULT '0',
        deleted INT UNSIGNED NOT NULL DEFAULT '0',
        moderation INT UNSIGNED NOT NULL DEFAULT '0',
        draft INT UNSIGNED NOT NULL DEFAULT '0',
        pending INT UNSIGNED NOT NULL DEFAULT '0',
        ratingnum INT UNSIGNED NOT NULL DEFAULT '0',
        ratingtotal INT UNSIGNED NOT NULL DEFAULT '0',
        rating FLOAT UNSIGNED NOT NULL DEFAULT '0',
        subscribeown ENUM('none', 'usercp', 'email') NOT NULL DEFAULT 'none',
        subscribeothers ENUM('none', 'usercp', 'email') NOT NULL DEFAULT 'none',
        uncatentries INT UNSIGNED NOT NULL DEFAULT '0',
        akismet_key VARCHAR(15) NOT NULL DEFAULT '',
        options_everyone INT UNSIGNED NOT NULL DEFAULT '0',
        options_buddy INT UNSIGNED NOT NULL DEFAULT '0',
        options_ignore INT UNSIGNED NOT NULL DEFAULT '0',
        isblogmoderator SMALLINT UNSIGNED NOT NULL DEFAULT '0',
        comments_moderation INT UNSIGNED NOT NULL DEFAULT '0',
        comments_deleted INT UNSIGNED NOT NULL DEFAULT '0',
        PRIMARY KEY  (bloguserid),
        KEY lastblog (lastblog, entries),
        KEY ratingnum (ratingnum, rating)
    )
");

Thus as above with this error.

Code:

Database error in vBulletin 3.6.8:

Invalid SQL:

            SELECT SQL_CALC_FOUND_ROWS [B]blog_user[/B].entries, [B][COLOR=Red]comments[/COLOR][/B], 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 = 1 AND buddy.type = 'buddy')
            LEFT JOIN userlist AS ignored ON (ignored.userid = user.userid AND ignored.relationid = 1 AND ignored.type = 'ignore')
            WHERE blog_subscribeuser.userid = 1
            ORDER BY blog_user.lastblog DESC
            LIMIT 0, 20;

MySQL Error  : Column '[B][COLOR=Red]comments[/COLOR][/B]' in field list is ambiguous
Error Number : 1052
Date         : Thursday, August 30th 2007 @ 02:36:10 AM
Script       : http://gamers-crib.com/blog_subscription.php?do=userlist
Referrer     : http://gamers-crib.com/blog_usercp.php
IP Address   : 87.232.32.46
Username     : Marty
Classname    : vB_Database

Which is called from file blog_subscription.php line 429

Code:

SELECT SQL_CALC_FOUND_ROWS [B]blog_user[/B].entries, [B][COLOR=Red]comments[/COLOR][/B], lastblog, lastblogid, lastblogtitle, blog_user.title, blog_subscribeuser.type, blog_user.ratingnum, blog_user.ratingtotal,

So with that in mind are we talking about the same database table.

This is a brand new installation from release vBulletin Blog 1.0.0

**Diggazz** · Thu 30 Aug '07, 2:54am

Originally posted by Freddie Bingham

You probably have a comments field in the user table from a hack. You'll need to remove it or rename it.

No this is not the case

No hacks installed that have a comments field in this new table

This is my first Blog software installation and no other hacks use table prefix vb3_blog_

**FBJunkie** · Thu 30 Aug '07, 8:13am

I am getting this error when clicking on the Blog Subscriptions button. Is there a fix to this?

PHP Code:


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 vb_blog_subscribeuser AS blog_subscribeuser
INNER JOIN vb_user AS user ON (user.userid = blog_subscribeuser.bloguserid)
LEFT JOIN vb_blog_user AS blog_user ON (blog_user.bloguserid = blog_subscribeuser.bloguserid)
LEFT JOIN vb_userlist AS buddy ON (buddy.userid = user.userid AND buddy.relationid = 1 AND buddy.type = 'buddy')
LEFT JOIN vb_userlist AS ignored ON (ignored.userid = user.userid AND ignored.relationid = 1 AND ignored.type = 'ignore')
WHERE blog_subscribeuser.userid = 1
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 @ 10:08:04 AM
Script : http://www.mywebsite.com/forums/blog_subscription.php?do=userlist
Referrer : http://www.mywebsite.com/forums/blog_subscription.php?do=entrylist
IP Address : **********
Username : myusername
Classname : vB_Database

**Marty1970** · Thu 30 Aug '07, 8:31am

Originally posted by FBJunkie

I am getting this error when clicking on the Blog Subscriptions button. Is there a fix to this?

PHP Code:


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 vb_blog_subscribeuser AS blog_subscribeuser
INNER JOIN vb_user AS user ON (user.userid = blog_subscribeuser.bloguserid)
LEFT JOIN vb_blog_user AS blog_user ON (blog_user.bloguserid = blog_subscribeuser.bloguserid)
LEFT JOIN vb_userlist AS buddy ON (buddy.userid = user.userid AND buddy.relationid = 1 AND buddy.type = 'buddy')
LEFT JOIN vb_userlist AS ignored ON (ignored.userid = user.userid AND ignored.relationid = 1 AND ignored.type = 'ignore')
WHERE blog_subscribeuser.userid = 1
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 @ 10:08:04 AM
Script : http://www.mywebsite.com/forums/blog_subscription.php?do=userlist
Referrer : http://www.mywebsite.com/forums/blog_subscription.php?do=entrylist
IP Address : **********
Username : myusername
Classname : vB_Database

doesn't seem to be, yet... you could of course delete the 'comments' row from your blog_user table, but thats not the answer, I'm sure the 'comments' row is there for a reason.

**Freddie Bingham** · Thu 30 Aug '07, 9:39am

One of the following tables has a comments field that is not part of vBulletin.

blog_subscribeuser
user
userlist

You can either find and remove/rename the field or you can edit the source code of blog_subscription.php and change comments to blog_user.comments

**FBJunkie** · Thu 30 Aug '07, 9:47am

If removing/renaming the fields or editing the source code in the file, will this affect comments functions in other areas other than the blog?

**Marty1970** · Thu 30 Aug '07, 10:09am

Originally posted by Freddie Bingham

One of the following tables has a comments field that is not part of vBulletin.

blog_subscribeuser
user
userlist

You can either find and remove/rename the field or you can edit the source code of blog_subscription.php and change comments to blog_user.comments

Thank you for the explanation, I had assumed the source code was only looking at blog_user table row comments, but now it makes sense.

So a quick fix for anyone else: open blog_subscriptions.php around line 429 find :

PHP Code:


SELECT SQL_CALC_FOUND_ROWS blog_user.entries, comments, lastblog, lastblogid, lastblogtitle, blog_user.title, blog_subscribeuser.type, blog_user.ratingnum, blog_user.ratingtotal,

and replace with :

PHP Code:


SELECT SQL_CALC_FOUND_ROWS blog_user.entries, blog_user.comments, lastblog, lastblogid, lastblogtitle, blog_user.title, blog_subscribeuser.type, blog_user.ratingnum, blog_user.ratingtotal,

Hope this helps...and remember this is something you guys and girls need to remember should there be an upgrade of this file.

**Freddie Bingham** · Thu 30 Aug '07, 12:56pm

What you need to remember, is that you have a field, installed by something other than vBulletin or the blog that conflicts with the blog. One of you send me a phpMyAdmin login and I'll tell you exactly what it is.

**Marty1970** · Thu 30 Aug '07, 2:23pm

maybe this new blog addon, needs to be more ''''commentary'''#,

Error when hitting the Blog Subscriptions Button

Error when hitting the Blog Subscriptions Button

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment