Announcement

Collapse
No announcement yet.

DB Error on Edit RSS

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

  • DB Error on Edit RSS

    Went to check out the new rss feature
    getting
    Database error in vBulletin 3.6.0 Beta 3:

    Invalid SQL:

    SELECT rssfeed.*, user.username, forum.title AS forumtitle
    FROM rssfeed AS rssfeed
    INNER JOIN user AS user ON(user.userid = rssfeed.userid)
    INNER JOIN forum AS forum ON(forum.forumid = rssfeed.forumid)
    ORDER BY rssfeed.title;

    MySQL Error : Table 'gamene5_gentendo.rssfeed' doesn't exist
    Error Number : 1146
    Date : Thursday, June 22nd 2006 @ 02:40:18 PM
    Script : http://gentendo.com/forum/admincp/rssposter.php
    Referrer : http://gentendo.com/forum/admincp/index.php?do=nav
    IP Address : 69.179.116.244
    Username : Karl
    Classname : vb_database

    whats up with that.

  • #2
    The rssfeed table was created in Beta 1. Did you upgrade or is this a fresh install? If you've installed any hacks or plugins, try removing them.
    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
      upgrade. is there any way i can run through that install again? because if this was missed who knows what else was missed.

      Comment


      • #4
        Not really. However you can try running this query to create that table:

        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


        • #5
          that did it, ill report any other errors that i get when they surface

          Comment


          • #6
            The same error here. It´s a incompatibility with the hack "Inferno RSS FF Technology", it uses the same table rssfeed.
            Eliminated the table, eliminated the problem, you can create the table now
            Last edited by luroca; Tue 11 Jul '06, 2:31pm. Reason: Complete the info

            Comment

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