Erro no Site

[IGlobal 50]

Bom, eu deixei o site todo on esta sem erros, mais tem um porem, quando você entra no home ou criar uma account, char e tal, aparece essa coisa, que te impede de logar no site..

 

string(100) "SELECT `ip`, `created`, `points`, `cooldown` FROM `znote_accounts` WHERE `account_id` = 449 LIMIT 1;" 
(query - SQL error) 
Type: select_single (select single row from database)

Table 'servidor.znote_accounts' doesn't exist

[luanluciano93 1994]

Execute esse comando no phpmyadmin:

CREATE TABLE `znote_accounts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`account_id` int(11) NOT NULL,
`ip` int(10) NOT NULL,
`created` int(10) NOT NULL,
`points` int(10) DEFAULT 0,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

[IGlobal 50]

O erro foi arrumado, mais apareceu outro em cima, obrigado

No changelogs submitted.string(165) "SELECT `n`.`id`, `n`.`title`, `n`.`text`, `n`.`date`, `p`.`name` FROM `znote_news` AS `n` INNER JOIN `players` AS `p` ON `n`.`pid` = `p`.`id` ORDER BY `n`.`id` DESC;" 
(query - SQL error) 
Type: select_multi (select multiple rows from database)

Unknown column 'n.pid' in 'on clause'

[gentil2017 0]

Meu tb

[jackless1 0]

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'

[Aksz 46]

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;