difficulties using blog_category.description

[Taragon]

Hello,

Currently I'm having some difficulties using blog_category.description within a mod.
// query to get the last blog entries
$latestblogs = $db->query_read_slave("
SELECT
blog.blogid,
blog.title,
blog_text.pagetext AS pagetext,
blog.comments_visible,
blog.username,
blog.dateline,
blog.firstblogtextid,
blog_text.blogtextid,
blog.userid,
blog.views,
blog_category.description AS description
FROM " . TABLE_PREFIX . "blog AS blog
INNER JOIN " . TABLE_PREFIX . "blog_text AS blog_text ON (blog.firstblogtextid = blog_text.blogtextid)
LEFT JOIN " . TABLE_PREFIX . "blog_user AS blog_user ON (blog_user.bloguserid=blog.userid)
WHERE blog.state = 'visible'
AND blog.pending = 0
AND blog_user.options_guest = 3
ORDER BY blog.blogid DESC
LIMIT " . $vbulletin->options['lb_limit'] . "
");

while ($showblogs=$db->fetch_array($latestblogs))
{
// strips the bbcode out of the post
$showblogs['pagetext'] = strip_bbcode($showblogs['pagetext'], $stripquotes = true, $fast_and_dirty = false, $showlinks = true);

// adds the cutoff ... with substr
$showblogs['pagetext'] = substr($showblogs['pagetext'], 0, $vbulletin->options['lb_cut']) . '...';

// convert pagetext to nice looking variable
$counter++;
$blog_userid = $showblogs['userid'];
$blogid = $showblogs['blogid'];
$blog_title = $showblogs['title'];
$blog_pagetext = $showblogs['pagetext'];
$blog_views = $showblogs['views'];
$blog_comments = $showblogs['comments_visible'];
$blog_username = $showblogs['username'];
$blog_description = $showblogs['description'];
$blog_dateline = vbdate($vbulletin->options['dateformat'], $showblogs['dateline']).' ';
$blog_dateline .= vbdate($vbulletin->options['timeformat'], $showblogs['dateline']);

eval('$latest_blogs .= "' . fetch_template('forumhome_latest_blog_bit') . '";');
}

eval('$latest_blogs = "' . fetch_template('forumhome_latest_blog') . '";');
Database error in vBulletin 3.8.0:

Invalid SQL:

SELECT
blog.blogid,
blog.title,
blog_text.pagetext AS pagetext,
blog.comments_visible,
blog.username,
blog.dateline,
blog.firstblogtextid,
blog_text.blogtextid,
blog.userid,
blog.views,
blog_category.description AS description
FROM blog AS blog
INNER JOIN blog_text AS blog_text ON (blog.firstblogtextid = blog_text.blogtextid)
LEFT JOIN blog_user AS blog_user ON (blog_user.bloguserid=blog.userid)
WHERE blog.state = 'visible'
AND blog.pending = 0
AND blog_user.options_guest = 3
ORDER BY blog.blogid DESC
LIMIT 5;

MySQL Error : Unknown column 'blog_category.description' in 'field list'
Error Number : 1054
Request Date : Monday, February 16th 2009 @ 07:09:39 PM
Error Date : Monday, February 16th 2009 @ 07:09:39 PM
Script : http://die16-clan.com/forum.php
Referrer :
IP Address : 77.166.91.51
Username : [DIE16]Taragon
Classname : vB_Database
MySQL Version : 5.0.67-community-log
Does someone know what I might be doing wrong here?

--------------- Added 1234834398 at 1234834398 ---------------

never mind this.

I was looking for a way to create an header image from this, like GARS, however I didn't think about multiple categories per blog...

looking for an alternative solution now :)

[Dismounted]

You need to join the "blog_category" to the query to be able to use it.