• 0
[GR] Daz

can't create bambie character

Question

Posted (edited)

Anyone know how to fix this on linux?

extDB2: Found extdb-conf.ini
extDB2: Detected 12 Cores, Setting up 6 Worker Threads


[14:21:24 +02:00] [Thread 1382] extDB2: Database Type: MySQL
[14:21:24 +02:00] [Thread 1382] extDB2: Database Session Pool Started
[14:21:24 +02:00] [Thread 1382] extDB2: SQL_CUSTOM_V2: Loading Template Filename: /home/tcagame/admin/12/@exileserver/extDB/sql_custom_v2/exile.ini
[14:21:24 +02:00] [Thread 1382] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available
[14:22:29 +02:00] [Thread 1382] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error    [mysql_stmt_error]: Field 'assigned_items' doesn't have a default value    [mysql_stmt_errno]: 1364    [mysql_stmt_sqlstate]: HY000    [statemnt]: INSERT INTO player SET account_uid = ?, name = ?
[14:22:29 +02:00] [Thread 1382] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[14:22:29 +02:00] [Thread 1382] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: createPlayer:76561198209407600:Daz
Edited by [GR] Daz

Share this post


Link to post
Share on other sites

3 answers to this question

  • 0

Posted (edited)

Fixed this i had to run 

Cent Os: yum install  glibc.i686 libstdc++ libstdc++.i686 


yum install tbb.i686

 

and run in the mysql

SELECT @@GLOBAL.sql_mode;
SET @@GLOBAL.sql_mode= '';
SET @@GLOBAL.sql_mode= 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

Edited by [GR] Daz

Share this post


Link to post
Share on other sites
  • 0
16 minutes ago, Steelius said:

Awhh :( I really wanted to resolve this!

aha sorry i did get another issue with mysql strict do you know how to save it perm? im on centos every time i restart mysql the strict mode comes back i have to run this every time mysql is restarted

SELECT @@GLOBAL.sql_mode;
SET @@GLOBAL.sql_mode= '';
SET @@GLOBAL.sql_mode= 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

Share this post


Link to post
Share on other sites
Advertisement

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.