collapse collapse
* User Info
 
 
Welcome, Guest. Please login or register.
* Search

* Board Stats
  • stats Total Members: 989
  • stats Total Posts: 18363
  • stats Total Topics: 2500
  • stats Total Categories: 7
  • stats Total Boards: 35
  • stats Most Online: 1144

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

0 Members and 2 Guests are viewing this topic.

Offline Wizhk

  • BeBot Apprentice
  • ***
  • Posts: 85
  • Karma: +0/-0
!Whois wont work for one of my bot Members
« 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


Offline squattinbull

  • BeBot User
  • **
  • Posts: 29
  • Karma: +0/-0
Re: !Whois wont work for one of my bot Members
« 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.
« Last Edit: February 10, 2009, 05:08:53 am by squattinbull »

Offline MysterF

  • BeBot User
  • **
  • Posts: 25
  • Karma: +0/-0
Re: !Whois wont work for one of my bot Members
« 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.
« Last Edit: March 13, 2009, 08:54:37 am by MysterF »

Offline Justine

  • BeBot Rookie
  • *
  • Posts: 16
  • Karma: +0/-0
Re: !Whois wont work for one of my bot Members
« 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?

 

* Recent Posts
[AoC] special char for items module by bitnykk
[February 09, 2024, 09:41:18 pm]


0.8.x updates for AoC by bitnykk
[January 30, 2024, 11:16:08 pm]


0.8.x updates for AO by bitnykk
[January 30, 2024, 11:15:37 pm]


BeBot still alive & kicking ! by bitnykk
[December 17, 2023, 12:58:44 am]


Bebot and Rasberry by bitnykk
[November 29, 2023, 11:04:14 pm]

* Who's Online
  • Dot Guests: 483
  • Dot Hidden: 0
  • Dot Users: 0

There aren't any users online.
* Forum Staff
bitnykk admin bitnykk
Administrator
Khalem admin Khalem
Administrator
WeZoN gmod WeZoN
Global Moderator
SimplePortal 2.3.7 © 2008-2024, SimplePortal