Tracące się skille TFS 0.3.4

DomosNew · Aug 1, 2009

Otóż mam taki błąd, ze strony chyba bazy danych (nie wywala jej).
Gdy gracz np wyskilluje do danego skilla (nie ważne np fighting, distance) skillę się nie zapisują po dednięciu albo wylogowaniu.

Sprawdzałem nawet w bazie MYSQL, czy w tabeli 'players'
jest save na 1 i jest ;p

Wcześniej mój server był na sqlite,
teraz przeszedł na Mysql i nie było błędu z niezapisującymi się skillami, tylko ten błąd, reszta się zapisuje lvl, mlvl, itd.

Może pokaże log.txt z serwera (może coś wam pomoże, w znalezieniu błędu):

The Forgotten Server, version 0.3.4 (Crying Damson)
A server developed by Elf, Talaturen, Lithium, Kiper, Kornholijo, KaczooH, slawkens & Macroman.
Visit our forum for updates, support and resources: http://otland.net.

>> Debugging: nothing.
>> Checking software version... up to date!

>> Loading config (config.lua)
> Using plaintext passwords
>> Loading RSA key
>> Starting SQL connection
>> Running Database Manager
> Trigger: ondelete_accounts does not exist, creating it...
mysql_real_query(): CREATE TRIGGER `ondelete_accounts` BEFORE DELETE ON `accounts` FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `type` != 1 AND `type` != 2 AND `value` = OLD.`id`; END; - MYSQL ERROR: Access denied; you need the SUPER privilege for this operation (1227)
> Trigger: oncreate_guilds does not exist, creating it...
mysql_real_query(): CREATE TRIGGER `oncreate_guilds` AFTER INSERT ON `guilds` FOR EACH ROW BEGIN INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('the Leader', 3, NEW.`id`); INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('a Vice-Leader', 2, NEW.`id`); INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('a Member', 1, NEW.`id`); END; - MYSQL ERROR: Access denied; you need the SUPER privilege for this operation (1227)
> Trigger: ondelete_guilds does not exist, creating it...
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: Access denied; you need the SUPER privilege for this operation (1227)
> Trigger: oncreate_players does not exist, creating it...
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: Access denied; you need the SUPER privilege for this operation (1227)
> Trigger: ondelete_players does not exist, creating it...
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: Access denied; you need the SUPER privilege for this operation (1227)
> No tables were optimized.
>> Loading items
>> Loading groups
>> Loading vocations
>> Loading script systems
[Warning - Event::loadScript] Cannot load script (data/actions/scripts/quests/annihilator.lua)
data/actions/scripts/quests/annihilator.lua:3: unexpected symbol near '['

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.lua

luaCreateConditionObject(). Condition not found

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.lua

luaSetConditionParam(). Condition not found

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.lua

luaCreateConditionObject(). Condition not found

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.lua

luaSetConditionParam(). Condition not found

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.lua

luaCreateConditionObject(). Condition not found

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.lua

luaSetConditionParam(). Condition not found

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.lua

luaCreateConditionObject(). Condition not found

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.lua

luaSetConditionParam(). Condition not found

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.lua

luaCreateConditionObject(). Condition not found

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.lua

luaSetConditionParam(). Condition not found

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.lua

luaCreateConditionObject(). Condition not found

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.lua

luaSetConditionParam(). Condition not found

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.lua

luaCreateConditionObject(). Condition not found

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.lua

luaSetConditionParam(). Condition not found

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.lua

luaCreateConditionObject(). Condition not found

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.lua

luaSetConditionParam(). Condition not found

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.lua

luaCreateConditionObject(). Condition not found

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.lua

luaSetConditionParam(). Condition not found

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.lua

luaCreateConditionObject(). Condition not found

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.lua

luaSetConditionParam(). Condition not found
>> Loading chat channels
>> Loading outfits
>> Loading experience stages
>> Loading monsters
>> Loading map and spawns...
> Map size: 2298x3045.
> Map descriptions:
Saved with Remere's Map Editor 1.1.4
SimOne MapEditor 0.5.0
Duplicate uniqueId 2455
Duplicate uniqueId 2160
Duplicate uniqueId 2160
Duplicate uniqueId 2528
Duplicate uniqueId 2476
Duplicate uniqueId 2487
Duplicate uniqueId 2488
Duplicate uniqueId 2393
Duplicate uniqueId 2195
> Map loading time: 3.179 seconds.
[Warning - Npc::loadFromXml] Cannot load npc file (data/npc/Laduje Softy.xml).
Info: failed to load external entity "data/npc/Laduje Softy.xml"

[Warning - Npc::loadFromXml] Cannot load npc file (data/npc/Vakri.xml).
Info: failed to load external entity "data/npc/Vakri.xml"

[Warning - Npc::loadFromXml] Cannot load npc file (data/npc/Banor the blessed.xml).
Info: failed to load external entity "data/npc/Banor the blessed.xml"

[Spawn::addMonster] Cannot find "Butterfly"
[Spawn::addMonster] Cannot find "Butterfly"
[Spawn::addMonster] Cannot find "Butterfly"
[Spawn::addMonster] Cannot find "Butterfly"
[Spawn::addMonster] Cannot find "Butterfly"
[Warning - Npc::loadFromXml] Cannot load npc file (data/npc/Banor the blessed.xml).
Info: failed to load external entity "data/npc/Banor the blessed.xml"

[Warning - Npc::loadFromXml] Cannot load npc file (data/npc/Bank.xml).
Info: failed to load external entity "data/npc/Bank.xml"

[Spawn::addMonster] Cannot find "Butterfly"
[Spawn::addMonster] Cannot find "Butterfly"
[Warning - Npc::loadFromXml] Cannot load npc file (data/npc/Banor the blessed.xml).
Info: failed to load external entity "data/npc/Banor the blessed.xml"

[Warning - Npc::loadFromXml] Cannot load npc file (data/npc/Maya.xml).
Info: failed to load external entity "data/npc/Maya.xml"

[Spawn::addMonster] Cannot find "Demon (Goblin)"
[Spawn::addMonster] Cannot find "Demon (Goblin)"
[Spawn::addMonster] Cannot find "Demon (Goblin)"
[Spawn::addMonster] Cannot find "Bonebeast"
[Spawn::addMonster] Cannot find "Bonebeast"
[Spawn::addMonster] Cannot find "Bonebeast"
[Spawn::addMonster] Cannot find "Bonebeast"
[Spawn::addMonster] Cannot find "Bonebeast"
[Spawn::addMonster] Cannot find "Bonebeast"
[Spawn::addMonster] Cannot find "Bonebeast"
[Warning - Npc::loadFromXml] Cannot load npc file (data/npc/A Dead Bureaucrat.xml).
Info: failed to load external entity "data/npc/A Dead Bureaucrat.xml"

[Warning - Npc::loadFromXml] Cannot load npc file (data/npc/A Dead Bureaucrat.xml).
Info: failed to load external entity "data/npc/A Dead Bureaucrat.xml"

[Warning - Npc::loadFromXml] Cannot load npc file (data/npc/A Dead Bureaucrat.xml).
Info: failed to load external entity "data/npc/A Dead Bureaucrat.xml"

[Warning - Npc::loadFromXml] Cannot load npc file (data/npc/A Dead Bureaucrat.xml).
Info: failed to load external entity "data/npc/A Dead Bureaucrat.xml"

[Warning - Npc::loadFromXml] Cannot load npc file (data/npc/A Dead Bureaucrat.xml).
Info: failed to load external entity "data/npc/A Dead Bureaucrat.xml"

[Warning - Npc::loadFromXml] Cannot load npc file (data/npc/A Dead Bureaucrat.xml).
Info: failed to load external entity "data/npc/A Dead Bureaucrat.xml"

[Warning - Npc::loadFromXml] Cannot load npc file (data/npc/A Dead Bureaucrat.xml).
Info: failed to load external entity "data/npc/A Dead Bureaucrat.xml"

[Warning - Npc::loadFromXml] Cannot load npc file (data/npc/A Dead Bureaucrat.xml).
Info: failed to load external entity "data/npc/A Dead Bureaucrat.xml"

[Warning - Npc::loadFromXml] Cannot load npc file (data/npc/A Dead Bureaucrat.xml).
Info: failed to load external entity "data/npc/A Dead Bureaucrat.xml"

[Warning - Npc::loadFromXml] Cannot load npc file (data/npc/A Dead Bureaucrat.xml).
Info: failed to load external entity "data/npc/A Dead Bureaucrat.xml"

[Warning - Npc::loadFromXml] Cannot load npc file (data/npc/A Dead Bureaucrat.xml).
Info: failed to load external entity "data/npc/A Dead Bureaucrat.xml"

[Warning - Npc::loadFromXml] Cannot load npc file (data/npc/A Dead Bureaucrat.xml).
Info: failed to load external entity "data/npc/A Dead Bureaucrat.xml"

[Warning - Houses::loadFromXml] House entry not set for: (65)
> Data loading time: 0.261 seconds.
> Unserialization time for houses: 0.005 seconds.
> Unserialization time for map: 8.512 seconds.
>> Checking world type... PvP
>> Initializing game state modules and registering services...
> Global address: nerania.eu
> Local ports:
7171 7172
>> All modules were loaded, server starting up...
>> Rivania server Online!

GOD Nerania has logged in.
Adus has logged in.
GOD Nerania has logged out.
Crucjatus Benifecus has logged in.
Crucjatus Benifecus has logged out.
Crucjatus Benifecus has logged in.
mysql_real_query(): INSERT INTO `server_motd` (`id`, `world_id`, `text`) VALUES (1, 0, 'Welcome to NeraniaOTS!'); - MYSQL ERROR: Duplicate entry '1-0' for key 1 (1062)
Aqua has logged in.
Aqua has logged out.
Crucjatus Benifecus has logged out.

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.luanUse

luaDoAddCondition(). Condition not found

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.luanUse

luaDoAddCondition(). Condition not found

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.luanUse

luaDoAddCondition(). Condition not found

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.luanUse

luaDoAddCondition(). Condition not found

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.luanUse

luaDoAddCondition(). Condition not found

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.luanUse

luaDoAddCondition(). Condition not found

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.luanUse

luaDoAddCondition(). Condition not found

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.luanUse

luaDoAddCondition(). Condition not found

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.luanUse

luaDoAddCondition(). Condition not found

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.luanUse

luaDoAddCondition(). Condition not found

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.luanUse

luaDoAddCondition(). Condition not found

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.luanUse

luaDoAddCondition(). Condition not found

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.luanUse

luaDoAddCondition(). Condition not found

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.luanUse

luaDoAddCondition(). Condition not found

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.luanUse

luaDoAddCondition(). Condition not found

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.luanUse

luaDoAddCondition(). Condition not found

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.luanUse

luaDoAddCondition(). Condition not found

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.luanUse

luaDoAddCondition(). Condition not found

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.luanUse

luaDoAddCondition(). Condition not found

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.luanUse

luaDoAddCondition(). Condition not found

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.luanUse

luaDoAddCondition(). Condition not found

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.luanUse

luaDoAddCondition(). Condition not found

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.luanUse

luaDoAddCondition(). Condition not found

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.luanUse

luaDoAddCondition(). Condition not found

Lua Script Error: [Action Interface]
data/actions/scripts/other/potions.luanUse

luaDoAddCondition(). Condition not found
> Saving server...
> SAVE: Complete in 3.041 seconds using relational house storage.

Kombinowałem nawet z naprawieniem bazy, nic z tego :/

Przypominam iż posiadam TFS 0.3.4

PS.Za pomoc REP++

Atleta · Aug 1, 2009

sciagnij pl 2 ^^

http://otland.net/f18/8-41-42-forgotten-server-0-3-4pl2-crying-damson-30905/

Dulin · Aug 1, 2009

Dodaj twojemu użytkownikowi uprawnienia "SUPER"

@EDIT
lub pod rootem wykonaj

Code:

USE twojabaza;
DELIMITER |

CREATE TRIGGER `ondelete_accounts`
BEFORE DELETE
ON `accounts`
FOR EACH ROW
BEGIN
    DELETE FROM `bans` WHERE `type` NOT IN (1,2) AND `value` = OLD.`id`;
END|

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|

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|

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|

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|

DELIMITER ;

DomosNew · Aug 1, 2009

Dzięki Dulin, dzięki wielkie. Chociaż nie mam jak tego dodać
bo nie mam roota, to poczekam na właściciela, aż mi da
uprawnienia 'Super'. Dla ciebie leci reput++

Tracące się skille TFS 0.3.4

DomosNew

cd /home/domos/

Atleta

Banned User

Dulin

Member

DomosNew

cd /home/domos/

Similar threads