BeBot - An Anarchy Online and Age Of Conan chat automaton

Archive => Anarchy Online Archive => BeBot 0.4 support => Topic started by: Aesgaard on October 21, 2007, 03:17:42 pm

Title: Blacklist error
Post by: 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?.

Title: Re: Blacklist error
Post by: Aesgaard 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.)

Title: Re: Blacklist error
Post by: Blueeagle 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. :)

Title: Re: Blacklist error
Post by: Blueeagle 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".

Title: Re: Blacklist error
Post by: Blueeagle 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.

Title: Re: Blacklist error
Post by: Aesgaard on October 25, 2007, 08:42:31 am

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

Title: Re: Blacklist error
Post by: Blueeagle 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) :D

I hope that helps.

Title: Re: Blacklist error
Post by: Aesgaard on October 29, 2007, 01:32:17 pm

Well, thanks, grabbed top module, got "creating database", got no more reccuring spam. <3