• 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!

Linux Problems with Database, cant create players!

Mestor

Active Member
Joined
Feb 1, 2009
Messages
515
Reaction score
35
Location
Sweden
Yo, I got 2 new main problem on the new dedicated server host I bought!




[DONT NEED HELP ANYMORE...]

1.

Cant create players cuzplayers diddent want to load on my sql... Can someone make a Sql Code? :$ [SOLVED]
PHP:
[22:55:05.439] > Trigger: oncreate_players does not exist, creating it...

[22:55:05.439] 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: Table 'Mestor_...Quicksilver.players' doesn't exist (1146)

[22:55:05.441] > Trigger: ondelete_players does not exist, creating it...

[22:55:05.441] 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: Table 'Mestor_...Quicksilver.players' doesn't exist (1146)


2.

Im running the server on Linux Debian, I did compile the server with Laatido... but still dont work, but Laatido is maybe only for Windows... idk first time I use Linux ;) [SOLVED]
PHP:
[23:14:15.010] ""
Allocation failed, server out of memory!
Decrease size of your map or compile in a 64-bit mode.


REP++ !
 
Last edited:
Back
Top