znote acc not auto install tables in mysql

[Hitman94]

eng:
hello, I can not turn on the auto install, it did not add a lot of tables in the database so I have a lot of errors. How to enable installations. sorry for english I use the translator

polish:
witam, nie potrafie włączyć auto install nie dodało dużo tabel w bazie przez co mam dużo blędów. Jak włączyć instalacje.

Ubuntu 16.04
php 7.0

otserv im downloading in here
[7.4][OTX] RLMAP 100%, Port Hope 7.4, POI, Demon OaK, War System, Shared Exp ...
this is tfs 1.2?

$config['TFSVersion'] = 'TFS_02';

my site
Znote AAC


config.php

<?php
    if (!defined('ZNOTE_OS')) {
        $isWindows = (strtoupper(substr(PHP_OS, 0, 3)) === 'WIN');
        define('ZNOTE_OS', ($isWindows) ? 'WINDOWS' : 'LINUX');
    }
   
    // If you want to use items.php (not 100% yet, I guess)
    // Tested with TFS items.xml master (1.3)
    $config['items'] = false;
   
    // Available options: TFS_02, TFS_03
    // TFS 0.2 = TFS_02
    // TFS 0.3 = TFS_03 (If ur using 0.3.6, set $config['salt'] to false)!
    // TFS 0.4 = TFS_03
    // TFS 1.0 = TFS_10 (Under developement)
    $config['TFSVersion'] = 'TFS_02';
    // As far as I know, OTX is based on TFS_03, so make sure TFS version is configured TFS_03
    $config['CustomVersion'] = false;

    $config['site_title'] = 'Znote AAC';
    $config['site_title_context'] = 'Because open communities are good communities. :3';
    $config['site_url'] = "195.242.117.68";

    // Path to server folder without / Example: C:\Users\Alvaro\Documents\GitHub\forgottenserver
    $config['server_path'] = '/home/otserv'; 

    // ------------------------ \\
    // MYSQL CONNECTION DETAILS \\
    // ------------------------ \\

    // phpmyadmin username for OT server: (DONT USE "root" if ur hosting to public.).
    $config['sqlUser'] = 'otserv';

    // phpmyadmin password for OT server:
    $config['sqlPassword'] = 'my pass';

    // The database name to connect to. (This is usually same as username).
    $config['sqlDatabase'] = 'otserv';

    // Hostname is usually localhost or 127.0.0.1.
    $config['sqlHost'] = '127.0.0.1';

    // QR code authenticator Only works with TFS 1.2+
    $config['twoFactorAuthenticator'] = true;
    // You can use the mobile phone app "authy" with this.

 

[Hitman94]

sample
CREATE CHARACTER

string(750) "INSERT INTO `players`(`name`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `premend`, `online`, `balance`) VALUES ('Ghjgh', '1', '11', '8', '1', '185', '185', '4200', '68', '76', '78', '58', '128', '0', '0', '40', '40', '0', '100', '1', '5', '5', '2', '', '470', '1', '0', '780550762', '1', '0', '0', '0', '', '0', '0', '0', '10', '10', '10', '0', '0', '0');" 
(query - SQL error) 
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Field 'auction_balance' doesn't have a default value

 

[Hitman94]

reginser account

Register Account
string(135) "INSERT INTO `accounts` (`name`, `password`, `email`) VALUES ('hitman094', '271999f80cb412115d5b8a2d65169088c45bd507', '[email protected]')" 
(query - SQL error) 
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Field 'email_new' doesn't have a default value