SQL Database Error

[lrmzx9]

Invalid SQL:
UPDATE histtd_rss
SET `description`='',
`todaytitles`=''
WHERE `enabled`='1';

MySQL Error : Unknown column 'enabled' in 'where clause'
Error Number : 1054

How do I manually get rid of this error?

There is no histtd_rss in my SQL database. Can I create it? I cannot find anything related to this..

[Eikinskjaldi]

Originally Posted by lrmzx9

How do I manually get rid of this error?

There is no histtd_rss in my SQL database. Can I create it? I cannot find anything related to this..

If there was no histtd_rss in your database you would be geting the error "table histtd_rss does not exist"


The fact that you are getting a column error means that the table does exist, but doesn't have the column in question.

The most immediate way to fix it is to add a column to the table called enabled. However you clearly have half a hack in your system, you need to get rid of it completely.

[Antivirus]

Maybe if you search for that table name histtd_rss in the mods forums here you can find out which hack is causing the issue.

[lrmzx9]

Well I reinstalled the mod but its for a different version of VB 3.5 and I am running 3.6.7 now so the table is there. I disabled the mod in my admincp but its still searching for it in the database. The problem that caused this in the first place was I unistalled the mod and it removed the SQL tables.

[Antivirus]

When are you getting the error? Is it all the time, or just on a certain page? What mod was it that caused the issue and please include a link to the mod's thread.