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: Data truncated for column "class1" at row 1 errors  (Read 2151 times)

0 Members and 1 Guest are viewing this topic.

Offline grey

  • BeBot Rookie
  • *
  • Posts: 7
  • Karma: +0/-0
Data truncated for column "class1" at row 1 errors
« on: November 25, 2011, 06:57:29 am »
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.  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.
This forces the sql server to behave as it did in version 4.0 and earlier, and it will not display this error.

 

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