Announcement

Collapse
No announcement yet.

Rss feed issues

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Joe D.
    replied
    "rss feed manager for cms" isn't a standard feature of VB4... Are you using this mod?

    If so support for mods takes place in their thread on vBulletin.org, we do not support mods on vbulletin.com.

    Leave a comment:


  • fusion_clan
    replied
    admin panel > rss feed manger >rss feed manger for cms then i get this error. all i do is click on the rss feed manger for cms and the error comes up.

    Code:
    Database error in vBulletin 4.1.9:  Invalid SQL:          
    SELECT rssfeed.*, user.username, forum.title AS forumtitle, sections.title AS sectiontitle         
    FROM rssfeed AS rssfeed         
    LEFT JOIN user AS user ON(user.userid = rssfeed.userid)         
    LEFT JOIN forum AS forum ON(forum.forumid = rssfeed.forumid)         
    LEFT JOIN cms_nodeinfo AS sections ON(sections.nodeid = rssfeed.sectionid)         
    ORDER BY rssfeed.title;  MySQL Error   : Unknown column 'rssfeed.sectionid' in 'on clause' 
    Error Number  : 1054 
    Request Date  : Monday, January 2nd 2012 @ 02:25:33 AM 
    Error Date    : Monday, January 2nd 2012 @ 02:25:33 AM 
    Script        : http://www.official-fusion.com/Home/admincp/rssposter_cms.php 
    Referrer      : http://www.official-fusion.com/Home/admincp/index.php?do=nav 
    IP Address    : 67.177.149.22 
    Username      : Pot 
    Classname     : vB_Database 
    MySQL Version : 5.0.92-community
    also get this error code when i try to add an rss feed for the cms this is after i submit it.

    Code:
    Database error in vBulletin 4.1.9:
    
    Invalid SQL:
    INSERT INTO rssfeed
        (title, url, ttl, maxresults, titletemplate, bodytemplate, searchwords, sectionid, forumid, prefixid, iconid, threadactiondelay, itemtype, endannouncement, userid, options)
    VALUES
        ('PC Gaming News', 'http://feeds.ign.com/ignfeeds/pc/', 600, 5, '{feed:title}', '{feed:description}\r\n\r\nMore...', '', 1, 3, '', 0, 0, 'cms', 7, '1', 5121);
    
    MySQL Error   : Unknown column 'sectionid' in 'field list'
    Error Number  : 1054
    Request Date  : Monday, January 2nd 2012 @ 02:29:05 AM
    Error Date    : Monday, January 2nd 2012 @ 02:29:05 AM
    Script        : http://www.official-fusion.com/Home/....php?do=update
    Referrer      : http://www.official-fusion.com/Home/....php?do=update
    IP Address    : 67.177.149.22
    Username      : Pot
    Classname     : vB_Database
    MySQL Version : 5.0.92-community
    Last edited by fusion_clan; Sun 1 Jan '12, 11:33pm.

    Leave a comment:


  • Joe D.
    replied
    Can you explain exactly where you are/what you do to get that error?

    Leave a comment:


  • fusion_clan
    replied
    any help here?

    Leave a comment:


  • fusion_clan
    started a topic [CMS] Rss feed issues

    Rss feed issues

    current error i get when i try to setup a rss feed for my cms news.

    Code:
    Database error in vBulletin 4.1.9:
    
    Invalid SQL:
    
            SELECT rssfeed.*, user.username, forum.title AS forumtitle, sections.title AS sectiontitle
            FROM rssfeed AS rssfeed
            LEFT JOIN user AS user ON(user.userid = rssfeed.userid)
            LEFT JOIN forum AS forum ON(forum.forumid = rssfeed.forumid)
            LEFT JOIN cms_nodeinfo AS sections ON(sections.nodeid = rssfeed.sectionid)
            ORDER BY rssfeed.title;
    
    MySQL Error   : Unknown column 'rssfeed.sectionid' in 'on clause'
    Error Number  : 1054
    Request Date  : Friday, December 30th 2011 @ 10:41:14 PM
    Error Date    : Friday, December 30th 2011 @ 10:41:14 PM
    Script        : http://www.official-fusion.com/Home/admincp/rssposter_cms.php
    Referrer      : http://www.official-fusion.com/Home/admincp/index.php?do=nav
    IP Address    : 67.177.149.22
    Username      : Pot
    Classname     : vB_Database
    MySQL Version : 5.0.92-community
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X