This is really strange...
I did some more testing with various numbers of child documents (4, 6, 9) in the folder and I was getting some really strange results. It seemed like the 3rd document was always wrong, the 4th was right and the 5th on would be wrong until you get to the 7th doc. Ok, I know by now you think I’m insane (believe me, you wouldn’t be wrong) but what makes things a little stranger is that when I actually query the database in mysql to see what’s going on I notice that all of the doc permissions are there, but the document number was never updated correctly. When I query the permissions for the second doc (remember the third doc has no permissions) I see this:
id document_group document
2764 10 774
2765 9 774
2766 84 774
2785 10 774
2786 9 774
2787 84 774
Those last three entries should have been document 775. Same thing happens with doc 7:
id document_group document
2767 84 779
2768 9 779
2769 10 779
2770 84 779
2771 9 779
2772 10 779
2791 10 779
2792 9 779
2793 84 779
The missing document permissions are there, they were just put into the database with the wrong document number. If it helps, I’m running MySQL 4.1.9-standard and using I.E. (sorry) in the manager interface.
Maybe there’s something wrong with our MySql server? Any help as to how to fix this would be greatly appreciated.
Thanks!