Erro Na Criação De Conta Do Admin - Xampp (Ultimo Passo)

[lanzah 0]

Alguem sabe o que fazer quando aparece o seguinte erro

 

STEP 5

 

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:237 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Account.php(237): 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 237

 

quando estou criando a conta que será usada pelo ADM do site, é praticamente o ultimo passo antes de abrir o site e da esse erro. Os passos anteriores parecem estar corretos...

 

STEP 3

 

Add tables and columns to DB

Installer try to add new tables and columns to database.

 

Add columns to table accounts

 

Can't add column page_lastday to table accounts, already exist?

Can't add column email_new to table accounts, already exist?

Can't add column email_new_time to table accounts, already exist?

Can't add column created to table accounts, already exist?

Can't add column rlname to table accounts, already exist?

Can't add column location to table accounts, already exist?

Can't add column page_access to table accounts, already exist?

Can't add column email_code to table accounts, already exist?

Can't add column next_email to table accounts, already exist?

Can't add column premium_points to table accounts, already exist?

Can't add column vote to table players, already exist?

Can't add column last posts to table accounts, already exist?

Can't add column flag to table accounts, already exist?

 

Add columns to table guilds

 

Can't add column description to table guilds, already exist?

Can't add column logo_gfx_name to table guilds, already exist?

 

Add columns to table players

 

Can't add column created to table players, already exist?

Can't add column nick_verify to table players, already exist?

Can't add column old_name to table players, already exist?

Can't add column hide_char to table players, already exist?

Can't add column worldtransfer to table players, already exist?

Can't add column comment to table players, already exist?

Can't add column comment to table players, already exist?

Can't add column comment to table players, already exist?

Can't add column comment to table players, already exist?

Can't add column comment to table players, already exist?

Can't add column comment to table players, already exist?

 

Add new tables to database

 

Table z_news_tickers not added. Already exist?

Table z_spells not added. Already exist?

Table z_monsters not added. Already exist?

Table z_ots_comunication not added. Already exist?

Table z_shop_offer not added. Already exist?

Table z_shop_history_item not added. Already exist?

Table z_shop_history_pacc not added. Already exist?

Table z_polls not added. Already exist?

Table z_polls_answers not added. Already exist?

Table zaypay_payment not added. Already exist?

Table z_bug_tracker not added. Already exist?

Table z_changelog not added. Already exist?

Table z_forum not added. Already exist?

 

Tables and columns added to database.

Go to STEP 4 - Add samples

 

STEP 4

 

Add samples to DB:

News ticker sample is already in database. New sample is not needed.

Character 'Rook Sample' already in database.

Character 'Sorcerer Sample' already in database.

Character 'Druid Sample' already in database.

Character 'Paladin Sample' already in database.

Character 'Knight Sample' already in database.

All samples added to database. Now you can go to STEP 5 - Set Admin Account

 

 

 

quem puder me ajudar add msn: lanzaserver@hotmail.com

ou responda aqui mesmo. Obrigado

[k2lan 45]

rode isso em sua database

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

[lanzah 0]

Obrigado funciono =)

[k2lan 45]

imagina, qualquer coisa estamos ai

[augh 0]

rode isso em sua database

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

 

Muito obg, me salvou.!

[Raizer1 0]

mt bom ajudo mt

[Tktforever 2]

não entendi, como eu faço pra rodar no database... me ajuda porfavor ++REEP

[baiakizicksz 3]

deu certo man vlw ^^

Editado Abril 20, 2012 por baiakizicksz

[andreoam 0]

rode isso em sua database

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

 

Como que eu rodo isso na DB do ser?

[gabrielhenriquecardoso 5]

AndreOaM, para rodar na database entre no localhost/phpmyadmin, logue na sua conta, entre na sua database, na aba SQL cole e execute.