Users getting "null" IDs. MySQL

[CTOUT]

Hi all,

Since moving from DBlite to MySQL, I noticed that newly registered users do not continue the numbering sequence and instead end up with null values. This results in SSC not working correctly and everyone sharing the same SSC account.

I've tried tinkering with the primary key settings, truncating the table and not allowing null - but if I do that, tShock complains that there is no "default value". If I give it a default value, then it uses just that value and does not increment it accordingly.

Likely something I've done wrong, but can anyone advise? Using the latest release at time of writing (TShock 4.4.0 Pre-release 12 for Terraria 1.4.0.5)

[CTOUT]

Nevermind, think I found it. Autoincrement was not set for users.id.