BeBot - An Anarchy Online and Age Of Conan chat automaton
Archive => Age of Conan Archive => BeBot Hyborian support => Topic started by: soccerboyis on July 27, 2008, 03:45:40 am
-
I'm getting the follow error when someone logs on. Also, my whois does not work. Also, when I do a !member it says there is 0 members but when I try to add someone that is in the guild it says they are already a member... Is this b/c I never put in a guild ID number? is there a way to find out ur guild ID number? Right now mine is set to 00000000.
MySQL error (# 0) on query: INSERT INTO whois (id, nickname, level, class, craft
1, craft2, location, online, updated) VALUES ('83889778', 'Meghiddo', '80', 'Bar
barian', '', '', 1217122332, 0, '1217122337') ON DUPLICATE KEY UPDATE id = VALUE
S(id), level = VALUES(level), class = VALUES(class), craft1 = VALUES(craft1), cr
aft2 = VALUES(craft2), online = VALUES(online), location = VALUES(location), up
dated = VALUES(updated)
Unknown column 'class' in 'field list'
Kodbot [BUDDY] [LOG] Meghiddo changed status
MySQL error (# 0) on query: INSERT INTO whois (id, nickname, level, class, craft
1, craft2, location, online, updated) VALUES ('83889778', 'Meghiddo', '80', 'Bar
barian', '', '', 1217122332, 0, '1217122337') ON DUPLICATE KEY UPDATE id = VALUE
S(id), level = VALUES(level), class = VALUES(class), craft1 = VALUES(craft1), cr
aft2 = VALUES(craft2), online = VALUES(online), location = VALUES(location), up
dated = VALUES(updated)
Unknown column 'class' in 'field list'
-
There is a problem with the whois table in your database.
The easiest way to fix this is to shut down the bot, remove the database table and start the bot up again (assuming the core/Whois.php file hasn't gotten corrupted somehow).
-
Thank you very much! All I did was drop the whois table booted the bot right back up and everything started working again!