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 2547 times)

0 Members and 1 Guest are viewing this topic.

Offline Ankou

  • BeBot User
  • **
  • Posts: 23
  • Karma: +0/-0
mysql error
« on: December 17, 2011, 11:13:20 am »
have a small problem with some of my guildies.

MySQL ERROR(# 419) on query: INSERT INTO whois (id, nickname, level, class, craf
t1, craft2, location, online, updated) VALUES ('33753750', 'Muba', '80', 'Dark T
emplar', 'None', 'None', 1324113938, 0, '1324113936') ON DUPLICATE KEY UPDATE id
 = VALUES(id), level = VALUES(level), class = VALUES(class), craft1 = VALUES(cra
ft1), craft2 = VALUES(craft2), online = VALUES(online), location = VALUES(locati
on),  updated = VALUES(updated)
Data truncated for column 'craft1' at row 1Succubot [BUDDY]     [LOG]   Muba cha
nged status
  • (MEMBER)


Its only with some charts, some others from the same person dont have this problem and if y use member del and member add run good... until this chart dont change of area.

I understand i need to change something in the database but dont know where and what.

Offline grey

  • BeBot Rookie
  • *
  • Posts: 7
  • Karma: +0/-0
Re: mysql error
« Reply #1 on: December 19, 2011, 05:17:25 pm »
For those experiencing this common error, which shows up when there are null entries in the crafting skills for bot members, there is a simple fix.  Stop your bot, 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. Now restart your bot.
This forces the sql server to behave as it did in version 4.0 and earlier, and it will not display this error.

Offline Ankou

  • BeBot User
  • **
  • Posts: 23
  • Karma: +0/-0
Re: mysql error
« Reply #2 on: December 19, 2011, 06:03:18 pm »
thank you very much

 

* 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: 361
  • 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