Author Topic: !Whois wont work for one of my bot Members (Read 8363 times)

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

squattinbull · « **Reply #1 on:** February 10, 2009, 03:00:57 am »

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.

MysterF · « **Reply #2 on:** March 11, 2009, 12:03:11 pm »

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

Code: [Select]

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.

Justine · « **Reply #3 on:** June 04, 2009, 12:55:51 am »

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?

Author Topic: !Whois wont work for one of my bot Members (Read 8363 times)

Wizhk

!Whois wont work for one of my bot Members

squattinbull

Re: !Whois wont work for one of my bot Members

MysterF

Re: !Whois wont work for one of my bot Members

Justine

Re: !Whois wont work for one of my bot Members