EoC2 - Unable to INSERT

[Darkscis]

Getting a weird issue with EoC2. Using the same user account that the server itself uses, all permissions to the database.

When using EoC2, it seems that it cannot create new rows in the tables. I have tried copying an NPC and creating a new item so far - everything goes as normal, I get a "NPC copied" or "item created" message - but when I search the database itself there is no new entry.

I have tested this user by copying the INSERT statement from the show sql button in PEQeditor and pasting it direct into HeidiSQL and it runs fine (as the same user) so I don't think it is permissions related.

Have no trouble at all updating/changing entries, even deleting entries works - just for some reason it will not insert a new entry.