BeBot - An Anarchy Online and Age Of Conan chat automaton

Archive => Age of Conan Archive => AoC 0.6 support => Topic started by: Kyr on April 03, 2011, 04:30:14 am

Title: is the nickname too big?
Post by: Kyr on April 03, 2011, 04:30:14 am

Has anyone seen this error?

Does this mean the nickname field isn't large enough for a character name in AoC?

~Kyr

Code: [Select]

MySQL ERROR(# 1) on query: INSERT INTO whois (id, nickname, level, class, craft1
, craft2, location, online, updated) VALUES ('117612832', 'Warlander117612832',
'28', 'Conqueror', '', '', 1294872775, 0, '1301797544') ON DUPLICATE KEY UPDATE
id = VALUES(id), level = VALUES(level), class = VALUES(class), craft1 = VALUES(c
raft1), craft2 = VALUES(craft2), online = VALUES(online), location = VALUES(loca
tion),  updated = VALUES(updated)
Data too long for column 'nickname' at row 1

Title: Re: is the nickname too big?
Post by: Kentarii on April 04, 2011, 04:19:32 pm

nickname field in whois table is 15 chars long while it's 25 chars in <botname>_users.

Guess you can just run in mysql console:

Code: [Select]

ALTER TABLE `whois` CHANGE `nickname` `nickname` VARCHAR(25) NOT NULL DEFAULT '';
Edit: although whois table isn't really important, I guess you should perform a backup first.

Edit 2: perhaps someone should add this change to the bebot release as well??