BeBot - An Anarchy Online and Age Of Conan chat automaton

Archive => Anarchy Online Archive => BeBot 0.5 support => Topic started by: Foodor on March 04, 2008, 06:50:31 pm

Title: SQL error on startup
Post by: Foodor on March 04, 2008, 06:50:31 pm

I was wondering why I get this error after I install nano plugin

MySQL error (# 0) on query: SELECT value FROM settings WHERE setting = 'nano icon'
Table 'bebot.settings' doesn't exist MySQL error (# 1) on query: NSERT INTO settings (setting, value) VALUES ('nano icon', '1')
Table 'bebot.settings' doesn't exist

Foo

Title: Re: SQL error on startup
Post by: Alreadythere on March 04, 2008, 08:09:38 pm

That must be an old module, bebot 0.4 and newer bring a settings framework as core module, which doesn't support those inserts anymore - it got a different table structure. Besides, the table most likely now is called botname_settings, as bebot on default is using the botname as table prefix for all the bot-specific tables, only some tables which should be global among all hosted bots are without prefix.

I believe there is a 0.4 version of the nano module around.

Title: Re: SQL error on startup
Post by: Temar on March 04, 2008, 08:56:27 pm

yes its under 0.4 unofficial modules
Go down the topic and find my verion its the latest.

http://bebot.link/index.php/topic,974.msg8161.html#msg8161 (http://bebot.link/index.php/topic,974.msg8161.html#msg8161)