abecikxp Posted March 19, 2013 Share Posted March 19, 2013 Hey any body know how fix this error in db ? I have imported db from Dvamp files but i have errors when try run kation files , on clear db all works perfect but i want use old db. 03/18/2013 17:49:17.937, fetch errorś 03/18/2013 17:49:17.937, sqlstate 22003 03/18/2013 17:49:17.937, msgText [Microsoft][ODBC SQL Server Driver]Numeric value out of range 03/18/2013 17:49:17.937, sql EXEC lin_GetUserDataByCharId 249763 03/18/2013 17:49:17.937, [.\User.cpp][4243] undefined (or unregistered) char Id[249763] 03/18/2013 17:49:17.937, --- call stack --- Link to comment Share on other sites More sharing options...
0 xeL Posted March 19, 2013 Share Posted March 19, 2013 Interlude pack? Link to comment Share on other sites More sharing options...
0 abecikxp Posted March 19, 2013 Author Share Posted March 19, 2013 yes intelude pack On all accounts i cant login to first created character , only on second and more. Link to comment Share on other sites More sharing options...
0 xeL Posted March 19, 2013 Share Posted March 19, 2013 table structure is different , what script u made to update? Link to comment Share on other sites More sharing options...
0 abecikxp Posted March 19, 2013 Author Share Posted March 19, 2013 I have using http://pastebin.com/iS72VccD Lin2world http://pastebin.com/jaCp85XY Lin2world up I have imported all tables from dvamp db to kation db , i cant understood why second characters on all acc works , problem is only with first characters on acc Link to comment Share on other sites More sharing options...
0 xeL Posted March 19, 2013 Share Posted March 19, 2013 I have using http://pastebin.com/iS72VccD Lin2world http://pastebin.com/jaCp85XY Lin2world up I have imported all tables from dvamp db to kation db , i cant understood why second characters on all acc works , problem is only with first characters on acc your update is for vanganath/kathion lin2world . I look for new script for u. Link to comment Share on other sites More sharing options...
0 xeL Posted March 19, 2013 Share Posted March 19, 2013 try this http://pastebin.com/CbPiNvag - i use for ilext 1.2.3.6 Link to comment Share on other sites More sharing options...
0 abecikxp Posted March 19, 2013 Author Share Posted March 19, 2013 try this http://pastebin.com/CbPiNvag - i use for ilext 1.2.3.6 Sorry i have using same update script but ,i have wrong paste (pastebin)from another kation files. ^ btw i have using same ext 1.2.3.6 I think err can be in char id , i will try to change to another id (free ) but db cant allow me this. Link to comment Share on other sites More sharing options...
0 xeL Posted March 20, 2013 Share Posted March 20, 2013 it should, if not uptdate sql to allow you that. Anyway dvamp has other structure of db, the update i posted same as yours is only for vanganath . I try today to make some change. I didn't test this . Link to comment Share on other sites More sharing options...
0 Sighed Posted March 25, 2013 Share Posted March 25, 2013 Changing database won't do much, you need manually or through a script move all the data from one database to the other. Link to comment Share on other sites More sharing options...
0 abecikxp Posted March 25, 2013 Author Share Posted March 25, 2013 I have fixed db , In user_data table (dvamp has exp Big int and vaule is bigger than int) i have down to int vaules and re import and works fine :) Link to comment Share on other sites More sharing options...
Question
abecikxp
Hey any body know how fix this error in db ?
I have imported db from Dvamp files but i have errors when try run kation files , on clear db all works perfect but i want use old db.
03/18/2013 17:49:17.937, fetch errorś
03/18/2013 17:49:17.937, sqlstate 22003
03/18/2013 17:49:17.937, msgText [Microsoft][ODBC SQL Server Driver]Numeric value out of range
03/18/2013 17:49:17.937, sql EXEC lin_GetUserDataByCharId 249763
03/18/2013 17:49:17.937, [.\User.cpp][4243] undefined (or unregistered) char Id[249763]
03/18/2013 17:49:17.937, --- call stack ---
Link to comment
Share on other sites
10 answers to this question
Recommended Posts