CMS MADE SIMPLE FORGE

Cataloger

 
Back Back to List

[#6146] MySQL tables are not created during installation (if MySQL version is higher then 5.0)

avatar
Created By: Alexander (awebtech)
Date Submitted: Tue Feb 22 05:01:09 -0500 2011

Assigned To:
Version: 0.9
CMSMS Version: None
Severity: Major
Resolution: None
State: Open
Summary:
MySQL tables are not created during installation (if MySQL version is higher then 5.0)
Detailed Description:
Hi.

If you try to install the Cataloger module on MySQL 5.1 or higher you will not
see any data (templates etc) in the module admin area. The related tables are
simply missing.

This happens because of incorrect MySQL engine type definition. Currently the
type is specified as 'TYPE=MyISAM' (file: method.install.php, line: 12). But the
TYPE keyword support was dropped since MySQL 5.1. So, the CREATE TABLE query is
incorrect because of TYPE usage.

The fix is very simple. It is necessary to replace TYPE with ENGINE. This
keyword is supported in all MySQL versions.


History