Lua:
[19/08/2009 00:08:15] The Forgotten Server, version 0.3.5 (Crying Damson)
[19/08/2009 00:08:15] Compiled with GNU C++ version 3.4.5 (mingw special) at Aug 9 2009, 13:50:45.
[19/08/2009 00:08:15] A server developed by Elf, slawkens, Talaturen, KaczooH, Lithium, Kiper, Kornholijo.
[19/08/2009 00:08:15] Visit our forum for updates, support and resources: [url]http://otland.net[/url].
[19/08/2009 00:08:15] >> Loading config (config.lua)
[19/08/2009 00:08:15] > Using plaintext passwords
[19/08/2009 00:08:15] >> Checking software version... up to date!
[19/08/2009 00:08:16] >> Fetching blacklist
[19/08/2009 00:08:16] >> Loading RSA key
[19/08/2009 00:08:16] >> Starting SQL connection
[19/08/2009 00:08:16] >> Running Database Manager
[19/08/2009 00:08:16] > Updating database to version: 1...
[19/08/2009 00:08:44] > Database has been updated to version: 1.
[19/08/2009 00:08:44] > Updating database to version: 2...
[19/08/2009 00:13:04] > Database has been updated to version: 2.
[19/08/2009 00:13:04] > Updating database to version: 3...
[19/08/2009 00:13:04] > Database has been updated to version: 3.
[19/08/2009 00:13:04] > Updating database to version: 4...
[19/08/2009 00:13:05] > Database has been updated to version: 4.
[19/08/2009 00:13:05] > Updating database to version: 5...
[19/08/2009 00:13:08] > Database has been updated to version: 5.
[19/08/2009 00:13:08] > Updating database to version: 6...
[19/08/2009 00:13:20] > Database has been updated to version: 6.
[19/08/2009 00:13:20] > Updating database to version: 7...
[19/08/2009 00:13:20] > Database has been updated to version: 7.
[19/08/2009 00:13:20] > Updating database version to: 8...
[19/08/2009 00:13:37] > Database has been updated to version: 8.
[19/08/2009 00:13:37] > Updating database to version: 9...
[19/08/2009 00:13:37] > Database has been updated to version: 9.
[19/08/2009 00:13:37] > Updating database to version: 10...
[19/08/2009 00:13:37] > Database has been updated to version: 10.
[19/08/2009 00:13:37] > Updating database to version: 11...
[19/08/2009 00:13:40] > Database has been updated to version: 11.
[19/08/2009 00:13:40] > Updating database to version: 12...
[19/08/2009 00:13:50] > Database has been updated to version: 12.
[19/08/2009 00:13:50] > Updating database to version: 13...
[19/08/2009 00:13:51] mysql_real_query(): ALTER TABLE `accounts` DROP KEY `group_id`; - MYSQL ERROR: Error on rename of '.\test\#sql-258_2ac' to '.\test\accounts' (errno: 150) (1025)
[19/08/2009 00:13:52] mysql_real_query(): ALTER TABLE `players` DROP KEY `group_id`; - MYSQL ERROR: Error on rename of '.\test\#sql-258_2ac' to '.\test\players' (errno: 150) (1025)
[19/08/2009 00:13:52] mysql_real_query(): DROP TABLE `groups`; - MYSQL ERROR: Cannot delete or update a parent row: a foreign key constraint fails (1217)
[19/08/2009 00:13:52] > Database has been updated to version: 13.
[19/08/2009 00:13:52] > Updating database to version: 14...
[19/08/2009 00:13:53] > Database has been updated to version: 14.
[19/08/2009 00:13:53] > Updating database to version: 15...
[19/08/2009 00:13:53] > Database has been updated to version: 15.
[19/08/2009 00:13:53] > Updating database to version: 16...
[19/08/2009 00:13:57] > Database has been updated to version: 16.
[19/08/2009 00:13:57] > Updating database to version: 17...
[19/08/2009 00:13:58] > Database has been updated to version: 17.
[19/08/2009 00:13:58] > Updating database to version: 18...
[19/08/2009 00:14:06] mysql_real_query(): ALTER TABLE `house_data` ADD FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE; - MYSQL ERROR: Can't create table 'test.#sql-258_2ac' (errno: 150) (1005)
[19/08/2009 00:14:07] mysql_real_query(): ALTER TABLE `guild_invites` ADD FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE; - MYSQL ERROR: Can't create table 'test.#sql-258_2ac' (errno: 150) (1005)
[19/08/2009 00:14:07] mysql_real_query(): ALTER TABLE `guild_invites` ADD FOREIGN KEY (`guild_id`) REFERENCES `guilds`(`id`) ON DELETE CASCADE; - MYSQL ERROR: Can't create table 'test.#sql-258_2ac' (errno: 150) (1005)
[19/08/2009 00:14:08] mysql_real_query(): ALTER TABLE `tiles` ADD FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE; - MYSQL ERROR: Can't create table 'test.#sql-258_2ac' (errno: 150) (1005)
[19/08/2009 00:14:08] > Database has been updated to version: 18.
[19/08/2009 00:14:08] > Updating database to version: 19...
[19/08/2009 00:14:09] mysql_real_query(): CREATE TABLE `house_auctions`( `house_id` INT UNSIGNED NOT NULL, `world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0, `player_id` INT NOT NULL, `bid` INT UNSIGNED NOT NULL DEFAULT 0, `limit` INT UNSIGNED NOT NULL DEFAULT 0, `endtime` BIGINT UNSIGNED NOT NULL DEFAULT 0, UNIQUE (`house_id`, `world_id`), FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE, FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE) ENGINE = InnoDB; - MYSQL ERROR: Can't create table 'test.house_auctions' (errno: 150) (1005)
[19/08/2009 00:14:09] > Database has been updated to version: 19.
[19/08/2009 00:14:09] > Updating database to version: 20...
[19/08/2009 00:14:12] > Database has been updated to version: 20.
[19/08/2009 00:14:12] > Updating database to version: 21...
[19/08/2009 00:14:12] > Database has been updated to version: 21.
[19/08/2009 00:14:12] > Trigger: oncreate_guilds does not exist, creating it...
[19/08/2009 00:14:13] > Trigger: ondelete_guilds does not exist, creating it...
[19/08/2009 00:14:13] > Trigger: oncreate_players does not exist, creating it...
[19/08/2009 00:14:14] > Optimizing table: accounts... [success]
[19/08/2009 00:14:15] > Optimizing table: bans... [success]
[19/08/2009 00:14:16] > Optimizing table: environment_killers... [success]
[19/08/2009 00:14:16] > Optimizing table: global_storage... [success]
[19/08/2009 00:14:16] > Optimizing table: groups... [success]
[19/08/2009 00:14:16] > Optimizing table: guild_invites... [success]
[19/08/2009 00:14:16] > Optimizing table: guild_ranks... [success]
[19/08/2009 00:14:17] > Optimizing table: guilds... [success]
[19/08/2009 00:14:17] > Optimizing table: house_data... [success]
[19/08/2009 00:14:17] > Optimizing table: house_lists... [success]
[19/08/2009 00:14:17] > Optimizing table: houses... [success]
[19/08/2009 00:14:18] > Optimizing table: killers... [success]
[19/08/2009 00:14:18] > Optimizing table: map_store... [success]
[19/08/2009 00:14:18] > Optimizing table: player_deaths... [success]
[19/08/2009 00:14:19] > Optimizing table: player_depotitems... [success]
[19/08/2009 00:14:22] > Optimizing table: player_items... [success]
[19/08/2009 00:14:30] > Optimizing table: player_killers... [success]
[19/08/2009 00:14:30] > Optimizing table: player_namelocks... [success]
[19/08/2009 00:14:31] > Optimizing table: player_skills... [success]
[19/08/2009 00:14:33] > Optimizing table: player_spells... [success]
[19/08/2009 00:14:34] > Optimizing table: player_storage... [success]
[19/08/2009 00:14:39] > Optimizing table: player_viplist... [success]
[19/08/2009 00:14:41] > Optimizing table: players... [success]
[19/08/2009 00:14:43] > Optimizing table: server_config... [success]
[19/08/2009 00:14:44] > Optimizing table: server_motd... [success]
[19/08/2009 00:14:44] > Optimizing table: server_record... [success]
[19/08/2009 00:14:44] > Optimizing table: server_reports... [success]
[19/08/2009 00:14:44] > Optimizing table: tile_items... [success]
[19/08/2009 00:14:48] > Optimizing table: tiles... [success]
[19/08/2009 00:14:49] > Optimizing table: z_changelog... [success]
[19/08/2009 00:14:49] >> Loading items
[19/08/2009 00:14:50] >> Loading groups
[19/08/2009 00:14:50] >> Loading vocations
[19/08/2009 00:14:50] >> Loading script systems
[19/08/2009 00:14:50] >> Loading chat channels
[19/08/2009 00:14:50] >> Loading outfits
[19/08/2009 00:14:50] >> Loading experience stages
[19/08/2009 00:14:50] >> Loading monsters
[19/08/2009 00:14:51] >> Loading mods...
[19/08/2009 00:14:51] Loading buypremium_command.xml... done.
[19/08/2009 00:14:51] Loading changender_command.xml... done.
[19/08/2009 00:14:51] Loading custommonsters.xml... done.
[19/08/2009 00:14:51] Loading customspells.xml... done.
[19/08/2009 00:14:51] Loading firstitems.xml... done.
[19/08/2009 00:14:51] Loading highscorebook.xml... done.
[19/08/2009 00:14:51] > 6 mods were loaded.
[19/08/2009 00:14:51] >> Loading map and spawns...
[19/08/2009 00:14:52] > Map size: 1000x1000.
[19/08/2009 00:14:52] > Map descriptions:
[19/08/2009 00:14:52] Saved with Remere's Map Editor 1.1.8
[19/08/2009 00:14:52] The Forgotten Server
[19/08/2009 00:14:53] > Map loading time: 2.093 seconds.
[19/08/2009 00:14:54] > Data parsing time: 0.344 seconds.
[19/08/2009 00:14:58] mysql_real_query(): SELECT `house_id`, `player_id`, `bid` FROM `house_auctions` WHERE `endtime` < 1250651698 - MYSQL ERROR: Table 'test.house_auctions' doesn't exist (1146)
[19/08/2009 00:14:58] > Houses synchronization time: 4.125 seconds.
[19/08/2009 00:15:01] > Content unserialization time: 3.485 seconds.
[19/08/2009 00:15:01] >> Checking world type... PvP
[19/08/2009 00:15:01] >> Initializing game state modules and registering services...
[19/08/2009 00:15:09] > Global address: 127.0.0.1
[19/08/2009 00:15:09] > Local ports: 7171 7172
[19/08/2009 00:15:09] >> All modules were loaded, server is starting up...
[19/08/2009 00:15:10] >> Forgotten server Online!
Lua:
mysql_real_query(): CREATE TABLE `house_auctions`( `house_id` INT UNSIGNED NOT NULL, `world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0, `player_id` INT NOT NULL, `bid` INT UNSIGNED NOT NULL DEFAULT 0, `limit` INT UNSIGNED NOT NULL DEFAULT 0, `endtime` BIGINT UNSIGNED NOT NULL DEFAULT 0, UNIQUE (`house_id`, `world_id`), FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE, FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE) ENGINE = InnoDB; - MYSQL ERROR: Can't create table 'test.house_auctions' (errno: 150) (1005)
I know.. this error is cuz FOREIGN KEY or something like it... but im failing hard trying to add this house_auctions to db..
Already tried to run a query...
I dont know what to do.. Any ideas?
already know Im a troll and cant speak english.. stay ontopic ty.