• 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!

Solved help with TFS 0.4

Ramy Sedkey

Ramy Sedkey

New Member
Joined
Dec 7, 2013
Messages
78
Reaction score
2
I got this massage early today and this is the first time it happen
Code: 
[1:59:10.140] > Saving server...
[1:59:10.140] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 2
AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exist
(1146)
[1:59:10.140] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 3
AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exist
(1146)
[1:59:10.156] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 4
AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exist
(1146)
[1:59:10.156] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 5
AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exist
(1146)
[1:59:10.156] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 6
AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exist
(1146)
[1:59:10.156] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 7
AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exist
(1146)
[1:59:10.156] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 8
AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exist
(1146)
[1:59:10.156] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 9
AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exist
(1146)
[1:59:10.156] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 6
3 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exis
t (1146)
[1:59:10.171] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 8
6 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exis
t (1146)
[1:59:10.171] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 8
7 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exis
t (1146)
[1:59:10.171] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 8
8 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exis
t (1146)
[1:59:10.171] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 8
9 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exis
t (1146)
[1:59:10.171] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 9
0 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exis
t (1146)
[1:59:10.187] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 9
1 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exis
t (1146)
[1:59:10.187] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 9
2 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exis
t (1146)
[1:59:10.187] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 9
3 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exis
t (1146)
[1:59:10.187] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 9
4 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exis
t (1146)
[1:59:10.187] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 9
5 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exis
t (1146)
[1:59:10.203] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 9
6 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exis
t (1146)
[1:59:10.203] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 9
7 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exis
t (1146)
[1:59:10.203] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 9
8 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exis
t (1146)
[1:59:10.203] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
00 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.203] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
01 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.203] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
02 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.218] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
03 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.218] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
05 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.218] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
06 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.218] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
07 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.218] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
10 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.218] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
11 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.234] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
12 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.234] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
13 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.234] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
14 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.234] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
15 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.234] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
16 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.250] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
17 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.250] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
18 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.250] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
19 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.250] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
20 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.250] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
21 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.250] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
22 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.265] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
23 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.265] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
24 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.265] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
25 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.265] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
26 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.265] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
27 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.281] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
28 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.281] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
29 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.281] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
30 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.281] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
31 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.296] mysql_real_query(): DELETE FROM `tile_items` WHERE `world_id` = 0
- MYSQL ERROR: Table 'my server 2.tile_items' doesn't exist (1146)
[1:59:10.312] mysql_real_query(): DELETE FROM `tile_items` WHERE `world_id` = 0
- MYSQL ERROR: Table 'my server 2.tile_items' doesn't exist (1146)
[1:59:10.312] mysql_real_query(): DELETE FROM `tile_items` WHERE `world_id` = 0
- MYSQL ERROR: Table 'my server 2.tile_items' doesn't exist (1146)
 
Sort by date Sort by votes
Ramy Sedkey said:
I got this massage early today and this is the first time it happen
Code: 
[1:59:10.140] > Saving server...
[1:59:10.140] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 2
AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exist
(1146)
[1:59:10.140] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 3
AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exist
(1146)
[1:59:10.156] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 4
AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exist
(1146)
[1:59:10.156] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 5
AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exist
(1146)
[1:59:10.156] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 6
AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exist
(1146)
[1:59:10.156] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 7
AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exist
(1146)
[1:59:10.156] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 8
AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exist
(1146)
[1:59:10.156] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 9
AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exist
(1146)
[1:59:10.156] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 6
3 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exis
t (1146)
[1:59:10.171] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 8
6 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exis
t (1146)
[1:59:10.171] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 8
7 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exis
t (1146)
[1:59:10.171] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 8
8 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exis
t (1146)
[1:59:10.171] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 8
9 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exis
t (1146)
[1:59:10.171] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 9
0 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exis
t (1146)
[1:59:10.187] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 9
1 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exis
t (1146)
[1:59:10.187] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 9
2 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exis
t (1146)
[1:59:10.187] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 9
3 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exis
t (1146)
[1:59:10.187] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 9
4 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exis
t (1146)
[1:59:10.187] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 9
5 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exis
t (1146)
[1:59:10.203] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 9
6 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exis
t (1146)
[1:59:10.203] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 9
7 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exis
t (1146)
[1:59:10.203] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 9
8 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exis
t (1146)
[1:59:10.203] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
00 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.203] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
01 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.203] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
02 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.218] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
03 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.218] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
05 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.218] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
06 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.218] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
07 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.218] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
10 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.218] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
11 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.234] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
12 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.234] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
13 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.234] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
14 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.234] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
15 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.234] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
16 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.250] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
17 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.250] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
18 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.250] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
19 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.250] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
20 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.250] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
21 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.250] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
22 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.265] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
23 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.265] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
24 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.265] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
25 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.265] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
26 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.265] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
27 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.281] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
28 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.281] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
29 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.281] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
30 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.281] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
31 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
[1:59:10.296] mysql_real_query(): DELETE FROM `tile_items` WHERE `world_id` = 0
- MYSQL ERROR: Table 'my server 2.tile_items' doesn't exist (1146)
[1:59:10.312] mysql_real_query(): DELETE FROM `tile_items` WHERE `world_id` = 0
- MYSQL ERROR: Table 'my server 2.tile_items' doesn't exist (1146)
[1:59:10.312] mysql_real_query(): DELETE FROM `tile_items` WHERE `world_id` = 0
- MYSQL ERROR: Table 'my server 2.tile_items' doesn't exist (1146)
Click to expand...

that happened after I added the wedsite
 
Upvote 0 Downvote
Hmm try to delete this table
[1:59:10.281] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 1
31 AND `world_id` = 0 - MYSQL ERROR: Table 'my server 2.house_lists' doesn't exi
st (1146)
 
Upvote 0 Downvote
Code: 
CREATE TABLE `house_lists`
(
   `house_id` INT UNSIGNED NOT NULL,
   `world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
   `listid` INT NOT NULL,
   `list` TEXT NOT NULL,
   UNIQUE (`house_id`, `world_id`, `listid`),
   FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE
) ENGINE = InnoDB;
 
Upvote 0 Downvote
Code: 
CREATE TABLE `tiles`
(
   `id` INT UNSIGNED NOT NULL,
   `world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
   `house_id` INT UNSIGNED NOT NULL,
   `x` INT(5) UNSIGNED NOT NULL,
   `y` INT(5) UNSIGNED NOT NULL,
   `z` TINYINT(2) UNSIGNED NOT NULL,
   UNIQUE (`id`, `world_id`),
   KEY (`x`, `y`, `z`),
   FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE
) ENGINE = InnoDB;

You can also just import the schema from your server, it's in the folder schemas.
 
Upvote 0 Downvote

Similar threads

WikiArk21
  • Question
Error MySql
Replies
0
Views
237
WikiArk21
WikiArk21
F
  • Question
TFS 1.X+ [tfs 1.4/1.5] edit database multiworld system
Replies
3
Views
635
lursky
L
johnsamir
  • Question
how to solve these errors that has appeared in my database
Replies
2
Views
636
johnsamir
johnsamir
OTcreator
  • Question
TFS 0.X MySQL [2013] - guild ranks
Replies
1
Views
368
tobi132
T
H
  • Question
TFS 1.X+ SQL considered slow? 10-17ms range for tile_store
Replies
0
Views
163
henkas
H
Back
Top