TFS 1.2 (i think) 10.98 server, [Error - mysql_real_query] \ Thread stack overrun:, wont allow me to delete characters

[Raukohin]

Hey guys, i know me again... im having this issue pop up now that ive tried deleting a bunch of test characters, they wont disappear from the account and i cant even delete them manually from the website admin panel, i get the same error about thread stacks... heres the whole code error right from the server prompt

> Initializing gamestate

[Error - mysql_real_query] Query: DELETE FROM players WHERE deletion != 0 AND deletion < 1590599516
Message: Thread stack overrun: 18392 bytes used of a 131072 byte stack, and 160000 bytes needed. Use 'mysqld --thread_stack=#' to specify a bigger stack.

 

[slaw]

You need to change in MySQL configuration (my.ini or my.cnf) the thread_stack option, for example from 128k to 256k.

If you use Uniform Server, then here's the solution:

Error creating new guild · Issue #127 · slawkens/myaac

Server configuration Operating System: Win10 Web Server (+ version): Uniform Server XIV PHP Version: 7.4.5 Server name and version: latest otservbr-global github version (tfs 1.3) MyAAC Version: la...

github.com

If you use linux, then the file is most probably
/etc/mysql/my.cnf

 

[Raukohin]

You need to change in MySQL configuration (my.ini or my.cnf) the thread_stack option, for example from 128k to 256k.

If you use Uniform Server, then here's the solution:

Error creating new guild · Issue #127 · slawkens/myaac

Server configuration Operating System: Win10 Web Server (+ version): Uniform Server XIV PHP Version: 7.4.5 Server name and version: latest otservbr-global github version (tfs 1.3) MyAAC Version: la...

github.com

If you use linux, then the file is most probably
/etc/mysql/my.cnf

Yes that was it! i just had to change the my.ini thread stack from 128 to 256 ty so much!!

i dont mean to be a pain but if youve got the time maybe you can help me with one other question so i dont need to make a new thread?? i can ask here or maybe PM you?

 

[Infernum]

Each question should be in a separate thread if it's not related to the original topic.

 

[Evil Puncker]

and making a new thread with question to get an answer is an excellent thing because if someone have the same problem he will find an answer by searching, if you solve an issue by PM the solution is not here for everyone to see

 

[Raukohin]

and making a new thread with question to get an answer is an excellent thing because if someone have the same problem he will find an answer by searching, if you solve an issue by PM the solution is not here for everyone to see

great point! thanks for the help guys