[GeorgeS]

I exported the schema with drop tables before inserts so you can get an exact copy
cavedude_schema.zip
Since you report the program reported all 30 spawngroups -were linked ok, it most likely must mean an index problem - as in auto-increment is on.
My program looks at the last index then adds 1. Everything created after that uses this index reference, till it's done.
If this method does not work, then a last index method needs to be called each time it tries to write data.

If it still fails using this exact schema, then I think I will have to rewrite the way I query and write indices.

you can quickly check if this works -

SELECT max(id)+1 as nextrecord FROM spawngroup

use the number from the previous query into the next one - replace the 51963-51965 with the your value, and increment+1

INSERT INTO spawngroup (id,name) VALUES (51963,"TEST1200");
INSERT INTO spawngroup (id,name) VALUES (51964,"TEST1201");
INSERT INTO spawngroup (id,name) VALUES (51965,"TEST1202");

if it works, then the problem is something else

Thanks for helping,
George