Fixing Easy2Gallery Installation SQL Errors on Older MySQL Hosts

Sometimes an Evolution extra fails before you even get to use it. In the Easy2Gallery case, installation stopped with a table-creation error and MySQL complained about syntax near the ENGINE=MyISAM part of the statement.

That usually points to an environment mismatch rather than a gallery bug in isolation. Older hosting stacks, incomplete SQL definitions, or a module package built for a different MySQL version can all cause the installer to stop when it tries to create its tables.

What to check

• Confirm the MySQL version on the host.
• Open the package install SQL and inspect the failing table definition.
• Look for syntax that an older server might reject, especially storage-engine declarations or charset fragments.
• Try creating the table manually in phpMyAdmin to see the exact failing line.

If manual execution shows that the SQL itself is the issue, the safest fix is to adapt the package installer to the server you actually have instead of rerunning the same install endlessly. For very old stacks, that can mean simplifying the table definition or upgrading the host before relying on the extra.

The broader lesson is that gallery modules depend on the database layer just as much as on PHP. When an installer fails on SQL, treat it as a compatibility problem first, not as a frontend problem.