• Congratulations to the OTLand January Mapping Competition Winner! The grand prize of Otland Premium goes to Andréew.
  • Sign up for February Mapping Competition! The prize includes Otland Premium time.
  • 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
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
487
Best answers
10
Reaction score
156
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