Details
-
Type:
Improvement
-
Status:
Open
-
Priority:
Minor
-
Resolution: Unresolved
-
Affects Version/s: 1.8.3, 1.9.3
-
Fix Version/s: STABLE backlog
-
Component/s: Course
-
Labels:None
-
Environment:SELECT COUNT(*) FROM moodle.mdl_course -> 2847
SELECT COUNT(*) FROM moodle.mdl_course_categories -> 645
-
Database:MySQL
-
Affected Branches:MOODLE_18_STABLE, MOODLE_19_STABLE
Description
it was not possible to move some courses or to create courses inside a special category.
Errormessage was something like [course not created]
sortorder (integer ?) maximum value was reached in some rows
ALTER TABLE `mdl_course` MODIFY COLUMN `sortorder` **BIGINT** UNSIGNED NOT NULL DEFAULT 0;
seemed to fix it.
Activity
- All
- Comments
- History
- Activity
- Source
- Test Sessions
Assigning to Petr and addressing to 1.9.4... if I'm nor wrong some time ago one fix was introduced for this problem and shouldn't be happening in 1.9.3.
Also, Martin, have you checked the status of your INTs in DB from Admin->Misc->XMLDB Editor->Check Bigints? If not it's highly recommended to do so in order to get "correct" BIGINTs in Moodle DB.
Ciao