• 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] Weird Error?

GOD Wille

Excellent OT User
Joined
Jan 11, 2010
Messages
2,826
Solutions
2
Reaction score
815
Location
Sweden
PHP:
 REFERENCES `newuser`.`players` (`id`) ON DELETE CASCADE) (1452)
[13:17:28.109] mysql_real_query(): INSERT INTO `player_items` (`player_id`, `pid`, `sid`, `itemtype`, `count`, `attributes`) VALUES (14563, 1, 101, 8820, 1, ''),(14563, 2, 102, 2173, 1, '�\0\0charges\0\0\0'),(14563, 3, 103, 1988, 1, ''),(14563, 4, 104, 8819, 1, ''),(14563, 5, 105, 2175, 1, ''),(14563, 6, 106, 2190, 1, ''),(14563, 7, 107, 2648, 1, ''),(14563, 8, 108, 2643, 1, ''),(14563, 103, 109, 2160, 5, '') - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`trollbasen`.`player_items`, CONSTRAINT `player_items_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `newuser`.`players` (`id`) ON DELETE CASCADE) (1452)
[13:17:28.115] Error while saving player: Willee.

I get this error when i log out from the server ;S
 
Still that error even though i drop my items on the floor and relog i get new items + the items on floor is there.
 
If there is no player in database `newuser` (table `players`) with `id` same as `player_id` in table `player_items` in database `trollbasen`, it shows error.
 
Back
Top