Alguem poderia me ajudar criar essa tabela no MYSQL??

 

mysql_real_query(): DELETE FROM real_castle WHERE world_id = '0' - MYSQL ERROR: Unknown column 'world_id' in 'where clause' (1054)
mysql_real_query(): INSERT INTO real_castle (guild_name, guild_id, tomorrow, world_id) VALUES ('Test Guild', '8', '25/10/2022', '0') - MYSQL ERROR: Unknown column 'guild_name' in 'field list' (1054)

 

3 horas atrás, vitinhoo96 disse:

Alguem poderia me ajudar criar essa tabela no MYSQL??

 

mysql_real_query(): DELETE FROM real_castle WHERE world_id = '0' - MYSQL ERROR: Unknown column 'world_id' in 'where clause' (1054)
mysql_real_query(): INSERT INTO real_castle (guild_name, guild_id, tomorrow, world_id) VALUES ('Test Guild', '8', '25/10/2022', '0') - MYSQL ERROR: Unknown column 'guild_name' in 'field list' (1054)

 

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=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=230 ;

se nao der tenta ese

 

ALTER TABLE `z_ots_comunication` ADD `type` varchar(255)

19 horas atrás, mullino disse:

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=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=230 ;

se nao der tenta ese

 

ALTER TABLE `z_ots_comunication` ADD `type` varchar(255)

continua o mesmo erro, assim que a guild domina o castle e da a hora de fechar aparece esse erro

 

mysql_real_query(): UPDATE `guilds` SET  `real_castle` = REPLACE(`real_castle`, 1, 0); - MYSQL ERROR: Unknown column 'real_castle' in 'field list' (1054)
mysql_real_query(): UPDATE `guilds` SET `real_castle` = 1 WHERE `id` = '8'; - MYSQL ERROR: Unknown column 'real_castle' in 'field list' (1054)
mysql_real_query(): DELETE FROM real_castle WHERE world_id = '0' - MYSQL ERROR: Unknown column 'world_id' in 'where clause' (1054)
mysql_real_query(): INSERT INTO real_castle (guild_name, guild_id, tomorrow, world_id) VALUES ('gcjmhvb', '8', '26/10/2022', '0') - MYSQL ERROR: Unknown column 'guild_name' in 'field list' (1054)

Editado Outubro 25, 2022 2 anos por vitinhoo96 (veja o histórico de edições)

27 minutos atrás, vitinhoo96 disse:

continua o mesmo erro, assim que a guild domina o castle e da a hora de fechar aparece esse erro

 

mysql_real_query(): UPDATE `guilds` SET  `real_castle` = REPLACE(`real_castle`, 1, 0); - MYSQL ERROR: Unknown column 'real_castle' in 'field list' (1054)
mysql_real_query(): UPDATE `guilds` SET `real_castle` = 1 WHERE `id` = '8'; - MYSQL ERROR: Unknown column 'real_castle' in 'field list' (1054)
mysql_real_query(): DELETE FROM real_castle WHERE world_id = '0' - MYSQL ERROR: Unknown column 'world_id' in 'where clause' (1054)
mysql_real_query(): INSERT INTO real_castle (guild_name, guild_id, tomorrow, world_id) VALUES ('gcjmhvb', '8', '26/10/2022', '0') - MYSQL ERROR: Unknown column 'guild_name' in 'field list' (1054)

ALTER TABLE guild ADD checkdata INT(11)

Ou

ALTER TABLE guilds ADD checkdata INT(11)

 

1 minuto atrás, mullino disse:

ALTER TABLE guild ADD checkdata INT(11)

Ou

ALTER TABLE guilds ADD checkdata INT(11)

 

#1060 - Duplicate column name 'checkdata'

 

 

e no console o erro

 

mysql_real_query(): DELETE FROM real_castle WHERE world_id = '0' - MYSQL ERROR: Unknown column 'world_id' in 'where clause' (1054)
mysql_real_query(): INSERT INTO real_castle (guild_name, guild_id, tomorrow, world_id) VALUES ('gcjmhvb', '8', '26/10/2022', '0') - MYSQL ERROR: Unknown column 'guild_name' in 'field list' (1054)

Editado Outubro 25, 2022 2 anos por vitinhoo96 (veja o histórico de edições)