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

--------------------
Bill
Syracuse, NY
www.gunsnhoses.org

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

--------------------
Digital Kaos | Dreambox Guides

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?

--------------------
Bryce R [[ BLOG ]]
The Blogging Café - Blogging Forum
Do you run a forum? Check out my forum owners blog.

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

--------------------
Bill
Syracuse, NY
www.gunsnhoses.org