Posts made by Martin Dougiamas

Picture of Core developers Picture of Documentation writers Picture of Moodle HQ Picture of Plugin developers Picture of Testers
Take a look at: http://moodle.org/user/index.php?id=5

Notice it's listing 197 or 198 records? It's supposed to be retrieving the first 200 (using SQL LIMIT), and in fact it WAS until a couple of days ago. The odd thing is that if I use the exact same SQL in phpmyadmin it works fine and retrieves the expected 200 user records.

SELECT u.* FROM user u, user_students s WHERE s.course = '5' AND s.userid = u.id AND u.deleted = '0' ORDER BY u.lastaccess DESC LIMIT 200

I'm going to check myself into a loony bin.

Ideas welcome! (for the SQL problem, not for good insane asylums)
Average of ratings: -