ERRO quer da no 

gesior-acc/

STEP 3Add tables and columns to DB
Installer try to add new tables and columns to database.
Query:ALTER TABLE `accounts` ADD `key` VARCHAR(20) NOT NULL DEFAULT '0'SQLSTATE:42S21Driver code:1060Error message:Duplicate column name 'key'Could not add column key to table accounts. Already exist?
Query:ALTER TABLE `accounts` ADD `email_new` VARCHAR(255) NOT NULL DEFAULT ''SQLSTATE:42S21Driver code:1060Error message:Duplicate column name 'email_new'Could not add column email_new to table accounts. Already exist?
Query:ALTER TABLE `accounts` ADD `email_new_time` INT(11) NOT NULL DEFAULT '0'SQLSTATE:42S21Driver code:1060Error message:Duplicate column name 'email_new_time'Could not add column email_new_time to table accounts. Already exist?
Query:ALTER TABLE `accounts` ADD `rlname` VARCHAR(255) NOT NULL DEFAULT ''SQLSTATE:42S21Driver code:1060Error message:Duplicate column name 'rlname'Could not add column rlname to table accounts. Already exist?
Query:ALTER TABLE `accounts` ADD `location` VARCHAR(255) NOT NULL DEFAULT ''SQLSTATE:42S21Driver code:1060Error message:Duplicate column name 'location'Could not add column location to table accounts. Already exist?
Query:ALTER TABLE `accounts` ADD `page_access` INT(11) NOT NULL DEFAULT '0'SQLSTATE:42S21Driver code:1060Error message:Duplicate column name 'page_access'Could not add column page_access to table accounts. Already exist?
Query:ALTER TABLE `accounts` ADD `email_code` VARCHAR(255) NOT NULL DEFAULT ''SQLSTATE:42S21Driver code:1060Error message:Duplicate column name 'email_code'Could not add column email_code to table accounts. Already exist?
Query:ALTER TABLE `accounts` ADD `next_email` INT(11) NOT NULL DEFAULT '0'SQLSTATE:42S21Driver code:1060Error message:Duplicate column name 'next_email'Could not add column next_email to table accounts. Already exist?
Query:ALTER TABLE `accounts` ADD `premium_points` INT(11) NOT NULL DEFAULT '0'SQLSTATE:42S21Driver code:1060Error message:Duplicate column name 'premium_points'Could not add column premium_points to table accounts. Already exist?
Query:ALTER TABLE `accounts` ADD `create_date` INT(11) NOT NULL DEFAULT '0'SQLSTATE:42S21Driver code:1060Error message:Duplicate column name 'create_date'Could not add column create_date to table accounts. Already exist?
Query:ALTER TABLE `accounts` ADD `create_ip` INT(11) NOT NULL DEFAULT '0'SQLSTATE:42S21Driver code:1060Error message:Duplicate column name 'create_ip'Could not add column create_ip to table accounts. Already exist?
Query:ALTER TABLE `accounts` ADD `last_post` INT(11) NOT NULL DEFAULT '0'SQLSTATE:42S21Driver code:1060Error message:Duplicate column name 'last_post'Could not add column last_post to table accounts. Already exist?
Query:ALTER TABLE `accounts` ADD `flag` VARCHAR(80) NOT NULL DEFAULT ''SQLSTATE:42S21Driver code:1060Error message:Duplicate column name 'flag'Could not add column flag to table accounts. Already exist?
Query:ALTER TABLE `guilds` ADD `description` TEXT NOT NULL DEFAULT ''SQLSTATE:42S21Driver code:1060Error message:Duplicate column name 'description'Could not add column description to table guilds. Already exist?
Query:ALTER TABLE `guilds` ADD `guild_logo` MEDIUMBLOB NULL DEFAULT NULLSQLSTATE:42S21Driver code:1060Error message:Duplicate column name 'guild_logo'Query:ALTER TABLE `guilds` ADD `guild_logo` MEDIUMBLOB NOT NULL DEFAULT ''SQLSTATE:42S21Driver code:1060Error message:Duplicate column name 'guild_logo'Could not add column guild_logo to table guilds. Already exist?
Query:ALTER TABLE `guilds` ADD `create_ip` INT(11) NOT NULL DEFAULT '0'SQLSTATE:42S21Driver code:1060Error message:Duplicate column name 'create_ip'Could not add column create_ip to table guilds. Already exist?
Query:ALTER TABLE `guilds` ADD `balance` BIGINT UNSIGNED NOT NULL DEFAULT '0'SQLSTATE:42S21Driver code:1060Error message:Duplicate column name 'balance'Could not add column balance to table guilds. Already exist?
Query:ALTER TABLE `players` ADD `deleted` TINYINT(1) NOT NULL DEFAULT '0'SQLSTATE:42S21Driver code:1060Error message:Duplicate column name 'deleted'Could not add column deleted to table players. Already exist?
Query:ALTER TABLE `players` ADD `description` VARCHAR(255) NOT NULL DEFAULT ''SQLSTATE:42S21Driver code:1060Error message:Duplicate column name 'description'Could not add column description to table players. Already exist?
Query:ALTER TABLE `players` ADD `comment` TEXT NOT NULL DEFAULT ''SQLSTATE:42S21Driver code:1060Error message:Duplicate column name 'comment'Could not add column comment to table players. Already exist?
Query:ALTER TABLE `players` ADD `create_ip` INT(11) NOT NULL DEFAULT '0'SQLSTATE:42S21Driver code:1060Error message:Duplicate column name 'create_ip'Could not add column create_ip to table players. Already exist?
Query:ALTER TABLE `players` ADD `create_date` INT(11) NOT NULL DEFAULT '0'SQLSTATE:42S21Driver code:1060Error message:Duplicate column name 'create_date'Could not add column create_date to table players. Already exist?
Query:ALTER TABLE `players` ADD `hide_char` INT(11) NOT NULL DEFAULT '0'SQLSTATE:42S21Driver code:1060Error message:Duplicate column name 'hide_char'Could not add column hide_char to table players. Already exist?
Query:CREATE TABLE `z_ots_comunication` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL, `type` varchar(255) NOT NULL, `action` varchar(255) NOT NULL, `param1` varchar(255) NOT NULL, `param2` varchar(255) NOT NULL, `param3` varchar(255) NOT NULL, `param4` varchar(255) NOT NULL, `param5` varchar(255) NOT NULL, `param6` varchar(255) NOT NULL, `param7` varchar(255) NOT NULL, `delete_it` int(2) NOT NULL default '1', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;SQLSTATE:42S01Driver code:1050Error message:Table 'z_ots_comunication' already existsCould not create table z_ots_comunication. Already exist?
Query:CREATE TABLE `z_shop_offer` ( `id` int(11) NOT NULL auto_increment, `points` int(11) NOT NULL default '0', `itemid1` int(11) NOT NULL default '0', `count1` int(11) NOT NULL default '0', `itemid2` int(11) NOT NULL default '0', `count2` int(11) NOT NULL default '0', `offer_type` varchar(255) default NULL, `offer_description` text NOT NULL, `offer_name` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;SQLSTATE:42S01Driver code:1050Error message:Table 'z_shop_offer' already existsCould not create table z_shop_offer. Already exist?
Query:CREATE TABLE `z_shop_history_item` ( `id` int(11) NOT NULL auto_increment, `to_name` varchar(255) NOT NULL default '0', `to_account` int(11) NOT NULL default '0', `from_nick` varchar(255) NOT NULL, `from_account` int(11) NOT NULL default '0', `price` int(11) NOT NULL default '0', `offer_id` varchar(255) NOT NULL default '', `trans_state` varchar(255) NOT NULL, `trans_start` int(11) NOT NULL default '0', `trans_real` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;SQLSTATE:42S01Driver code:1050Error message:Table 'z_shop_history_item' already existsCould not create table z_shop_history_item. Already exist?
Query:CREATE TABLE `z_forum` ( `id` int(11) NOT NULL auto_increment, `first_post` int(11) NOT NULL default '0', `last_post` int(11) NOT NULL default '0', `section` int(3) NOT NULL default '0', `replies` int(20) NOT NULL default '0', `views` int(20) NOT NULL default '0', `author_aid` int(20) NOT NULL default '0', `author_guid` int(20) NOT NULL default '0', `post_text` text NOT NULL, `post_topic` varchar(255) NOT NULL, `post_smile` tinyint(1) NOT NULL default '0', `post_date` int(20) NOT NULL default '0', `last_edit_aid` int(20) NOT NULL default '0', `edit_date` int(20) NOT NULL default '0', `post_ip` varchar(15) NOT NULL default '0.0.0.0', PRIMARY KEY (`id`), KEY `section` (`section`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;SQLSTATE:42S01Driver code:1050Error message:Table 'z_forum' already existsCould not create table z_forum. Already exist?
Tables and columns added to database.
Go to STEP 4 - Add samples

o erro esta te informando que as tabelas e colunas ja existe portanto não precisa instalar o site novamente.

 

The Following Errors Have Occurred:

• Wrong characters configuration. Try again or contact with admin. ADMIN: Edit file config/config.php and set valid characters to copy names. Character to copy Knight Sample doesn't exist.

opa,

 

kara eu coloquei para rodar aqui, para ver como está essa versão deu um erro no " MySQL Error Message: Can't connect to MySQL server on '127.0.0.1" <10061) ERROR: failed to connect to database. No services running. the SERVER IS NOT ONLINE.

o que pode ser esse erro^?

tem que colocar o site online

Será que tem Como você postar a DB que vc usou o SITE pq aqui da ERRO no Gesior eo Znote Ngm ajuda Installar , Ajuda Ai PF

 

Agradeço desde já ,

 

Obrigado.

 

@Edit ~~

 

Eu Consegui Instalar (ZNOTE AAC) mas n abre as Paginas (Todas n abre), seria qual o problema ?

Tipo eu clicko nas Paginas Lá n da em Nada !

 

Ajuda Ai Por Favor.

Editado Dezembro 17, 2013 11 anos por caiiocess (veja o histórico de edições)