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

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

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 or phpMyAdmin.

Cheers,
Tony