BeBot - An Anarchy Online and Age Of Conan chat automaton
Archive => Age of Conan Archive => BeBot Hyborian support => Topic started by: Wizhk on January 04, 2009, 11:54:01 pm
-
This is the error.
MySQL error (# 0) on query: INSERT INTO whois (id, nickname, level, class, craft
1, craft2, location, online, updated) VALUES ('385928658', 'Decapitated', '72',
'Tempest of Set', 'Gemcutter', 'None', 1231109425, 0, '1231109422') ON DUPLICATE
KEY UPDATE id = VALUES(id), level = VALUES(level), class = VALUES(class), craft
1 = VALUES(craft1), craft2 = VALUES(craft2), online = VALUES(online), location =
VALUES(location), updated = VALUES(updated)
Data truncated for column 'craft2' at row 1
MySQL error (# 0) on query: INSERT INTO whois (id, nickname, level, class, craft
1, craft2, location, online, updated) VALUES ('385928658', 'Decapitated', '72',
'Tempest of Set', 'Gemcutter', 'None', 1231109425, 0, '1231109422') ON DUPLICATE
KEY UPDATE id = VALUES(id), level = VALUES(level), class = VALUES(class), craft
1 = VALUES(craft1), craft2 = VALUES(craft2), online = VALUES(online), location =
VALUES(location), updated = VALUES(updated)
Data truncated for column 'craft2' at row 1
Thanks
Wizhk
-
I saw this and wanted to add. Hope you don't mind me jumping in on this issue. I keep getting this on all the characters:
MySQL error (#0) on query: INSERT INTO whois (id, nickname, level, class, craft1, craft2, location, online, update) VALUES
After VALUES it all seems fine and shows the guild member's information and what not. Is there any resolve to this. I did as the first guy stated re-set up SQL and re-did the bebot and it is still doing this. In game everything apears to be working just fine. However I notice it does not state each character's level when they log on. It will state their name then say
Level ()
Hopefully this gives enough information to work with. If not please let me know what you need and I will add whatever information is needed to resolve this issue for us. :) Thanks in advance.
-
I'm getting same errors like the guys above, running bebot for Age of Conan, and the problem is geting more complicated every day, if at beginning i had 1 player with this error now i got 5, what i suspect is that it triggers after the player reach lvl 40 and he is asked to set his craft info's...but i might be wrong.
PROBLEM appeared when i updated from version 0.6.1 to 0.6.2.
ERROR LOG
MySQL error (# 0) on query: INSERT INTO whois (id, nickname, level, class, craft
1, craft2, location, online, updated) VALUES ('16860488', 'Vasili', '80', 'Range
r', 'None', 'None', 1236702616, 0, '1236767630') ON DUPLICATE KEY UPDATE id = VA
LUES(id), level = VALUES(level), class = VALUES(class), craft1 = VALUES(craft1),
craft2 = VALUES(craft2), online = VALUES(online), location = VALUES(location),
updated = VALUES(updated)
Data truncated for column 'craft1' at row 1
Assasinul [BUDDY] [LOG] Keyley changed status [1] (MEMBER)
MySQL error (# 0) on query: INSERT INTO whois (id, nickname, level, class, craft
1, craft2, location, online, updated) VALUES ('17059630', 'Tigrox', '47', 'Heral
d of Xotli', 'None', 'None', 1236721610, 0, '1236767635') ON DUPLICATE KEY UPDAT
E id = VALUES(id), level = VALUES(level), class = VALUES(class), craft1 = VALUES
(craft1), craft2 = VALUES(craft2), online = VALUES(online), location = VALUES(lo
cation), updated = VALUES(updated)
Data truncated for column 'craft1' at row 1
MySQL error (# 0) on query: INSERT INTO whois (id, nickname, level, class, craft
1, craft2, location, online, updated) VALUES ('17066862', 'Nectis', '49', 'Necro
mancer', 'None', 'None', 1236762429, 0, '1236767636') ON DUPLICATE KEY UPDATE id
= VALUES(id), level = VALUES(level), class = VALUES(class), craft1 = VALUES(cra
ft1), craft2 = VALUES(craft2), online = VALUES(online), location = VALUES(locati
on), updated = VALUES(updated)
Data truncated for column 'craft1' at row 1
MySQL error (# 0) on query: INSERT INTO whois (id, nickname, level, class, craft
1, craft2, location, online, updated) VALUES ('17078907', 'Moetos', '43', 'Tempe
st of Set', 'None', 'None', 1236707984, 0, '1236767636') ON DUPLICATE KEY UPDATE
id = VALUES(id), level = VALUES(level), class = VALUES(class), craft1 = VALUES(
craft1), craft2 = VALUES(craft2), online = VALUES(online), location = VALUES(loc
ation), updated = VALUES(updated)
Data truncated for column 'craft1' at row 1
My opinion is that ALL aoc users who upgraded got the error , they just don't read the bot info's or they didn't notice it yet or they don't got players to trigger it (see above comment)
..as I said I think this is correlated with the crafting option ( can those be disabled?)
LATER EDIT Problem solved by droping the WhoIS table.
-
We just updated to 0.6.3 and noticed the errors listed above, I was told the errors were showing the same as the OP had listed. After reading MysterF's post and thoughts that it was due to the crafting, we asked each member if they had set crafting with the bot. The members who had errors had set none as one of the two crafts. After asking them to fake being gemcutters (lol) they logged in and out and this fixed the errors. Admittedly I am not very bot savvy and try to pick up what I can, this seemed a bit easier then just dropping the whois table. Is there anything else we might have been able to do, to fix the none option?