• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Sql errors !!!

mesosot

Member
Joined
Aug 16, 2007
Messages
356
Reaction score
5
hello : there

i got these errors in my consile . i hope u can help me

[04/05/2011 13:52:57] >> Running Database Manager
[04/05/2011 13:52:58] > Trigger: oncreate_players does not exist, creating it...
[04/05/2011 13:52:58] mysql_real_query(): CREATE TRIGGER `oncreate_players` AFTER INSERT ON `players` FOR EACH ROW BEGIN INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 0, 10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 1, 10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 2, 10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 3, 10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 4, 10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 5, 10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 6, 10); END; - MYSQL ERROR: Incorrect file format 'players' (130)
[04/05/2011 13:52:58] > Trigger: ondelete_players does not exist, creating it...
[04/05/2011 13:52:58] mysql_real_query(): CREATE TRIGGER `ondelete_players` BEFORE DELETE ON `players` FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `type` = 2 AND `value` = OLD.`id`; UPDATE `houses` SET `owner` = 0 WHERE `owner` = OLD.`id`; END; - MYSQL ERROR: Incorrect file format 'players' (130)
[04/05/2011 13:52:58] > No tables were optimized.

2:
mysql_real_query(): SELECT * FROM 'tile_items' WHERE 'tile_id' = 2450 AND 'world_id' = 0 ORDERD BY 'sid' DESC - MSQL ERROR:Incorrect file format 'tile_items' (130)
This error keep swamps down ....
 
Back
Top