Andy Burns wrote:
I couldn't see any changes to the cache table, it seems that between the value parameters passed to the insert statement and the table defaults all columns are being provided with a value, the only other constraint I can see is the reference to the session table, did I miss something else?
I decided to clean out the cache and session tables to see if that helped, it didn't fix the error, but it allowed me to see that there are no entries being added to the session table when a user logs in, so presumably that explains the constraint error ...