If anyone wants to see what is going on, feel free to go to
www.idreia.com/lms
I was installing moodle and all was well until I accepted the agreeement; then it just stopped. Now I get either a blank screen or a message telling me the page does not exist or the server is having issues--depends on the browser.
I am wondering if I too am suffering from the php memory limit, but it is presenting diffrently? Yes, my server has limited to 8M, though I can overcome this, I think, if that is what is wrong--yet I suspect something else at this moment.
phpinfo.php reports that all is well, and the prechecks all passes. The install scripts have created all the tables in the DB.
I am not seeing any meaningful errors in the logs, so I am at a loss.
Any ideas out there?
Dave
Folks, I know everyone is busy but I was hoping that I would have had someone offer some advice by now. I have tried to reinstall moodle. I increased the memory limit to 32M, increaed timeout vars, and still nothing.
When I reran the install I was able to get to the screen that showed that all dbs had been created. Then when I clicked on 'continue' I get nothing. I can not find any errors in any log, and I even setup a phperrors.log and nothing is there either.
Here is the output from last screen that worked...
(mysql): CREATE TABLE `mdl_config` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `value` text NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`)) TYPE=MyISAM COMMENT='Moodle configuration variables'
(mysql): CREATE TABLE `mdl_config_plugins` ( `id` int(10) unsigned NOT NULL auto_increment, `plugin` varchar(100) NOT NULL default 'core', `name` varchar(100) NOT NULL default '', `value` text NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `plugin_name` (`plugin`, `name`)) TYPE=MyISAM COMMENT='Moodle modules and plugins configuration variables'
(mysql): CREATE TABLE `mdl_course` ( `id` int(10) unsigned NOT NULL auto_increment, `category` int(10) unsigned NOT NULL default '0', `sortorder` int(10) unsigned NOT NULL default '0', `password` varchar(50) NOT NULL default '', `fullname` varchar(254) NOT NULL default '', `shortname` varchar(15) NOT NULL default '', `idnumber` varchar(100) NOT NULL default '', `summary` text NOT NULL, `format` varchar(10) NOT NULL default 'topics', `showgrades` smallint(2) unsigned NOT NULL default '1', `modinfo` longtext NOT NULL, `newsitems` smallint(5) unsigned NOT NULL default '1', `teacher` varchar(100) NOT NULL default 'Teacher', `teachers` varchar(100) NOT NULL default 'Teachers', `student` varchar(100) NOT NULL default 'Student', `students` varchar(100) NOT NULL default 'Students', `guest` tinyint(2) unsigned NOT NULL default '0', `startdate` int(10) unsigned NOT NULL default '0', `enrolperiod` int(10) unsigned NOT NULL default '0', `numsections` smallint(5) unsigned NOT NULL default '1', `marker` int(10) unsigned NOT NULL default '0', `maxbytes` int(10) unsigned NOT NULL default '0', `showreports` int(4) unsigned NOT NULL default '0', `visible` int(1) unsigned NOT NULL default '1', `hiddensections` int(2) unsigned NOT NULL default '0', `groupmode` int(4) unsigned NOT NULL default '0', `groupmodeforce` int(4) unsigned NOT NULL default '0', `lang` varchar(10) NOT NULL default '', `theme` varchar(50) NOT NULL default '', `cost` varchar(10) NOT NULL default '', `timecreated` int(10) unsigned NOT NULL default '0', `timemodified` int(10) unsigned NOT NULL default '0', `metacourse` int(1) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `category` (`category`), KEY `idnumber` (`idnumber`), KEY `shortname` (`shortname`)) TYPE=MyISAM
(mysql): CREATE TABLE `mdl_course_categories` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `description` text NOT NULL, `parent` int(10) unsigned NOT NULL default '0', `sortorder` int(10) unsigned NOT NULL default '0', `coursecount` int(10) unsigned NOT NULL default '0', `visible` tinyint(1) NOT NULL default '1', `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`)) TYPE=MyISAM COMMENT='Course categories'
(mysql): CREATE TABLE `mdl_course_display` ( `id` int(10) unsigned NOT NULL auto_increment, `course` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `display` int(10) NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), KEY `courseuserid` (course, userid)) TYPE=MyISAM COMMENT='Stores info about how to display the course'
(mysql): CREATE TABLE `mdl_course_meta` ( `id` int(10) unsigned NOT NULL auto_increment, `parent_course` int(10) NOT NULL default 0, `child_course` int(10) NOT NULL default 0, PRIMARY KEY (`id`), KEY `parent_course` (parent_course), KEY `child_course` (child_course))
(mysql): CREATE TABLE `mdl_course_modules` ( `id` int(10) unsigned NOT NULL auto_increment, `course` int(10) unsigned NOT NULL default '0', `module` int(10) unsigned NOT NULL default '0', `instance` int(10) unsigned NOT NULL default '0', `section` int(10) unsigned NOT NULL default '0', `added` int(10) unsigned NOT NULL default '0', `score` tinyint(4) NOT NULL default '0', `indent` int(5) unsigned NOT NULL default '0', `visible` tinyint(1) NOT NULL default '1', `groupmode` tinyint(4) NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), KEY `visible` (`visible`), KEY `course` (`course`), KEY `module` (`module`), KEY `instance` (`instance`)) TYPE=MyISAM
(mysql): CREATE TABLE `mdl_course_sections` ( `id` int(10) unsigned NOT NULL auto_increment, `course` int(10) unsigned NOT NULL default '0', `section` int(10) unsigned NOT NULL default '0', `summary` text NOT NULL, `sequence` text NOT NULL default '', `visible` tinyint(1) NOT NULL default '1', PRIMARY KEY (`id`), KEY `coursesection` (course, section)) TYPE=MyISAM
(mysql): CREATE TABLE `mdl_event` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `description` text NOT NULL, `format` int(4) unsigned NOT NULL default '0', `courseid` int(10) unsigned NOT NULL default '0', `groupid` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `repeatid` int(10) unsigned NOT NULL default '0', `modulename` varchar(20) NOT NULL default '', `instance` int(10) unsigned NOT NULL default '0', `eventtype` varchar(20) NOT NULL default '', `timestart` int(10) unsigned NOT NULL default '0', `timeduration` int(10) unsigned NOT NULL default '0', `visible` tinyint(4) NOT NULL default '1', `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), KEY `courseid` (`courseid`), KEY `userid` (`userid`), KEY `timestart` (`timestart`), KEY `timeduration` (`timeduration`)) TYPE=MyISAM COMMENT='For everything with a time associated to it'
(mysql): CREATE TABLE `mdl_cache_filters` ( `id` int(10) unsigned NOT NULL auto_increment, `filter` varchar(32) NOT NULL default '', `version` int(10) unsigned NOT NULL default '0', `md5key` varchar(32) NOT NULL default '', `rawtext` text NOT NULL, `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `filtermd5key` (filter, md5key)) TYPE=MyISAM COMMENT='For keeping information about cached data'
(mysql): CREATE TABLE `mdl_cache_text` ( `id` int(10) unsigned NOT NULL auto_increment, `md5key` varchar(32) NOT NULL default '', `formattedtext` longtext NOT NULL, `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `md5key` (`md5key`)) TYPE=MyISAM COMMENT='For storing temporary copies of processed texts'
(mysql): CREATE TABLE `mdl_grade_category` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(64) default NULL, `courseid` int(10) unsigned NOT NULL default '0', `drop_x_lowest` int(10) unsigned NOT NULL default '0', `bonus_points` int(10) unsigned NOT NULL default '0', `hidden` int(10) unsigned NOT NULL default '0', `weight` decimal(4, 2) default '0.00', PRIMARY KEY (`id`), KEY `courseid` (`courseid`)) TYPE=MyISAM
(mysql): CREATE TABLE `mdl_grade_exceptions` ( `id` int(10) unsigned NOT NULL auto_increment, `courseid` int(10) unsigned NOT NULL default '0', `grade_itemid` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `courseid` (`courseid`)) TYPE=MyISAM
(mysql): CREATE TABLE `mdl_grade_item` ( `id` int(10) unsigned NOT NULL auto_increment, `courseid` int(10) unsigned default NULL, `category` int(10) unsigned default NULL, `modid` int(10) unsigned default NULL, `cminstance` int(10) unsigned default NULL, `scale_grade` float(11, 10) default '1.0000000000', `extra_credit` int(10) unsigned NOT NULL default '0', `sort_order` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `courseid` (`courseid`)) TYPE=MyISAM
(mysql): CREATE TABLE `mdl_grade_letter` ( `id` int(10) unsigned NOT NULL auto_increment, `courseid` int(10) unsigned NOT NULL default '0', `letter` varchar(8) NOT NULL default 'NA', `grade_high` decimal(4, 2) NOT NULL default '100.00', `grade_low` decimal(4, 2) NOT NULL default '0.00', PRIMARY KEY (`id`), KEY `courseid` (`courseid`)) TYPE=MyISAM
(mysql): CREATE TABLE `mdl_grade_preferences` ( `id` int(10) unsigned NOT NULL auto_increment, `courseid` int(10) unsigned default NULL, `preference` int(10) NOT NULL default '0', `value` int(10) NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `courseidpreference` (`courseid`, `preference`)) TYPE=MyISAM
(mysql): CREATE TABLE `mdl_groups` ( `id` int(10) unsigned NOT NULL auto_increment, `courseid` int(10) unsigned NOT NULL default '0', `name` varchar(254) NOT NULL default '', `description` text NOT NULL, `password` varchar(50) NOT NULL default '', `lang` varchar(10) NOT NULL default 'en', `theme` varchar(50) NOT NULL default '', `picture` int(10) unsigned NOT NULL default '0', `hidepicture` int(2) unsigned NOT NULL default '0', `timecreated` int(10) unsigned NOT NULL default '0', `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), KEY `courseid` (`courseid`)) TYPE=MyISAM COMMENT='Each record is a group in a course.'
(mysql): CREATE TABLE `mdl_groups_members` ( `id` int(10) unsigned NOT NULL auto_increment, `groupid` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `timeadded` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), KEY `groupid` (`groupid`), KEY `userid` (`userid`)) TYPE=MyISAM COMMENT='Lists memberships of users to groups'
(mysql): CREATE TABLE `mdl_log` ( `id` int(10) unsigned NOT NULL auto_increment, `time` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `ip` varchar(15) NOT NULL default '', `course` int(10) unsigned NOT NULL default '0', `module` varchar(20) NOT NULL default '', `cmid` int(10) unsigned NOT NULL default '0', `action` varchar(15) NOT NULL default '', `url` varchar(100) NOT NULL default '', `info` varchar(255) NOT NULL default '', PRIMARY KEY (`id`), KEY `timecoursemoduleaction` (time, course, module, action), KEY `coursemoduleaction` (course, module, action), KEY `courseuserid` (course, userid)) TYPE=MyISAM COMMENT='Every action is logged as far as possible.'
(mysql): CREATE TABLE `mdl_log_display` ( `module` varchar(20) NOT NULL default '', `action` varchar(20) NOT NULL default '', `mtable` varchar(20) NOT NULL default '', `field` varchar(40) NOT NULL default '') TYPE=MyISAM COMMENT='For a particular module/action, specifies a moodle table/field.'
(mysql): CREATE TABLE `mdl_message` ( `id` int(10) unsigned NOT NULL auto_increment, `useridfrom` int(10) NOT NULL default '0', `useridto` int(10) NOT NULL default '0', `message` text NOT NULL, `format` int(4) unsigned NOT NULL default '0', `timecreated` int(10) NOT NULL default '0', `messagetype` varchar(50) NOT NULL default '', PRIMARY KEY (`id`), KEY `useridfrom` (`useridfrom`), KEY `useridto` (`useridto`)) TYPE=MyISAM COMMENT='Stores all unread messages'
(mysql): CREATE TABLE `mdl_message_read` ( `id` int(10) unsigned NOT NULL auto_increment, `useridfrom` int(10) NOT NULL default '0', `useridto` int(10) NOT NULL default '0', `message` text NOT NULL, `format` int(4) unsigned NOT NULL default '0', `timecreated` int(10) NOT NULL default '0', `timeread` int(10) NOT NULL default '0', `messagetype` varchar(50) NOT NULL default '', `mailed` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`), KEY `useridfrom` (`useridfrom`), KEY `useridto` (`useridto`)) TYPE=MyISAM COMMENT='Stores all messages that have been read'
(mysql): CREATE TABLE `mdl_message_contacts` ( `id` int(10) unsigned NOT NULL auto_increment, `userid` int(10) unsigned NOT NULL default '0', `contactid` int(10) unsigned NOT NULL default '0', `blocked` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `usercontact` (`userid`, `contactid`)) TYPE=MyISAM COMMENT='Maintains lists of relationships between users'
(mysql): CREATE TABLE `mdl_modules` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(20) NOT NULL default '', `version` int(10) NOT NULL default '0', `cron` int(10) unsigned NOT NULL default '0', `lastcron` int(10) unsigned NOT NULL default '0', `search` varchar(255) NOT NULL default '', `visible` tinyint(1) NOT NULL default '1', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), KEY `name` (`name`)) TYPE=MyISAM
(mysql): CREATE TABLE `mdl_scale` ( `id` int(10) unsigned NOT NULL auto_increment, `courseid` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `name` varchar(255) NOT NULL default '', `scale` text NOT NULL, `description` text NOT NULL, `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (id), KEY `courseid` (`courseid`)) TYPE=MyISAM COMMENT='Defines grading scales'
(mysql): CREATE TABLE `mdl_sessions` ( `sesskey` char(32) NOT null, `expiry` int(11) unsigned NOT null, `expireref` varchar(64), `data` text NOT null, PRIMARY KEY (`sesskey`), KEY (`expiry`)) TYPE=MyISAM COMMENT='Optional database session storage, not used by default'
(mysql): CREATE TABLE `mdl_timezone` ( `id` int(10) NOT NULL auto_increment, `name` varchar(100) NOT NULL default '', `year` int(11) NOT NULL default '0', `rule` varchar(20) NOT NULL default '', `gmtoff` int(11) NOT NULL default '0', `dstoff` int(11) NOT NULL default '0', `dst_month` tinyint(2) NOT NULL default '0', `dst_startday` tinyint(3) NOT NULL default '0', `dst_weekday` tinyint(3) NOT NULL default '0', `dst_skipweeks` tinyint(3) NOT NULL default '0', `dst_time` varchar(5) NOT NULL default '00:00', `std_month` tinyint(2) NOT NULL default '0', `std_startday` tinyint(3) NOT NULL default '0', `std_weekday` tinyint(3) NOT NULL default '0', `std_skipweeks` tinyint(3) NOT NULL default '0', `std_time` varchar(5) NOT NULL default '00:00', PRIMARY KEY (`id`)) TYPE=MyISAM COMMENT='Rules for calculating local wall clock time for users'
(mysql): CREATE TABLE `mdl_user` ( `id` int(10) unsigned NOT NULL auto_increment, `auth` varchar(20) NOT NULL default 'manual', `confirmed` tinyint(1) NOT NULL default '0', `policyagreed` tinyint(1) NOT NULL default '0', `deleted` tinyint(1) NOT NULL default '0', `username` varchar(100) NOT NULL default '', `password` varchar(32) NOT NULL default '', `idnumber` varchar(64) default NULL, `firstname` varchar(20) NOT NULL default '', `lastname` varchar(20) NOT NULL default '', `email` varchar(100) NOT NULL default '', `emailstop` tinyint(1) unsigned NOT NULL default '0', `icq` varchar(15) default NULL, `skype` varchar(50) default NULL, `yahoo` varchar(50) default NULL, `aim` varchar(50) default NULL, `msn` varchar(50) default NULL, `phone1` varchar(20) default NULL, `phone2` varchar(20) default NULL, `institution` varchar(40) default NULL, `department` varchar(30) default NULL, `address` varchar(70) default NULL, `city` varchar(20) default NULL, `country` char(2) default NULL, `lang` varchar(10) default 'en', `theme` varchar(50) NOT NULL default '', `timezone` varchar(100) NOT NULL default '99', `firstaccess` int(10) unsigned NOT NULL default '0', `lastaccess` int(10) unsigned NOT NULL default '0', `lastlogin` int(10) unsigned NOT NULL default '0', `currentlogin` int(10) unsigned NOT NULL default '0', `lastIP` varchar(15) default NULL, `secret` varchar(15) default NULL, `picture` tinyint(1) default NULL, `url` varchar(255) default NULL, `description` text, `mailformat` tinyint(1) unsigned NOT NULL default '1', `maildigest` tinyint(1) unsigned NOT NULL default '0', `maildisplay` tinyint(2) unsigned NOT NULL default '2', `htmleditor` tinyint(1) unsigned NOT NULL default '1', `autosubscribe` tinyint(1) unsigned NOT NULL default '1', `trackforums` tinyint(1) unsigned NOT NULL default '0', `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), UNIQUE KEY `username` (`username`), KEY `user_deleted` (`deleted`), KEY `user_confirmed` (`confirmed`), KEY `user_firstname` (`firstname`), KEY `user_lastname` (`lastname`), KEY `user_city` (`city`), KEY `user_country` (`country`), KEY `user_lastaccess` (`lastaccess`), KEY `user_email` (`email`)) TYPE=MyISAM COMMENT='One record for each person'
(mysql): ALTER TABLE `mdl_user` ADD INDEX `auth` (`auth`)
(mysql): ALTER TABLE `mdl_user` ADD INDEX `idnumber` (`idnumber`)
(mysql): CREATE TABLE `mdl_user_admins` ( `id` int(10) unsigned NOT NULL auto_increment, `userid` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), KEY `userid` (`userid`)) TYPE=MyISAM COMMENT='One record per administrator user'
(mysql): CREATE TABLE `mdl_user_preferences` ( `id` int(10) unsigned NOT NULL auto_increment, `userid` int(10) unsigned NOT NULL default '0', `name` varchar(50) NOT NULL default '', `value` varchar(255) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), KEY `useridname` (userid, name)) TYPE=MyISAM COMMENT='Allows modules to store arbitrary user preferences'
(mysql): CREATE TABLE `mdl_user_students` ( `id` int(10) unsigned NOT NULL auto_increment, `userid` int(10) unsigned NOT NULL default '0', `course` int(10) unsigned NOT NULL default '0', `timestart` int(10) unsigned NOT NULL default '0', `timeend` int(10) unsigned NOT NULL default '0', `time` int(10) unsigned NOT NULL default '0', `timeaccess` int(10) unsigned NOT NULL default '0', `enrol` varchar(20) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), UNIQUE KEY `courseuserid` (course, userid), KEY `userid` (userid), KEY `enrol` (enrol), KEY `timeaccess` (timeaccess)) TYPE=MyISAM
(mysql): CREATE TABLE `mdl_user_teachers` ( `id` int(10) unsigned NOT NULL auto_increment, `userid` int(10) unsigned NOT NULL default '0', `course` int(10) unsigned NOT NULL default '0', `authority` int(10) NOT NULL default '3', `role` varchar(40) NOT NULL default '', `editall` int(1) unsigned NOT NULL default '1', `timestart` int(10) unsigned NOT NULL default '0', `timeend` int(10) unsigned NOT NULL default '0', `timemodified` int(10) unsigned NOT NULL default '0', `timeaccess` int(10) unsigned NOT NULL default '0', `enrol` varchar(20) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), UNIQUE KEY `courseuserid` (course, userid), KEY `userid` (userid), KEY `enrol` (enrol)) TYPE=MyISAM COMMENT='One record per teacher per course'
(mysql): CREATE TABLE `mdl_user_coursecreators` ( `id` int(10) unsigned NOT NULL auto_increment, `userid` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), KEY `userid` (`userid`)) TYPE=MyISAM COMMENT='One record per course creator'
(mysql): CREATE TABLE `adodb_logsql` ( `created` datetime NOT NULL, `sql0` varchar(250) NOT NULL, `sql1` text NOT NULL, `params` text NOT NULL, `tracer` text NOT NULL, `timer` decimal(16, 6) NOT NULL)
(mysql): INSERT INTO mdl_log_display VALUES ('user', 'view', 'user', 'CONCAT(firstname, " ", lastname)')
(mysql): INSERT INTO mdl_log_display VALUES ('course', 'user report', 'user', 'CONCAT(firstname, " ", lastname)')
(mysql): INSERT INTO mdl_log_display VALUES ('course', 'view', 'course', 'fullname')
(mysql): INSERT INTO mdl_log_display VALUES ('course', 'update', 'course', 'fullname')
(mysql): INSERT INTO mdl_log_display VALUES ('course', 'enrol', 'course', 'fullname')
(mysql): INSERT INTO mdl_log_display VALUES ('message', 'write', 'user', 'CONCAT(firstname, " ", lastname)')
(mysql): INSERT INTO mdl_log_display VALUES ('message', 'read', 'user', 'CONCAT(firstname, " ", lastname)')
(mysql): INSERT INTO mdl_log_display VALUES ('message', 'add contact', 'user', 'CONCAT(firstname, " ", lastname)')
(mysql): INSERT INTO mdl_log_display VALUES ('message', 'remove contact', 'user', 'CONCAT(firstname, " ", lastname)')
(mysql): INSERT INTO mdl_log_display VALUES ('message', 'block contact', 'user', 'CONCAT(firstname, " ", lastname)')
(mysql): INSERT INTO mdl_log_display VALUES ('message', 'unblock contact', 'user', 'CONCAT(firstname, " ", lastname)')
When I reran the install I was able to get to the screen that showed that all dbs had been created. Then when I clicked on 'continue' I get nothing. I can not find any errors in any log, and I even setup a phperrors.log and nothing is there either.
Here is the output from last screen that worked...
Setting up database
(mysql): CREATE TABLE `mdl_config` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `value` text NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`)) TYPE=MyISAM COMMENT='Moodle configuration variables'
Success
(mysql): CREATE TABLE `mdl_config_plugins` ( `id` int(10) unsigned NOT NULL auto_increment, `plugin` varchar(100) NOT NULL default 'core', `name` varchar(100) NOT NULL default '', `value` text NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `plugin_name` (`plugin`, `name`)) TYPE=MyISAM COMMENT='Moodle modules and plugins configuration variables'
Success
(mysql): CREATE TABLE `mdl_course` ( `id` int(10) unsigned NOT NULL auto_increment, `category` int(10) unsigned NOT NULL default '0', `sortorder` int(10) unsigned NOT NULL default '0', `password` varchar(50) NOT NULL default '', `fullname` varchar(254) NOT NULL default '', `shortname` varchar(15) NOT NULL default '', `idnumber` varchar(100) NOT NULL default '', `summary` text NOT NULL, `format` varchar(10) NOT NULL default 'topics', `showgrades` smallint(2) unsigned NOT NULL default '1', `modinfo` longtext NOT NULL, `newsitems` smallint(5) unsigned NOT NULL default '1', `teacher` varchar(100) NOT NULL default 'Teacher', `teachers` varchar(100) NOT NULL default 'Teachers', `student` varchar(100) NOT NULL default 'Student', `students` varchar(100) NOT NULL default 'Students', `guest` tinyint(2) unsigned NOT NULL default '0', `startdate` int(10) unsigned NOT NULL default '0', `enrolperiod` int(10) unsigned NOT NULL default '0', `numsections` smallint(5) unsigned NOT NULL default '1', `marker` int(10) unsigned NOT NULL default '0', `maxbytes` int(10) unsigned NOT NULL default '0', `showreports` int(4) unsigned NOT NULL default '0', `visible` int(1) unsigned NOT NULL default '1', `hiddensections` int(2) unsigned NOT NULL default '0', `groupmode` int(4) unsigned NOT NULL default '0', `groupmodeforce` int(4) unsigned NOT NULL default '0', `lang` varchar(10) NOT NULL default '', `theme` varchar(50) NOT NULL default '', `cost` varchar(10) NOT NULL default '', `timecreated` int(10) unsigned NOT NULL default '0', `timemodified` int(10) unsigned NOT NULL default '0', `metacourse` int(1) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `category` (`category`), KEY `idnumber` (`idnumber`), KEY `shortname` (`shortname`)) TYPE=MyISAM
Success
(mysql): CREATE TABLE `mdl_course_categories` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `description` text NOT NULL, `parent` int(10) unsigned NOT NULL default '0', `sortorder` int(10) unsigned NOT NULL default '0', `coursecount` int(10) unsigned NOT NULL default '0', `visible` tinyint(1) NOT NULL default '1', `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`)) TYPE=MyISAM COMMENT='Course categories'
Success
(mysql): CREATE TABLE `mdl_course_display` ( `id` int(10) unsigned NOT NULL auto_increment, `course` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `display` int(10) NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), KEY `courseuserid` (course, userid)) TYPE=MyISAM COMMENT='Stores info about how to display the course'
Success
(mysql): CREATE TABLE `mdl_course_meta` ( `id` int(10) unsigned NOT NULL auto_increment, `parent_course` int(10) NOT NULL default 0, `child_course` int(10) NOT NULL default 0, PRIMARY KEY (`id`), KEY `parent_course` (parent_course), KEY `child_course` (child_course))
Success
(mysql): CREATE TABLE `mdl_course_modules` ( `id` int(10) unsigned NOT NULL auto_increment, `course` int(10) unsigned NOT NULL default '0', `module` int(10) unsigned NOT NULL default '0', `instance` int(10) unsigned NOT NULL default '0', `section` int(10) unsigned NOT NULL default '0', `added` int(10) unsigned NOT NULL default '0', `score` tinyint(4) NOT NULL default '0', `indent` int(5) unsigned NOT NULL default '0', `visible` tinyint(1) NOT NULL default '1', `groupmode` tinyint(4) NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), KEY `visible` (`visible`), KEY `course` (`course`), KEY `module` (`module`), KEY `instance` (`instance`)) TYPE=MyISAM
Success
(mysql): CREATE TABLE `mdl_course_sections` ( `id` int(10) unsigned NOT NULL auto_increment, `course` int(10) unsigned NOT NULL default '0', `section` int(10) unsigned NOT NULL default '0', `summary` text NOT NULL, `sequence` text NOT NULL default '', `visible` tinyint(1) NOT NULL default '1', PRIMARY KEY (`id`), KEY `coursesection` (course, section)) TYPE=MyISAM
Success
(mysql): CREATE TABLE `mdl_event` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `description` text NOT NULL, `format` int(4) unsigned NOT NULL default '0', `courseid` int(10) unsigned NOT NULL default '0', `groupid` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `repeatid` int(10) unsigned NOT NULL default '0', `modulename` varchar(20) NOT NULL default '', `instance` int(10) unsigned NOT NULL default '0', `eventtype` varchar(20) NOT NULL default '', `timestart` int(10) unsigned NOT NULL default '0', `timeduration` int(10) unsigned NOT NULL default '0', `visible` tinyint(4) NOT NULL default '1', `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), KEY `courseid` (`courseid`), KEY `userid` (`userid`), KEY `timestart` (`timestart`), KEY `timeduration` (`timeduration`)) TYPE=MyISAM COMMENT='For everything with a time associated to it'
Success
(mysql): CREATE TABLE `mdl_cache_filters` ( `id` int(10) unsigned NOT NULL auto_increment, `filter` varchar(32) NOT NULL default '', `version` int(10) unsigned NOT NULL default '0', `md5key` varchar(32) NOT NULL default '', `rawtext` text NOT NULL, `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `filtermd5key` (filter, md5key)) TYPE=MyISAM COMMENT='For keeping information about cached data'
Success
(mysql): CREATE TABLE `mdl_cache_text` ( `id` int(10) unsigned NOT NULL auto_increment, `md5key` varchar(32) NOT NULL default '', `formattedtext` longtext NOT NULL, `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `md5key` (`md5key`)) TYPE=MyISAM COMMENT='For storing temporary copies of processed texts'
Success
(mysql): CREATE TABLE `mdl_grade_category` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(64) default NULL, `courseid` int(10) unsigned NOT NULL default '0', `drop_x_lowest` int(10) unsigned NOT NULL default '0', `bonus_points` int(10) unsigned NOT NULL default '0', `hidden` int(10) unsigned NOT NULL default '0', `weight` decimal(4, 2) default '0.00', PRIMARY KEY (`id`), KEY `courseid` (`courseid`)) TYPE=MyISAM
Success
(mysql): CREATE TABLE `mdl_grade_exceptions` ( `id` int(10) unsigned NOT NULL auto_increment, `courseid` int(10) unsigned NOT NULL default '0', `grade_itemid` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `courseid` (`courseid`)) TYPE=MyISAM
Success
(mysql): CREATE TABLE `mdl_grade_item` ( `id` int(10) unsigned NOT NULL auto_increment, `courseid` int(10) unsigned default NULL, `category` int(10) unsigned default NULL, `modid` int(10) unsigned default NULL, `cminstance` int(10) unsigned default NULL, `scale_grade` float(11, 10) default '1.0000000000', `extra_credit` int(10) unsigned NOT NULL default '0', `sort_order` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `courseid` (`courseid`)) TYPE=MyISAM
Success
(mysql): CREATE TABLE `mdl_grade_letter` ( `id` int(10) unsigned NOT NULL auto_increment, `courseid` int(10) unsigned NOT NULL default '0', `letter` varchar(8) NOT NULL default 'NA', `grade_high` decimal(4, 2) NOT NULL default '100.00', `grade_low` decimal(4, 2) NOT NULL default '0.00', PRIMARY KEY (`id`), KEY `courseid` (`courseid`)) TYPE=MyISAM
Success
(mysql): CREATE TABLE `mdl_grade_preferences` ( `id` int(10) unsigned NOT NULL auto_increment, `courseid` int(10) unsigned default NULL, `preference` int(10) NOT NULL default '0', `value` int(10) NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `courseidpreference` (`courseid`, `preference`)) TYPE=MyISAM
Success
(mysql): CREATE TABLE `mdl_groups` ( `id` int(10) unsigned NOT NULL auto_increment, `courseid` int(10) unsigned NOT NULL default '0', `name` varchar(254) NOT NULL default '', `description` text NOT NULL, `password` varchar(50) NOT NULL default '', `lang` varchar(10) NOT NULL default 'en', `theme` varchar(50) NOT NULL default '', `picture` int(10) unsigned NOT NULL default '0', `hidepicture` int(2) unsigned NOT NULL default '0', `timecreated` int(10) unsigned NOT NULL default '0', `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), KEY `courseid` (`courseid`)) TYPE=MyISAM COMMENT='Each record is a group in a course.'
Success
(mysql): CREATE TABLE `mdl_groups_members` ( `id` int(10) unsigned NOT NULL auto_increment, `groupid` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `timeadded` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), KEY `groupid` (`groupid`), KEY `userid` (`userid`)) TYPE=MyISAM COMMENT='Lists memberships of users to groups'
Success
(mysql): CREATE TABLE `mdl_log` ( `id` int(10) unsigned NOT NULL auto_increment, `time` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `ip` varchar(15) NOT NULL default '', `course` int(10) unsigned NOT NULL default '0', `module` varchar(20) NOT NULL default '', `cmid` int(10) unsigned NOT NULL default '0', `action` varchar(15) NOT NULL default '', `url` varchar(100) NOT NULL default '', `info` varchar(255) NOT NULL default '', PRIMARY KEY (`id`), KEY `timecoursemoduleaction` (time, course, module, action), KEY `coursemoduleaction` (course, module, action), KEY `courseuserid` (course, userid)) TYPE=MyISAM COMMENT='Every action is logged as far as possible.'
Success
(mysql): CREATE TABLE `mdl_log_display` ( `module` varchar(20) NOT NULL default '', `action` varchar(20) NOT NULL default '', `mtable` varchar(20) NOT NULL default '', `field` varchar(40) NOT NULL default '') TYPE=MyISAM COMMENT='For a particular module/action, specifies a moodle table/field.'
Success
(mysql): CREATE TABLE `mdl_message` ( `id` int(10) unsigned NOT NULL auto_increment, `useridfrom` int(10) NOT NULL default '0', `useridto` int(10) NOT NULL default '0', `message` text NOT NULL, `format` int(4) unsigned NOT NULL default '0', `timecreated` int(10) NOT NULL default '0', `messagetype` varchar(50) NOT NULL default '', PRIMARY KEY (`id`), KEY `useridfrom` (`useridfrom`), KEY `useridto` (`useridto`)) TYPE=MyISAM COMMENT='Stores all unread messages'
Success
(mysql): CREATE TABLE `mdl_message_read` ( `id` int(10) unsigned NOT NULL auto_increment, `useridfrom` int(10) NOT NULL default '0', `useridto` int(10) NOT NULL default '0', `message` text NOT NULL, `format` int(4) unsigned NOT NULL default '0', `timecreated` int(10) NOT NULL default '0', `timeread` int(10) NOT NULL default '0', `messagetype` varchar(50) NOT NULL default '', `mailed` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`), KEY `useridfrom` (`useridfrom`), KEY `useridto` (`useridto`)) TYPE=MyISAM COMMENT='Stores all messages that have been read'
Success
(mysql): CREATE TABLE `mdl_message_contacts` ( `id` int(10) unsigned NOT NULL auto_increment, `userid` int(10) unsigned NOT NULL default '0', `contactid` int(10) unsigned NOT NULL default '0', `blocked` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `usercontact` (`userid`, `contactid`)) TYPE=MyISAM COMMENT='Maintains lists of relationships between users'
Success
(mysql): CREATE TABLE `mdl_modules` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(20) NOT NULL default '', `version` int(10) NOT NULL default '0', `cron` int(10) unsigned NOT NULL default '0', `lastcron` int(10) unsigned NOT NULL default '0', `search` varchar(255) NOT NULL default '', `visible` tinyint(1) NOT NULL default '1', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), KEY `name` (`name`)) TYPE=MyISAM
Success
(mysql): CREATE TABLE `mdl_scale` ( `id` int(10) unsigned NOT NULL auto_increment, `courseid` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `name` varchar(255) NOT NULL default '', `scale` text NOT NULL, `description` text NOT NULL, `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (id), KEY `courseid` (`courseid`)) TYPE=MyISAM COMMENT='Defines grading scales'
Success
(mysql): CREATE TABLE `mdl_sessions` ( `sesskey` char(32) NOT null, `expiry` int(11) unsigned NOT null, `expireref` varchar(64), `data` text NOT null, PRIMARY KEY (`sesskey`), KEY (`expiry`)) TYPE=MyISAM COMMENT='Optional database session storage, not used by default'
Success
(mysql): CREATE TABLE `mdl_timezone` ( `id` int(10) NOT NULL auto_increment, `name` varchar(100) NOT NULL default '', `year` int(11) NOT NULL default '0', `rule` varchar(20) NOT NULL default '', `gmtoff` int(11) NOT NULL default '0', `dstoff` int(11) NOT NULL default '0', `dst_month` tinyint(2) NOT NULL default '0', `dst_startday` tinyint(3) NOT NULL default '0', `dst_weekday` tinyint(3) NOT NULL default '0', `dst_skipweeks` tinyint(3) NOT NULL default '0', `dst_time` varchar(5) NOT NULL default '00:00', `std_month` tinyint(2) NOT NULL default '0', `std_startday` tinyint(3) NOT NULL default '0', `std_weekday` tinyint(3) NOT NULL default '0', `std_skipweeks` tinyint(3) NOT NULL default '0', `std_time` varchar(5) NOT NULL default '00:00', PRIMARY KEY (`id`)) TYPE=MyISAM COMMENT='Rules for calculating local wall clock time for users'
Success
(mysql): CREATE TABLE `mdl_user` ( `id` int(10) unsigned NOT NULL auto_increment, `auth` varchar(20) NOT NULL default 'manual', `confirmed` tinyint(1) NOT NULL default '0', `policyagreed` tinyint(1) NOT NULL default '0', `deleted` tinyint(1) NOT NULL default '0', `username` varchar(100) NOT NULL default '', `password` varchar(32) NOT NULL default '', `idnumber` varchar(64) default NULL, `firstname` varchar(20) NOT NULL default '', `lastname` varchar(20) NOT NULL default '', `email` varchar(100) NOT NULL default '', `emailstop` tinyint(1) unsigned NOT NULL default '0', `icq` varchar(15) default NULL, `skype` varchar(50) default NULL, `yahoo` varchar(50) default NULL, `aim` varchar(50) default NULL, `msn` varchar(50) default NULL, `phone1` varchar(20) default NULL, `phone2` varchar(20) default NULL, `institution` varchar(40) default NULL, `department` varchar(30) default NULL, `address` varchar(70) default NULL, `city` varchar(20) default NULL, `country` char(2) default NULL, `lang` varchar(10) default 'en', `theme` varchar(50) NOT NULL default '', `timezone` varchar(100) NOT NULL default '99', `firstaccess` int(10) unsigned NOT NULL default '0', `lastaccess` int(10) unsigned NOT NULL default '0', `lastlogin` int(10) unsigned NOT NULL default '0', `currentlogin` int(10) unsigned NOT NULL default '0', `lastIP` varchar(15) default NULL, `secret` varchar(15) default NULL, `picture` tinyint(1) default NULL, `url` varchar(255) default NULL, `description` text, `mailformat` tinyint(1) unsigned NOT NULL default '1', `maildigest` tinyint(1) unsigned NOT NULL default '0', `maildisplay` tinyint(2) unsigned NOT NULL default '2', `htmleditor` tinyint(1) unsigned NOT NULL default '1', `autosubscribe` tinyint(1) unsigned NOT NULL default '1', `trackforums` tinyint(1) unsigned NOT NULL default '0', `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), UNIQUE KEY `username` (`username`), KEY `user_deleted` (`deleted`), KEY `user_confirmed` (`confirmed`), KEY `user_firstname` (`firstname`), KEY `user_lastname` (`lastname`), KEY `user_city` (`city`), KEY `user_country` (`country`), KEY `user_lastaccess` (`lastaccess`), KEY `user_email` (`email`)) TYPE=MyISAM COMMENT='One record for each person'
Success
(mysql): ALTER TABLE `mdl_user` ADD INDEX `auth` (`auth`)
Success
(mysql): ALTER TABLE `mdl_user` ADD INDEX `idnumber` (`idnumber`)
Success
(mysql): CREATE TABLE `mdl_user_admins` ( `id` int(10) unsigned NOT NULL auto_increment, `userid` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), KEY `userid` (`userid`)) TYPE=MyISAM COMMENT='One record per administrator user'
Success
(mysql): CREATE TABLE `mdl_user_preferences` ( `id` int(10) unsigned NOT NULL auto_increment, `userid` int(10) unsigned NOT NULL default '0', `name` varchar(50) NOT NULL default '', `value` varchar(255) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), KEY `useridname` (userid, name)) TYPE=MyISAM COMMENT='Allows modules to store arbitrary user preferences'
Success
(mysql): CREATE TABLE `mdl_user_students` ( `id` int(10) unsigned NOT NULL auto_increment, `userid` int(10) unsigned NOT NULL default '0', `course` int(10) unsigned NOT NULL default '0', `timestart` int(10) unsigned NOT NULL default '0', `timeend` int(10) unsigned NOT NULL default '0', `time` int(10) unsigned NOT NULL default '0', `timeaccess` int(10) unsigned NOT NULL default '0', `enrol` varchar(20) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), UNIQUE KEY `courseuserid` (course, userid), KEY `userid` (userid), KEY `enrol` (enrol), KEY `timeaccess` (timeaccess)) TYPE=MyISAM
Success
(mysql): CREATE TABLE `mdl_user_teachers` ( `id` int(10) unsigned NOT NULL auto_increment, `userid` int(10) unsigned NOT NULL default '0', `course` int(10) unsigned NOT NULL default '0', `authority` int(10) NOT NULL default '3', `role` varchar(40) NOT NULL default '', `editall` int(1) unsigned NOT NULL default '1', `timestart` int(10) unsigned NOT NULL default '0', `timeend` int(10) unsigned NOT NULL default '0', `timemodified` int(10) unsigned NOT NULL default '0', `timeaccess` int(10) unsigned NOT NULL default '0', `enrol` varchar(20) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), UNIQUE KEY `courseuserid` (course, userid), KEY `userid` (userid), KEY `enrol` (enrol)) TYPE=MyISAM COMMENT='One record per teacher per course'
Success
(mysql): CREATE TABLE `mdl_user_coursecreators` ( `id` int(10) unsigned NOT NULL auto_increment, `userid` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), KEY `userid` (`userid`)) TYPE=MyISAM COMMENT='One record per course creator'
Success
(mysql): CREATE TABLE `adodb_logsql` ( `created` datetime NOT NULL, `sql0` varchar(250) NOT NULL, `sql1` text NOT NULL, `params` text NOT NULL, `tracer` text NOT NULL, `timer` decimal(16, 6) NOT NULL)
Success
(mysql): INSERT INTO mdl_log_display VALUES ('user', 'view', 'user', 'CONCAT(firstname, " ", lastname)')
Success
(mysql): INSERT INTO mdl_log_display VALUES ('course', 'user report', 'user', 'CONCAT(firstname, " ", lastname)')
Success
(mysql): INSERT INTO mdl_log_display VALUES ('course', 'view', 'course', 'fullname')
Success
(mysql): INSERT INTO mdl_log_display VALUES ('course', 'update', 'course', 'fullname')
Success
(mysql): INSERT INTO mdl_log_display VALUES ('course', 'enrol', 'course', 'fullname')
Success
(mysql): INSERT INTO mdl_log_display VALUES ('message', 'write', 'user', 'CONCAT(firstname, " ", lastname)')
Success
(mysql): INSERT INTO mdl_log_display VALUES ('message', 'read', 'user', 'CONCAT(firstname, " ", lastname)')
Success
(mysql): INSERT INTO mdl_log_display VALUES ('message', 'add contact', 'user', 'CONCAT(firstname, " ", lastname)')
Success
(mysql): INSERT INTO mdl_log_display VALUES ('message', 'remove contact', 'user', 'CONCAT(firstname, " ", lastname)')
Success
(mysql): INSERT INTO mdl_log_display VALUES ('message', 'block contact', 'user', 'CONCAT(firstname, " ", lastname)')
Success
(mysql): INSERT INTO mdl_log_display VALUES ('message', 'unblock contact', 'user', 'CONCAT(firstname, " ", lastname)')
Success
Database was successfully upgraded