HELP with a serious problem
Posted: Mon Jan 11, 2010 11:12 pm
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:
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
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;
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