First When someone creates a guild, in the game they can't see the name of the guild when he click on it..
[03/12/2010 15:26:59] >> Loading config (config.lua)
[03/12/2010 15:26:59] > Using SHA1 encryption
[03/12/2010 15:26:59] >> Loading RSA key
[03/12/2010 15:26:59] >> Starting SQL connection
[03/12/2010 15:26:59] >> Running Database Manager
[03/12/2010 15:26:59] > Trigger: oncreate_guilds does not exist, creating it...
[03/12/2010 15:26:59] mysql_real_query(): CREATE TRIGGER `oncreate_guilds` AFTER INSERT ON `guilds` FOR EACH ROW BEGIN INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Leader', 3, NEW.`id`); INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Vice-Leader', 2, NEW.`id`); INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Member', 1, NEW.`id`); END; - MYSQL ERROR: Table 'neotibia.guilds' doesn't exist (1146)
[03/12/2010 15:26:59] > Trigger: ondelete_guilds does not exist, creating it...
[03/12/2010 15:26:59] mysql_real_query(): CREATE TRIGGER `ondelete_guilds` BEFORE DELETE ON `guilds` FOR EACH ROW BEGIN UPDATE `players` SET `guildnick` = '', `rank_id` = 0 WHERE `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = OLD.`id`); END; - MYSQL ERROR: Table 'neotibia.guilds' doesn't exist (1146)
[03/12/2010 15:27:00] > No tables were optimized.
[03/12/2010 15:27:00] >> Loading items
[03/12/2010 15:27:00] >> Loading groups
[03/12/2010 15:27:00] >> Loading vocations
[03/12/2010 15:27:00] >> Loading script systems
[03/12/2010 15:27:00] [Warning - Actions::registerEvent] Duplicate registered item with id: 2422, in fromid: 2421 and toid: 2441
[03/12/2010 15:27:01] >> Loading chat channels
[03/12/2010 15:27:01] >> Loading outfits
[03/12/2010 15:27:01] >> Loading experience stages
[03/12/2010 15:27:01] >> Loading monsters
[03/12/2010 15:27:02] >> Loading mods...
[03/12/2010 15:27:02] > Loading arena.xml... done.
[03/12/2010 15:27:02] > Loading demonOak.xml... done.
[03/12/2010 15:27:02] > 2 mods were loaded.
[03/12/2010 15:27:02] >> Loading map and spawns...
[03/12/2010 15:27:02] > Map size: 2048x2048.
[03/12/2010 15:27:02] > Map descriptions:
[03/12/2010 15:27:02] "Saved with Remere's Map Editor 2.0"
[03/12/2010 15:27:02] "SimOne MapEditor 0.5.4"
[03/12/2010 15:27:06] > Map loading time: 4.672 seconds.
[03/12/2010 15:27:07] [Warning - Houses::loadFromXml] House entry not set for: Forgotten headquarter (Flat 1, Area 42) (1283)
[03/12/2010 15:27:07] > Data parsing time: 0.781 seconds.
[03/12/2010 15:27:07] > Houses synchronization time: 0.094 seconds.
[03/12/2010 15:27:08] > Content unserialization time: 0.562 seconds.
[03/12/2010 15:27:08] >> Checking world type... PvP
[03/12/2010 15:27:08] >> Initializing game state modules and registering services...
[03/12/2010 15:27:08] > Global address: ------------
[03/12/2010 15:27:08] > Local ports: 7171 7172
[03/12/2010 15:27:08] >> All modules were loaded, server is starting up...
[03/12/2010 15:27:08] >> NeoTibia 8.60! server Online!
Second when i click in my webpage in guilds secctions it shows this
A Database Error Occurred
Error Number: 1146
Table 'neotibia.guilds' doesn't exist
SELECT `id`, `world_id`, `name`, `motd` FROM `guilds`
and in the top of the page shows a red box with this
Error:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'neotibia.guilds' doesn't exist
Please help
[03/12/2010 15:26:59] >> Loading config (config.lua)
[03/12/2010 15:26:59] > Using SHA1 encryption
[03/12/2010 15:26:59] >> Loading RSA key
[03/12/2010 15:26:59] >> Starting SQL connection
[03/12/2010 15:26:59] >> Running Database Manager
[03/12/2010 15:26:59] > Trigger: oncreate_guilds does not exist, creating it...
[03/12/2010 15:26:59] mysql_real_query(): CREATE TRIGGER `oncreate_guilds` AFTER INSERT ON `guilds` FOR EACH ROW BEGIN INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Leader', 3, NEW.`id`); INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Vice-Leader', 2, NEW.`id`); INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Member', 1, NEW.`id`); END; - MYSQL ERROR: Table 'neotibia.guilds' doesn't exist (1146)
[03/12/2010 15:26:59] > Trigger: ondelete_guilds does not exist, creating it...
[03/12/2010 15:26:59] mysql_real_query(): CREATE TRIGGER `ondelete_guilds` BEFORE DELETE ON `guilds` FOR EACH ROW BEGIN UPDATE `players` SET `guildnick` = '', `rank_id` = 0 WHERE `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = OLD.`id`); END; - MYSQL ERROR: Table 'neotibia.guilds' doesn't exist (1146)
[03/12/2010 15:27:00] > No tables were optimized.
[03/12/2010 15:27:00] >> Loading items
[03/12/2010 15:27:00] >> Loading groups
[03/12/2010 15:27:00] >> Loading vocations
[03/12/2010 15:27:00] >> Loading script systems
[03/12/2010 15:27:00] [Warning - Actions::registerEvent] Duplicate registered item with id: 2422, in fromid: 2421 and toid: 2441
[03/12/2010 15:27:01] >> Loading chat channels
[03/12/2010 15:27:01] >> Loading outfits
[03/12/2010 15:27:01] >> Loading experience stages
[03/12/2010 15:27:01] >> Loading monsters
[03/12/2010 15:27:02] >> Loading mods...
[03/12/2010 15:27:02] > Loading arena.xml... done.
[03/12/2010 15:27:02] > Loading demonOak.xml... done.
[03/12/2010 15:27:02] > 2 mods were loaded.
[03/12/2010 15:27:02] >> Loading map and spawns...
[03/12/2010 15:27:02] > Map size: 2048x2048.
[03/12/2010 15:27:02] > Map descriptions:
[03/12/2010 15:27:02] "Saved with Remere's Map Editor 2.0"
[03/12/2010 15:27:02] "SimOne MapEditor 0.5.4"
[03/12/2010 15:27:06] > Map loading time: 4.672 seconds.
[03/12/2010 15:27:07] [Warning - Houses::loadFromXml] House entry not set for: Forgotten headquarter (Flat 1, Area 42) (1283)
[03/12/2010 15:27:07] > Data parsing time: 0.781 seconds.
[03/12/2010 15:27:07] > Houses synchronization time: 0.094 seconds.
[03/12/2010 15:27:08] > Content unserialization time: 0.562 seconds.
[03/12/2010 15:27:08] >> Checking world type... PvP
[03/12/2010 15:27:08] >> Initializing game state modules and registering services...
[03/12/2010 15:27:08] > Global address: ------------
[03/12/2010 15:27:08] > Local ports: 7171 7172
[03/12/2010 15:27:08] >> All modules were loaded, server is starting up...
[03/12/2010 15:27:08] >> NeoTibia 8.60! server Online!
Second when i click in my webpage in guilds secctions it shows this
A Database Error Occurred
Error Number: 1146
Table 'neotibia.guilds' doesn't exist
SELECT `id`, `world_id`, `name`, `motd` FROM `guilds`
and in the top of the page shows a red box with this
Error:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'neotibia.guilds' doesn't exist
Please help