Solved Help After Creating Guild, doesn't create

[Lalo I]

It tells me that I created A guild

But After I click Submit This happens

this is my .sql from my page

does anyone have a fix? or a guild.sql that I can put into the page? please help!!!!

 

[Lalo I]

@BUMP

 

[Sun]

When you ask for website support you should always specify which AAC you're using.

If you using gesior edit this line in index.php
define('DEBUG_DATABASE', false);
to
define('DEBUG_DATABASE', true);

Then create a new guild and provide the error report

 

[Lalo I]

My bad it is a
Gesior2012-master

This is the code that comes up with the error,

Submit
Query:    SELECT `players`.`id`, `players`.`name`, `players`.`group_id`, `players`.`account_id`, `players`.`level`, `players`.`vocation`, `players`.`health`, `players`.`healthmax`, `players`.`experience`, `players`.`lookbody`, `players`.`lookfeet`, `players`.`lookhead`, `players`.`looklegs`, `players`.`looktype`, `players`.`lookaddons`, `players`.`maglevel`, `players`.`mana`, `players`.`manamax`, `players`.`manaspent`, `players`.`soul`, `players`.`town_id`, `players`.`posx`, `players`.`posy`, `players`.`posz`, `players`.`conditions`, `players`.`cap`, `players`.`sex`, `players`.`lastlogin`, `players`.`lastip`, `players`.`save`, `players`.`skull`, `players`.`skulltime`, `players`.`lastlogout`, `players`.`blessings`, `players`.`balance`, `players`.`stamina`, `players`.`skill_fist`, `players`.`skill_fist_tries`, `players`.`skill_club`, `players`.`skill_club_tries`, `players`.`skill_sword`, `players`.`skill_sword_tries`, `players`.`skill_axe`, `players`.`skill_axe_tries`, `players`.`skill_dist`, `players`.`skill_dist_tries`, `players`.`skill_shielding`, `players`.`skill_shielding_tries`, `players`.`skill_fishing`, `players`.`skill_fishing_tries`, `players`.`deleted`, `players`.`create_ip`, `players`.`create_date`, `players`.`comment`, `players`.`hide_char` FROM `players` WHERE `account_id` = '4' ORDER BY `name` ASC
SQLSTATE:    00000
Driver code:   
Error message:   
Query:    SELECT `rank_id`, `nick` FROM `guild_membership` WHERE `player_id` = '5'
SQLSTATE:    00000
Driver code:   
Error message:   
Query:    SELECT `rank_id`, `nick` FROM `guild_membership` WHERE `player_id` = '8'
SQLSTATE:    00000
Driver code:   
Error message:   
Query:    SELECT `rank_id`, `nick` FROM `guild_membership` WHERE `player_id` = '10'
SQLSTATE:    00000
Driver code:   
Error message:   
Query:    SELECT `rank_id`, `nick` FROM `guild_membership` WHERE `player_id` = '9'
SQLSTATE:    00000
Driver code:   
Error message:   
Query:    SELECT `rank_id`, `nick` FROM `guild_membership` WHERE `player_id` = '6'
SQLSTATE:    00000
Driver code:   
Error message:   
Query:    SELECT `rank_id`, `nick` FROM `guild_membership` WHERE `player_id` = '7'
SQLSTATE:    00000
Driver code:   
Error message:   
Query:    SELECT `id`, `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`, `lastlogout`, `blessings`, `balance`, `stamina`, `skill_fist`, `skill_fist_tries`, `skill_club`, `skill_club_tries`, `skill_sword`, `skill_sword_tries`, `skill_axe`, `skill_axe_tries`, `skill_dist`, `skill_dist_tries`, `skill_shielding`, `skill_shielding_tries`, `skill_fishing`, `skill_fishing_tries`, `deleted`, `create_ip`, `create_date`, `comment`, `hide_char` FROM `players` WHERE `name` = 'Druid Sample'
SQLSTATE:    00000
Driver code:   
Error message:   
Query:    SELECT `id`, `name`, `ownerid`, `creationdata`, `motd`, `description`, `create_ip`, `guild_logo` FROM `guilds` WHERE `name` = 'Tetz'
SQLSTATE:    00000
Driver code:   
Error message:   
Query:    INSERT INTO `guilds` (`name`, `ownerid`, `creationdata`, `motd`, `description`, `create_ip`, `guild_logo`) VALUES ('Tetz', '8', '1534018380', '', 'New guild. Leader must edit this text :)', '', '1534018380;data:image/gif;base64,R0lGODlhQABAAPcAAAAAAAgAABAAABgAABgIACEIACkIADEIADkIADkQAEIQAEoQAFIQAFoQAFoYAGMYAGNjUmsYAGtKAGtjUmtjWmtrWnMYAHNSAHNrWnNrY3sYAHshAHtSAHtaAHtzY3tza4QhAIRaAIRaCIRjCIR7a4R7c4whAIxjCIyEc4yEe5QhAJRrCJSMe5wpAJxrCJxzCJyMe5yMhJyUhKUpAKVzCKV7CKWUhKWcjK0pAK17CK2cjLUpALV7CLWECLWllLWtlL0xAL2ECL2MCL21nMYxAMaMCMaUCMa1pc4xAM6UCM69rdYxANY5ANaUCNacCN45AO/exvfnzv///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////yH5BAEAAFEALAAAAABAAEAAAAj+AKNECQCgIMEACBMaNKjwIEIACR82XAhRosOCAjNqDICECJKPHkMyCYlkpEgiTEqq7IgSpMmSKVN+BNkxZQAbGjUCGFmyZcqWPUkyGYpy6JOiQHl6jElzJpGQAEjgzDlQJdGYQzu6rPkxa9aiVn3K5Nn1KcioU3MGYBqz6EilMJdyNQtTJkiUHruydEkEgIcYVKuaHAuz7tCYT8h6NVoT79XDkLMiAZCBRWAAM4mufIl3JRIgIBwYSJDAgQocMz0Xppl3JmXLVDH/3NEChIkWLXZk1rsjAcIDFm6rsJBAgAAFQGTiJdIiAoMECxQ42DDjKZMAlS8TYVAQgIADCxL+GCAgIEABC0+BGAAQAQgRHBEWjHZgAggQBwAIuN9QvuBxBc+t99AO2MGW004BnJBEEUk0mIQRRghRxAsHEAQACEy0QABBB0QAAggPbBjABupVZEEQCz7YIIMNBhFABAVelmEBD46gAGkXXFADiwUEAEQLEIFQV00pAQlRBD1IWIQRQbwwQgdQjlAEgwDs8Fpga03WQxHHmaDCAwwQ0J0CTCwQQAcAbCAZSQQG8ICEEl7wUAGlMaAAAAckUcNaV8aW0gMJOFGDbJkZ4AASvgXB4AH6FUaECQAk0EOEgx6UXF42iZDEAg9clx1VWRIRwKQFbJBZBAYgUYACCxDwYBH+KwRgAl5mKigEDQUAoICPChxgF3MATBkASjGCCtJzTvQAgFvDPrAWEb0BkIOEBThAhJg5JBHErip0ZMGwsn4VwApJMLCATZ8e6BQALxQhgQEjKbBBCz6qRIQKADQoxHoCSDjoAul5VJqVS4lWhLItFauuSvQmKYADQHAEwKxD9hVAEELQKcQJAYBARHIduedjAhZkCEAQRnS8lMI69TQSaUwWFAG+Lmv11K6K5hdAdVrZ+4ACOFQJAA1FRKAAV32q6xYTBHQgYQAOEPBATyyZBSkAQgRxYWpPLSc0ACvAylHVSbf800cR21oeanlZ9xkA3yZQRA7DOpWZqBvYKUT+rCCfle5Gv3oUsab7GoBD12WN10MPCSbxgAF0mQVtAQWYEMAIAFTXGhNlZ7QT1UQcFfEDD56AmXVPBZ2DEXeeLIQAM6Q2EpC5Bg2ACpq11LlAmKVGk7MG9ICyA1AD0RHlRgw6QwIKFCFC3U/NAIABKyBcJVtmsez5UkTltcD0AGiq7a5SBzBttR+bXwQAuT1QUAcMuiDAZFhpxvnfnn/FFBIOFABjAAaggRAkNIIAHEAIdJuBAgtggCIkJAE7ytqudrIslxxmMvgTSJYyYxIVyKoARAABQuAnBAC4IAl0Iw9CKHeCGqBMCD34XgFw4KNlYco9HdldFHbikSewJCX+EYtYVzbgn2AJYVRTSpKEMEYDZxlQNypIAL1a0zMMGkgnZlnTSIZVpcwAgYFzC0COLiCCCzCgRwRRgArctoAIOIABZEEcErTHu8QgwYeSUxUIEhCBljxFakWwgAGIIx4D7GoFg9ILSgAQMZ7FZSZ03GHkgAIEy00RdQKggREK4KiRAEB4w6KLByOGujh66oqeI5Jq5jiDAJSsa64L5SMLMIIkFEA3LNlZAhigFcbARIe9o1pYiCg99zwlX0fkydloua8WLMUCMxyWciJjRSz18iedmeMDiGefVjZoLV9BSQGMUIQDmCAlrQSCAEqmHLd9RIccIUlZVBK0FpQHCPj+ahABukaWcRbBARgCkgoYcAC6KKU1kbSh/rzyGYHmKgLBSoI0sUmEcZZrAx40gbPi4jYfwiShclFkFYkIAu5gLZlWSYk/fZO57xnvbkxZCjzt9ZKrtARIBmhBjxgwNsWMMwgE0A8BDtCVt9wlmzPlzP5288Xb3QciBFjVeAoCIfOozC4XlMxPQIopYbaTYRB5QG5a4IAFtLFh6zOAe7CylcK8BZ5Ysc5Sl7KUA5TVQgEggAESUgSURi4sQ/oIV0uCR+WAjiWoMkIOClCbDczLAvnqwLmAYq8fhrOafjrKT65iLz++bUGMVI4BLmDLGbzEKYiTXFbgmU3HdMWjqg3+QLsU0EcgBqAILhqLZOz2lt4m1W2QoWw2GWCAmIXkcUkQAQP+SsWiJiWSoTQq94BLUSAYMVxzfBrb7li1uJAlNSCtrFXu1raRFOBNLxiWdJKwggR85i2OyeNj3pnBHSoFvtc8DFA+dtLyXOx1OxiK8eJ4Nw4Ktr69Qx1fVhI6qjHBkNoSQNjslJSuOcYkF95ifcfWkaNMly1nI4q0FmSEF1RQqXIVb3cT6jvN7EZyKEnMowJghCSUcI3zPAlXckxfVPIucBecy3SB0j+gLtdl+lPkV1eG4K+o2HduSw4QE6CrKubYj+F0m6g2TKTp9pJ7Rt0tjrMYZgOzFSs63GH+YHsb18joVy5spSJkegm6AFDAAzIIjH3tVtTdsFkx9QOLR+f63S1SgAQ30LMkd4vkBdOEJ5qlM5Kz6paETaC+GVHCTnCoW0wt+Yc9GzCGdTsXm0AAA4hWtECGUJClxtWykpZnFS/Ytq4UZAKozrOqVy2DUE5SVBKpyLIkExGIGKTDYpkjBCiQARLoetervkGxGUIBCmAgA9jOdt2us+wKZDvb3VkIQihQgQ+kINHQ1ogSfCCDEnjg2xnwAAlQwIJ625sFEiO3B+h973qjgATv/rYHSiADH6Q7MEPQgQz6LQN0U8UHAQA4CRTtgxss/N4y0MHBNw7tIdwAMBwPucgLVe3wKEBh5IoOCAAAOw==')
SQLSTATE:    HY000
Driver code:    1436
Error message:    Thread stack overrun: 8688 bytes used of a 131072 byte stack, and 128000 bytes needed. Use 'mysqld --thread_stack=#' to specify a bigger stack.
Query:    SELECT `guild_ranks`.`id`, `guild_ranks`.`guild_id`, `guild_ranks`.`name`, `guild_ranks`.`level` FROM `guild_ranks` WHERE `guild_id` = '0' ORDER BY `level` DESC
SQLSTATE:    00000
Driver code:   
Error message:

It's pretty big, but thats what popped up

 

[Laloomega]

Bump Kiddos, help?

 

[Sun]

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

Basically mysql requires you to increase your thread_stack for some queries to run.
If you're hosting your website through uniformserver on windows do the following

If you have uniform server running mysql turn it off.
Go to
C:\UniServerZ\core\mysql/my.ini
find
thread_stack = 128K
increase it to 190k
save
start mysql

Otherwise use google to find where to change your mysql thread_stack value

 

[Lalo I]

Fixed thank you