Author Topic: mysql error (Read 2546 times)

Ankou · « **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.

grey · « **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.

Ankou · « **Reply #2 on:** December 19, 2011, 06:03:18 pm »

thank you very much

Author Topic: mysql error (Read 2546 times)

Ankou

mysql error

grey

Re: mysql error

Ankou

Re: mysql error