Support Forum

OK - this is a first for me and something I have never seen before and seems to be the root cause of the permission issue.

Your auto-increment process of your mySQL database appears to either go up 2 digits at a time or something on your database is set to never have a key field value where the number is even. I.e., all of your table records that are numerically stored follow the patter 1, 3, 5, 7, 9 etc.!

It was not always like this as I see some early records in your DB where all numbers were used but it has been like this for a while. The effect on SP has been to throw the 'authcat' relationships out. This could be repaired manually very easily I believe if you are Ok to do that - I can tell you what needs changing of course.

But - I would really like to know what the root cause is of the odd keys and will need to look at SP to see if that might have any future negative effect. So let's say I am burning up with curiosity!

'look at SP' means that I have to look at the code to ensure we are safe for this weird db key allocation of yours.

I will go through now and work pout the changes and come back within half an hour with instructions.

But I still want to know why your DB is doing this. Actually - that is pretty important to know.