Ok, yes, the table was missing. I had to use your second Create Table because the key was too big (I’m limited to 1000 bytes).
Now, let’s see if the practical use of it fixes the problem.
Update: Nope. Nothing is going into the new table. Not to mention that you don’t have a Foreign key linking these two together, only Primary Keys. (Or perhaps that’s a quirk of MySQL? I learned Oracle 10g SQL and PL/SQL, so I’m only loosely familiar with MySQL.)
At any rate, I tried both updating an existing group and creating a new one and no new data. But then, if you’re trying to link them by object_id, they are now out of sync anyway. Your object_id in the main table is automatically incrementing, so it can’t be matched to the object_id of the new table. And since a Primary Key can’t have duplicates, you can’t have up to four rows of the same object_id to represent each of the four categories that can be in a group.
Or maybe I’m missing a link that is a different field.