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

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

Author Topic: MySQL error  (Read 2494 times)

0 Members and 1 Guest are viewing this topic.

Offline soccerboyis

  • BeBot Rookie
  • *
  • Posts: 3
  • Karma: +0/-0
MySQL error
« on: July 27, 2008, 03:45:40 am »
I'm getting the follow error when someone logs on. Also, my whois does not work. Also, when I do a !member it says there is 0 members but when I try to add someone that is in the guild it says they are already a member... Is this b/c I never put in a guild ID number? is there a way to find out ur guild ID number? Right now mine is set to 00000000.

Quote
MySQL error (# 0) on query: INSERT INTO whois (id, nickname, level, class, craft
1, craft2, location, online, updated) VALUES ('83889778', 'Meghiddo', '80', 'Bar
barian', '', '', 1217122332, 0, '1217122337') ON DUPLICATE KEY UPDATE id = VALUE
S(id), level = VALUES(level), class = VALUES(class), craft1 = VALUES(craft1), cr
aft2 = VALUES(craft2), online = VALUES(online), location = VALUES(location),  up
dated = VALUES(updated)
Unknown column 'class' in 'field list'
Kodbot [BUDDY]  [LOG]   Meghiddo changed status
  • (MEMBER)

MySQL error (# 0) on query: INSERT INTO whois (id, nickname, level, class, craft
1, craft2, location, online, updated) VALUES ('83889778', 'Meghiddo', '80', 'Bar
barian', '', '', 1217122332, 0, '1217122337') ON DUPLICATE KEY UPDATE id = VALUE
S(id), level = VALUES(level), class = VALUES(class), craft1 = VALUES(craft1), cr
aft2 = VALUES(craft2), online = VALUES(online), location = VALUES(location),  up
dated = VALUES(updated)
Unknown column 'class' in 'field list'

Offline Vrykolas

  • BeBot Apprentice
  • ***
  • Posts: 100
  • Karma: +0/-0
Re: MySQL error
« Reply #1 on: July 27, 2008, 03:59:13 am »
There is a problem with the whois table in your database.

The easiest way to fix this is to shut down the bot, remove the database table and start the bot up again (assuming the core/Whois.php file hasn't gotten corrupted somehow).

Offline soccerboyis

  • BeBot Rookie
  • *
  • Posts: 3
  • Karma: +0/-0
Re: MySQL error
« Reply #2 on: July 27, 2008, 06:27:23 am »
Thank you very much! All I did was drop the whois table booted the bot right back up and everything started working again!

 

* Recent Posts
Com bot module by bitnykk
[November 25, 2024, 05:36:11 pm ]


0.8.x updates for AO by bitnykk
[June 23, 2024, 03:19:47 pm ]


0.8.x updates for AoC by bitnykk
[June 23, 2024, 03:19:44 pm ]


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


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

* Who's Online
  • Dot Guests: 297
  • 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