Booya
collapse collapse

* User Info

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

* Search


* Board Stats

  • stats Total Members: 987
  • stats Total Posts: 18309
  • stats Total Topics: 2490
  • stats Total Categories: 7
  • stats Total Boards: 33
  • stats Most Online: 500

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

0 Members and 1 Guest are viewing this topic.

Offline DarkGord

  • BeBot Rookie
  • *
  • Posts: 9
  • Karma: +0/-0
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
  • Karma: +0/-0
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
  • Karma: +0/-0
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

0.7.x updates for AO by bitnykk
[September 16, 2020, 04:40:04 pm]


0.7.x updates for AoC by bitnykk
[September 16, 2020, 04:39:47 pm]


Bebot 0.7.x still Alive ?! by bitnykk
[August 28, 2020, 07:09:23 pm]


Stats module by bitnykk
[April 16, 2020, 04:45:43 pm]


OnlineOrg by Hell
[February 28, 2020, 11:21:55 pm]

* Who's Online

  • Dot Guests: 78
  • 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-2020, SimplePortal