Erro no Site

6 horas atrás, jackless1 disse:

eu estou com esse erro no meu site e nao consigo arumar, alguem pode ajudar ?

 

 

string(339) "SELECT `p`.`id`, `p`.`name`, `p`.`level`, `p`.`vocation`, `p`.`town_id`, `p`.`lastlogin`, `gm`.`rank_id`, `po`.`player_id` AS `online` FROM `players` AS `p` LEFT JOIN `guild_membership` AS `gm` ON `p`.`id`=`gm`.`player_id` LEFT JOIN `players_online` AS `po` ON `p`.`id`=`po`.`player_id` WHERE `p`.`account_id`='0' ORDER BY `p`.`level` DESC"
(query - SQL error)
Type: select_multi (select multiple rows from database)

Unknown column 'gm.rank_id' in 'field list'

Está dando um JOIN, na tabela guild_membership, e na tabela não tem o rank_id.

Executa esse comando

 

ALTER TABLE guild_membership ADD COLUMN rank_id INT NOT NULL;