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: MySQL error  (Read 1648 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
[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: 485
  • 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