new error.

08/31/2011 19:00 Svinseladden#1
from: PS_GAME__system.log__20110831_184606.log

get and error is LUA,

2011-08-31 18:46:08 connect mgr 836

2011-08-31 18:46:08 connect dbagent 844

2011-08-31 18:46:08 connect dbagent2 856

2011-08-31 18:46:08 connect gamelog 888

2011-08-31 18:46:08 Market End -----------------------

2011-08-31 18:46:09 cannot open .\Data\Lua\127.lua: No such file or directory

2011-08-31 18:46:09 cannot open .\Data\Lua\127.lua: No such file or directory

2011-08-31 18:46:09 cannot open .\Data\Lua\127.lua: No such file or directory

2011-08-31 18:46:09 cannot open .\Data\Lua\127.lua: No such file or directory

2011-08-31 18:46:09 cannot open .\Data\Lua\127.lua: No such file or directory

2011-08-31 18:46:09 cannot open .\Data\Lua\127.lua: No such file or directory

2011-08-31 18:46:09 cannot open .\Data\Lua\133.lua: No such file or directory

2011-08-31 18:46:09 cannot open .\Data\Lua\133.lua: No such file or directory

2011-08-31 18:46:09 cannot open .\Data\Lua\133.lua: No such file or directory

2011-08-31 18:46:09 cannot open .\Data\Lua\133.lua: No such file or directory

2011-08-31 18:46:09 cannot open .\Data\Lua\133.lua: No such file or directory

2011-08-31 18:46:09 cannot open .\Data\Lua\133.lua: No such file or directory

2011-08-31 18:46:09 cannot open .\Data\Lua\133.lua: No such file or directory

2011-08-31 18:46:09 cannot open .\Data\Lua\133.lua: No such file or directory

2011-08-31 18:46:09 cannot open .\Data\Lua\133.lua: No such file or directory

2011-08-31 18:46:09 cannot open .\Data\Lua\134.lua: No such file or directory

2011-08-31 18:46:09 cannot open .\Data\Lua\138.lua: No such file or directory

2011-08-31 18:46:09 cannot open .\Data\Lua\139.lua: No such file or directory

2011-08-31 18:46:09 cannot open .\Data\Lua\147.lua: No such file or directory

2011-08-31 18:46:09 cannot open .\Data\Lua\141.lua: No such file or directory

2011-08-31 18:46:09 cannot open .\Data\Lua\145.lua: No such file or directory

2011-08-31 18:46:09 cannot open .\Data\Lua\129.lua: No such file or directory

2011-08-31 18:46:09 cannot open .\Data\Lua\144.lua: No such file or directory

2011-08-31 18:46:09 cannot open .\Data\Lua\146.lua: No such file or directory

2011-08-31 18:46:09 cannot open .\Data\Lua\126.lua: No such file or directory

2011-08-31 18:46:09 Load Shaiya.SData 14

never hade this before?

also having:


from PS_DBAGENT__system.log__20110831_184606.log :

2011-08-31 18:47:39 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]MSDTC on server 'servername' is unavailable., SQL STATE: 42000, NATIVE ERROR: 8501 (0x2135)

2011-08-31 18:47:39 SaveBuyPointItem 92 "char name" qerr=0, {?=call usp_Save_User_BuyPointItems_NCash(26,92,0,'ressrun en','2011-08-31 18:47:39')}

2011-08-31 18:53:02 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]MSDTC on server 'VPS-1053' is unavailable., SQL STATE: 42000, NATIVE ERROR: 8501 (0x2135)

2011-08-31 18:53:02 SaveBuyPointItem 42 "charname" qerr=0, {?=call usp_Save_User_BuyPointItems_NCash(8,42,0,'B1_Nosss 0001','2011-08-31 18:53:01')}

2011-08-31 19:04:01 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]MSDTC on server 'VPS-1053' is unavailable., SQL STATE: 42000, NATIVE ERROR: 8501 (0x2135)

2011-08-31 19:04:01 SaveBuyPointItem 778 ghg qerr=0, {?=call usp_Save_User_BuyPointItems_NCash(315,778,0,'Wearh ouse1','2011-08-31 19:04:01')}


and from 2011-08-31 18:46:06 PS_GAMELOG__system log start (GameLog01)

2011-08-31 18:46:08 connect game

2011-08-31 18:54:07 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2011-08-31 18:54:07 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'username',10,103,'char name', 70,350000000,54, 80.198616,5.698793,42.135147, '2011-08-31 18:54:07' ,121, 3322905799076020224,100082, 3,1,13, NULL,79,NULL,NULL,NULL,'Operator's Exclusive',NULL,'0,0,0,0,0,0 (Option:)','2011-08-14 21:20:56'



all this and all i'm right now can see that is wrong is that i get discon when i buy stuff from itemmall. and on my test servere it works.. can't understand why this is happening

sorry was only MSDTC that was on manualy..
08/31/2011 23:03 JohnHeatz#2
If you had read, you are missing files on that directory

Quote:
.\Data\Lua\
all the files listed there are simply not there. As for the SQL, it is really easy to just google those errors code and find a fix for it, it really is.
08/31/2011 23:18 Svinseladden#3
Quote:
Originally Posted by JohnHeatz View Post
If you had read, you are missing files on that directory



all the files listed there are simply not there. As for the SQL, it is really easy to just google those errors code and find a fix for it, it really is.
ty but i found it. too much info mabe you missed it:-)

sorry was only MSDTC that was on manualy..

but thanks for the help..