DB error

[neuromancer11]

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 ?

[Floris]

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.

[Paul M]

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.

[neuromancer11]

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.

[neuromancer11]

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

[Steve Machol]

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)
);

[neuromancer11]

Solved the problem.

Thanks for fast support

[Steve Machol]

You're welcome.

[CocteauBoy]

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

[Steve Machol]

Run that query in the SQL tab in phpMyAdmin.

[CocteauBoy]

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

[Steve Machol]

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

[CocteauBoy]

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!

[CocteauBoy]

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

[Steve Machol]

See post #6 except change the table name from rssfeed to vb3_rssfeed.