• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

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

Hubert xD

New Member
Joined
Jul 10, 2013
Messages
21
Solutions
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
 
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 (?)
 
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
 
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)
 
Back
Top