Announcement

Collapse
No announcement yet.

DB error

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

  • DB error

    Database error in vBulletin 3.6.0:
    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 : Unknown column 'rssfeed.userid' in 'on clause'
    Error Number : 1054
    Date : Saturday, August 5th 2006 @ 10:43:17 PM
    Script : http://www.****.org/admincp/rssposter.php
    Referrer : http://www.****.org/admincp/index.php?do=nav
    IP Address : 85.*****
    Username : ******
    Classname : vb_database
    I get this error.

    What is the problem ?? How can I fix it ?

  • #2
    MySQL Error : Unknown column 'rssfeed.userid' in 'on clause'

    Is this a fresh 3.6 installation or an upgrade from an older version. If the latter, from which version?

    Run the maintenance > diagnostics > suspect file versions > and check if any of the files are perhaps still from the old version.

    Comment


    • #3
      The error doesn't really make much sense unless your rssfeed table is corrupt in some way. Userid is one of the default fields in it.

      In sql, run a "describe rssfeed" query and see if the field is listed.
      Baby, I was born this way

      Comment


      • #4
        Originally posted by Floris View Post
        MySQL Error : Unknown column 'rssfeed.userid' in 'on clause'

        Is this a fresh 3.6 installation or an upgrade from an older version. If the latter, from which version?

        Run the maintenance > diagnostics > suspect file versions > and check if any of the files are perhaps still from the old version.
        I have upgraded it from vb 3.5.3.

        Now I ran 'suspect file versions', there isn't any old version files.

        Comment


        • #5
          I have disabled 'Inferno RSS FF Technology' hack from old version vbulletin. Now I have uninstall it. And I get this error now.

          Database error in vBulletin 3.6.0:
          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 'forumneu_vbul.rssfeed' doesn't exist
          Error Number : 1146
          Date : Sunday, August 6th 2006 @ 12:16:46 AM
          Script : http://www.****.org/admincp/rssposter.php
          Referrer : http://www.****.org/admincp/index.php?do=nav
          IP Address : 85.*****
          Username : *****9*
          Classname : vb_database

          Comment


          • #6
            You missed a step where this table was created. Run 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


            • #7
              Solved the problem.

              Thanks for fast support

              Comment


              • #8
                You're welcome.
                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


                • #9
                  Originally posted by Steve Machol View Post
                  You missed a step where this table was created. Run 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)
                  );
                  I have this same problem and when I try to run a QUERY on my forum database, the response is "you have to choose at least one column to display." I am not very experienced with MySQL or PHPMyAdmin, so I am sure I am just running this incorrectly. Can you easily instruct me as to how to run this Query, or direct me to specific directions?

                  Thank you so much!

                  troy

                  Comment


                  • #10
                    Run that query in the SQL tab in phpMyAdmin.
                    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


                    • #11
                      Originally posted by Steve Machol View Post
                      Run that query in the SQL tab in phpMyAdmin.
                      Oh, I did that. The response is that I have to choose a column? What does that mean? To be clear about what I am doing:

                      Clicking SQL tab of my forum database
                      Copy/Pasting your Query into the lower, right box labled: "SQL query on database [forum database name]:"
                      And then I get that result I quoted above.

                      Thanks!

                      EDIT: Okay, I ran this directly through the SQL "tab" (as you called it), which I thought was the actual tab within the database selected, but I figured out that you meant the SQL Button (as I would call it) that is at the top of the column on the left, which launches a window for the Query. In other words, I figured it out and it seems to have run properly! YAY!

                      troy
                      Last edited by CocteauBoy; Sun 6th Aug '06, 12:10pm.

                      Comment


                      • #12
                        I have no idea why you would get that 'choose a column' issue. I've never heard of this before.
                        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


                        • #13
                          Originally posted by Steve Machol View Post
                          I have no idea why you would get that 'choose a column' issue. I've never heard of this before.
                          I don't know, either, but check out my EDIT in the last post for an update! YAY!

                          Comment


                          • #14
                            More Database Errors

                            After running the Query, I am getting new errors generated (various versions of this same message):

                            Database error in vBulletin 3.6.0:

                            Invalid SQL:

                            SELECT rssfeed.*, rssfeed.options AS rssoptions, user.*
                            FROM vb3_rssfeed AS rssfeed
                            LEFT JOIN vb3_user AS user USING(userid)
                            WHERE rssfeed.options & 1;

                            MySQL Error : Table 'truthlov_tleforum.vb3_rssfeed' doesn't exist
                            Error Number : 1146
                            Date : Monday, August 7th 2006 @ 07:46:51 AM
                            Script : http://www.truthloveenergy.com/forum...p?&rand=503227
                            Referrer : http://www.truthloveenergy.com/forum...p?&rand=503227
                            IP Address : 84.251.244.45
                            Username : Unregistered
                            Classname : vb_database

                            Comment


                            • #15
                              See post #6 except change the table name from rssfeed to vb3_rssfeed.
                              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

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