Reply to thread

Message

<blockquote data-quote="NotoriousJameson" data-source="post: 404514" data-attributes="member: 65480">(Warning: if you already have rooms made with floor plan editor, this will delete any black screened rooms and I've been searching for ages for this answer.)So for some of you who use *****'s PlusEMU and get this error on emulator, open up your database,Copy the whole code below[CODE]-- Table structure for `room_models`-- ----------------------------DROP TABLE IF EXISTS `room_models`;CREATE TABLE `room_models` (&nbsp; `id` varchar(100) NOT NULL,&nbsp; `door_x` int(11) NOT NULL,&nbsp; `door_y` int(11) NOT NULL,&nbsp; `door_z` double NOT NULL,&nbsp; `door_dir` int(4) NOT NULL DEFAULT '2',&nbsp; `heightmap` text NOT NULL,&nbsp; `public_items` VARCHAR(50) NOT NULL DEFAULT '0',&nbsp; `club_only` enum('0','1') NOT NULL DEFAULT '0',&nbsp; `poolmap` varchar(100) NOT NULL DEFAULT '',&nbsp; `custom` enum('0','1') NOT NULL DEFAULT '0',&nbsp; `wall_height` int(11) NOT NULL DEFAULT '-1',&nbsp; PRIMARY KEY (`id`),&nbsp; UNIQUE KEY `id` (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;[/CODE]After you paste this in, take room_models from your original SQL file and paste it in(in short, do not copy above from your database.sql FILE, this WILL mess it up again, only do the actual values.Open up HeidiSQL(For MariaDB users), login with your root/password, open up your database, and open up room_models, then click on Tab: room_models, basic and change TEXT on public_items to VARCHAR and then put 0 as the default.Bottom below and code is for fresh starters using another method, if you are using xampp/phpmyadmin, same applies, copy code, do a query(Save as a db.sql file then upload into database).Remember, this will overwrite your current room_models, if you are fresh starting and a noob and couldn't find this, hope this helps anybody else with the problem!Warning: You will have to manually remove your rooms from the database itself, they cannot be used and/or fixed. Any editing before doing the above will not fix the rooms already saved with floor plan but will make sure they work next time upon creation.</blockquote>

[QUOTE="NotoriousJameson, post: 404514, member: 65480"] (Warning: if you already have rooms made with floor plan editor, this will delete any black screened rooms and I've been searching for ages for this answer.)So for some of you who use *****'s PlusEMU and get this error on emulator, open up your database, Copy the whole code below [CODE]-- Table structure for `room_models` -- ---------------------------- DROP TABLE IF EXISTS `room_models`; CREATE TABLE `room_models` ( `id` varchar(100) NOT NULL, `door_x` int(11) NOT NULL, `door_y` int(11) NOT NULL, `door_z` double NOT NULL, `door_dir` int(4) NOT NULL DEFAULT '2', `heightmap` text NOT NULL, `public_items` VARCHAR(50) NOT NULL DEFAULT '0', `club_only` enum('0','1') NOT NULL DEFAULT '0', `poolmap` varchar(100) NOT NULL DEFAULT '', `custom` enum('0','1') NOT NULL DEFAULT '0', `wall_height` int(11) NOT NULL DEFAULT '-1', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;[/CODE] After you paste this in, take room_models from your original SQL file and paste it in(in short, do not copy above from your database.sql FILE, this WILL mess it up again, only do the actual values. Open up HeidiSQL(For MariaDB users), login with your root/password, open up your database, and open up room_models, then click on Tab: room_models, basic and change TEXT on public_items to VARCHAR and then put 0 as the default. Bottom below and code is for fresh starters using another method, if you are using xampp/phpmyadmin, same applies, copy code, do a query(Save as a db.sql file then upload into database). Remember, this will overwrite your current room_models, if you are fresh starting and a noob and couldn't find this, hope this helps anybody else with the problem! Warning: You will have to manually remove your rooms from the database itself, they cannot be used and/or fixed. Any editing before doing the above will not fix the rooms already saved with floor plan but will make sure they work next time upon creation. [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members