Infelizmente grande parte dos meus erros não estão aí D: saudades do arquivo schemas/mysql.sql, obrigado se puder ajudar.

Ps.:Note que os primeiros são ao executar a pasta data e após a mensagem ">>> Alissow Server Online!" é quando tento logar algum char.

Ótimo tutorial, vai ajudar muita gente, reputado!

Bom, este tutorial não resolve qualquer erro na database como diz o título, mas é um ótimo tutorial e deve ter dado um trabalhinho para fazer-lo.

Kkk, eh levou um tempinho e por hora realmente n resolve QUALQUER erro n, mas estou atualizando para que ele atenda o q promete.

@Beyond Sky, vou procurar aqui os códigos pra resolver seu problema e implementar mais o tutorial.

Editado Junho 3, 2014 10 anos por danihcv (veja o histórico de edições)

Opa, galerinha do TK, pro meu primeiro tutorial resolvi fazer uma solução de um problema que desde que cheguei no TK, vejo que ocorre com uma certa frequência. Os erros da data base.

 

Neste tutorial vou ensinar a resolver os erros do tipo No such table, Insert into, No such column, ... has no column named... etc.

 

1°) NO SUCH TABLE

 

Bom, para o erro No such table, basta vc visualizar qual table está faltando. Para isso basta ler o erro na distro:

 

No caso da imagem, está faltando a table: player_statements

Para resolver este e qualquer outro problema deste tipo, caso sua data base seja sqlite,

basta abrir sua data base pelo Sqlite Studio(download: http://sqlitestudio.pl/?act=download) e clicar em Open SQL query editor:

 

Mas caso sua data base seja Mysql abra pelo phpMyadmin, ou por outro editor de sua preferencia.

 

1.1°) EXECUTANDO OS COMANDOS PARA RESOLVER O PROBLEMA

  Bom, dependendo da table que estiver faltando, vc irá colocar seu respectivo comando, segue abaixo TODOS os comandos básicos necessários para que sua data base fique Ok! :   (VC VAI PEGAR O COMANDO REFERENTE À TABLE QUE VC QUER!!!)

 

 

 

account_viplist

CREATE TABLE account_viplist ( 
    account_id  INTEGER         NOT NULL,
    world_id    INTEGER         NOT NULL
                                DEFAULT '0',
    player_id   INTEGER         NOT NULL,
    description VARCHAR( 128 )  NOT NULL
                                DEFAULT '''',
    icon        INTEGER         NOT NULL
                                DEFAULT '0',
    notify      BOOLEAN         NOT NULL
                                DEFAULT '''',
    UNIQUE ( account_id, player_id ),
    FOREIGN KEY ( account_id ) REFERENCES accounts ( id ),
    FOREIGN KEY ( player_id ) REFERENCES players ( id ) 
);

 

accounts

CREATE TABLE accounts ( 
    id       INTEGER         PRIMARY KEY
                             NOT NULL,
    name     VARCHAR( 255 )  NOT NULL,
    password VARCHAR( 255 )  NOT NULL,
    salt     VARCHAR( 40 )   NOT NULL
                             DEFAULT '''',
    premdays INTEGER         NOT NULL
                             DEFAULT '0',
    lastday  INTEGER         NOT NULL
                             DEFAULT '0',
    email    VARCHAR( 255 )  NOT NULL
                             DEFAULT '''',
    [key]    VARCHAR( 32 )   NOT NULL
                             DEFAULT '0',
    blocked  BOOLEAN         NOT NULL
                             DEFAULT 'FALSE',
    warnings INTEGER         NOT NULL
                             DEFAULT '0',
    group_id INTEGER         NOT NULL
                             DEFAULT '1',
    UNIQUE ( name ) 
);

 

bans

CREATE TABLE bans ( 
    id          INTEGER         PRIMARY KEY
                                NOT NULL,
    type        INTEGER         NOT NULL,
    value       INTEGER         NOT NULL,
    param       INTEGER         NOT NULL
                                DEFAULT '4294967295',
    active      BOOLEAN         NOT NULL
                                DEFAULT 'TRUE',
    expires     INTEGER         NOT NULL,
    added       INTEGER         NOT NULL,
    admin_id    INTEGER         NOT NULL
                                DEFAULT '0',
    comment     TEXT            NOT NULL,
    reason      INTEGER         NOT NULL
                                DEFAULT '0',
    [action]    INTEGER         NOT NULL
                                DEFAULT '0',
    [statement] VARCHAR( 255 )  NOT NULL
                                DEFAULT '''' 
);

 

environment_killers

CREATE TABLE environment_killers ( 
    kill_id INTEGER         NOT NULL,
    name    VARCHAR( 255 )  NOT NULL,
    FOREIGN KEY ( kill_id ) REFERENCES killers ( id ) 
);

 

global_storage

CREATE TABLE global_storage ( 
    [key]    VARCHAR( 32 )   NOT NULL,
    world_id INTEGER         NOT NULL
                             DEFAULT '0',
    value    VARCHAR( 255 )  NOT NULL
                             DEFAULT '0',
    UNIQUE ( [key], world_id ) 
);

 

 

guild_invites

CREATE TABLE guild_invites ( 
    player_id INTEGER NOT NULL,
    guild_id  INTEGER NOT NULL,
    UNIQUE ( player_id, guild_id ),
    FOREIGN KEY ( player_id ) REFERENCES players ( id ),
    FOREIGN KEY ( guild_id ) REFERENCES guilds ( id ) 
);

 

guild_kills

CREATE TABLE guild_kills ( 
    id       INT PRIMARY KEY
                 NOT NULL,
    guild_id INT NOT NULL,
    war_id   INT NOT NULL,
    death_id INT NOT NULL 
);

 

guild_ranks

CREATE TABLE guild_ranks ( 
    id       INTEGER         PRIMARY KEY,
    guild_id INTEGER         NOT NULL,
    name     VARCHAR( 255 )  NOT NULL,
    level    INTEGER         NOT NULL,
    FOREIGN KEY ( guild_id ) REFERENCES guilds ( id ) 
);

 

guild_wars

CREATE TABLE guild_wars ( 
    id          INTEGER       NOT NULL,
    guild_id    INT           NOT NULL,
    enemy_id    INT           NOT NULL,
    [begin]     BIGINT        NOT NULL
                              DEFAULT '0',
    [end]       BIGINT        NOT NULL
                              DEFAULT '0',
    frags       INT           NOT NULL
                              DEFAULT '0',
    payment     BIGINT        NOT NULL
                              DEFAULT '0',
    guild_kills INT           NOT NULL
                              DEFAULT '0',
    enemy_kills INT           NOT NULL
                              DEFAULT '0',
    status      TINYINT( 1 )  NOT NULL
                              DEFAULT '0',
    PRIMARY KEY ( id ),
    FOREIGN KEY ( guild_id ) REFERENCES guilds ( id ),
    FOREIGN KEY ( enemy_id ) REFERENCES guilds ( id ) 
);

 

guilds

CREATE TABLE guilds ( 
    id           INTEGER         PRIMARY KEY,
    world_id     INTEGER         NOT NULL
                                 DEFAULT '0',
    name         VARCHAR( 255 )  NOT NULL,
    ownerid      INTEGER         NOT NULL,
    creationdata INTEGER         NOT NULL,
    checkdata    INTEGER         NOT NULL,
    motd         VARCHAR( 255 )  NOT NULL
                                 DEFAULT '''',
    balance      BIGINT          NOT NULL
                                 DEFAULT '0',
    UNIQUE ( name, world_id ),
    FOREIGN KEY ( ownerid ) REFERENCES players ( id ) 
);

 

house_auctions

CREATE TABLE house_auctions ( 
    house_id  INTEGER NOT NULL,
    world_id  INTEGER NOT NULL
                      DEFAULT '0',
    player_id INTEGER NOT NULL,
    bid       INTEGER NOT NULL
                      DEFAULT '0',
    [limit]   INTEGER NOT NULL
                      DEFAULT '0',
    endtime   INTEGER NOT NULL
                      DEFAULT '0',
    UNIQUE ( house_id, world_id ),
    FOREIGN KEY ( house_id, world_id ) REFERENCES houses ( id, world_id ),
    FOREIGN KEY ( player_id ) REFERENCES players ( id ) 
);

 

house_data

~CREATE TABLE house_data ( 
    house_id INTEGER  NOT NULL,
    world_id INTEGER  NOT NULL
                      DEFAULT '0',
    data     LONGBLOB NOT NULL,
    UNIQUE ( house_id, world_id ),
    FOREIGN KEY ( house_id, world_id ) REFERENCES houses ( id, world_id ) 
);

 

house_lists

CREATE TABLE house_lists ( 
    house_id INTEGER NOT NULL,
    world_id INTEGER NOT NULL
                     DEFAULT '0',
    listid   INTEGER NOT NULL,
    list     TEXT    NOT NULL,
    UNIQUE ( house_id, world_id, listid ),
    FOREIGN KEY ( house_id, world_id ) REFERENCES houses ( id, world_id ) 
);

 

houses

CREATE TABLE houses ( 
    id          INTEGER         NOT NULL,
    world_id    INTEGER         NOT NULL
                                DEFAULT '0',
    owner       INTEGER         NOT NULL,
    paid        INTEGER         NOT NULL
                                DEFAULT '0',
    warnings    INTEGER         NOT NULL
                                DEFAULT '0',
    lastwarning INTEGER         NOT NULL
                                DEFAULT '0',
    name        VARCHAR( 255 )  NOT NULL,
    town        INTEGER         NOT NULL
                                DEFAULT '0',
    size        INTEGER         NOT NULL
                                DEFAULT '0',
    price       INTEGER         NOT NULL
                                DEFAULT '0',
    rent        INTEGER         NOT NULL
                                DEFAULT '0',
    doors       INTEGER         NOT NULL
                                DEFAULT '0',
    beds        INTEGER         NOT NULL
                                DEFAULT '0',
    tiles       INTEGER         NOT NULL
                                DEFAULT '0',
    guild       BOOLEAN         NOT NULL
                                DEFAULT 'FALSE',
    clear       BOOLEAN         NOT NULL
                                DEFAULT 'FALSE',
    UNIQUE ( id, world_id ) 
);

 

killers

CREATE TABLE killers ( 
    id          INTEGER PRIMARY KEY,
    death_id    INTEGER NOT NULL,
    final_hit   BOOLEAN NOT NULL
                        DEFAULT 'FALSE',
    unjustified BOOLEAN NOT NULL
                        DEFAULT 'FALSE',
    war         BIGINT  NOT NULL
                        DEFAULT '0',
    FOREIGN KEY ( death_id ) REFERENCES player_deaths ( id ) 
);

 

market_history

CREATE TABLE market_history ( 
    id         INTEGER          PRIMARY KEY
                                NOT NULL,
    player_id  INTEGER          NOT NULL,
    sale       BOOLEAN          NOT NULL
                                DEFAULT '0',
    itemtype   UNSIGNED INTEGER NOT NULL,
    amount     UNSIGNED INTEGER NOT NULL,
    price      UNSIGNED INTEGER NOT NULL
                                DEFAULT '0',
    expires_at UNSIGNED INTEGER NOT NULL,
    inserted   UNSIGNED INTEGER NOT NULL,
    state      UNSIGNED INTEGER NOT NULL,
    world_id   TINYINT( 4 )     NOT NULL
                                DEFAULT ( 0 ),
    FOREIGN KEY ( player_id ) REFERENCES players ( id ) ON DELETE CASCADE 
);

 

market_offers

CREATE TABLE market_offers ( 
    id        INTEGER          PRIMARY KEY
                               NOT NULL,
    player_id INTEGER          NOT NULL,
    sale      BOOLEAN          NOT NULL
                               DEFAULT '0',
    itemtype  UNSIGNED INTEGER NOT NULL,
    amount    UNSIGNED INTEGER NOT NULL,
    created   UNSIGNED INTEGER NOT NULL,
    anonymous BOOLEAN          NOT NULL
                               DEFAULT '0',
    price     UNSIGNED INTEGER NOT NULL
                               DEFAULT '0',
    world_id  TINYINT( 4 )     NOT NULL
                               DEFAULT ( 0 ),
    FOREIGN KEY ( player_id ) REFERENCES players ( id ) ON DELETE CASCADE 
);

 

player_deaths

CREATE TABLE player_deaths ( 
    id        INTEGER PRIMARY KEY,
    player_id INTEGER NOT NULL,
    date      INTEGER NOT NULL,
    level     INTEGER NOT NULL,
    FOREIGN KEY ( player_id ) REFERENCES players ( id ) 
);

 

player_depotitems

CREATE TABLE player_depotitems ( 
    player_id  INTEGER NOT NULL,
    sid        INTEGER NOT NULL,
    pid        INTEGER NOT NULL
                       DEFAULT '0',
    itemtype   INTEGER NOT NULL,
    count      INTEGER NOT NULL
                       DEFAULT '0',
    attributes BLOB    NOT NULL,
    UNIQUE ( player_id, sid ),
    FOREIGN KEY ( player_id ) REFERENCES players ( id ) 
);

 

player_inboxitems

CREATE TABLE player_inboxitems ( 
    player_id  INT( 11 )      NOT NULL,
    sid        INT( 11 )      NOT NULL,
    pid        INT( 11 )      NOT NULL
                              DEFAULT ( 0 ),
    itemtype   SMALLINT( 6 )  NOT NULL,
    count      SMALLINT( 5 )  NOT NULL
                              DEFAULT ( 0 ),
    attributes BLOB           NOT NULL 
);

 

player_items

CREATE TABLE player_items ( 
    player_id  INT  NOT NULL,
    sid        INT  NOT NULL,
    pid        INT  NOT NULL
                    DEFAULT '0',
    itemtype   INT  NOT NULL,
    count      INT  NOT NULL
                    DEFAULT '0',
    attributes BLOB NOT NULL,
    UNIQUE ( player_id, sid ),
    FOREIGN KEY ( player_id ) REFERENCES players ( id ) 
);

 

player_killers

CREATE TABLE player_killers ( 
    kill_id   INTEGER NOT NULL,
    player_id INTEGER NOT NULL,
    FOREIGN KEY ( kill_id ) REFERENCES killers ( id ),
    FOREIGN KEY ( player_id ) REFERENCES players ( id ) 
);

 

player_namelocks

CREATE TABLE player_namelocks ( 
    player_id INTEGER         NOT NULL,
    name      VARCHAR( 255 )  NOT NULL,
    new_name  VARCHAR( 255 )  NOT NULL,
    date      INTEGER         NOT NULL
                              DEFAULT '0',
    FOREIGN KEY ( player_id ) REFERENCES players ( id ) 
);

 

player_skills

CREATE TABLE player_skills ( 
    player_id INTEGER NOT NULL,
    skillid   INTEGER NOT NULL,
    value     INTEGER NOT NULL
                      DEFAULT '0',
    count     INTEGER NOT NULL
                      DEFAULT '0',
    UNIQUE ( player_id, skillid ),
    FOREIGN KEY ( player_id ) REFERENCES players ( id ) 
);

 

player_spells

CREATE TABLE player_spells ( 
    player_id INTEGER         NOT NULL,
    name      VARCHAR( 255 )  NOT NULL,
    UNIQUE ( player_id, name ),
    FOREIGN KEY ( player_id ) REFERENCES players ( id ) 
);

 

player_statements

CREATE TABLE player_statements ( 
    id         INTEGER         PRIMARY KEY,
    player_id  INTEGER         NOT NULL,
    channel_id INTEGER         NOT NULL
                               DEFAULT '0',
    text       VARCHAR( 255 )  NOT NULL,
    date       INTEGER         NOT NULL
                               DEFAULT '0',
    FOREIGN KEY ( player_id ) REFERENCES players ( id ) 
);

 

player_storage

CREATE TABLE player_storage ( 
    player_id INTEGER         NOT NULL,
    [key]     VARCHAR( 32 )   NOT NULL,
    value     VARCHAR( 255 )  NOT NULL
                              DEFAULT '0',
    UNIQUE ( player_id, [key] ),
    FOREIGN KEY ( player_id ) REFERENCES players ( id ) 
);

 

player_viplist

CREATE TABLE player_viplist ( 
    player_id   INTEGER         NOT NULL,
    vip_id      INTEGER         NOT NULL,
    description VARCHAR( 128 )  NOT NULL
                                DEFAULT '''',
    icon        INTEGER         NOT NULL
                                DEFAULT '0',
    notify      BOOLEAN         NOT NULL
                                DEFAULT '''',
    UNIQUE ( player_id, vip_id ),
    FOREIGN KEY ( player_id ) REFERENCES players ( id ),
    FOREIGN KEY ( vip_id ) REFERENCES players ( id ) 
);

 

players

CREATE TABLE players ( 
    id                    INTEGER           PRIMARY KEY
                                            NOT NULL,
    name                  VARCHAR( 255 )    NOT NULL,
    world_id              INTEGER           NOT NULL
                                            DEFAULT '0',
    group_id              INTEGER           NOT NULL,
    account_id            INTEGER           NOT NULL,
    level                 INTEGER           NOT NULL
                                            DEFAULT '1',
    vocation              INTEGER           NOT NULL
                                            DEFAULT '0',
    health                INTEGER           NOT NULL
                                            DEFAULT '100',
    healthmax             INTEGER           NOT NULL
                                            DEFAULT '100',
    experience            INTEGER           NOT NULL
                                            DEFAULT '0',
    lookbody              INTEGER           NOT NULL
                                            DEFAULT '10',
    lookfeet              INTEGER           NOT NULL
                                            DEFAULT '10',
    lookhead              INTEGER           NOT NULL
                                            DEFAULT '10',
    looklegs              INTEGER           NOT NULL
                                            DEFAULT '10',
    looktype              INTEGER           NOT NULL
                                            DEFAULT '136',
    lookaddons            INTEGER           NOT NULL
                                            DEFAULT '0',
    lookmount             INTEGER           NOT NULL
                                            DEFAULT '0',
    maglevel              INTEGER           NOT NULL
                                            DEFAULT '0',
    mana                  INTEGER           NOT NULL
                                            DEFAULT '100',
    manamax               INTEGER           NOT NULL
                                            DEFAULT '100',
    manaspent             INTEGER           NOT NULL
                                            DEFAULT '0',
    soul                  INTEGER           NOT NULL
                                            DEFAULT '0',
    town_id               INTEGER           NOT NULL,
    posx                  INTEGER           NOT NULL
                                            DEFAULT '0',
    posy                  INTEGER           NOT NULL
                                            DEFAULT '0',
    posz                  INTEGER           NOT NULL
                                            DEFAULT '0',
    conditions            BLOB              NOT NULL,
    cap                   INTEGER           NOT NULL
                                            DEFAULT '0',
    sex                   INTEGER           NOT NULL
                                            DEFAULT '0',
    lastlogin             INTEGER           NOT NULL
                                            DEFAULT '0',
    lastip                INTEGER           NOT NULL
                                            DEFAULT '0',
    save                  BOOLEAN           NOT NULL
                                            DEFAULT 'TRUE',
    skull                 INTEGER           NOT NULL
                                            DEFAULT '0',
    skulltime             INTEGER           NOT NULL
                                            DEFAULT '0',
    rank_id               INTEGER           NOT NULL,
    guildnick             VARCHAR( 255 )    NOT NULL
                                            DEFAULT '''',
    lastlogout            INTEGER           NOT NULL
                                            DEFAULT '0',
    blessings             INTEGER           NOT NULL
                                            DEFAULT '0',
    pvp_blessing          BOOLEAN           NOT NULL
                                            DEFAULT 'FALSE',
    balance               INTEGER           NOT NULL
                                            DEFAULT '0',
    stamina               INTEGER           NOT NULL
                                            DEFAULT '151200000',
    direction             INTEGER           NOT NULL
                                            DEFAULT '2',
    loss_experience       INTEGER           NOT NULL
                                            DEFAULT '100',
    loss_mana             INTEGER           NOT NULL
                                            DEFAULT '100',
    loss_skills           INTEGER           NOT NULL
                                            DEFAULT '100',
    loss_containers       INTEGER           NOT NULL
                                            DEFAULT '100',
    loss_items            INTEGER           NOT NULL
                                            DEFAULT '100',
    premend               INTEGER           NOT NULL
                                            DEFAULT '0',
    online                INTEGER           NOT NULL
                                            DEFAULT '0',
    marriage              INTEGER           NOT NULL
                                            DEFAULT '0',
    promotion             INTEGER           NOT NULL
                                            DEFAULT '0',
    deleted               INTEGER           NOT NULL
                                            DEFAULT '0',
    description           VARCHAR( 255 )    NOT NULL
                                            DEFAULT '''',
    offlinetraining_time  SMALLINT UNSIGNED NOT NULL
                                            DEFAULT '43200',
    offlinetraining_skill INT               NOT NULL
                                            DEFAULT '-1',
    ip                    VARCHAR( 17 )     NOT NULL
                                            DEFAULT '0',
    UNIQUE ( name, deleted ),
    FOREIGN KEY ( account_id ) REFERENCES accounts ( id ) 
);

 

server_config

CREATE TABLE server_config ( 
    config VARCHAR( 35 )   NOT NULL
                           DEFAULT '''',
    value  VARCHAR( 255 )  NOT NULL
                           DEFAULT '''',
    UNIQUE ( config ) 
);

 

server_motd

CREATE TABLE server_motd ( 
    id       INTEGER NOT NULL,
    world_id INTEGER NOT NULL
                     DEFAULT '0',
    text     TEXT    NOT NULL
                     DEFAULT '''',
    UNIQUE ( id, world_id ) 
);

 

server_record

CREATE TABLE server_record ( 
    record    INTEGER NOT NULL,
    world_id  INTEGER NOT NULL
                      DEFAULT '0',
    timestamp INTEGER NOT NULL,
    UNIQUE ( record, world_id, timestamp ) 
);

 

server_reports

CREATE TABLE server_reports ( 
    id        INTEGER PRIMARY KEY,
    world_id  INTEGER NOT NULL
                      DEFAULT '0',
    player_id INTEGER NOT NULL
                      DEFAULT '0',
    posx      INTEGER NOT NULL
                      DEFAULT '0',
    posy      INTEGER NOT NULL
                      DEFAULT '0',
    posz      INTEGER NOT NULL
                      DEFAULT '0',
    timestamp INTEGER NOT NULL
                      DEFAULT '0',
    report    TEXT    NOT NULL
                      DEFAULT '''',
    reads     INTEGER NOT NULL
                      DEFAULT '0' 
);

 

tile_items

CREATE TABLE tile_items ( 
    tile_id    INTEGER NOT NULL,
    world_id   INTEGER NOT NULL
                       DEFAULT '0',
    sid        INTEGER NOT NULL,
    pid        INTEGER NOT NULL
                       DEFAULT '0',
    itemtype   INTEGER NOT NULL,
    count      INTEGER NOT NULL
                       DEFAULT '0',
    attributes BLOB    NOT NULL,
    UNIQUE ( tile_id, world_id, sid ),
    FOREIGN KEY ( tile_id ) REFERENCES tiles ( id ) 
);

 

tile_store

CREATE TABLE tile_store ( 
    house_id INTEGER  NOT NULL,
    world_id INTEGER  NOT NULL
                      DEFAULT '0',
    data     LONGBLOB NOT NULL,
    FOREIGN KEY ( house_id ) REFERENCES houses ( id ) 
);

 

tiles

CREATE TABLE tiles ( 
    id       INTEGER NOT NULL,
    world_id INTEGER NOT NULL
                     DEFAULT '0',
    house_id INTEGER NOT NULL,
    x        INTEGER NOT NULL,
    y        INTEGER NOT NULL,
    z        INTEGER NOT NULL,
    UNIQUE ( id, world_id ),
    FOREIGN KEY ( house_id, world_id ) REFERENCES houses ( id, world_id ) 
);

 

Para mysql:

 

 

announcements

CREATE TABLE IF NOT EXISTS `announcements` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) NOT NULL,
  `text` varchar(255) NOT NULL,
  `date` varchar(20) NOT NULL,
  `author` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 

pagsegurotransacoes

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,
  `NumItens` int(11) NOT NULL,
  `Data` datetime NOT NULL,
  `ProdQuantidade_x` int(5) NOT NULL,
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0',
  UNIQUE KEY `TransacaoID` (`TransacaoID`,`StatusTransacao`),
  KEY `Referencia` (`Referencia`),
  KEY `status` (`status`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

player_advances

CREATE TABLE IF NOT EXISTS `player_advances` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cid` int(11) DEFAULT NULL,
  `skill` int(11) DEFAULT NULL,
  `oldlevel` int(11) DEFAULT NULL,
  `newlevel` int(11) DEFAULT NULL,
  `time` int(11) DEFAULT NULL,
  UNIQUE KEY `id` (`id`),
  KEY `cid` (`cid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3337 ;

 

reports

CREATE TABLE IF NOT EXISTS `reports` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `world_id` tinyint(4) unsigned NOT NULL DEFAULT '0',
  `player_id` int(11) NOT NULL DEFAULT '1',
  `posx` int(11) NOT NULL DEFAULT '32369',
  `posy` int(11) NOT NULL DEFAULT '32241',
  `posz` int(11) NOT NULL DEFAULT '7',
  `timestamp` bigint(20) NOT NULL DEFAULT '0',
  `report` text NOT NULL,
  `reads` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `world_id` (`world_id`),
  KEY `reads` (`reads`),
  KEY `player_id` (`player_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 

thanks

CREATE TABLE IF NOT EXISTS `thanks` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `account_id` varchar(30) NOT NULL,
  `forum_id` text NOT NULL,
  `player_name` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 

z_bug_logs

CREATE TABLE IF NOT EXISTS `z_bug_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account_id` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `description` text NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 

z_featured_article

CREATE TABLE IF NOT EXISTS `z_featured_article` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) NOT NULL,
  `text` varchar(255) NOT NULL,
  `date` varchar(30) NOT NULL,
  `author` varchar(50) NOT NULL,
  `read_more` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 

z_forum

CREATE TABLE IF NOT EXISTS `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',
  `icon_id` tinyint(4) NOT NULL DEFAULT '1',
  `post_icon_id` tinyint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `section` (`section`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

 

z_helpdesk

 

CREATE TABLE IF NOT EXISTS `z_helpdesk` (
  `account` varchar(255) NOT NULL,
  `type` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `text` text NOT NULL,
  `id` int(11) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `priority` int(11) NOT NULL,
  `reply` int(11) NOT NULL,
  `who` int(11) NOT NULL,
  `uid` int(11) NOT NULL AUTO_INCREMENT,
  `tag` int(11) NOT NULL,
  `registered` int(11) NOT NULL,
  PRIMARY KEY (`uid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=26 ;

 

z_monsters

CREATE TABLE IF NOT EXISTS `z_monsters` (
  `hide_creature` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL,
  `mana` int(11) NOT NULL,
  `exp` int(11) NOT NULL,
  `health` int(11) NOT NULL,
  `speed_lvl` int(11) NOT NULL DEFAULT '1',
  `use_haste` tinyint(1) NOT NULL,
  `voices` text NOT NULL,
  `immunities` varchar(255) NOT NULL,
  `summonable` tinyint(1) NOT NULL,
  `convinceable` tinyint(1) NOT NULL,
  `race` varchar(255) NOT NULL,
  `loot` text NOT NULL,
  `gfx_name` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

z_network_box

CREATE TABLE IF NOT EXISTS `z_network_box` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `network_name` varchar(10) NOT NULL,
  `network_link` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 

z_news_tickers

CREATE TABLE IF NOT EXISTS `z_news_tickers` (
  `date` int(11) NOT NULL DEFAULT '1',
  `author` int(11) NOT NULL,
  `image_id` int(3) NOT NULL DEFAULT '0',
  `text` text NOT NULL,
  `hide_ticker` tinyint(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

z_ots_comunication

CREATE TABLE IF NOT EXISTS `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 AUTO_INCREMENT=1 ;

 

z_polls

CREATE TABLE IF NOT EXISTS `z_polls` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `question` varchar(255) NOT NULL,
  `end` int(11) NOT NULL,
  `start` int(11) NOT NULL,
  `answers` int(11) NOT NULL,
  `votes_all` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 

z_polls_answers

CREATE TABLE IF NOT EXISTS `z_polls_answers` (
  `poll_id` int(11) NOT NULL,
  `answer_id` int(11) NOT NULL,
  `answer` varchar(255) NOT NULL,
  `votes` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

z_shop_history_item

CREATE TABLE IF NOT EXISTS `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 AUTO_INCREMENT=1 ;

 

z_shop_history_pacc

CREATE TABLE IF NOT EXISTS `z_shop_history_pacc` (
  `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',
  `pacc_days` int(11) NOT NULL DEFAULT '0',
  `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=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 

z_shop_offer

CREATE TABLE IF NOT EXISTS `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 AUTO_INCREMENT=1 ;

 

z_spells

CREATE TABLE IF NOT EXISTS `z_spells` (
  `name` varchar(255) NOT NULL,
  `spell` varchar(255) NOT NULL,
  `spell_type` varchar(255) NOT NULL,
  `mana` int(11) NOT NULL DEFAULT '0',
  `lvl` int(11) NOT NULL DEFAULT '0',
  `mlvl` int(11) NOT NULL DEFAULT '0',
  `soul` int(11) NOT NULL DEFAULT '0',
  `pacc` varchar(255) NOT NULL,
  `vocations` varchar(255) NOT NULL,
  `conj_count` int(11) NOT NULL DEFAULT '0',
  `hide_spell` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

 

z_news_big

CREATE TABLE IF NOT EXISTS `z_news_big` 
(
`hide_news` tinyint(1) NOT NULL DEFAULT '0',
`date` int(11) NOT NULL DEFAULT '0',
`author` varchar(255) NOT NULL,
`author_id` int(11) NOT NULL,
`image_id` int(3) NOT NULL DEFAULT '0',
`topic` varchar(255) NOT NULL,
`text` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

 

2°) No such column /  "NOME DA TABLE" has no column named "NOME DA COLUMN QUE FALTA" / Insert into

  Bom, para resolver esse problema vc deve identificar em qual TABLE está essa coluna que falta. Para isso, basta ler o erro como na imagem:

 

No caso da imagem, está faltando a column WORLD_ID dentro da table MARKET_OFFERS. Para resolver, vc deve executar excluir a sua table MARKET_OFFERS existante em sua data base, e em seguida, executar o domando da da market_offers, encontrado acima, logicamente isso só se aplica ao caso da imagem, depende do seu caso, vc deve excutar o comando da table que estiver sendo referida no erro. Mas antes de executá-lo vc deve excluir a sua table EXISTENTE, para então executar o comando.

 

ESTA FORMA DE RESOLUÇÃO SE APLICA AOS TRÊS CASOS: NO SUCH COLUMN, ...HAS NO COLUMN NAMED... e INSERT INTO.

 

 

 

Bom galera, é isso.

 

SE ENCONTRAREM, OU SE DEPARAREM COM ALGUM ERRO, BASTA ME PEDIR AJUDA QUE EU DAREI TOTAL SUPORTE PARA VOCÊS!

 

SE ESTIVR FALTANDO MAIS ALGUMA TABLE QUE EU NÃO COLOQUEI AQUI, PF ME INFORMEM E EU ATUALIZAREI O TÓPICO!!!

 

 

Lembrem-se, se eu te ajudei, por favor, deem REP++ pois foi meio trabolhoso fazer este tutorial todo...

 

ESTOU A DISPOSIÇÃO DE TODOS! Tanto por PM quanto por SKYPE, e até mesmo por aqui, pois vou checar este tópico regularmente!!

 

 

Espero ter ajudado!!

Abraços.

gostei ajudo muito  

+ rep !