Thursday, April 5, 2012

Upgrade to moodle 2 issue and fix

If upgrading from 1.9 to moodle 2 and you're running into issue like

!! Data too long for column 'questiontext' at row 1

Fix is

Running ALTER TABLE mdl_question MODIFY questiontext MEDIUMTEXT;

Sunday, April 1, 2012

Moodle 2 moodledata directory

Here is the info for moodledata directory in moodle 2

For example
moodledata/filedir/d2/90/d2901f1f5f46134bd8cd767448c1da7daf9a41a2

Then connect to the Moodle 2 database and run a query

SELECT * FROM mdl_files WHERE contenthash = 'd2901f1f5f46134bd8cd767448c1da7daf9a41a2';