Missing Skills and Items after Dbserver Update Mir2

[HeavenSent]

Hi all fixed the spell's & guild bug but buy doing so i now have a big bug >.<

When i loged in my gm char was gone but i had just added the new dbserver so wasent to fused,

Tryed makeing the gm name i had b4 but it was taken oh well ill make a new name so i did & made it a gm been in game about 10mins testing the new skills put mirarmour & gmblade on & had 3 skills equiped when i loged off this was in my dbserver...


Server Started...
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Fld_Position'
[UserMagics] Error Loading Char: testrr
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Fld_Position'
[UserMagics] Error Loading Char: InfinityGM
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Fld_Position'
[UserMagics] Error Loading Char: InfinityGM
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Fld_Position'
[UserMagics] Error Loading Char: InfinityGM
-- SQL KeepAlive
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Fld_Position'
[UserMagics] Error Loading Char: InfinityGM
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Fld_Status13'
[StatusArray] Error updating char:InfinityGM
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Fld_Position'
[UserItem] Error Inserting magic char:InfinityGM Magicindex:52
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Fld_Position'
[UserMagics] Error Loading Char: InfinityGM
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Fld_Status13'
[StatusArray] Error updating char:InfinityGM
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Fld_Position'
[UserItem] Error Inserting magic char:InfinityGM Magicindex:52
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Fld_Position'
[UserItem] Error Inserting magic char:InfinityGM Magicindex:53
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Fld_Position'
[UserItem] Error Inserting magic char:InfinityGM Magicindex:51
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Fld_Position'
[UserMagics] Error Loading Char: testrr
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Fld_Position'
[UserMagics] Error Loading Char: InfinityGM


So i decided to log back in & see if my chars items & skill's ware still on
loged ingame char was there i was ware i loged off & i had gmblade & mirarmour on but my skill's had gone when i loged on here is what the dbserver has...


Server Started...
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Fld_Position'
[UserMagics] Error Loading Char: testrr
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Fld_Position'
[UserMagics] Error Loading Char: InfinityGM
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Fld_Position'
[UserMagics] Error Loading Char: InfinityGM
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Fld_Position'
[UserMagics] Error Loading Char: InfinityGM
-- SQL KeepAlive
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Fld_Position'
[UserMagics] Error Loading Char: InfinityGM
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Fld_Status13'
[StatusArray] Error updating char:InfinityGM

 

[shunt]

normally after getting the latest exe's i delete the hum file from dbserver/fdb
the id file from loginsrv/iddb, and then also delete the entries from the sql tables for account, accountadd (if you are using loginsrvsql), charinfo, charlist and statusarray, i leave the info in useritems and usermagic, then as long as i crate a char same name,, it recognises i have items, skills ect,, you just might have contamination (cant think of any other word for it) from varioas data sources.?

 

[HeavenSent]

TY i have to go ben now ill try it 2morow any one elce got a idea???

 

[shunt]

i hope "ben" appreciates you giving up valuable server time

 

[deanfletc]

in tbl_usermagic you gotta add fld_position (tinyint, no null, just set default to 0) this will be used to make the players magics save in correct order for when he relogs

VirUs

 

[thedeath]

ppl should really read updates.doc it's soooooo usefull

 

[HeavenSent]

I did read it must have mised it sorry & ty :boff:

 

[deanfletc]

lol np

VirUs