Database tables problemas

[leohcr7 1]

Ola, meus problemas sao na table players_item e players_depot_items ai esta o erro, caso alguem possa me ajudar:

mysql_real_query(): INSERT INTO `player_items` (`player_id`, `pid`, `sid`, `itemtype`, `count`, `attributes`, `m_uid`) VALUES (35, 1, 101, 2457, 1, '', 0),(35, 3, 102, 9774, 1, '', 0),(35, 4, 103, 2463, 1, '', 0),(35, 5, 104, 2525, 1, '', 0),(35, 7, 105, 2647, 1, '', 0),(35, 8, 106, 2643, 1, '', 0),(35, 102, 107, 2152, 50, '2', 0),(35, 102, 108, 2789, 100, 'd', 0),(35, 102, 109, 2554, 1, '', 0),(35, 102, 110, 2120, 1, '', 0) - MYSQL ERROR: Unknown column 'm_uid' in 'field list' (1054)

[4:49:13.411] mysql_real_query(): INSERT INTO `player_items` (`player_id`, `pid`, `sid`, `itemtype`, `count`, `attributes`, `m_uid`) VALUES (35, 1, 101, 2457, 1, '', 0),(35, 3, 102, 9774, 1, '', 0),(35, 4, 103, 2463, 1, '', 0),(35, 5, 104, 2525, 1, '', 0),(35, 7, 105, 2647, 1, '', 0),(35, 8, 106, 2643, 1, '', 0),(35, 102, 107, 2152, 50, '2', 0),(35, 102, 108, 2789, 100, 'd', 0),(35, 102, 109, 2554, 1, '', 0),(35, 102, 110, 2120, 1, '', 0) - MYSQL ERROR: Unknown column 'm_uid' in 'field list' (1054)

[4:49:13.412] mysql_real_query(): INSERT INTO `player_items` (`player_id`, `pid`, `sid`, `itemtype`, `count`, `attributes`, `m_uid`) VALUES (35, 1, 101, 2457, 1, '', 0),(35, 3, 102, 9774, 1, '', 0),(35, 4, 103, 2463, 1, '', 0),(35, 5, 104, 2525, 1, '', 0),(35, 7, 105, 2647, 1, '', 0),(35, 8, 106, 2643, 1, '', 0),(35, 102, 107, 2152, 50, '2', 0),(35, 102, 108, 2789, 100, 'd', 0),(35, 102, 109, 2554, 1, '', 0),(35, 102, 110, 2120, 1, '', 0) - MYSQL ERROR: Unknown column 'm_uid' in 'field list' (1054)

Error while saving player: Liujin.

[4:49:14.632] mysql_real_query(): SELECT `pid`, `sid`, `itemtype`, `count`, `attributes`, `m_uid` FROM `player_items` WHERE `player_id` = 35 ORDER BY `sid` DESC - MYSQL ERROR: Unknown column 'm_uid' in 'field list' (1054)

[4:49:14.632] mysql_real_query(): SELECT `pid`, `sid`, `itemtype`, `count`, `attributes`, `m_uid` FROM `player_depotitems` WHERE `player_id` = 35 ORDER BY `sid` DESC - MYSQL ERROR: Unknown column 'm_uid' in 'field list' (1054)

caso ajude, minha player_items table e essa:

CREATE TABLE IF NOT EXISTS `player_items` (

  `player_id` int(11) NOT NULL DEFAULT '0',

  `pid` int(11) NOT NULL DEFAULT '0',

  `sid` int(11) NOT NULL DEFAULT '0',

  `itemtype` int(11) NOT NULL DEFAULT '0',

  `count` int(11) NOT NULL DEFAULT '0',

  `attributes` blob NOT NULL,

  UNIQUE KEY `player_id_2` (`player_id`,`sid`),

  KEY `player_id` (`player_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--

-- Dumping data for table `player_items`

--


INSERT INTO `player_items` (`player_id`, `pid`, `sid`, `itemtype`, `count`, `attributes`) VALUES

(3, 1, 101, 2457, 1, '0'),

(3, 3, 102, 1988, 1, '0'),

(3, 4, 103, 2463, 1, '0'),

(3, 5, 104, 2525, 1, '0'),

(3, 6, 105, 2190, 1, '0'),

(3, 7, 106, 2647, 1, '0'),

(3, 8, 107, 3982, 1, '0'),

(3, 10, 108, 2789, 20, 0x0f14),

(3, 102, 109, 2120, 1, '0'),

(3, 102, 110, 5710, 1, '0'),

(3, 102, 111, 2152, 50, 0x0f32),

(4, 1, 101, 2457, 1, '0'),

(4, 3, 102, 1988, 1, '0'),

(4, 4, 103, 2463, 1, '0'),

(4, 5, 104, 2525, 1, '0'),

(4, 6, 105, 2182, 1, '0'),

(4, 7, 106, 2647, 1, '0'),

(4, 8, 107, 3982, 1, '0'),

(4, 10, 108, 2789, 20, 0x0f14),

(4, 102, 109, 2120, 1, '0'),

(4, 102, 110, 5710, 1, '0'),

(4, 102, 111, 2152, 50, 0x0f32),

(5, 1, 101, 2457, 1, '0'),

(5, 3, 102, 1988, 1, '0'),

(5, 4, 103, 2463, 1, '0'),

(5, 5, 104, 2525, 1, '0'),

(5, 6, 105, 2389, 1, 0x0f01),

(5, 7, 106, 2647, 1, '0'),

(5, 8, 107, 3982, 1, '0'),

(5, 10, 108, 2789, 20, 0x0f14),

(5, 102, 109, 2120, 1, '0'),

(5, 102, 110, 5710, 1, '0'),

(5, 102, 111, 2152, 50, 0x0f32),

(6, 1, 101, 2457, 1, '0'),

(6, 3, 102, 1988, 1, '0'),

(6, 4, 103, 2463, 1, '0'),

(6, 5, 104, 2428, 1, '0'),

(6, 6, 105, 2525, 1, '0'),

(6, 7, 106, 2647, 1, '0'),

(6, 8, 107, 3982, 1, '0'),

(6, 10, 108, 2789, 20, 0x0f14),

(6, 102, 109, 2152, 50, 0x0f32),

(6, 102, 110, 2120, 1, '0'),

(6, 102, 111, 5710, 1, '0'),

(6, 102, 112, 2417, 1, '0'),

(6, 102, 113, 2383, 1, '0'),

(7, 3, 101, 1988, 1, 0x8001000b006465736372697074696f6e012100000065737365206974656d20666f692063726961646f2070656c6f205465737465722e),

(7, 4, 102, 2487, 1, '0'),

(7, 5, 103, 2160, 100, 0x0f64),

(7, 6, 104, 8930, 1, '0'),

(7, 8, 105, 2640, 1, 0x80020008006465636179696e67020100000008006475726174696f6e020027b500),

(7, 10, 106, 2519, 1, '0'),

(7, 101, 107, 2492, 1, '0'),

(7, 101, 108, 2148, 80, 0x0f50),

(7, 101, 109, 2152, 99, 0x0f63),

(7, 101, 110, 2160, 28, 0x0f1c),

(7, 101, 111, 2365, 1, '0'),

(7, 101, 112, 5803, 1, '0'),

(7, 101, 113, 6132, 1, '0'),

(7, 101, 114, 5791, 1, '0'),

(7, 101, 115, 2361, 1, '0'),

(7, 101, 116, 2358, 1, '0'),

(7, 101, 117, 2273, 82, 0x0f52),

(7, 101, 118, 2120, 1, 0x8001000b006465736372697074696f6e012100000065737365206974656d20666f692063726961646f2070656c6f205465737465722e),

(7, 101, 119, 2160, 100, 0x0f64),

(8, 1, 101, 2457, 1, '0'),

(8, 3, 102, 1988, 1, '0'),

(8, 4, 103, 2463, 1, '0'),

(8, 5, 104, 2525, 1, '0'),

(8, 6, 105, 2182, 1, '0'),

(8, 7, 106, 2647, 1, '0'),

(8, 8, 107, 3982, 1, '0'),

(8, 10, 108, 2789, 20, 0x0f14),

(8, 102, 109, 2643, 1, '0'),

(8, 102, 110, 2120, 1, '0'),

(8, 102, 111, 5710, 1, '0'),

(8, 102, 112, 2152, 50, 0x0f32);

Editado Julho 10, 2012 por leohcr7
Adicionando informacoes (veja o histórico de edições)

[Puncker 201]

Execute isto no seu banco de dados e verifique se o erro persiste:

ALTER TABLE player_items ADD m_uid int NOT NULL DEFAULT '0';

ALTER TABLE player_depotitems ADD m_uid int NOT NULL DEFAULT '0';

Editado Julho 10, 2012 por Puncker (veja o histórico de edições)

[leohcr7 1]

Parabens meu amigo, tudo parece ok agora. REP+