2010-07-19 20:44:50
Installation of ATutor 20 Fails during Step2 Database Fixed
Hopefully this helps someone else who may have the same problem either upgrading or during a fresh install.
During a fresh install of the latest ATutor Stable (v2) the installation would halt during step 2 while importing the DB Schema. The behavior indicated several tables would be created and many more failed to be created.
Inside the <Atutor Root>/install/db/ folder there are two files "atutor_schema.sql" and "atutor_language_text.sql" that are applicable to new installations and the remainder appear to indicate schema changes for upgrading.
In any case they use the syntax TYPE=MyISAM which is a deprecated syntax and has been removed as of MySQL 5.4.4. Performing a quick SED replace of this to make this use ENGINE=MyISAM corrects the problem and lets installation proceed as normal.
Affected platforms/users:
MySQL Server Version >= 5.4.4
ATutor Version = 2 (Most likely all previous versions will be affected the same way)
Fix: Update Schema Syntax in install directory.