Using Moodle 1.9.x (probably later than 7)
We have a number of databases with a worrying problem.
On the list page when clicking on the "More" icon for some entries the link goes to a different entry than the one corresponding to the one specified by ##user##.
The username generated by ##user## and the link generated by ##more## do not always point to the same record.
This is also the case in the search screen The search will find a record where (for example) the name meets a certain criterion however the ##more## link generates an rid to a different record which may or may not meet the criterion.
When on a single entry page and clicking on the comment link this will take the commenter to a different record.
See the image "comment.jpg": the comment link points to rid=36956 whereas the record on the screen is rid=36954
We cannot see a pattern to the rid substitutions though they are within +/- 2 or 3 record numbers.
A few are fine with the links going to the correct record.
We are very puzzled by this problem and would appreciate any insight. Please ask further questions if the problem is not clearly stated.