Life is Feudal Official Forum

[Rustyrocks6969]

Will this disable any of the achievements ? really like the new coops too! flat pave, beautiful!

[Hhas189]

-Cannot build/drop objects, action happens, there is no 'debunk' sound. Nothing appears

-Several of the Combat base skills are locked and cannot be unlocked
(Chracters made after the patch have base skills unlocked)
-Some players cannot use primitive tools

-Player lifted a crate (top crate of a stack of two) and the crate was both on his back and in the original position [could not interact with the duplicated crate]
Player returned the crate to the original position and crate continues to be unaccessable

-Animals disappear on death

[TimKing]

Applied update and now no one can build or place anything.
Also cant get into the side room of the Windmill anymore.

[Alakar]

here is the problem with patch.sql

remove the definers that they even left themselves notes on line 3 not to do =)

line 3: -- NOTE: do not use DEFINER for stored procedures and functions here

Okay then here is a howto:

Open patch.sql in your favorite text editor.

Find and Replace the following line with nothing

DEFINER=`root`@`localhost`

so "DEFINER=`root`@`localhost`" becomes ""

-Alakar

[MasterChief]

here is the problem with patch.sql

remove the definers that they even left themselves notes on line 3 not to do =)

line 3: -- NOTE: do not use DEFINER for stored procedures and functions here

Okay then here is a howto:

Open patch.sql in your favorite text editor.

Find and Replace the following line with nothing

DEFINER=`root`@`localhost`

so "DEFINER=`root`@`localhost`" becomes ""

-Alakar

yea, made this change right after patch, my servers runs fine, none of these reported problems while playing

[TimKing]

here is the problem with patch.sql

remove the definers that they even left themselves notes on line 3 not to do =)

line 3: -- NOTE: do not use DEFINER for stored procedures and functions here

Okay then here is a howto:

Open patch.sql in your favorite text editor.

Find and Replace the following line with nothing

DEFINER=`root`@`localhost`

so "DEFINER=`root`@`localhost`" becomes ""

-Alakar

yea, made this change right after patch, my servers runs fine, none of these reported problems while playing

I finally found the line but there are 2 lines. Do i just change both ?



DROP FUNCTION IF EXISTS _getMaxSkillValue;
CREATE DEFINER=`root`@`localhost` FUNCTION `_getMaxSkillValue`(
`in_parentSkillValue` INT UNSIGNED
)
RETURNS INT UNSIGNED
BEGIN
declare skillAmountMult INT UNSIGNED DEFAULT 10000000;

if(in_parentSkillValue < 30*skillAmountMult) then
return 0;
elseif(in_parentSkillValue < 60*skillAmountMult) then
return (30*skillAmountMult - 1);
end if;

return 100*skillAmountMult;
END;

DROP PROCEDURE IF EXISTS _transferSkillStraight;
CREATE DEFINER=`root`@`localhost` PROCEDURE _transferSkillStraight(
IN `in_oldSkillTypeID` INT UNSIGNED,
IN `in_newSkillTypeID` INT UNSIGNED

[Djdizx]

here is the problem with patch.sql

remove the definers that they even left themselves notes on line 3 not to do =)

line 3: -- NOTE: do not use DEFINER for stored procedures and functions here

Okay then here is a howto:

Open patch.sql in your favorite text editor.

Find and Replace the following line with nothing

DEFINER=`root`@`localhost`

so "DEFINER=`root`@`localhost`" becomes ""

-Alakar

yea, made this change right after patch, my servers runs fine, none of these reported problems while playing

I finally found the line but there are 2 lines. Do i just change both ?



DROP FUNCTION IF EXISTS _getMaxSkillValue;
CREATE DEFINER=`root`@`localhost` FUNCTION `_getMaxSkillValue`(
`in_parentSkillValue` INT UNSIGNED
)
RETURNS INT UNSIGNED
BEGIN
declare skillAmountMult INT UNSIGNED DEFAULT 10000000;

if(in_parentSkillValue < 30*skillAmountMult) then
return 0;
elseif(in_parentSkillValue < 60*skillAmountMult) then
return (30*skillAmountMult - 1);
end if;

return 100*skillAmountMult;
END;

DROP PROCEDURE IF EXISTS _transferSkillStraight;
CREATE DEFINER=`root`@`localhost` PROCEDURE _transferSkillStraight(
IN `in_oldSkillTypeID` INT UNSIGNED,
IN `in_newSkillTypeID` INT UNSIGNED

Try one, try the other. try both, and get back to us. I am going to be testing it on my server in a few hours when I get home.

[MasterChief]

here is the problem with patch.sql

remove the definers that they even left themselves notes on line 3 not to do =)

line 3: -- NOTE: do not use DEFINER for stored procedures and functions here

Okay then here is a howto:

Open patch.sql in your favorite text editor.

Find and Replace the following line with nothing

DEFINER=`root`@`localhost`

so "DEFINER=`root`@`localhost`" becomes ""

-Alakar

yea, made this change right after patch, my servers runs fine, none of these reported problems while playing

I finally found the line but there are 2 lines. Do i just change both ?



DROP FUNCTION IF EXISTS _getMaxSkillValue;
CREATE DEFINER=`root`@`localhost` FUNCTION `_getMaxSkillValue`(
`in_parentSkillValue` INT UNSIGNED
)
RETURNS INT UNSIGNED
BEGIN
declare skillAmountMult INT UNSIGNED DEFAULT 10000000;

if(in_parentSkillValue < 30*skillAmountMult) then
return 0;
elseif(in_parentSkillValue < 60*skillAmountMult) then
return (30*skillAmountMult - 1);
end if;

return 100*skillAmountMult;
END;

DROP PROCEDURE IF EXISTS _transferSkillStraight;
CREATE DEFINER=`root`@`localhost` PROCEDURE _transferSkillStraight(
IN `in_oldSkillTypeID` INT UNSIGNED,
IN `in_newSkillTypeID` INT UNSIGNED

just delete all lines that contains DEFINER=`root`@`localhost` to this :
CREATE DEFINER=`root`@`localhost` FUNCTION `_getMaxSkillValue to
CREATE FUNCTION `_getMaxSkillValue

[TimKing]

I may be missing something. Doesn't seem to work.
Can someone post the correct patch.sql file please.