DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
I’m getting the above error on my site. It seems like I can just delete sessions from the sessions table and that will fix things, though I’m not sure if there are any side effects of just running a sql command directly on the db and not going through the admin or something of that sort.
Also, how long will that fix really last (if there are duplicates now, what’s stopping this from happening again in about 2 minutes)
Yeah, sorry, should have included that. It looks like it’s OJS 2.4.6.
When I inspect the index, it describes that as non unique, which is one reason that I was a bit confused on how to move forward with it.
Also, as a follow up on the short term solution, it seems as though someone truncated the sessions table. The site is running, I’m just looking to make sure it’s not a recurring bug.