Is there anyone who can help and see what the reason is, thank you very much!

Results 1 to 7 of 7
  1. #1
    Apprentice liulinkan is online now
    MemberRank
    May 2022 Join Date
    23Posts

    Is there anyone who can help and see what the reason is, thank you very much!

    I used (K18.3) to control (Nanus FlyFF) source code, added these functions, and then prompted error, I do not have the ability to solve, there is a big guy to say what is the cause?

    1.SQLSTATE:42000 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]The stored procedure 'uspVendorNpcGet' could not be found.

    2.query:{call CHARACTER_STR('U1','0000001','01','',?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, 0, 0, 0,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}SQLSTATE:42000 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]Too many parameters were specified for the procedure or function CHARACTER_STR.

    3.SavePlayer(admin) - Exec RETURN FALSE, ThreadID : 7988

    4.SavePlayer(admin) - Exec RETURN FALSE, ThreadID : 9996

    5.GetDlgItem : nID=929 not Found.----Just open the personal shop or inventory and the client will crash! And prompt this error!

    6.CDbManager::VendNpcGet[Line:299] Failed, Query: uspVendorNpcGet 1Click image for larger version. 

Name:	2M4IL[LNF(]T`G~FN8(4[(J.png 
Views:	4 
Size:	5.2 KB 
ID:	171873Click image for larger version. 

Name:	[{@8BDPJ{PTI0{RX90K]1YV.png 
Views:	3 
Size:	13.0 KB 
ID:	171872Click image for larger version. 

Name:	30CV(F6XCALU2WLPO`4FLL7.png 
Views:	2 
Size:	2.5 KB 
ID:	171874Click image for larger version. 

Name:	G{S(3_VH`6P44(9LKARTDI3.png 
Views:	6 
Size:	1.9 KB 
ID:	171875Click image for larger version. 

Name:	P@243%W5(G]`ENNRXD8BA~T.png 
Views:	1 
Size:	2.0 KB 
ID:	171876

    - - - Updated - - -



    These are the features that have been added

    #define __DONATE_INVENT
    #define __CHIP_PLAYER_CUSTOM
    #define __VENDOR_UPDATE
    #define __CHIP_PLAYERSHOP
    #define __VENDING_NPC
    #define __ANARCHY_SYSTEM


  2. #2
    ‎‎‎‎ Ketchup is offline
    ModeratorRank
    Jan 2009 Join Date
    2,455Posts

    Re: Is there anyone who can help and see what the reason is, thank you very much!

    The error tells you exactly what the problem is.

    Your missing the vending npc database.

  3. #3
    Apprentice liulinkan is online now
    MemberRank
    May 2022 Join Date
    23Posts

    Re: Is there anyone who can help and see what the reason is, thank you very much!

    Thank you very much for the answer, I also think it is a database problem, but I don't know how to solve it!

  4. #4
    Member c2cube is online now
    MemberRank
    Sep 2021 Join Date
    74Posts

    Re: Is there anyone who can help and see what the reason is, thank you very much!

    Quote Originally Posted by liulinkan View Post
    Thank you very much for the answer, I also think it is a database problem, but I don't know how to solve it!
    i have the same problem before, error number 1, 2, 6 but in VendNpcUpdate because ive try to add OFFLINE_VENDOR from Guru Ultimate and use Florist Files database from Ketchup in release section,
    but in my error log there is specific error line in DbManager. and after i check in there, i miss one part database in uspVendorNpcUpdate . and right now im a bit understand about the database works after getting this error.
    maybe u need to check CDbManager::VendNpcGet[Line:299]

  5. #5
    Apprentice liulinkan is online now
    MemberRank
    May 2022 Join Date
    23Posts

    Re: Is there anyone who can help and see what the reason is, thank you very much!

    Thanks for your answer, but I still don't know how to modify the database, I use the SQL2008R2 database------- and I found a new problem in K18.3, that is, the font above the button does not show!
    Attached Thumbnails Attached Thumbnails @@R1P0T94OT6BJ{AL21NJ9A.png  

  6. #6
    Member c2cube is online now
    MemberRank
    Sep 2021 Join Date
    74Posts

    Re: Is there anyone who can help and see what the reason is, thank you very much!

    Quote Originally Posted by liulinkan View Post
    Thanks for your answer, but I still don't know how to modify the database, I use the SQL2008R2 database------- and I found a new problem in K18.3, that is, the font above the button does not show!
    you need to add v19 button if u still dont have it i think

  7. #7
    Apprentice liulinkan is online now
    MemberRank
    May 2022 Join Date
    23Posts

    Re: Is there anyone who can help and see what the reason is, thank you very much!

    The font above the button is solved, but this problem has a wooden big guy to give a solution, thank you----


    1.SQLSTATE:42000 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]The stored procedure 'uspVendorNpcGet' could not be found.

    2.query:{call CHARACTER_STR('U1','0000001','01','',?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, 0, 0, 0,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}SQLSTATE:42000 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]Too many parameters were specified for the procedure or function CHARACTER_STR.

    3.SavePlayer(admin) - Exec RETURN FALSE, ThreadID : 7988

    4.SavePlayer(admin) - Exec RETURN FALSE, ThreadID : 9996

    5.GetDlgItem : nID=929 not Found.----Just open the personal shop or inventory and the client will crash! And prompt this error!

    6.CDbManager::VendNpcGet[Line:299] Failed, Query: uspVendorNpcGet 1


    Now I've blocked all these features, and then it's back to normal
    Last edited by liulinkan; 21-06-22 at 03:22 PM.



Advertisement