i have fixed this....
apparently this application is trying to add multiple records of the same record to the join table
and since there are multiple entries to student id and phone id in the jointable this is what is causing the problem. How to fix this?
1. remove all foreign keys on the join table
2. alter the join table
3. remove the primary key
4. add a new primary key with auto increment
5. save the table
6. run the project and now it runs properly without any errors and it inserts perfectly into the tables
I love this place!
Never trust an airline that limits their passengers to one carry on iguana. Put this tiny ad in your shoe: