BeBot - An Anarchy Online and Age Of Conan chat automaton
Archive => Anarchy Online Archive => BeBot 0.3 support => Topic started by: Vallaroo on June 30, 2006, 07:52:49 pm
-
When i start the bot i get the following errors:
Connected to MySQL
MySQL error (# 0) on query: ALTER TABLE admin_groups ADD description VARCHAR(80)
Duplicate column name 'description'
MySQL error (# 1) on query: ALTER TABLE admin_groups ADD short VARCHAR(5)
MySQL error (# 2) on query: ALTER IGNORE TABLE guests ADD COLUMN name VARCHAR(25
) NOT NULL AFTER id
Duplicate column name 'name'
MySQL error (# 3) on query: ALTER IGNORE TABLE guests ADD COLUMN timeadd INT NOT
NULL AFTER name
Duplicate column name 'timeadd'
MySQL error (# 4) on query: ALTER IGNORE TABLE guests ADD COLUMN addby VARCHAR(2
5) NOT NULL AFTER timeadd
Duplicate column name 'addby'
and a few:
MySQL error (# 5) on query: SELECT nickname, level, rank_name, profession, id, a
ilevel FROM members WHERE id = 790755685
Table 'polbot2.members' doesn't exist
Looking at the DB the members table doesnt exist.
I installed 0.3.4 in an empty database.
Another thing too, all commands only work in tells. How can i allow them to work in gc ?
-
The ALTER MySQL errors can be ignored.
You can comment out those queries from the modules that call them since they are only needed to be run once.
Error #5 is likely from the Online module.
I just committed a fix for that issue to svn, so do an update.
To adjust commands access, /tell botname !commands
When running svn versions, be sure to keep an eye on http://bebot.link/index.php/topic,147.105.html for any information related to SVN being broken etc.
-
Thank you for the fast response :)
I updated online.php as you suggested, and the previous error #5 is gone. On the other hand, i now have a new one:
MySQL error (# 5) on query: SELECT nickname, level, org_rank, profession, id, de
fender_rank_id FROM whois WHERE id = 790755685
Unknown column 'nickname' in 'field list'
Also my bot.conf files currently contain 3 SA`s, when i do a /tell mybot admin groups, all groups come up emtpy. So there are no admins/SAs on my bot atm.
-
Think of the bot.conf SA's as hardcoded backdoors. The admin groups command reads from the database and that doesn't include what was put in the conf file.
It's handy for making org non-members SA's. ;)
-
Well my bot doesnt listen to anyone, and i get "you must be superadmin..." a lot. And i AM superadmin. Btw. in 2.5 those hardcoded guild or not guild SA`s appear in the list. So there is something wrong with my installation running 0.3.4.
-
My mistake. Mine are there. Are you sure they're in the right format? When I changed from .2.5 to .3 I didn't move my Bot.conf over because I noticed some changes to how it was laid out and stuff (don't exactly remember now), I just re-entered the information.
$super_admin["Ainen"] = true;
Sometimes you have to check that the lines aren't accidentally commented out.
-
Yep, there are 3 SAs in the conf file, but they dont get added to the DB. And the lines are correct.
-
I added them manually to the DB, works like a charm now.