erro sod not work

Newbie Spellweaver
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
 
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!
 
Back