[Aaron310012]

Lynne,

Thank you for your response. Just to recap, I have enabled RSS in the VB options. I then found this thread about limiting the RSS feed:

https://vborg.vbsupport.ru/showthread.php?t=166703

So at this point, I am using the plugin code:

unset($vbulletin->GPC['fulldesc']);
$vbulletin->options['threadpreview'] = 250;
$hook_query_fields .= ",LEFT(post.pagetext,400) AS message";

And I have created 3 separate plugins; 1 for the CMS product, 1 for the Forum product, and 1 for the Blog product.

This has worked great for the CMS and Forum, those RSS feeds are limited. However, I have tried both the external_query and the blog_external_query hooks using the code above but the blog RSS feed is not limited. Additionally, when using the blog_external_query hook only, I receive the database error when clicking the RSS icon from within the blog. Here is the database error:

Database error in vBulletin 4.1.12:

Invalid SQL:

SELECT blog.*, blog_text.*, user.*
,LEFT(post.pagetext,400) AS message
FROM blog AS blog
INNER JOIN blog_text AS blog_text ON (blog.firstblogtextid = blog_text.blogtextid)
INNER JOIN blog_user AS blog_user ON (blog_user.bloguserid = blog.userid)
LEFT JOIN user AS user ON (user.userid = blog_text.userid)


WHERE 1=1
AND blog.state = 'visible'
AND blog.dateline <= 1335495900
AND blog.pending = 0
AND blog_user.options_guest & 1
AND ~blog.options & 8



ORDER BY blog.dateline DESC
LIMIT 15;

MySQL Error : Unknown column 'post.pagetext' in 'field list'
Error Number : 1054
Request Date : Thursday, April 26th 2012 @ 09:05:00 PM
Error Date : Thursday, April 26th 2012 @ 09:05:00 PM
Script : http://www.mysite.com/blog_external.php?type=RSS2
Referrer : http://www.mysite.com/blog.php
IP Address : ***.**.***.***
Username : Unregistered
Classname : vB_Database
MySQL Version :

Any thoughts would be highly appreciated, I would really like to enable RSS for the blog, however I would prefer that the RSS feed only be a preview to the full content which could be found directly on my site if at all possible.