Hey there,
Troubleshooting an issue where it's not possible to create guilds.
Info:
Canary 13.21
Znote AAC 1.6
Server runs fine, SQL DB is fine, querying session user seems fine and player objects seem fine.
Can't really find any other major issues.
There are currently no guilds created in the SQL DB.
There are many users accounts and many player characters.
How to produce error:
Be logged in, navigate to Guilds in drop-down menu.
The page produces a message noting that no guilds exist along with a menu containing the accounts characters, a field to enter a name and a button to create guild.
Choose a character from the list, enter a name, press the button.
The guilds.php page becomes rather empty, only showing the initial message that no guilds exist, no other buttons to interact with.
At the same time the below error is produced.
Stacktrace from webserver logs:
I'm not an SQL/PHP expert so this might be quite an obvious fix if there's some user error going on, if so please enlighten me.
Otherwise if you've seen something similar or know how I might be able to fix this, I'm all ears.
Troubleshooting an issue where it's not possible to create guilds.
Info:
Canary 13.21
Znote AAC 1.6
Server runs fine, SQL DB is fine, querying session user seems fine and player objects seem fine.
Can't really find any other major issues.
There are currently no guilds created in the SQL DB.
There are many users accounts and many player characters.
How to produce error:
Be logged in, navigate to Guilds in drop-down menu.
The page produces a message noting that no guilds exist along with a menu containing the accounts characters, a field to enter a name and a button to create guild.
Choose a character from the list, enter a name, press the button.
The guilds.php page becomes rather empty, only showing the initial message that no guilds exist, no other buttons to interact with.
At the same time the below error is produced.
Stacktrace from webserver logs:
Code:
[php:error] [pid 38664:tid 1792] [client ::1:63400] PHP Fatal error: Uncaught mysqli_sql_exception: Thread stack overrun: 15752 bytes used of a 131072 byte stack, and 160000 bytes needed. Use 'mysqld --thread_stack=#' to specify a bigger stack. in C:\\REDACTED\\www\\engine\\database\\connect.php:90\nStack trace:\n#0 C:\\REDACTED\\www\\engine\\database\\connect.php(90): mysqli_query()\n#1 C:\\REDACTED\\www\\engine\\database\\connect.php(80): voidQuery()\n#2 C:\\REDACTED\\www\\engine\\function\\users.php(465): mysql_insert()\n#3 C:\\REDACTED\\www\\guilds.php(128): create_guild()\n#4 {main}\n thrown in C:\\REDACTED\\www\\engine\\database\\connect.php on line 90, referer: http://localhost/guilds.php
I'm not an SQL/PHP expert so this might be quite an obvious fix if there's some user error going on, if so please enlighten me.
Otherwise if you've seen something similar or know how I might be able to fix this, I'm all ears.
Last edited: