• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Windows Help : MYSQL - table doesnt exist ~ REP++ to helper

jo31_99

Senior Member
Joined
Jul 23, 2011
Messages
56
Reaction score
1
Location
Sweden
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 131 AND `world_id` = 0 - MYSQL ERROR: Table 'swev.house_lists' doesn't exist (1146)




It comes from house 1 to house 131

- - - Updated - - -

Omfg !!!
Emergency !!
Help !!!

- - - Updated - - -

Bump
 
Last edited:
Exewcute this.

PHP:
-- ----------------------------
-- Table structure for `house_lists`
-- ----------------------------
DROP TABLE IF EXISTS `house_lists`;
CREATE TABLE `house_lists` (
  `house_id` int(10) unsigned NOT NULL,
  `world_id` tinyint(4) unsigned NOT NULL DEFAULT '0',
  `listid` int(11) NOT NULL,
  `list` text NOT NULL,
  UNIQUE KEY `house_id` (`house_id`,`world_id`,`listid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of house_lists
-- ----------------------------

On Mysql Admin.
 
Back
Top