EDIT : the bug is here : MDL-79017
Hi,
I am having similar issues with my Moodle.
I deleted 5000 courses and I have this error message for 21 courses :
error/filereferenceproblem
Info de débogage Not an unserializeable value
Error code: filereferenceproblem
$a contents: stdClass Object
(
[repositoryid] =>
[reference] => a:6:{s:9:"contextid";i:3817;s:9:"component";s:12:"mod_resource";s:6:"itemid";i:0;s:8:"filearea";s:7:"content";s:8:"filepath";s:1:"/";s:8:"filename";s:80:"ISLDA20b- 1b - Les notions employées - éthique ; morale ; adab ; aḫlāq.docx";}
[referencefileid] =>
[fileid] =>
)
Error code: filereferenceproblem
$a contents: stdClass Object
(
[repositoryid] =>
[reference] => a:6:{s:9:"contextid";i:3817;s:9:"component";s:12:"mod_resource";s:6:"itemid";i:0;s:8:"filearea";s:7:"content";s:8:"filepath";s:1:"/";s:8:"filename";s:80:"ISLDA20b- 1b - Les notions employées - éthique ; morale ; adab ; aḫlāq.docx";}
[referencefileid] =>
[fileid] =>
)
I noticed the filename contains a semicolon :
- directy in the filename, example : here : a:6:{s:9:"contextid";i:94526;s:9:"component";s:10:"mod_folder";s:6:"itemid";i:0;s:8:"filearea";s:7:"content";s:8:"filepath";s:1:"/";s:8:"filename";s:25:"Description_d_image;.docx";}
- or because the filename contains special characters which have been encoded ? (õ = Unicode Decimal Code õ ) a:6:{s:9:"contextid";i:93114;s:9:"component";s:12:"mod_resource";s:6:"itemid";i:0;s:8:"filearea";s:7:"content";s:8:"filepath";s:1:"/";s:8:"filename";s:30:"s#245;navara-p34-crossword.pdf";}
=> but I found another example with special characters which have not been encoded (so I guess Moodle do not encode special characters)
[reference] => a:6:{s:9:"contextid";i:3817;s:9:"component";s:12:"mod_resource";s:6:"itemid";i:0;s:8:"filearea";s:7:"content";s:8:"filepath";s:1:"/";s:8:"filename";s:80:"ISLDA20b- 1b - Les notions employées - éthique ; morale ; adab ; aḫlāq.docx";}
Anyway, when the filename contains a semicolon, it seems that the unserialize function failed.
Is it a bug ?
Can I remove the semicolon in the field filename on the database to finalize the course deletion ?
# select filename from mdl_files where filename LIKE '%;%';
s#245;navara-p34-crossword.pdf
s#245;navara-p34-crossword.pdf
Thank you