Normal Alguem me pode ajudar com isso??

[Jose Garces 0]

sqlite3_prepare_v2(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
sqlite3_prepare_v2(): SQLITE ERROR: no such table: z_ots_guildcomunication (SELECT * FROM z_ots_guildcomunication WHERE "type" = 'login';)

 

 

 

[Rakan 0]

Execute este comando na DB e veja se da mesmo erro:

DROP TABLE IF EXISTS `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 ;

[Jose Garces 0]

Como posso executar comando na DB, me pode ajudar x.x?

[Rakan 0]

Abra o SQLStudio e execute este comando:

DROP TABLE IF EXISTS z_ots_comunication;
CREATE TABLE z_ots_comunication ( 
    id        INT( 11 )       NOT NULL,
    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 ) 
);

 

[Jose Garces 0]

Mais como posso executar oq tenho oq fazer!!

[Rakan 0]

Qual e o mapa que ta dando esse erro

[Jose Garces 0]

map tipo baiakinho mais ele roda em linux eu fiz oq ele rode em windows mais ele ta dando issos bugs e tmb nao deixa logar account manager

[Rakan 0]

Desculpe pelo erro de ortografia. kkk

Da para entender.

[Jose Garces 0]

em ele second comando oq vc posto saiu isso 0 row(s) affected in 0.243211 second(s).

em ele primeiro saiu syntax error

Agr me pode ajudar com isso??   NAO DEIXA ENTRAR ACC MANAGER NEM FAZER CONTA

 

 

Account Manager has logged in.
Account Manager has logged out.

[Error - CreatureScript Interface]
data/creaturescripts/scripts/army.lua:onLogin
Description:
(LuaInterface::luaRegisterCreatureEvent) Creature not found

[Error - CreatureScript Interface]
data/creaturescripts/scripts/army.lua:onLogin
Description:
(LuaInterface::luaRegisterCreatureEvent) Creature not found

[Error - CreatureScript Interface]
data/creaturescripts/scripts/army.lua:onLogin
Description:
(LuaInterface::luaGetCreatureStorage) Creature not found

[Error - CreatureScript Interface]
data/creaturescripts/scripts/army.lua:onLogin
Description:
(LuaInterface::luaGetCreatureStorage) Creature not found

[Error - CreatureScript Interface]
In a timer event called from:
data/creaturescripts/scripts/otlist.lua:onLogin
Description:
(LuaInterface::internalGetPlayerInfo) Player not found when requesting player info #29