• 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 Error in consol

Simoria

Hola at me
Joined
May 3, 2012
Messages
447
Reaction score
10
Location
Sweden
Hello today when I restarted my server I got this errors .....


Code:
MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:06] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1007 AND `y` = 1014 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:06] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1007 AND `y` = 1015 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:06] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1006 AND `y` = 1012 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:06] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1006 AND `y` = 1013 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:06] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1006 AND `y` = 1014 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:06] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1007 AND `y` = 1012 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:06] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1007 AND `y` = 1013 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:06] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1007 AND `y` = 1014 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:06] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1008 AND `y` = 1009 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:06] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1008 AND `y` = 1010 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:06] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1008 AND `y` = 1011 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:06] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1009 AND `y` = 1009 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:06] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1009 AND `y` = 1010 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:06] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1009 AND `y` = 1011 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:07] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1010 AND `y` = 1009 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:07] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1010 AND `y` = 1010 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:07] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1010 AND `y` = 1011 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:07] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1011 AND `y` = 1009 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:07] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1011 AND `y` = 1010 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:07] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1011 AND `y` = 1011 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:07] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1008 AND `y` = 1008 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:07] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1008 AND `y` = 1009 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:07] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1008 AND `y` = 1010 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:07] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1008 AND `y` = 1011 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:07] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1009 AND `y` = 1009 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:07] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1009 AND `y` = 1010 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:07] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1009 AND `y` = 1011 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:07] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1010 AND `y` = 1009 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:07] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1010 AND `y` = 1010 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:08] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1010 AND `y` = 1011 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:08] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1008 AND `y` = 1012 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:08] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1008 AND `y` = 1013 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:08] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1008 AND `y` = 1014 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:08] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1008 AND `y` = 1015 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:08] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1009 AND `y` = 1012 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:08] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1009 AND `y` = 1013 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:08] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1009 AND `y` = 1014 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:08] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1009 AND `y` = 1015 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:08] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1010 AND `y` = 1012 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:08] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1010 AND `y` = 1013 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:08] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1010 AND `y` = 1014 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:08] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1010 AND `y` = 1015 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:08] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1011 AND `y` = 1012 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:08] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1011 AND `y` = 1013 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:08] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1011 AND `y` = 1014 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:09] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1011 AND `y` = 1015 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:09] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1008 AND `y` = 1012 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:09] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1008 AND `y` = 1013 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:09] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1008 AND `y` = 1014 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:09] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1009 AND `y` = 1012 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:09] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1009 AND `y` = 1013 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:09] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1009 AND `y` = 1014 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:09] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1010 AND `y` = 1012 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:09] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1010 AND `y` = 1013 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:09] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1010 AND `y` = 1014 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:09] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1011 AND `y` = 1012 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:09] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1011 AND `y` = 1013 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:09] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1011 AND `y` = 1014 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:09] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1012 AND `y` = 1012 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:09] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1012 AND `y` = 1013 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:10] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1012 AND `y` = 1014 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:10] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1012 AND `y` = 1015 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:10] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1013 AND `y` = 1012 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:10] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1013 AND `y` = 1013 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:10] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1013 AND `y` = 1014 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:10] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1013 AND `y` = 1015 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:10] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1014 AND `y` = 1012 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:10] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1014 AND `y` = 1013 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:10] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1014 AND `y` = 1014 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:10] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1014 AND `y` = 1015 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:10] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1015 AND `y` = 1012 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:10] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1015 AND `y` = 1013 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:10] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1015 AND `y` = 1014 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:10] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1015 AND `y` = 1015 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:10] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1012 AND `y` = 1012 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:11] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1012 AND `y` = 1013 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:11] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1012 AND `y` = 1014 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:11] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1013 AND `y` = 1012 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:11] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1013 AND `y` = 1013 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:11] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1013 AND `y` = 1014 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:11] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1014 AND `y` = 1012 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:11] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1014 AND `y` = 1013 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:11] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1014 AND `y` = 1014 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:11] mysql_real_query(): SELECT * FROM `tiles` WHERE `house_id` = 8 AND `world_id` = 0 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:11] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1011 AND `y` = 1002 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:11] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1011 AND `y` = 1003 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:11] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1012 AND `y` = 1001 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:11] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1012 AND `y` = 1002 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:11] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1012 AND `y` = 1003 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:11] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1013 AND `y` = 1001 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:12] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1013 AND `y` = 1002 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:12] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1013 AND `y` = 1003 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:12] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1014 AND `y` = 1001 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:12] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1014 AND `y` = 1002 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:12] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1014 AND `y` = 1003 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:12] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1015 AND `y` = 1001 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:12] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1015 AND `y` = 1002 AND `z` = 6 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'centeraot.tiles' doesn't exist (1146)
[17/05/2012 20:33:12] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 1015 AND `y` = 1003 AND `z` = 6 AND `world_id` = 0 LIMIT 1 -

wtf is this ?
 
>MYSQL ERROR
>query

SQL:
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;
 
CREATE TABLE `tile_items`
(
	`tile_id` INT UNSIGNED NOT NULL,
	`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
	`sid` INT NOT NULL,
	`pid` INT NOT NULL DEFAULT 0,
	`itemtype` INT NOT NULL,
	`count` INT NOT NULL DEFAULT 0,
	`attributes` BLOB NOT NULL,
	UNIQUE (`tile_id`, `world_id`, `sid`), KEY (`sid`),
	FOREIGN KEY (`tile_id`) REFERENCES `tiles`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;
 
>MYSQL ERROR
>query

SQL:
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;
 
CREATE TABLE `tile_items`
(
    `tile_id` INT UNSIGNED NOT NULL,
    `world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
    `sid` INT NOT NULL,
    `pid` INT NOT NULL DEFAULT 0,
    `itemtype` INT NOT NULL,
    `count` INT NOT NULL DEFAULT 0,
    `attributes` BLOB NOT NULL,
    UNIQUE (`tile_id`, `world_id`, `sid`), KEY (`sid`),
    FOREIGN KEY (`tile_id`) REFERENCES `tiles`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

Thanks for that. I had the same problem and this solved it.
 
Back
Top