Announcement

Collapse
No announcement yet.

vB MySQL Error 1054

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

  • vB MySQL Error 1054

    Hey everyone. Just installed 3.6.4 and I am getting an error message email with the following contents every ten minutes or so.

    Database error in vBulletin 3.6.4:

    Invalid SQL:

    SELECT rssfeed.*, rssfeed.options AS rssoptions, user.*, forum.forumid
    FROM rssfeed AS rssfeed
    INNER JOIN user AS user ON (user.userid = rssfeed.userid)
    INNER JOIN forum AS forum ON (forum.forumid = rssfeed.forumid)
    WHERE rssfeed.options & 1;

    MySQL Error : Unknown column 'rssfeed.options' in 'field list'
    Error Number : 1054
    Date : Friday, January 12th 2007 @ 08:20:24 AM
    Script : http://www.bondmovies.com/board/cron.php?&rand=590964
    Referrer :
    IP Address : 74.6.72.35
    Username : Unregistered
    Classname : vb_database
    Any suggestions on a solution for this error? I have a newsbot installed from vB 3.5...Could this be the cause? I have tried to disable the bot, but I still get these errors...
    [email protected]
    BondMovies.com - "Nobody Does It Better."

  • #2
    You will need to remove the newsbot completely, and then look at your database to see which rss tables you have. Uninstalling the bot will remove some of the rss tables used by 3.6.4 as they have the same names, but these can easily be recreated by running some queries in phpmyadmin.
    Kerry-Anne :)

    Twitter Blog

    www.peterska2.com www.worldnewszone.com www.popularusenetgroups.com www.superclickers.co.uk www.forumsforchrist.com www.browsergameplanet.com

    Comment


    • #3
      So it is impossible for me to have this newsbot on my board without errors?

      It seemed to be working properly, too.
      [email protected]
      BondMovies.com - "Nobody Does It Better."

      Comment


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


        • #5
          Ok I ran that query successfully...Does this fix my board's RSS feed or allow me to have the newsbot functioning again without the error messages?

          Thanks for all of your help!
          [email protected]
          BondMovies.com - "Nobody Does It Better."

          Comment


          • #6
            This sets the vB RSS feed table. As for your 'newsbot' that is a non-vB program that we don't support. My guess is that this is not compatible with vB 3.6.4.
            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


            • #7
              No worries.

              Thanks a million for your quick responses.

              You guys rock and so does vB!
              [email protected]
              BondMovies.com - "Nobody Does It Better."

              Comment


              • #8
                http://www.vbulletin.org/forum/showt...12#post1066446

                3.6 has RSS feeds as a default feature. This modification uses the same tables as 3.6 and so will cause errors on upgrading to 3.6 unless you uninstall it first, and will not work due to the same tables being used.

                Comment

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