Announcement

Collapse
No announcement yet.

RSS Feed DB error

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

  • RSS Feed DB error

    Hi,

    I get this when I click on "RSS Feed Manager". Add new RSS feed displays correct.

    Database error in vBulletin 3.6.4:

    Invalid SQL:

    SELECT rssfeed.*, user.username, forum.title AS forumtitle
    FROM 360_rssfeed AS rssfeed
    LEFT JOIN 360_user AS user ON(user.userid = rssfeed.userid)
    LEFT JOIN 360_forum AS forum ON(forum.forumid = rssfeed.forumid)
    ORDER BY rssfeed.title;

    MySQL Error : Unknown column 'rssfeed.userid' in 'on clause'
    Error Number : 1054
    Date : Tuesday, December 26th 2006 @ 01:36:41 AM
    Script : http://www.aaa.com/admincp/rssposter.php
    Referrer : http://www.aaa.com/admincp/index.php?do=nav
    Cheers..

  • #2
    That rssfeed table is from a hack you had installed. You need to drop that table, then recreate it with this query:

    CREATE TABLE rssfeed (
    rssfeedid INT UNSIGNED NOT NULL AUTO_INCREMENT,
    title VARCHAR(250) NOT NULL,
    url VARCHAR(250) NOT NULL,
    port SMALLINT UNSIGNED NOT NULL DEFAULT '80',
    ttl SMALLINT UNSIGNED NOT NULL DEFAULT '1500',
    maxresults SMALLINT NOT NULL DEFAULT '0',
    userid INT UNSIGNED NOT NULL,
    forumid SMALLINT UNSIGNED NOT NULL,
    iconid SMALLINT UNSIGNED NOT NULL,
    titletemplate MEDIUMTEXT NOT NULL,
    bodytemplate MEDIUMTEXT NOT NULL,
    searchwords MEDIUMTEXT NOT NULL,
    itemtype ENUM('thread','announcement') NOT NULL DEFAULT 'thread',
    threadactiondelay SMALLINT UNSIGNED NOT NULL,
    endannouncement INT UNSIGNED NOT NULL,
    options INT UNSIGNED NOT NULL,
    lastrun INT UNSIGNED NOT NULL,
    PRIMARY KEY (rssfeedid),
    KEY lastrun (lastrun)
    );
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      Thanks for the reply.

      I thought the RSS came with 3.6.4 but I know I installed the 3.5 RSS hack, sorry and thanks for that info

      Comment

      Loading...
      Working...
      X