AAC Failed Account [ Znote ACC ]

Seba1212

New Member
Joined
Nov 6, 2018
Messages
14
Best answers
0
Reaction score
0
I can not create a new character is an error



string(740) "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 ('Test', '1', '2', '8', '1', '185', '185', '4200', '68', '76', '78', '58', '128', '0', '0', '40', '40', '0', '100', '1', '5', '5', '2', '', '470', '1', '0', '0', '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)

Thread stack overrun: 8688 bytes used of a 131072 byte stack, and 128000 bytes needed. Use 'mysqld --thread_stack=#' to specify a bigger stack.
 
OP
S

Seba1212

New Member
Joined
Nov 6, 2018
Messages
14
Best answers
0
Reaction score
0
skip-external-locking
key_buffer_size = 16K
max_allowed_packet = 1M
table_open_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 128K

character-set-server=utf8
 

Mile Kitic

Banned User
Joined
Dec 8, 2017
Messages
143
Best answers
2
Reaction score
41
skip-external-locking
key_buffer_size = 16K
max_allowed_packet = 1M
table_open_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 128K

character-set-server=utf8
thread_stack = 128K ->>>> thread_stack = 128M
Restart Uniserver/Or what else you are using
 
OP
S

Seba1212

New Member
Joined
Nov 6, 2018
Messages
14
Best answers
0
Reaction score
0
ok and this error?

highlighted in yellow

Bez tytułu.png
 

Mile Kitic

Banned User
Joined
Dec 8, 2017
Messages
143
Best answers
2
Reaction score
41
Are you sure you set right tfs version in config.php ?
 

vicki24

Member
Joined
Feb 2, 2017
Messages
69
Best answers
0
Reaction score
7
Location
Europe
Here you go execute those 2 codes in sql database
Code:
ALTER TABLE `players` ADD `exphist_lastexp` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist1` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist2` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist3` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist4` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist5` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist6` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist7` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetimetoday` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime1` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime2` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime3` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime4` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime5` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime6` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime7` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetimeall` BIGINT( 255 ) NOT NULL DEFAULT '0';
Code:
UPDATE `players` SET `exphist_lastexp`=`players`.`experience`
 
OP
S

Seba1212

New Member
Joined
Nov 6, 2018
Messages
14
Best answers
0
Reaction score
0
  • string(93) "SELECT * FROM players WHERE group_id < 2 AND broadcasting = 1 ORDER BY viewers DESC LIMIT 5;"
    (query - SQL error)
    Type: select_multi (select multiple rows from database)

    Unknown column 'broadcasting' in 'where clause'
in active Casters
 
Top