Gesior AAC ERRO STEP 5

[axebruno 1]

Set Admin Account

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'vip_time' in 'field list'' in C:\xampp\htdocs\pot\OTS_Account.php:228 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Account.php(228): PDO->query('SELECT `id`, `n...') #1 C:\xampp\htdocs\install.php(572): OTS_Account->load(1) #2 {main} thrown in C:\xampp\htdocs\pot\OTS_Account.php on line 228

ALGUEM PODE ME AJUDAR?

[Sekk 396]

executa isso na sua db do mysql

 

ALTER TABLE `accounts` ADD `vip_time` int(11) NOT NULL DEFAULT 0;

 

[axebruno 1]

como eu faco isso? pelo localhost/phpmyadmin ? 

ou pelo mysql.sql ?

 

pode me ajudar pelo skype? ou teamspeak3? 

Editado Maio 11, 2016 por axebruno (veja o histórico de edições)

[Sekk 396]

Desculpa, to meio ocupado pra poder usar skype e outros... Mas sim, é no localhost/phpmyadmin

 

La vc abre a sua db, abre a coluna "SQL", cola aquela query e executa.

[axebruno 1]

Obrigado, consegui criar o site, mas agora ta dando outro erro ;/

 

quando abro o site, jogo localhost la, mostra o site ai clico em qlq coisa da 
 

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'global.pagsegurotransacoes' doesn't exist' in C:\xampp\htdocs\layouts\tibiacom\layout.php:460 Stack trace: #0 C:\xampp\htdocs\layouts\tibiacom\layout.php(460): PDO->query('SELECT COUNT(*)...') #1 C:\xampp\htdocs\index.php(345): include('C:\xampp\htdocs...') #2 {main} thrown inC:\xampp\htdocs\layouts\tibiacom\layout.phpon line 460

[Sekk 396]

CREATE TABLE IF NOT EXISTS `PagSeguroTransacoes` (      `TransacaoID` VARCHAR(36) NOT NULL,
      `VendedorEmail` VARCHAR(200) NOT NULL,
      `Referencia` VARCHAR(200) DEFAULT NULL,
      `TipoFrete` CHAR(2) DEFAULT NULL,
      `ValorFrete` DECIMAL(10,2) DEFAULT NULL,
      `Extras` DECIMAL(10,2) DEFAULT NULL,
      `Anotacao` text,
      `TipoPagamento` VARCHAR(50) NOT NULL,
      `StatusTransacao` VARCHAR(50) NOT NULL,
      `CliNome` VARCHAR(200) NOT NULL,
      `CliEmail` VARCHAR(200) NOT NULL,
      `CliEndereco` VARCHAR(200) NOT NULL,
      `CliNumero` VARCHAR(10) DEFAULT NULL,
      `CliComplemento` VARCHAR(100) DEFAULT NULL,
      `CliBairro` VARCHAR(100) NOT NULL,
      `CliCidade` VARCHAR(100) NOT NULL,
      `CliEstado` CHAR(2) NOT NULL,
      `CliCEP` VARCHAR(9) NOT NULL,
      `CliTelefone` VARCHAR(14) DEFAULT NULL,
      `ProdDescricao` VARCHAR(200) DEFAULT NULL,
      `ProdValor` VARCHAR(200) DEFAULT NULL,
      `ProdID` VARCHAR(200) DEFAULT NULL,
      `ProdQuantidade` VARCHAR(200) DEFAULT NULL,
      `NumItens` INT(11) NOT NULL,
      `Data` datetime NOT NULL,
      `status` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
      `servidor` VARCHAR(20) NOT NULL,
      `DataEntregue` INT(3) NOT NULL,
      UNIQUE KEY `TransacaoID` (`TransacaoID`,`StatusTransacao`),
      KEY `Referencia` (`Referencia`),
      KEY `status` (`status`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

 

[axebruno 1]

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'broadcasting' in 'where clause'' in C:\xampp\htdocs\cast.php:158 Stack trace: #0 C:\xampp\htdocs\cast.php(158): PDO->query('SELECT name,lev...') #1 C:\xampp\htdocs\index.php(297): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\cast.php on line 158

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'global.woe' doesn't exist' in C:\xampp\htdocs\warofemperium.php:10 Stack trace: #0 C:\xampp\htdocs\warofemperium.php(10): PDO->query('???SELECT w.id ...') #1 C:\xampp\htdocs\index.php(277): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\warofemperium.php on line 10

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'global.lottery' doesn't exist' in C:\xampp\htdocs\lottery.php:3 Stack trace: #0 C:\xampp\htdocs\lottery.php(3): PDO->query('SELECT id, name...') #1 C:\xampp\htdocs\index.php(292): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\lottery.php on line 3

[kualkerun 29]

cara tu pegou um site sem a data base , vai ter que ir criando tabela por tabela

[axebruno 1]

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'global.players' doesn't exist' in C:\xampp\htdocs\latestnews.php:10 Stack trace: #0 C:\xampp\htdocs\latestnews.php(10): PDO->query('SELECT `players...') #1 C:\xampp\htdocs\index.php(63): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\latestnews.php on line 10