CMS MADE SIMPLE FORGE

Gallery

 
Back Back to List

[#5991] MySQL error during installation (if MySQL version is higher then 5.0)

avatar
Created By: Alexander (awebtech)
Date Submitted: Wed Jan 12 17:41:16 -0500 2011

Assigned To: Jos (josvd)
Version: 1.4.3
CMSMS Version: None
Severity: Major
Resolution: Fixed
State: Closed
Summary:
MySQL error during installation (if MySQL version is higher then 5.0)
Detailed Description:
Hi.

If you try to install the Gallery module on MySQL 5.1 or higher you will get the
following error: ERROR: Table 'dbname.module_gallery_templateprops' doesn't
exist.

This happens because of incorrect MySQL engine type definition. Currently the
type is specified as 'TYPE=MyISAM' (file: method.install.php, line: 34). 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

Comments
avatar 
Date: 2011-02-07 13:24
Posted By: Jos (josvd)

Thanks for the clear report. Fixed in Gallery version 1.4.4
Updates

Updated: 2011-02-07 13:24
resolution_id: => 7
assigned_to_id: 100 => 11752
state: Open => Closed