After moving to 1.4 on a new Suse 9.1 server, I stopped seeing logs displayed. Two other servers running 1.4 Beta do not have this problem. Logs are being recorded into the mdl_log file. Repairing the database files files has not altered the problem, but the user drop down on the log display page only shows a partial participant list. Is this an index issue? Which files may need checking?
Did you visit the admin page directly after upgrading?
Yes, But there may have been an interuption with the connection during the schema expansion.
I have same problem, I always get above error messages. What can I do???? when I click continue button, same page reload. I delete mdl_blocks from my mysql, but I get same error. Please say someting to solve my problem.
(mysql): CREATE TABLE `mdl_blocks` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(40) 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', `visible` tinyint(1) NOT NULL default '1', PRIMARY KEY (`id`)) TYPE=MyISAM
1050: Table 'mdl_blocks' already exists
WARNING!!! The code you are using is OLDER than the version that made these databases!
| Upgrading database |
| GOLE » Upgrading database |
(mysql): CREATE TABLE `mdl_blocks` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(40) 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', `visible` tinyint(1) NOT NULL default '1', PRIMARY KEY (`id`)) TYPE=MyISAM
1050: Table 'mdl_blocks' already exists
Error
| Blocks tables could NOT be set up successfully! |
Hello Mark.
We almost have the same upgrade problem. It's just that I upgraded from 1.3.3 to 1.3.4 Last Stable Release. Since my upgrade last Friday, I lost my logs. MOODLE doesn't seem to generate logs after the upgrade. When I clicked on the Admin link it opens the Setting up module tables page with these messages
WARNING!!! The code you are using is OLDER than the version that made these databases!
(mysql): CREATE TABLE mdl_scorm ( id int(10) unsigned NOT NULL auto_increment, course int(10) unsigned NOT NULL default '0', name varchar(255) NOT NULL default '', reference varchar(255) NOT NULL default '', datadir varchar(255) NOT NULL default '', launch int(10) unsigned NOT NULL default 0, summary text NOT NULL, auto tinyint(1) unsigned NOT NULL default '0', popup varchar(255) NOT NULL default '', timemodified int(10) unsigned NOT NULL default '0', PRIMARY KEY (id), UNIQUE KEY id (id)) TYPE=MyISAM
1050: Table 'mdl_scorm' already exists
Error
(mysql): CREATE TABLE mdl_scorm_scoes ( id int(10) unsigned NOT NULL auto_increment, scorm int(10) unsigned NOT NULL default '0', parent varchar(255) NOT NULL default '', identifier varchar(255) NOT NULL default '', launch varchar(255) NOT NULL default '', type varchar(5) NOT NULL default '', title varchar(255) NOT NULL default '', datafromlms longtext, next tinyint(1) unsigned NOT NULL default '0', previous tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (id), UNIQUE KEY id (id)) TYPE=MyISAM
1050: Table 'mdl_scorm_scoes' already exists
Error
(mysql): CREATE TABLE mdl_scorm_sco_users ( id int(10) unsigned NOT NULL auto_increment, userid int(10) unsigned NOT NULL default '0', scormid int(10) NOT NULL default '0', scoid int(10) unsigned NOT NULL default '0', cmi_core_lesson_location varchar(255) NOT NULL default '', cmi_core_lesson_status varchar(30) NOT NULL default '', cmi_core_exit varchar(30) NOT NULL default '', cmi_core_total_time varchar(13) NOT NULL default '00:00:00', cmi_core_session_time varchar(13) NOT NULL default '00:00:00', cmi_core_score_raw float(3) NOT NULL default '0', cmi_suspend_data longtext, PRIMARY KEY (id)) TYPE=MyISAM
1050: Table 'mdl_scorm_sco_users' already exists
Error
(mysql): INSERT INTO mdl_log_display VALUES ('scorm', 'view', 'scorm', 'name')
Success
(mysql): INSERT INTO mdl_log_display VALUES ('scorm', 'update', 'scorm', 'name')
Success
(mysql): INSERT INTO mdl_log_display VALUES ('scorm', 'add', 'scorm', 'name')
Success
| scorm tables could NOT be set up successfully! |
(mysql): SELECT * FROM mdl_course WHERE category = '0' LIMIT 1
Got any idea what this is all about? I'm not into programming so this is really foreign to me. Did you get these same messages?
Scorm modules added fine for me, and it appears that they had been setup once before for you.
I solved my problem by going into the database to empty the mdl_log table, then performed a cvs update.
I lost my logs but the new entries display as they should.
Thanks for the feedback!