(Error) Help - me L2O

[Renato15]

please, they help me. that error eh this? When I go to create a doll. this happens. they help me plx >.<

SS of the Error:

 

[Shawnmb]

I have previously posted a fix for this, search is disabled right now though

 

[Renato15]

It does not have nor a tip of what it can be? : (

 

[Shawnmb]

Because searching here is disabled, I'll link you to another copy of the thread on PostPacific.

To view the content, you need to sign in or register

The warning message cache spams when a user without time data logs in:

03/11/2006 02:30:02.937, [Account.cpp][381]Error. Cannot load Week play time, account id [xxxxx]
03/11/2006 02:30:03.531, [Account.cpp][321] Cannot load day uesed time for account [xxxxx]

This may have been posted before, don't know, didn't check, but it works.
I wrote this in about 2 minutes and didnt bother to make it quick to run, because you only need to do it once. It takes about 5 minutes on SQL 2000 and 15 seconds on 2005.

Declare @acc int
Set @acc = 0

WHILE(@acc < 150000)
BEGIN
INSERT lin2world.dbo.time_data (account_id, last_logout, used_sec)
VALUES (@acc, '1/1/2004 1:00:00 AM', '0')
Set @acc = @acc + 1
END

(I wrote this again from memory after 2 nights of no sleep, hope I didn't make any typos)

Edit: This should leave current time data which already exists in tact, SQL errors and continues when a duplicate row is detected in INSERT.

 

[Renato15]

It forgives for encomodo Shawnmb, more now this giving this here:

It has as to adjust? I made something wrong? it can help me please!

:schmoll: :schmoll:

 

[Shawnmb]

It will give you an error for every already-created row, ignore them, the error on Cache should dissapear regardless.

 

[Renato15]

=(

Good day. Shawnmb, I placed I executed the Query and everything. but now not of the o error, more it is in the same thing. that is it does not create char, has plus some thing that I can make?