BeBot - An Anarchy Online and Age Of Conan chat automaton
Archive => Anarchy Online Archive => BeBot 0.2 support => Topic started by: Takun on May 12, 2007, 12:55:26 am
-
Ho kay so, I R moving bot from one org to another... All I did was go into the Conf file and change the org name and # there... moved the bot toon into the org and made it member blah blah cookies and pie
SO NOW!
After moving the bot im having problems with it keeping any new members... people in org arnt getting updated into roster and are not considered members so they cant do any bot commands... even doing !member doesnt do anything... only my self set as admin in the bot (or what ever) file can give it commands...
Did I miss something? (A setting) Did I need to reset the bot some how? Maybe make a new table for the new org roster in SQLyog?
Anyways Anyways, I have no idea if this is even related or wtfux sauce is going on but this is what I get when I log the bot on...
[ROSTER] [UPDATE] Starting roster update
MySQL error 0 on query: SELECT id, rank, level, ailevel, lastseen, updated FROM members WHERE id = 429368548
Unknow column 'ailevel' in 'field list'
MySQL error 1 on query: REPLACE INTO members (id, nickname, firstname, lastname, rank, rank_name, level, profession, gender, breed, ailevel, aititle, lastseen, updated)
VALUES (429368548
Takun, Naota
FuriKuri 0
Director 220
Engineer Male
Solitus 21
Then it Does it again.. for more members
Then I get that about 9 more times till it reaches the 10 error limit then stops..
Then we go into...
[BUDDY] [ADD] Takun (does for everyone in org)
[ROSTER] [UPDATE] Roster Update Complete Added 92 members, removed 0
[BUDDY LOG] Takun Logged [off] (not member)
Now dont get me wrong.. but if it just updated me as a buddy and member why am i not considered a member in the BUDDY LOG part?
JJ gief help and beastnet points! Khalem you can help too ;p
-
Double check the roster_guild.php is the same between the two bots, it doesn't seem to be as your database hasn't been created correctly.
-jj-
-
Sounds like some time ago when the bot was running in the old org you changed the roster_guild.php to the new version that includes the ai level but you didn't drop the 'members' table. This doesn't affect you much in the old org because the members were already in the database, but when the bot tries to add members now it cannot go through because of the error. The bot will still see them logging on and off (since they are in the buddy list) but won't accept any command because they are not in the members table. Try dropping (deleting) your old members table in the database, /should/ solve the problem.
Cheers,
Tony
-
From what I can tell the members database is already gone (from the old org) Theres 0 Rows in the data at least, which I would assume means that there is nothing :P
All the old org-s members arnt members anymore....
Im very confuzzled! ???
Btw JJ there is no 2 bots here.. its one bot.. it was the org bot for one org then i moved it to another...
Secondly in case I do need to make a database for my members / a new one / something how would one go about doing such a thing :<
-
1) Have you tried deleting the table? not just clear it.... if the table doesn't exist, roster_guild.php will create a new one with all the updated columns.
2) If you want to create a new member table, I suggest starting from scratch and create a fresh database, since other tables might be out of date too. If you don't know how, try getting mysql frontend such as SQLyog (http://www.webyog.com/en/downloads.php) or phpMyAdmin (http://www.phpmyadmin.net/home_page/downloads.php).
Cheers,
Tony