Ms sql error , moving Dvampire to Kation

[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 ---

[xeL]

Interlude pack?

[abecikxp]

yes intelude pack

 

On all accounts i cant login to first created character , only on second and more.

[xeL]

table structure is different , what script u made to update?

[abecikxp]

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

[xeL]

  On 3/19/2013 at 7:00 PM, abecikxp said:

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.

[xeL]

try this

 

http://pastebin.com/CbPiNvag - i use for ilext 1.2.3.6

[abecikxp]

  On 3/19/2013 at 7:32 PM, xeL said:

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.

 

[xeL]

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 .

[Sighed]

Changing database won't do much, you need manually or through a script move all the data from one database to the other.

[abecikxp]

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 :)