Experienced Elementalist
- Joined
- Aug 10, 2008
- Messages
- 291
- Reaction score
- 10
its not really difficult for anyone to install MySQL..
just make sure that You pick the configuration that you can control the database even when there are a lot of people playing.. just type in a password and execute and your done....
for those people that are having trouble with the installation. or won't start service... i had that problem once.. went to hell and back just to look for a solution.. seems that slickone said that to delete the old folder and install it in a new directory... which didn't help me @ all since im using vista.( compatibility issues ) i Reformated my computer and that solved a lot for me.
to those having problem connecting from navicat. just check if there is an instance running in your MySQL.
to those unable to Log in game here's what you do.
you will see two tabs when entering you username and password. Click the tab with the Gravity Logo and you won't get the "DATABASE ERROR"
for those who still have server problems. that means when configuring saga.map instead of Pressing "Y" at the end you pressed "N" ... that's it...
===========================================
for my problem.
@Raven i still cant do it... "!item <itemID> <amnt> <Charactername>
is there something that's suppose to happen.?? cause there isnt anyway for me to use the command??
it comes out in the Database in table "list_eventrewards" but i can't receive it..
i tried to get it in Kafra "event" but no avail. is there something else i have to do to get that item?? cause i'm really out of ideas...
try /item <itemID> <amnt> <Charactername>
het my authentication exe thing wonr stay open I open it the it closes (note it worked through the start thing) but after I had put in all the settings when I ran it ti mentions some error for like 0.001 of a second and closes D:
yes i did... Like i said before..
it already shows in table " list_eventrewardlist " <<
how do i get the eventreward? i dont get it?
Code:try /item <itemID> <amnt> <Charactername>
its still won't work? is there a table i'm missing? @__@ ... im not really sure...
@ slickone is there something leftout from the database? im not sure aswell @__@
@ Slick i made a Split Rar Self Extractor of your client and install it on this Directory C:\SLiCKRO\ but have a problem uploading it...
and is there a way to get items??? i cant find anything in the DB @____@ and also in command line in the server.. Raven Says its in the item_data.xml << i know that but i don't know what to do with it.. @___@
I got the following error
LuaInterface.LuaException: [string "chunk"]:1: attempt to call global 'QUEST_VER
IFY' (a nil value)
at LuaInterface.Lua.ThrowExceptionFromError(Int32 oldTop)
at LuaInterface.Lua.DoString(String chunk)
at Saga.Map.Data.LuaQuest.LuaQuestProvider.OnVerify(UInt32 cid)
LuaInterface.LuaException: [string "chunk"]:1: attempt to call global 'QUEST_VER
IFY' (a nil value)
at LuaInterface.Lua.ThrowExceptionFromError(Int32 oldTop)
at LuaInterface.Lua.DoString(String chunk)
at Saga.Map.Data.LuaQuest.LuaQuestProvider.OnVerify(UInt32 cid)
LuaInterface.LuaException: [string "chunk"]:1: attempt to call global 'QUEST_VER
IFY' (a nil value)
at LuaInterface.Lua.ThrowExceptionFromError(Int32 oldTop)
at LuaInterface.Lua.DoString(String chunk)
at Saga.Map.Data.LuaQuest.LuaQuestProvider.OnVerify(UInt32 cid)
LuaInterface.LuaException: [string "chunk"]:1: attempt to call global 'QUEST_VER
IFY' (a nil value)
at LuaInterface.Lua.ThrowExceptionFromError(Int32 oldTop)
at LuaInterface.Lua.DoString(String chunk)
at Saga.Map.Data.LuaQuest.LuaQuestProvider.OnVerify(UInt32 cid)
LuaInterface.LuaException: [string "chunk"]:1: attempt to call global 'QUEST_VER
IFY' (a nil value)
at LuaInterface.Lua.ThrowExceptionFromError(Int32 oldTop)
at LuaInterface.Lua.DoString(String chunk)
at Saga.Map.Data.LuaQuest.LuaQuestProvider.OnVerify(UInt32 cid)
LuaInterface.LuaException: [string "chunk"]:30: '=' expected near 'freeslots'
at LuaInterface.Lua.ThrowExceptionFromError(Int32 oldTop)
at LuaInterface.Lua.DoString(String chunk)
at Saga.Map.Data.LuaQuest.LuaQuestProvider.Initialize(UInt32 cid, String Base
Directory)
LuaInterface.LuaException: [string "chunk"]:1: attempt to call global 'QUEST_VER
IFY' (a nil value)
at LuaInterface.Lua.ThrowExceptionFromError(Int32 oldTop)
at LuaInterface.Lua.DoString(String chunk)
at Saga.Map.Data.LuaQuest.LuaQuestProvider.OnVerify(UInt32 cid)
LuaInterface.LuaException: [string "chunk"]:30: '=' expected near 'freeslots'
at LuaInterface.Lua.ThrowExceptionFromError(Int32 oldTop)
at LuaInterface.Lua.DoString(String chunk)
at Saga.Map.Data.LuaQuest.LuaQuestProvider.Initialize(UInt32 cid, String Base
Directory)
LuaInterface.LuaException: [string "chunk"]:1: attempt to call global 'QUEST_VER
IFY' (a nil value)
at LuaInterface.Lua.ThrowExceptionFromError(Int32 oldTop)
at LuaInterface.Lua.DoString(String chunk)
at Saga.Map.Data.LuaQuest.LuaQuestProvider.OnVerify(UInt32 cid)
LuaInterface.LuaException: [string "chunk"]:30: '=' expected near 'freeslots'
at LuaInterface.Lua.ThrowExceptionFromError(Int32 oldTop)
at LuaInterface.Lua.DoString(String chunk)
at Saga.Map.Data.LuaQuest.LuaQuestProvider.Initialize(UInt32 cid, String Base
Directory)
LuaInterface.LuaException: [string "chunk"]:1: attempt to call global 'QUEST_VER
IFY' (a nil value)
at LuaInterface.Lua.ThrowExceptionFromError(Int32 oldTop)
at LuaInterface.Lua.DoString(String chunk)
at Saga.Map.Data.LuaQuest.LuaQuestProvider.OnVerify(UInt32 cid)
coz your not suppose to.. you have to open the bat file...
System.Exception: Server failed to connect to the database server
at Saga.Managers.Database.Load() in C:\Documents and Settings\Owner\Desktop\GameServers\Saga Revised\Saga.Map\Managers\World Managers\Managers.Database.cs:line 89
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1' at line 33
[Err] -- ----------------------------
-- Table structure for characters
-- ----------------------------
CREATE TABLE `characters` (
`CharId` int(10) unsigned NOT NULL AUTO_INCREMENT,
`CharName` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`CharFace` varbinary(11) DEFAULT NULL,
`UserId` int(10) unsigned NOT NULL DEFAULT '0',
`Cexp` int(10) unsigned NOT NULL DEFAULT '1',
`Jexp` int(10) unsigned NOT NULL DEFAULT '1',
`Job` tinyint(3) unsigned NOT NULL DEFAULT '1',
`Map` tinyint(3) unsigned NOT NULL DEFAULT '11',
`Gender` tinyint(3) unsigned NOT NULL DEFAULT '1',
`HP` mediumint(8) unsigned NOT NULL DEFAULT '200',
`SP` mediumint(8) unsigned NOT NULL DEFAULT '210',
`LP` tinyint(3) unsigned NOT NULL DEFAULT '1',
`LC` tinyint(3) unsigned NOT NULL DEFAULT '45',
`Position.x` float NOT NULL DEFAULT '-17208',
`Position.y` float NOT NULL DEFAULT '9944',
`Position.z` float NOT NULL DEFAULT '109',
`Saveposition.x` float NOT NULL DEFAULT '-6558.26',
`Saveposition.y` float NOT NULL DEFAULT '14842.2',
`Saveposition.z` float NOT NULL DEFAULT '4322.33',
`Saveposition.map` tinyint(3) unsigned NOT NULL DEFAULT '3',
`Stats.Str` tinyint(3) unsigned NOT NULL DEFAULT '0',
`Stats.Dex` tinyint(3) unsigned NOT NULL DEFAULT '0',
`Stats.Int` tinyint(3) unsigned NOT NULL DEFAULT '0',
`Stats.Con` tinyint(3) unsigned NOT NULL DEFAULT '0',
`Stats.Luc` tinyint(3) unsigned NOT NULL DEFAULT '0',
`Stats.Pending` tinyint(3) unsigned NOT NULL DEFAULT '0',
`Rufi` int(10) unsigned NOT NULL DEFAULT '0',
`UppercasedCharName` varchar(32) DEFAULT NULL,
PRIMARY KEY (`CharId`,`UserId`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
[Msg] Finished - Unsuccessfully
--------------------------------------------------