Course sorting does not work

Course sorting does not work

by Philip L. -
Number of replies: 2

Since the latest upgrad, and possible before as I haven't really noticed it, it seems when trying to sort the courses out they do not move.

I've tried using "Re-sort courses by name" and moving individual couses up and down using the arrows, the courses just dont move.

Our VLE version is: 1.9.10+ (Build: 20101214)
PHP: 5.3.4
MySQL: 5.1.4
Apache: 2.2.3

Any help would be apreciated please.

I tried turning debugging on, but it doesn't show any error messages in the log.

Thanks,
Phil

Average of ratings: -
In reply to Philip L.

Re: Course sorting does not work

by Charlie Roberts -

I am having the same problem except that I receive an error message.  When I go to the Apache log I find an error message

Here's the error message:
[Thu Feb 03 15:20:06 2011] [error] [client 205.126.61.236] Default exception handler: Error writing to database Debug: Duplicate entry '2-10002' for key 2\nUPDATE mdl_course SET sortorder = ? WHERE id = ?\n[array (\n  0 => '10002',\n  1 => '36',\n)]\n* line 394 of /lib/dml/moodle_database.php: dml_write_exception throw
n\n* line 1021 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_dat
abase->query_end()\n* line 1441 of /lib/dml/moodle_database.php: call to mysqli_native_moodle_database->set_field_select()\n* line 143 of /course/category.php: call to moodle_database->set_field()\n, referer: http://moodle.washk12.org/cours e/category.php?id=2&categoryedit=on&sesskey=Ryl5qXomI3

There doesn't seem to be any other problems that I have found, but the sorting doesn't work on any level.

Any suggestions would be appreciated.

Thanks, Charlie

In reply to Philip L.

Re: Course sorting does not work

by Anthony Borrow -
Picture of Core developers Picture of Plugin developers Picture of Testers

Perhaps it is related to MDL-21011. I believe with sites with large numbers of courses that there have been some issues. Hopefully the tracker issue will give you some insights. Peace - Anthony