everything works

Really? Then what are you asking? If the insert is the issue, write a small self contained script that demonstrates the issue with the insert.

Actually, there are two possibilities, either the insert is failing or you are failing to validate that the insert succeeded. We can't tell anything about either of those options based on the information we have so far.