[DM2+]DBServer problem

[koni]

most prob a noob mistake but ive double checked everything to make sure i have not missed anything,

did the latest update from thedeath (23/08/07) - have not updated in months so i thaught id better do it

changed all the exe's etc etc

did all the updates in sql and added all the new tables etc

but my dbserver is reporting the following message:
TFrmDBSrv.starttimer

then when i run the other gates it spams with

gate connected
gate disconnected

the m2 server then spams with dbserver connected all over it

and the selgate is saying "kickoff then leo's server count ip"

and then lol after about 1 min my desktop gets spammed with access violation messages form the db server

any help would be appreciated

 

[Fire]

you havent done all the sql updates basically. look for the charinfo and charlist table ones

 

[Angelis]

Correct as Fire says you havent fully updated your SQL to the Updates.doc

 

[NewHope]

Anyone know the specific reason for this problem, i have this also and have been searching the forums for any help - it seems many people have encountered this problem yet no one seems to have posted how they fixed it.

 

[Angelis]

We just said how to fix it... You have to do all the updates to your database.

Everything you need to do to your DB is in the Updates.doc

 

[NewHope]

We just said how to fix it... You have to do all the updates to your database.

Everything you need to do to your DB is in the Updates.doc

I have been through the Updates doc a few times now re-checking things, and i cant find what i've missed if theres anything. >.<

 

[koni]

the first problem is now resolved i dont really want to own up to it lol but i put this update:
changes to tbl_CharListallow null is always false )
Fld_Index(int, length4, increment = yes, identity increment = 1)
Fld_Account(varchar,16)
Fld_CharName(varchar,20)
Fld_CreateDate(bigint,8,default 0)
Fld_Modifydate(bigint,8, default 0)
Fld_SelectID(int,4,default 0)
Fld_Deleted(bit,1,default 0)
Fld_Selected(bit, 1, default value 0)


lmfao i put it in tbl_charinfo

got another small problem now but i can fix that one lol

sorry for the thread wasnt really needed just a stupid mistake ><

edited: everything is sorted now =)

 

[NewHope]

the first problem is now resolved i dont really want to own up to it lol but i put this update:
changes to tbl_CharListallow null is always false )
Fld_Index(int, length4, increment = yes, identity increment = 1)
Fld_Account(varchar,16)
Fld_CharName(varchar,20)
Fld_CreateDate(bigint,8,default 0)
Fld_Modifydate(bigint,8, default 0)
Fld_SelectID(int,4,default 0)
Fld_Deleted(bit,1,default 0)
Fld_Selected(bit, 1, default value 0)


lmfao i put it in tbl_charinfo

got another small problem now but i can fix that one lol

sorry for the thread wasnt really needed just a stupid mistake ><

edited: everything is sorted now =)

Heh, i was d the same thing - corrected the mistake yet it still doesnt work for me... sucks.

 

[koni]

i used the single database made by shunt and supplied in the update, then went through every update over and over and over lol and now its working

just have a good look through the updates.doc and go through every update from top to bottom and make sure you have done everyone and not missed any

make sure you are using all the exe's supplied in the latest update