vBulletin error messages

**Retired Chief** · 04-06-2008, 09:59 AM

I get a couple of error messages regularly, that I'd like to address and maybe someone here can help;

#1
Invalid SQL:
select * from rssfeed;

MySQL Error : Table 'mydomain_vbforum.rssfeed' doesn't exist Error Number : 1146
Date : Sunday, April 6th 2008 @ 11:39:45 AM
Script : http://www.mydomain.org/forum/cron.php?&rand=677094
Referrer : http://www.mydomain.org/forum/index.php
IP Address : xx.67.214.214
Username : Unregistered
Classname : vB_Database

#2
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 : Table 'mydomain_vbforum.rssfeed' doesn't exist Error Number : 1146
Date : Sunday, April 6th 2008 @ 11:28:10 AM
Script : http://www.mydomain.org/forum/cron.php?&rand=850718
Referrer : http://www.mydomain.org/forum/showthread.php?t=146
IP Address : xx.162.153.126
Username : Unregistered
Classname : vB_Database

I removed the domain name in case leaving it on the web was a hazard. vBulletin.com support said I have to create a table, but I need some direction on where and how to do it. If I see it once, I should be able to get it.

On another note, I get sometimes a half dozen spam registrations a day, many from .ru. Has anyone found a way to reduce this?

Thanks
Bill

**glennybee** · 04-06-2008, 10:02 PM

Sorry, can't help with the errors, although they seem related to the RSS.

But you can add .ru email address to the banned list in ACP so that they can't register if using those addresses.

vBulletin Options -> User Banning Options

**bdude** · 04-06-2008, 11:58 PM

It means the 'rssfeed' table doesn't exist in your database - how to get it back I'm not sure, I don't know if running install.php will wipe your whole db. Try posting on vbulletin.com forums?

**Retired Chief** · 04-10-2008, 06:56 PM

Thank you both for your help. I'll post the question on vb.com.