Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

erro sod not work

Initiate Mage
Joined
Jul 21, 2008
Messages
5
Reaction score
0
when I want to use the clan sod manager I received this error dan my BillingDBError

191045 | SELECT IDX FROM WHERE userid = 'user1' AND ChName = 'char1' AND DelActive = 0 Incorrect syntax near the keyword 'WHERE'.

191101 | SELECT IDX FROM WHERE userid = 'user2' AND ChName = 'char2' AND DelActive = 0 Incorrect syntax near the keyword 'WHERE'.

192822 | INSERT INTO SOD2RecBySandurr (UserID, CharName, CharType, Point, KillCount, GLevel, TotalPoint, TotalUser, SuccessUser, ServerName, PCRNo, GPCode, Contribute, RegistDay, BusinessName, BAddress1, PMNo, ServerTime) VALUES ( 'user2', 'char2 ', 3, 18998814, 573, 119, 32364700, 2, 2,' servername ', 0,'', 117,'08-03-2008 19:28:22','','', 0, -134217728 )

192822 | INSERT INTO SOD2RecBySandurr (UserID, CharName, CharType, Point, KillCount, GLevel, TotalPoint, TotalUser, SuccessUser, ServerName, PCRNo, GPCode, Contribute, RegistDay, BusinessName, BAddress1, PMNo, ServerTime) VALUES ( 'user1', 'char1 ', 8, 13365886, 335, 120, 32364700, 2, 2,' servername ', 0,'', 82,'08-03-2008 19:28:22','','', 0, -134217728 )

pleaze help me for resolving this error

I use sql.dll configure and clan. Dll configure
 
Joined
Jan 19, 2007
Messages
400
Reaction score
38
open the other sql log... its some like... date.log... example 20082507.log i don't remmember now...
but.. in this log i can see what is wrong!
u will see some like that:
--------------------------------
error converting datetime value to char value... or table missing or some like it!
---------------------------------
for fix it... u can try fix the error reading the log...
or ...
go to "SOD2RecBySandurr " right click button... configure
change all value to:
nvarchar(50)
close and save... ^^
its fix many errors of sql!
 
Initiate Mage
Joined
Jul 21, 2008
Messages
5
Reaction score
0
i joint my log and bderror :)
 

Attachments

You must be registered for see attachments list
Back
Top