BeBot - An Anarchy Online and Age Of Conan chat automaton

Archive => Age of Conan Archive => AoC 0.6 support => Topic started by: Gauche on January 12, 2010, 11:47:43 am

Title: Whois Error
Post by: Gauche on January 12, 2010, 11:47:43 am

Hi, today i have this error :

Code: [Select]

Count: 1
MySQL ERROR(# 852) on query: SELECT * FROM whois WHERE nickname = 'Sulate'
Table '.\bebot\whois' is marked as crashed and should be repairedMySQL ERROR(# 8
53) on query: INSERT INTO whois (id, nickname, level, class, craft1, craft2, loc
ation, online, updated) VALUES ('218263075', 'Sulate', '80', 'Guardian', '', '',
 199016, 1, '1263292244') ON DUPLICATE KEY UPDATE id = VALUES(id), level = VALUE
S(level), class = VALUES(class), craft1 = VALUES(craft1), craft2 = VALUES(craft2
), online = VALUES(online), location = VALUES(location),  updated = VALUES(updat
ed)
Table '.\bebot\whois' is marked as crashed and should be repairedMrbot [GROUP]
Total Count: 178205
Count: 1
MySQL ERROR(# 854) on query: SELECT * FROM whois WHERE nickname = 'Sulate'
Table '.\bebot\whois' is marked as crashed and should be repairedMySQL ERROR(# 8...


Title: Re: Whois Error
Post by: snyder on January 12, 2010, 11:57:57 am

says it should be repaired, did you try that?
if that dont work, delete that table and make new one

Code: [Select]

CREATE TABLE IF NOT EXISTS `whois` (
  `ID` int(15) NOT NULL DEFAULT '0',
  `nickname` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `level` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `class` enum('Commoner','Conqueror','Dark Templar','Guardian','Bear Shaman','Priest of Mitra','Scoin of Set','Tempest of Set','Assassin','Barbarian','Ranger','Demonologist','Herald of Xotli','Lich','Necromancer') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Commoner',
  `craft1` enum('','Alchemist','Architect','Armorsmith','Gemcutter','Weaponsmith','None') COLLATE utf8_unicode_ci DEFAULT NULL,
  `craft2` enum('','Alchemist','Architect','Armorsmith','Gemcutter','Weaponsmith','None') COLLATE utf8_unicode_ci DEFAULT NULL,
  `location` int(15) NOT NULL DEFAULT '0',
  `online` tinyint(1) NOT NULL DEFAULT '0',
  `used` bigint(25) NOT NULL DEFAULT '0',
  `org_rank_id` int(15) NOT NULL DEFAULT '0',
  `org_rank` int(15) NOT NULL DEFAULT '0',
  `org_name` varchar(15) COLLATE utf8_unicode_ci DEFAULT '',
  `updated` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`nickname`),
  KEY `ID` (`ID`),
  KEY `Class` (`class`),
  KEY `updated` (`updated`),
  KEY `used` (`used`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

Title: Re: Whois Error
Post by: Gauche on January 12, 2010, 01:34:46 pm

Oki thx it's ok^^

Title: Re: Whois Error
Post by: Gauche on January 16, 2010, 07:06:00 pm

Now I have a problem some users are increasingly recognized as a member of the bot, more some accounts have this when they connect :

Code: [Select]

Bot [BUDDY] [LOG] -1 changed status [1] <MEMBER>
Bot [BUDDY] [LOG] -1 changed status [6] <MEMBER>


Title: Re: Whois Error
Post by: Gauche on January 29, 2010, 10:01:36 am

No idea for my prob?