Announcement

Collapse
No announcement yet.

DB error

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

  • CocteauBoy
    replied
    Originally posted by Steve Machol View Post
    See post #6 except change the table name from rssfeed to vb3_rssfeed.
    Oh wow, thank you! I ran it, so I will report in as to whether this worked, or if new issues emerge. Thank you so much!

    troy

    Leave a comment:


  • Steve Machol
    replied
    See post #6 except change the table name from rssfeed to vb3_rssfeed.

    Leave a comment:


  • CocteauBoy
    replied
    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

    Leave a comment:


  • CocteauBoy
    replied
    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!

    Leave a comment:


  • Steve Machol
    replied
    I have no idea why you would get that 'choose a column' issue. I've never heard of this before.

    Leave a comment:


  • CocteauBoy
    replied
    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 6 Aug '06, 12:10pm.

    Leave a comment:


  • Steve Machol
    replied
    Run that query in the SQL tab in phpMyAdmin.

    Leave a comment:


  • CocteauBoy
    replied
    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

    Leave a comment:


  • Steve Machol
    replied
    You're welcome.

    Leave a comment:


  • neuromancer11
    replied
    Solved the problem.

    Thanks for fast support

    Leave a comment:


  • Steve Machol
    replied
    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)
    );

    Leave a comment:


  • neuromancer11
    replied
    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

    Leave a comment:


  • neuromancer11
    replied
    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.

    Leave a comment:


  • Paul M
    replied
    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.

    Leave a comment:


  • Floris
    replied
    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.

    Leave a comment:

Related Topics

Collapse

Working...
X