Update. 26/02/2010

[lapta]

Think i have found the problem @ last.

I think the problem with the current accounts and the new database is the 2 fields related to date the account was created and last updated.

At the moment every import account has no created date, and it seems that if i update the account with a real time and date then the account database works.

Need to wait for ezzo so that he can help me update every account at once, rather then doing it manually.

Will keep u update.

/Lapta

[cushy]

cheers 4 all updates. hope to soon be ingame again. Always wanted my own server, but after all your headaches i think im happier playing lol.
GL with it all.

[tunder007]

hope ezzo isn't coming on a camel then as it might take weeks for him to arrive

[monkeyfromzoo]

Nice one sexy boy! Lets get it up by the weekend. I wana talk to u later jay

[Wacey]

sorry i dont know what database app your using but just an offering of advice

make a list of dates in excel the same size as you need in the database and copy them in
obv its easier to make the list in excel cuz you can type two then highlight, left click corner and drag down to how many u need

or make a tquery

UPDATE [Table]
SET [Field] = '01/01/2000'
WHERE [Field] is Null;

[lapta]

sorry i dont know what database app your using but just an offering of advice

make a list of dates in excel the same size as you need in the database and copy them in
obv its easier to make the list in excel cuz you can type two then highlight, left click corner and drag down to how many u need

sql 2008.

Have tried import account, the date needs to be genarated for the dbserver to be happy.

[ecalos]

sorry i dont know what database app your using but just an offering of advice

make a list of dates in excel the same size as you need in the database and copy them in
obv its easier to make the list in excel cuz you can type two then highlight, left click corner and drag down to how many u need

or copy the whole db section into excel - make the changes accordingly then upload as a table. rather straightforward unless i'm missing something so complicated it will inevitably delay roll out ><

[Wacey]

sql 2008.

Have tried import account, the date needs to be genarated for the dbserver to be happy.

hard to know whats happening without being there.
guess its best to wait for ezzo.

[lapta]

hard to know whats happening without being there.
guess its best to wait for ezzo.

spent the last 36 hours on this problem, when sql genarates its own time stamp its happy. Maunally inputting data into the time stamp field locks the database.

[Deano187]

36 hours on one problem, damn, i admire your patience and dedication. for all those people asking about when its gonna be up, this is probably why your getting a ban, like FOOOOK could i be arsed being stuck on the same problem for anything more than an hour and have vountless people whinging at me.... ouch