English (United Kingdom)
Jms Multi Site, formerly joomla multisite.
Create, share multiple joomla sites in few clicks !
Welcome, Guest
Please Login or Register.    Lost Password?
Go to bottomPage: 1
TOPIC: Cannot install new slave sites
#11706
Cannot install new slave sites 3 Years, 10 Months ago Karma: 0
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.
christianpatrick
Fresh Boarder
Posts: 2
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#11711
Re: Cannot install new slave sites 3 Years, 9 Months ago Karma: 53
- 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"
edwin2win
Moderator
Posts: 5265
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#12275
Re: Cannot install new slave sites 2 Years, 9 Months ago Karma: 0
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
erentaltools
Fresh Boarder
Posts: 9
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#12276
Re: Cannot install new slave sites 2 Years, 9 Months ago Karma: 53
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 );
}
edwin2win
Moderator
Posts: 5265
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#12277
Re: Cannot install new slave sites 2 Years, 9 Months ago Karma: 0
Worked perfectly. Thanks so much for the quick response!
erentaltools
Fresh Boarder
Posts: 9
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
Go to topPage: 1
get the latest posts directly to your desktop
2Win, Multisite(s) are trademarks of Edwin2Win.
Joomla