Booya
collapse collapse

Menu

* User Info

 
 
Welcome, Guest. Please login or register.
Did you miss your activation email?

* Search


* Board Stats

  • stats Total Members: 1062
  • stats Total Posts: 18264
  • stats Total Topics: 2480
  • stats Total Categories: 7
  • stats Total Boards: 31
  • stats Most Online: 178

Author Topic: BeBot v0.6.2 released  (Read 11923 times)

0 Members and 1 Guest are viewing this topic.

Offline DarkGord

  • BeBot Rookie
  • *
  • Posts: 9
Re: BeBot v0.6.2 released
« Reply #15 on: August 08, 2009, 06:41:45 pm »
hello again :)
upgraded to 6.4 final and that was the first thing i tested. !setcraft none none to a fresh char today, but it seems the old problem exists, here for the bot window:

XXXX [MySQL] [ERROR] (# 23) on query: INSERT INTO whois (id, nickname, level,
 class, craft1, craft2, location, online, updated) VALUES ('17182482', 'XXXXX',
 '61', 'Demonologist', 'None', 'None', 3357156, 1, '1249747332') ON DUPLICATE KE
Y UPDATE id = VALUES(id), level = VALUES(level), class = VALUES(class), craft1 =
 VALUES(craft1), craft2 = VALUES(craft2), online = VALUES(online), location = VA
LUES(location),  updated = VALUES(updated)
Data truncated for column 'craft1' at row 1

Any thoughts? Or hits how i can resolve it?

Offline DarkGord

  • BeBot Rookie
  • *
  • Posts: 9
Re: BeBot v0.6.2 released
« Reply #16 on: November 05, 2009, 05:10:50 pm »
hate to bring this up again, but so far i am missing a solution. and being a noob is not helping here ;)
logging to mysql root and using the command
Code: [Select]
mysql>ALTER TABLE whois MODIFY craft2 enum('','Alchemist','Architect','Armorsmith','Gemcutter','Weaponsmith','None'); is resulting in database not specified error.. which makes sense... can you help me out by sharing how to direct the command at the database for bebot ?

Offline grey

  • BeBot Rookie
  • *
  • Posts: 8
Re: BeBot v0.6.2 released
« Reply #17 on: November 25, 2011, 06:51:33 am »
easiest way to resolve this issue, which is caused by blanks in your table, is to edit your my.ini file in your mysql install to comment out the current sql-mode= statement and add this one:
sql-mode=MYSQL40

then stop and restart your mysql service.

 

* Recent Posts

Some slight issues! by bitnykk
[October 04, 2017, 11:53:10 am]


Bot hosting (UtAvDrift Hosting) by Tessman
[August 24, 2017, 10:19:33 am]


CIDB by bitnykk
[July 21, 2017, 10:19:38 am]


Line 99 StartBot.php by Kepha
[October 17, 2016, 10:37:57 am]


New Central itemDB (!item[s|reg]) by aoc_botter
[September 17, 2016, 07:06:44 pm]

* Who's Online

  • Dot Guests: 28
  • Dot Hidden: 0
  • Dot Users: 0

There aren't any users online.

* Forum Staff

Khalem admin Khalem
Administrator
WeZoN gmod WeZoN
Global Moderator