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!

I think I’m ok to repair manually if you tell me what to do.What does ‘look at SP’ mean?

‘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.

I imagine it is pretty important to know to stop it mis-allocating in the future. I look forward to your response.

Just looked at the auth_ids on wp_sfauths and these are also missing all even numbers. Will this be a problem as well? I’ll hold off updating the auth_cats until you respond. Thanks.

I sent you an email with the details about 20 minutes ago…

Yes – thanks for that.

So I am putting together some update statements to set all the authcat 3s to 2s, all the 5s to 3s etc. I don’t think your email mentioned the auth_id which is also showing only odd numbers, unless I mis-read something? 

The auth_id also needs changing as in the part at the top of the text file.

Yes I understood to change the authcat_id, I’m talking about the auth_id, which on my localhost version runs from 1 to 30 but on my production version only has odd numbers and goes up to 59.

That one should be fine.

That’s sorted the uploading issue but I can’t create a poll??

…..looks like some of the auth_cats weren’t quite right – will try and sort now.

No. Can’t see the poll button even though the permission is set correctly.

And are polls turned on for the forum in question?

No!

Will you let me know if you here anything about the sequence anomaly?

Thanks for all your help – well worth the membership fee.

reading up on it I have to assume that your MySQL setting called ‘auto_increment_increment’ is set to 2. As I said before, this was not always the case looking at earlier records in your DB which suggests it was changed after you started the site and created the DB. It is most curious as to why this should happen and, perhaps of more importance to you, who or what made the change…