StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
15880537
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-04-08T13:35:29.637
FavoriteCount
0
LastActivityDate
2015-11-08T08:05:43.623
LastEditDate
2015-11-08T08:05:43.623
LastEditorUserId
1023794
OwnerUserId
1023794
ParentId
12265927
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
<h2>Problem background</h2> <p>Since Moodle 2.0, files are no longer stored on server in the conventional <code>/this/is/the/path/to/my.file</code> way. Instead, files are rehashed and stored in Repositories (i.e. spread all over the <code>moodledata</code> folder as a collection of seemingly random data). This increases security and cross-OS compatibility but complicates stuff for people who would like to simply upload a SCORM zip package via FTP. Here's more information on <a href="http://docs.moodle.org/20/en/File_handling" rel="nofollow">file handling in Moodle 2.0</a></p> <h2>Path to the soluton</h2> <p>Let's locate the file you want to update, then update it. </p> <ol> <li>Run phpmyadmin, go to <code>mdl_files</code> table, find your file by name in the <code>filename</code> field (let's say it's <code>portrait.jpg</code>)</li> <li>Look at the <code>contenthash</code> field, it'll look like <code>abcde1234567890</code>. This means your file is stored in <code>moodledata/filedir/ab/cd/</code> folder under the name <code>abcde1234567890</code>.</li> <li>Rename the updated <code>portrait.jpg</code> to <code>abcde1234567890</code>, upload and overwrite.</li> <li>Go back to phpmyadmin and update the <code>filesize</code> field in record for <code>portrait.jpg</code> with the size of the updated file.</li> </ol> <p>Obviously, this process can be automated. You'll have to write a script that allows you to upload a file, then it'll search for that file in mdl_files, save it to the correct folder and update all fields accordingly. </p> <h2>Alternative idea</h2> <p>Enable external package type (and also enable 'Update on every launch'). Go to Site administration / Plugins / Activities / SCORM and check the box down below. Now you'll be able to launch SCORM packages directly from another server, so Moodle won't mess with it. Of course, you can run in other (probably cross-domain related) problems.</p>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow do I edit files in place that were uploaded to Moodle?
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USSergey Snegirev
UserOwnerUserId
1. USSergey Snegirev
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.