• 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!

PHP MYSQL mysql_real_query error?

APTGET

New Member
Joined
Dec 29, 2020
Messages
37
Reaction score
3
Lua:
[Error - mysql_real_query] Query: SELECT `name`, `level`, `spectators` FROM `players` LEFT JOIN `players_online` on `players`.`id` = `players_online`.`player_id` WHERE `broadcasting` = 1
Message: Unknown column 'spectators' in 'field list'
[Error - mysql_store_result] Query: SELECT `name`, `level`, `spectators` FROM `players` LEFT JOIN `players_online` on `players`.`id` = `players_online`.`player_id` WHERE `broadcasting` = 1
Message: Unknown column 'spectators' in 'field list'
[Error - mysql_real_query] Query: SELECT `index` FROM `player_containers` WHERE `player_id` = 114 ORDER BY `index` DESC
Message: Table 'database.player_containers' doesn't exist
[Error - mysql_store_result] Query: SELECT `index` FROM `player_containers` WHERE `player_id` = 114 ORDER BY `index` DESC
Message: Table 'database.player_containers' doesn't exist
Dodger has logged in.
[Error - mysql_real_query] Query: INSERT INTO `players_online` (`player_id`, `broadcasting`, `password`, `description`, `spectators`) VALUES (114, 0, '', '', 0)
Message: Unknown column 'broadcasting' in 'field list'

[Error - mysql_real_query] Query: DELETE FROM player_containers WHERE player_id = 114
Message: Table 'database.player_containers' doesn't exist

Lua:
[Error - mysql_store_result] Query: SELECT `name`, `level`, `spectators` FROM `players` LEFT JOIN `players_online` on `players`.`id` = `players_online`.`player_id` WHERE `broadcasting` = 1

[Error - mysql_real_query] Query: INSERT INTO `players_online` (`player_id`, `broadcasting`, `password`, `description`, `spectators`) VALUES (114, 0, '', '', 0)
Message: Unknown column 'broadcasting' in 'field list'

[Error - mysql_real_query] Query: UPDATE `players_online` SET `broadcasting` = 1, `password` = '', `description` = '', `spectators` = 0  WHERE `player_id` = 10
Message: Unknown column 'broadcasting' in 'field list'

Hello everybody. I know that my database and my existing columns are missing some things. I don't have the minimum knowledge to make this change in tables and in my database. Could someone help me please?
 
Last edited:
Personal update. I managed to make the changes in my database. But now I get the errors:

Console
Lua:
[Error - mysql_store_result] Query: SELECT * FROM z_ots_communication;
Message: Table 'cast.z_ots_communication' doesn't exist

When trying to enter the game WITH or WITHOUT account number and password
Code:
Your connection has been lost.
Either your network or the server went down. (ERROR 2)

I'm trying to implement the cast system in the Nostalrius base, and it looks like I'm close. I've seen it work but with executable windows. I'm trying to compile on Linux ubuntu 18 still to no avail.
 
Back
Top