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

MYSQL House Error.

Teddy

Teddy

SweStream.se
Joined
Oct 2, 2008
Messages
3,797
Reaction score
10
Location
Sweden 172
Hello guys i just installed :
http://otland.net/f82/2-0-database-...s-players-child-data-skills-items-etc-127320/

All works fine but i got one problem with houses?
Every server save this error come up and lagging the server down as hell.
Code: 
[12/11/2012 11:59:34] mysql_real_query(): INSERT INTO `house_lists` (`house_id`, `world_id`, `listid`, `list`) VALUES (1930, 0, 257, 'Haschpiiipa\nSir Kron') - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`tibiaduvbo`.`house_lists`, CONSTRAINT `house_lists_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE) (1452)
[12/11/2012 11:59:35] mysql_real_query(): INSERT INTO `tiles` (`id`, `world_id`, `house_id`, `x`, `y`, `z`) VALUES (237, 0, 1930, 1058, 991, 6) - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`tibiaduvbo`.`tiles`, CONSTRAINT `tiles_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE) (1452)
[12/11/2012 11:59:35] mysql_real_query(): INSERT INTO `tiles` (`id`, `world_id`, `house_id`, `x`, `y`, `z`) VALUES (237, 0, 1930, 1058, 991, 7) - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`tibiaduvbo`.`tiles`, CONSTRAINT `tiles_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE) (1452)
[12/11/2012 11:59:35] mysql_real_query(): INSERT INTO `tiles` (`id`, `world_id`, `house_id`, `x`, `y`, `z`) VALUES (237, 0, 1930, 1056, 995, 7) - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`tibiaduvbo`.`tiles`, CONSTRAINT `tiles_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE) (1452)
[12/11/2012 11:59:36] mysql_real_query(): INSERT INTO `tiles` (`id`, `world_id`, `house_id`, `x`, `y`, `z`) VALUES (237, 0, 1930, 1057, 993, 7) - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`tibiaduvbo`.`tiles`, CONSTRAINT `tiles_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE) (1452)
[12/11/2012 11:59:36] mysql_real_query(): INSERT INTO `tiles` (`id`, `world_id`, `house_id`, `x`, `y`, `z`) VALUES (237, 0, 1930, 1059, 992, 7) - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`tibiaduvbo`.`tiles`, CONSTRAINT `tiles_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE) (1452)
[12/11/2012 11:59:37] mysql_real_query(): INSERT INTO `tiles` (`id`, `world_id`, `house_id`, `x`, `y`, `z`) VALUES (237, 0, 1930, 1059, 995, 7) - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`tibiaduvbo`.`tiles`, CONSTRAINT `tiles_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE) (1452)
[12/11/2012 11:59:37] mysql_real_query(): INSERT INTO `tiles` (`id`, `world_id`, `house_id`, `x`, `y`, `z`) VALUES (237, 0, 1930, 1060, 992, 5) - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`tibiaduvbo`.`tiles`, CONSTRAINT `tiles_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE) (1452)
[12/11/2012 11:59:37] mysql_real_query(): INSERT INTO `tiles` (`id`, `world_id`, `house_id`, `x`, `y`, `z`) VALUES (237, 0, 1930, 1063, 993, 6) - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`tibiaduvbo`.`tiles`, CONSTRAINT `tiles_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE) (1452)
[12/11/2012 11:59:38] mysql_real_query(): INSERT INTO `tiles` (`id`, `world_id`, `house_id`, `x`, `y`, `z`) VALUES (237, 0, 1930, 1060, 994, 7) - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`tibiaduvbo`.`tiles`, CONSTRAINT `tiles_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE) (1452)
[12/11/2012 11:59:38] mysql_real_query(): INSERT INTO `tiles` (`id`, `world_id`, `house_id`, `x`, `y`, `z`) VALUES (237, 0, 1930, 1060, 995, 7) - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`tibiaduvbo`.`tiles`, CONSTRAINT `tiles_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE) (1452)
[12/11/2012 11:59:39] mysql_real_query(): INSERT INTO `tiles` (`id`, `world_id`, `house_id`, `x`, `y`, `z`) VALUES (237, 0, 1930, 1059, 996, 7) - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`tibiaduvbo`.`tiles`, CONSTRAINT `tiles_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE) (1452)
[12/11/2012 11:59:39] mysql_real_query(): INSERT INTO `tiles` (`id`, `world_id`, `house_id`, `x`, `y`, `z`) VALUES (237, 0, 1930, 1064, 997, 6) - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`tibiaduvbo`.`tiles`, CONSTRAINT `tiles_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE) (1452)
[12/11/2012 11:59:39] mysql_real_query(): INSERT INTO `tiles` (`id`, `world_id`, `house_id`, `x`, `y`, `z`) VALUES (237, 0, 1930, 1064, 997, 7) - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`tibiaduvbo`.`tiles`, CONSTRAINT `tiles_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE) (1452)
[12/11/2012 11:59:40] mysql_real_query(): INSERT INTO `tiles` (`id`, `world_id`, `house_id`, `x`, `y`, `z`) VALUES (237, 0, 1930, 1059, 1001, 7) - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`tibiaduvbo`.`tiles`, CONSTRAINT `tiles_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE) (1452)
[12/11/2012 11:59:40] mysql_real_query(): INSERT INTO `tiles` (`id`, `world_id`, `house_id`, `x`, `y`, `z`) VALUES (780, 0, 2046, 962, 1014, 5) - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`tibiaduvbo`.`tiles`, CONSTRAINT `tiles_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE) (1452)
[12/11/2012 11:59:41] mysql_real_query(): INSERT INTO `tiles` (`id`, `world_id`, `house_id`, `x`, `y`, `z`) VALUES (780, 0, 2046, 962, 1014, 6) - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`tibiaduvbo`.`tiles`, CONSTRAINT `tiles_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE) (1452)
[12/11/2012 11:59:41] mysql_real_query(): INSERT INTO `tiles` (`id`, `world_id`, `house_id`, `x`, `y`, `z`) VALUES (780, 0, 2046, 962, 1014, 7) - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`tibiaduvbo`.`tiles`, CONSTRAINT `tiles_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE) (1452)
[12/11/2012 11:59:42] mysql_real_query(): INSERT INTO `tiles` (`id`, `world_id`, `house_id`, `x`, `y`, `z`) VALUES (780, 0, 2046, 968, 1014, 6) - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`tibiaduvbo`.`tiles`, CONSTRAINT `tiles_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE) (1452)
[12/11/2012 11:59:42] mysql_real_query(): INSERT INTO `tiles` (`id`, `world_id`, `house_id`, `x`, `y`, `z`) VALUES (780, 0, 2046, 968, 1014, 7) - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`tibiaduvbo`.`tiles`, CONSTRAINT `tiles_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE) (1452)
[12/11/2012 11:59:43] mysql_real_query(): INSERT INTO `tiles` (`id`, `world_id`, `house_id`, `x`, `y`, `z`) VALUES (780, 0, 2046, 963, 1017, 6) - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`tibiaduvbo`.`tiles`, CONSTRAINT `tiles_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE) (1452)
[12/11/2012 11:59:43] mysql_real_query(): INSERT INTO `tiles` (`id`, `world_id`, `house_id`, `x`, `y`, `z`) VALUES (780, 0, 2046, 964, 1017, 5) - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`tibiaduvbo`.`tiles`, CONSTRAINT `tiles_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE) (1452)
[12/11/2012 11:59:43] mysql_real_query(): INSERT INTO `tiles` (`id`, `world_id`, `house_id`, `x`, `y`, `z`) VALUES (780, 0, 2046, 964, 1017, 7) - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`tibiaduvbo`.`tiles`, CONSTRAINT `tiles_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE) (1452)
[12/11/2012 11:59:44] mysql_real_query(): INSERT INTO `tiles` (`id`, `world_id`, `house_id`, `x`, `y`, `z`) VALUES (780, 0, 2046, 968, 1018, 6) - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`tibiaduvbo`.`tiles`, CONSTRAINT `tiles_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE) (1452)
[12/11/2012 11:59:44] mysql_real_query(): INSERT INTO `tiles` (`id`, `world_id`, `house_id`, `x`, `y`, `z`) VALUES (780, 0, 2046, 968, 1016, 7) - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`tibiaduvbo`.`tiles`, CONSTRAINT `tiles_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE) (1452)
[12/11/2012 11:59:45] mysql_real_query(): INSERT INTO `tiles` (`id`, `world_id`, `house_id`, `x`, `y`, `z`) VALUES (780, 0, 2046, 968, 1017, 7) - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`tibiaduvbo`.`tiles`, CONSTRAINT `tiles_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE) (1452)
[12/11/2012 11:59:45] mysql_real_query(): INSERT INTO `tiles` (`id`, `world_id`, `house_id`, `x`, `y`, `z`) VALUES (780, 0, 2046, 968, 1018, 7) - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`tibiaduvbo`.`tiles`, CONSTRAINT `tiles_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE) (1452)
[12/11/2012 11:59:46] mysql_real_query(): INSERT INTO `tiles` (`id`, `world_id`, `house_id`, `x`, `y`, `z`) VALUES (780, 0, 2046, 969, 1016, 7) - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`tibiaduvbo`.`tiles`, CONSTRAINT `tiles_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE) (1452)
[12/11/2012 11:59:46] mysql_real_query(): INSERT INTO `tiles` (`id`, `world_id`, `house_id`, `x`, `y`, `z`) VALUES (780, 0, 2046, 969, 1017, 7) - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`tibiaduvbo`.`tiles`, CONSTRAINT `tiles_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE) (1452)
[12/11/2012 11:59:46] mysql_real_query(): INSERT INTO `tiles` (`id`, `world_id`, `house_id`, `x`, `y`, `z`) VALUES (780, 0, 2046, 971, 1017, 7) - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`tibiaduvbo`.`tiles`, CONSTRAINT `tiles_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE) (1452)
[12/11/2012 11:59:47] mysql_real_query(): INSERT INTO `tiles` (`id`, `world_id`, `house_id`, `x`, `y`, `z`) VALUES (780, 0, 2046, 970, 1021, 6) - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`tibiaduvbo`.`tiles`, CONSTRAINT `tiles_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE) (1452)

- - - Updated - - -

Cant someone plz help , need fast help with this
 
Sort by date Sort by votes
When you go into rme get the coordinates for the houses and then make sure that the house is identified in the map editor and that should fix it.
 
Upvote 0 Downvote

Similar threads

WikiArk21
  • Question
Error MySql
Replies
0
Views
213
WikiArk21
WikiArk21
F
  • Question
TFS 1.X+ [tfs 1.4/1.5] edit database multiworld system
Replies
3
Views
589
lursky
L
H
  • Question
TFS 1.X+ SQL considered slow? 10-17ms range for tile_store
Replies
0
Views
145
henkas
H
Back
Top