Solved Znote Error create players +REP

[Joserxo023]

I have this error with znoteacc by creating a player, please who can help me ?:

Create Character
1string(753) "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 ('Joserox', '1', '2', '8', '1', '185', '185', '4200', '68', '76', '78', '58', '128', '0', '0', '40', '40', '0', '100', '2', '5', '5', '2', '', '470', '1', '0', '-1062731519', '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.

 

[LordVissie]

https://otland.net/threads/phpadmin-www-page-error.240630/

 

[forgee]

Your thread stack is at the smallest possible size. Try setting it to the default, 196608 if you're using a 32-bit OS or 262144 for 64-bit.
More information can be found here: http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_thread_stack

Where the configuration files for mysql is located depends on which OS you are using. If you're on Windows you likely have a menu in your server package package (ex. Uniserver) to edit config values or open the config file.

 

[Joserxo023]

Cant edit post but just use the search function

Your thread stack is at the smallest possible size. Try setting it to the default, 196608 if you're using a 32-bit OS or 262144 for 64-bit.
More information can be found here: http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_thread_stack

Where the configuration files for mysql is located depends on which OS you are using. If you're on Windows you likely have a menu in your server package package (ex. Uniserver) to edit config values or open the config file.

Help me I do not understand much and apart not find a solution.
Here is a picture of the error:

http://prnt.sc/ab7g29

Error:

http://prnt.sc/ab7gdq

My:

http://prnt.sc/ab7qzm

My operating system:

http://prnt.sc/ab7rnc


Help me please

 

[forgee]

In the file you have open called "my", change thread_stack to 256K.

 

[Joserxo023]

In the file you have open called "my", change thread_stack to 256K.

-I did what you told me, edit the file and then gave it to save. And still persists the same error when trying to create a player

http://prntscr.com/ab81xb

 

[forgee]

Did you restart MySQL after saving?

 

[Joserxo023]

Did you restart MySQL after saving?

Omg! Thanks so much, i love u *-*

 

[Lobo Solitario]

af

 

[Blasphemy]

In the file you have open called "my", change thread_stack to 256K.

bro you helped me a lot DDD I actually love you <3

 

[willy231]

Did you restart MySQL after saving?

THANKS SO MUCHHHHHHHH!!! LOVEE

 

[MyksaND]

and me... hahah thx!

 

[Znote]

Changing thread stack to 256k is usually fine, 512k is plenty.

Solved - ZnoteAAC Thread stack overrun

Hi, need help with this problem in ZnoteAcc: Create Character string(741) "INSERT INTO `players`(`name`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`...

otland.net