#6 Install Fails with Incorrect SQL INSERT Statements

[Anonymous]

I'm running Moodle version Moodle 1.6.2 (2006050520)
installed from the Debian Unstable package. When trying
to install the module, I got errors saying that the
INSERT statements failed for table prefix_log_display.

This happened because the mysql.sql file had an
incorrect INSERT statement that neglected to include a
field for the autoincrement ID field. Including the
keyword DEFAULT for the ID field fixed the problem. The
corrected INSERT statements are included below:

--------------------

INSERT INTO prefix_log_display VALUES (DEFAULT,
'evaluation', 'view', 'evaluation', 'name');
INSERT INTO prefix_log_display VALUES (DEFAULT,
'evaluation', 'add', 'evaluation', 'name');
INSERT INTO prefix_log_display VALUES (DEFAULT,
'evaluation', 'update', 'evaluation', 'name');
INSERT INTO prefix_log_display VALUES (DEFAULT,
'evaluation', 'view submission', 'evaluation', 'name');
INSERT INTO prefix_log_display VALUES (DEFAULT,
'evaluation', 'upload', 'evaluation', 'name');

Corrected file is attached.

--Tim Ingalls
tim@ideadynamics.com

[Nobody/Anonymous]

Corrected SQL file

[Nobody/Anonymous]

Logged In: NO

Actually, although this stops the Admin page from displaying
any error messages when it is installing the module, when
trying to use the modules, various field names don't work
right. For example, when adding an activity by clicking the
"Add an activity..." dropdown, the module name shows up as
[[modulename]] instead of the proper name for the module.
The same thing happens for the other MTM modules I installed.

To fix this problem, I copied the evaluations.php file from
the "/usr/share/moodle/lang/en" folder into the
"/usr/share/moodle/lang/en_utf8" and now it all works.

--Tim Ingalls