Hello,

We have been using multisites for a couple of years now and have had no problems installing slave sites. We recently upgraded our server to PHP 5.4 and MySQL 5.5.32. Since then we have not been able to install any new slave sites. The error we receive is: "Create external Table Error query [CREATE TABLE `#__". It duplicates this error for every table in the database including the core files. We have Joomla 1.5.26.

Thanks for any help.

- Verify the syntax of the create table and provide the full error message.
The answer is present in the message.

- You mentioned that you have upgraded to MySQL 5.5.32 and perhaps that MySQL kept a old "TYPE=MyISAM" instead of MySQL 5.5 syntax "ENGINE=MyISAM"

Was this issue ever solved? We upgraded to MySQL 5.5 on Joomla 1.5.26 and experienced this same issue.

We updated our installation directory to replace the type=MyISAM with ENGINE=MyISAM, but it still seems to be adding TYPE=MyISAM into the create table statements when creating a new site. Any idea why this is and how to override this?

Our multisites version is 1.2.97

Such type of issue is solved in JMS 1.3.23 for nov-2013 (1 year ago).

JMS 1.2.97 is no more updated for dec-2012 (almost 2 year) and is replaced by JMS 1.3.x.

If you are a developer and want to try fixing the source in JMS 1.2, you have to update the source /administrator/component/com_multisites/classes/multisitesdb.php

search for the function _getCreateTable

Before the end of the function with return $sql;
Add the following code.


// If MySQL version >= 5.1 and TYPE=(MyISAM|InnoDB)
$query = "SELECT Version() AS version";
$db->setQuery( $query );
$version = $db->loadResult();
$mySQLVers = preg_replace('#[^0-9\.]#', '', $version); // Just keep Digits and Dot
if ( version_compare( $mySQLVers, '5.1') >= 0 && strpos( $sql, 'TYPE=') !== false) {
// Ensure that the statement use "ENGINE=xxxx" instead of TYPE=xxxxx
// In case of MySQL version 5.5.32, it is possible that we still receive a TYPE=MyISAM instead of ENGINE=MyISAM
// Probably in the case of an upgrade of MySQL 4.x to MySQL 5.5
$sql = str_replace( array( "TYPE=MyISAM", "TYPE=InnoDB"),
array( "ENGINE=MyISAM", "ENGINE=InnoDB"),
$sql );
}

Worked perfectly. Thanks so much for the quick response!