Yeah, that's what seems to be happening. What do you think is causing it to do that? Here's the output of the command, let me know if this is what you wanted to see. Also I changed the database name to sqlDatabase and changed the email a bit for security reasons.
Foreign key constraint fails for tablesqlDatabase.posts:
,
CONSTRAINTposts_user_id_foreignFOREIGN KEY (user_id) REFERENCESusers(id) ON DELETE SET NULL
Trying to add in child table, in indexposts_user_id_created_at_index` tuple:
DATA TUPLE: 3 fields;
0: len 4; hex 00000000; asc ;;
1: len 5; hex 998da778aa; asc x ;;
2: len 4; hex 00000101; asc ;;
But in parent table sqlDatabase.users, in index PRIMARY,
the closest match we can find is record:
PHYSICAL RECORD: n_fields 18; compact format; info bits 0
0: len 4; hex 00000001; asc ;;
1: len 6; hex 00000834719c; asc 4q ;;
2: len 7; hex 4c000001ba0dd8; asc L ;;
3: len 7; hex 456d6f74696f6e; asc Emotion;;
4: len 23; hex 61646d696e40656d6f74696f6e666f72756d732e636f6d; asc [MYEMAIL]@emotionforums.com;;
5: len 1; hex 81; asc ;;
6: len 30; hex 243279243130244e544f6267595a71596b66594b2f3265336d39366f2e6b; asc $2y$10$NTObgYZqYkfYK/2e3m96o.k; (total 60 bytes);
7: SQL NULL;
8: len 12; hex 6176617461725f312e6a7067; asc avatar_1.jpg;;
9: SQL NULL;
10: len 5; hex 998d7b5ba1; asc {[ ;;
11: len 5; hex 99a59e3afa; asc : ;;
12: SQL NULL;
13: SQL NULL;
14: len 4; hex 0000002d; asc -;;
15: len 4; hex 00000110; asc ;;
16: SQL NULL;
17: SQL NULL;
`
