There is a bug in MySQL 4.1.21 that affects Moodle. It's caused by an SQL statement that contains both a 'DISTINCT' clause and an 'ORDER BY' clause. We have seen the affect on the reorder courses screen of the categories list. In this case, when you are looking at the edit (reorder) screen the courses look like the don't re-order and they won't be in the correct order. If you look at them with editing turned off, they will be fine.
I recommend you don't upgrade to this version.
mike
I'm experiencing the same problem over here, but mine is perhaps worse. I am running that version of MySQL, but our courses don't even re-order when we turn editing off. How did you manage to re-order your courses? Every time I try to move mine it stays and turning editing off doesn't move it either.
Any input would be appreciated! Thanks!
Any input would be appreciated! Thanks!
I have this version of MYSQL and the same problem and mine don't reorder with editing turned on or off.
What is the solution? I can't change the MYSQL version.
Unfortunately, its a MySQL bug. Until they fix it, there's not much you can do.
I do know that this problem doesn't exist in Moodle 1.6. That version uses a different SQL statement that is not affected by the MySQL bug. (but, there may be other places that we haven't found yet).
If you can get to an older version of MySQL, you will be fine.
mike
I do know that this problem doesn't exist in Moodle 1.6. That version uses a different SQL statement that is not affected by the MySQL bug. (but, there may be other places that we haven't found yet).
If you can get to an older version of MySQL, you will be fine.
mike