Author Topic: Blacklist error (Read 3958 times)

Aesgaard · « **on:** October 21, 2007, 03:17:42 pm »

MySQL error (# 0) on query: SELECT * FROM betacom_blacklist WHERE expire > 0 AND
expire < 1192972474
Table 'alpha.betacom_blacklist' doesn't exist

now what?.

Aesgaard · « **Reply #1 on:** October 23, 2007, 01:23:56 am »

Still kinda waiting for an explanation as to why my bot is constantly spamming this or a sollution to fix/remove this problem (Somehow I think it includes manually creating a table but I'm not too familiar with mysql.)

Blueeagle · « **Reply #2 on:** October 23, 2007, 05:54:35 am »

This is a module that fails to create the table it's using. I'll have a look into it right away.

Blueeagle · « **Reply #3 on:** October 23, 2007, 06:28:24 am »

It appears that you're in the odd situation where a setting has been created even if the table does not exist.

This is, as far as I can see, a deficiency in the table schema code. I'm pondering what will be the best way to fix this.

The first workaround that comes to mind is to force a table creation if the table does not exist however it might not be "the best way".

Blueeagle · « **Reply #4 on:** October 23, 2007, 06:58:06 am »

There is untested code in the SVN that should handle the case where the setting has been created but the table is missing.

Aesgaard · « **Reply #5 on:** October 25, 2007, 08:42:31 am »

Untested codes? .. How do I get rid of the error ?

Blueeagle · « **Reply #6 on:** October 29, 2007, 01:24:55 pm »

I'm sorry, I assumed you knew how to grab files from the SVN. If you have a look at the menu at the top-left of this page you'll find an entry for "Browse SVN" Then you navigate trough bebot->trunk->modules->Blacklist.php and click the "Download" link. Replace the file you've got with that one. Be sure to make a backup before grabbing the latest version from the SVN as the files in the SVN might be broken (even more broken than what's in the releases)

I hope that helps.