HELP! Problem creating character (name taken) Znote

[Zephyr]

Well I'm trying to make an ot just for friends and stuff and everything is fine, I can create an account but cant create a char. If I try on account manager (tibia) it tells me the name is already taken and no matter what name I choose it's taken. Then I try on Znote and it gives me the next error:

string(339) "SELECT p.id, p.name, p.level, p.vocation, p.town_id, p.lastlogin, gm.rank_id, po.player_id AS online FROM players AS p LEFT JOIN guild_membership AS gm ON p.id=gm.player_id LEFT JOIN players_online AS po ON p.id=po.player_id WHERE p.account_id='3' ORDER BY p.level DESC"
(query - SQL error)
Type: select_multi (select multiple rows from database)

Table 'otserv.guild_membership' doesn't exist

 

[Gesior.pl]

MYSQL ERROR: Thread stack overrun: 18024 bytes used of a 131072 byte stack, and 160000 bytes needed. Use 'mysqld --thread_stack=#' to specify a bigger stack.

Creating new player executes some triggers in database. Probably creates 'skill = 10' in table 'player_skills'.
Documentation says, that some triggers require 200KB to execute. Minimum thread_stack value is 128KB. Default value in MariaDB is 292KB, default value in MySQL 8.0 is 256KB, but somehow your MySQL server uses 128KB. You must edit your MySQL configuration and restart MySQL server. You can set it to 1M (MB).

More info about it:

MySQL error 1436: Thread stack overrun, with simple query

I am doing a very simple update on a table, which also triggers a really simple trigger, and it gives me the error #1436 - Thread stack overrun: 6136 bytes used of a 131072 byte stack, and 128000...

stackoverflow.com

MariaDB Memory Allocation

Basic issues in RAM allocation for MariaDB.

mariadb.com

thread_stack — MariaDB Documentation

MariaDB is the leading enterprise open source database with features previously only available in costly proprietary databases. Enterprise grade, wallet friendly.

mariadb.com

Table 'otserv.guild_membership' doesn't exist

It means that acc. maker is trying to use 'new guild table structure' - added in some version of TFS 1.x - and your ots is using old structure (without guild_membership table). I don't know, if it's configurable in Znote. If it's not configurable, it means that this acc. maker is not compatible with your server.

 

[Zephyr]

Creating new player executes some triggers in database. Probably creates 'skill = 10' in table 'player_skills'.
Documentation says, that some triggers require 200KB to execute. Minimum thread_stack value is 128KB. Default value in MariaDB is 292KB, default value in MySQL 8.0 is 256KB, but somehow your MySQL server uses 128KB. You must edit your MySQL configuration and restart MySQL server. You can set it to 1M (MB).

More info about it:

MySQL error 1436: Thread stack overrun, with simple query

I am doing a very simple update on a table, which also triggers a really simple trigger, and it gives me the error #1436 - Thread stack overrun: 6136 bytes used of a 131072 byte stack, and 128000...

stackoverflow.com

MariaDB Memory Allocation

Basic issues in RAM allocation for MariaDB.

mariadb.com

thread_stack — MariaDB Documentation

MariaDB is the leading enterprise open source database with features previously only available in costly proprietary databases. Enterprise grade, wallet friendly.

mariadb.com

It means that acc. maker is trying to use 'new guild table structure' - added in some version of TFS 1.x - and your ots is using old structure (without guild_membership table). I don't know, if it's configurable in Znote. If it's not configurable, it means that this acc. maker is not compatible with your server.

Yup, the stack problem I fixed after posting thats why I edited; thanks though, just changed it to 300K tho.

On the other hand, the other problem about znote I guess I'll have a look and hopefully be able to config and fix it, either way, I was able to create a char using the old 1/1 account manager hehe so thats good... I guess