NULL entries in mdl_file

NULL entries in mdl_file

by Howard Miller -
Number of replies: 2
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers

Can anybody tell me what the mdl_file entries are that have a filename of a single dot and a mime type of NULL?

Typical example...

select * from mdl_files where id=26193\G
*************************** 1. row ***************************
id: 26193
contenthash: da39a3ee5e6b4b0d3255bfef95601890afd80709
pathnamehash: 6a6bff94c3c95b798275697ab0b89591d7185692
contextid: 3577
component: user
filearea: icon
itemid: 0
filepath: /
filename: .
userid: NULL
filesize: 0
mimetype: NULL
status: 0
source: NULL
author: NULL
license: NULL
timecreated: 1349984128
timemodified: 1349984128
sortorder: 0
referencefileid: NULL
referencelastsync: NULL
referencelifetime: NULL
1 row in set (0.00 sec)

Average of ratings: -
In reply to Howard Miller

Re: NULL entries in mdl_file

by Davo Smith -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers

They are the base folder for each file area.

As with most file systems, folders are treated as a special type of file and data about them is stored alongside the files themselves. For consistency all files are stored within a folder, even if they are in the base folder, so the base/root folder ('/') for each file area needs to exist.

Average of ratings: Useful (3)
In reply to Davo Smith

Re: NULL entries in mdl_file

by Howard Miller -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers

Great - yes, I wondered why every file seems to have one. Thanks!

Average of ratings: -