Announcement

Collapse
No announcement yet.

Rss feed issues

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

  • [CMS] 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

  • #2
    any help here?

    Comment


    • #3
      Can you explain exactly where you are/what you do to get that error?

      Comment


      • #4
        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.

        Comment


        • #5
          "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.

          Comment

          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
          Working...
          X