Invalid query error in step 4 of 0.10beta3 install

[tamlyn]

I'm getting the error described by piratos in this post in the german forum. It's a fresh install of 0.10beta3 on a web server that has had beta1 installed and upgraded to beta3 without problems. Checking the database shows that only the cms_module_news_categories tables has actually been created even though the install script claims to have successfully created all tables. Any ideas?

[piratos]

The only table that created is the only that used this code:

Code: Select all

$dict = NewDataDictionary($db);

	$taboptarray = array('mysql' => 'TYPE=MyISAM');
	$sqlarray = $dict->CreateTableSQL($db_prefix."module_news_categories", 
			$flds, $taboptarray);
	$dict->ExecuteSQLArray($sqlarray);

all others

Code: Select all

$dbdict = NewDataDictionary($db);
	$flds = "
		module_name C(255),
		template_name C(200),
		content X,
		create_date T,
		modified_date T
	";
	$taboptarray = array('mysql' => 'TYPE=MyISAM CHARSET=utf8');
	$sqlarray = $dbdict->CreateTableSQL($db_prefix."module_templates", $flds, $taboptarray);
	$dbdict->ExecuteSQLArray($sqlarray);

Pointer override  or so

[Ted]

Interesting catch.  I'll look into it.

[Ted]

I know what it is...

Version 3 doesn't support the CHARSET option when creating databases.  I'm going to take them all out.