I'm sure that this is going to be a problem with the nut behind the keyboard. I'm having a specific insert record problem, stating that a FK Constraint is violated. Here is a screen capture of a few commands to show the problem.
mysql> select * from player where playerID = 12464;
+----------+--------------+-------------+--------+-------+-------+----------+--------+----------------+---------
| playerID | playerStatus | handle | prefix | fName | mName | lName | suffix | longName | address
+----------+--------------+-------------+--------+-------+-------+----------+--------+----------------+---------
| 12464 | P | pdga#-13087 | | Bruce | | Brakel | | Bruce Brakel |
+----------+--------------+-------------+--------+-------+-------+----------+--------+----------------+---------
1 row in set (0.00 sec)
mysql> select * from club where clubID = 1;
+--------+-----------+------------------------------------+---------------------------+-----------+-------------
| clubID | shortName | longName | url | contactID | customTable
+--------+-----------+------------------------------------+---------------------------+-----------+-------------
| 1 | PDGA | Professional Disc Golf Association |
http://www.badcodisc.com/ | 1 |
+--------+-----------+------------------------------------+---------------------------+-----------+-------------
1 row in set (0.00 sec)
mysql> INSERT INTO affiliation (playerID, clubID, memberID, status) VALUES (1, 12464, '13087', 'Y');
ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`discweb/affiliation`, CONSTRAINT `Affiliation_Club_FK` FOREIGN KEY (`clubID`) REFERENCES `club` (`clubID`) ON DELETE CASCADE)
mysql>