Page 1 of 1

HELP with a serious problem

Posted: Mon Jan 11, 2010 11:12 pm
by kocinski
L2jO Revision Number: 1424
L2jODP Revision Number: 1424

Anyone can help me to guess why some accounts of my DB (about 2k of a total of 30k) store mistakenly the "lastactive" field with only 10 digits and not with the correct 13.

Lot of this accounts are 1 day last used but stores this data bad...

I recently used a unused accounts Script who deleted that accounts:

Code: Select all

DELETE FROM accounts WHERE DATEDIFF( CURRENT_DATE( ) , FROM_UNIXTIME( `lastactive` /1000 ) ) > @60;
And of course... i did before a DB Backup but now, 48h. later can't restore the DB for obviously reasons and have a serious problem to insert manually the data because of "idfactory" in "items" table...

Anyone have some brilliant idea how to solve it?

Thanks for all of your help...

P.S.: I know this is a L2jServer Forum but i'm going to migrate to it soon and it's Devs JIV, Charus & Gnazik are now L2jServer formerly Devs.
P.S2: Sorry for all the inconveniences
P.S3: Obviously i'm not searching for support, only a little Help with that trouble

Re: HELP with a serious problem

Posted: Mon Jan 11, 2010 11:41 pm
by JIV
i noticed it sometimes that last active is only 10 numbers but these account were never connected yet. If im correct "10" is created by acm. So i dont think you deleted something wrong, but if you want to change things back easiest way is make rollback 48h. Other way is update duplicate ids where item id is different.

Re: HELP with a serious problem

Posted: Tue Jan 12, 2010 8:13 am
by kocinski
JIV wrote:i noticed it sometimes that last active is only 10 numbers but these account were never connected yet. If im correct "10" is created by acm. So i dont think you deleted something wrong, but if you want to change things back easiest way is make rollback 48h. Other way is update duplicate ids where item id is different.
Thanks for your answer,

This "10" digits last active accounts are in use accounts with characters lvl 80 for example...

Anyway, thank you very much.