TFS 0.X Missing some line in DB. can someone recognise it?

Hubert xD

New Member
Joined
Jul 10, 2013
Messages
21
Best answers
1
Reaction score
1
Hi guys, I just noticed an error on my console:

mysql_store_result(): UPDATE `players` SET `online` = 0 WHERE `world_id` = 0; - MYSQL ERROR: (0)

Anyone got any idea what should I do to remove this error?
I believe it is a missing line in database, but I got no idea how to insert it.

Thanks in advance
 

Webtimize

Pro Grammer
Joined
Oct 3, 2011
Messages
485
Best answers
10
Reaction score
153
Location
The Netherlands
Do you have both the `online` and `world_id` columns in your `players` table?

The `online` column was dropped in TFS 1.2 by separating online players into another table (players_online).
I'm not sure about `world_id`, I am familiar with it - but it doesn't seem to show up on TFS repo, so it might be dropped long ago (?)
 
OP
H

Hubert xD

New Member
Joined
Jul 10, 2013
Messages
21
Best answers
1
Reaction score
1
Do you have both the `online` and `world_id` columns in your `players` table?

The `online` column was dropped in TFS 1.2 by separating online players into another table (players_online).
I'm not sure about `world_id`, I am familiar with it - but it doesn't seem to show up on TFS repo, so it might be dropped long ago (?)
I do have online column, but can't see world id. seems it is missing. any idea how to fix it? thanks
 
OP
H

Hubert xD

New Member
Joined
Jul 10, 2013
Messages
21
Best answers
1
Reaction score
1
no, sorry. I have both of columns. I see now I got either online and world_id.

By the way I am using tfs 0.4 (8.60)
 
Top