Ir para conteúdo

Posts Recomendados

aye, eu mais uma vez aki xD aew galera aki no meu server ta dando esse erro:

 

 

mysql_real_query(): SELECT `id`, `account_id`, `group_id`, `world_i

d`, `sex`, `vocation`, `experience`, `level`, `maglevel`, `health`, `healthmax`,

`blessings`, `pvp_blessing`, `mana`, `manamax`, `manaspent`, `soul`, `lookbody`

, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `lookmount`, `po

sx`, `posy`, `posz`, `cap`, `lastlogin`, `lastlogout`, `lastip`, `conditions`, `

skull`, `skulltime`, `guildnick`, `rank_id`, `town_id`, `balance`, `stamina`, `d

irection`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_containers`, `lo

ss_items`, `marriage`, `promotion`, `description` FROM `players` WHERE `name` =

'Account Manager' AND `world_id` = 0 AND `deleted` = 0 LIMIT 1 - MYSQL ERROR: Un

known column 'lookmount' in 'field list' (1054)

 

Desde ja agradecido pela ajuda de vós.

Link para o comentário
https://xtibia.com/forum/topic/190712-your-character-could-not-be-loaded/
Compartilhar em outros sites

roda isso na sua DB pra ve se funciona

 

ALTER TABLE players ADD lookmount int(11) NOT NULL DEFAULT '0'

 

dps isso

 

CREATE TABLE IF NOT EXISTS `accounts` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `name` varchar(32) NOT NULL DEFAULT '',
 `password` varchar(255) NOT NULL,
 `salt` varchar(40) NOT NULL DEFAULT '',
 `premdays` int(11) NOT NULL DEFAULT '0',
 `lastday` int(10) unsigned NOT NULL DEFAULT '0',
 `email` varchar(255) NOT NULL DEFAULT '',
 `key` varchar(20) NOT NULL DEFAULT '0',
 `blocked` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'internal usage',
 `warnings` int(11) NOT NULL DEFAULT '0',
 `group_id` int(11) NOT NULL DEFAULT '1',
 `viptime` int(15) NOT NULL DEFAULT '0',
 `page_lastday` int(11) NOT NULL,
 `email_new` varchar(255) NOT NULL,
 `email_new_time` int(15) NOT NULL,
 `created` int(11) NOT NULL DEFAULT '0',
 `rlname` varchar(255) NOT NULL DEFAULT '',
 `location` varchar(255) NOT NULL DEFAULT '',
 `page_access` int(11) NOT NULL DEFAULT '0',
 `email_code` varchar(255) NOT NULL DEFAULT '0',
 `next_email` int(11) NOT NULL DEFAULT '0',
 `premium_points` int(11) NOT NULL DEFAULT '0',
 `vote` int(11) NOT NULL,
 `last_post` int(11) NOT NULL DEFAULT '0',
 `flag` varchar(255) NOT NULL,
 `vip_time` int(11) NOT NULL,
 PRIMARY KEY (`id`),
 UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6741028 ;

Link para o comentário
https://xtibia.com/forum/topic/190712-your-character-could-not-be-loaded/#findComment-1303537
Compartilhar em outros sites

×
×
  • Criar Novo...