Page 1 of 1
Invalid query error in step 4 of 0.10beta3 install
Posted: Tue May 31, 2005 2:34 am
by 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?
Re: Invalid query error in step 4 of 0.10beta3 install
Posted: Tue May 31, 2005 8:32 am
by 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
Re: Invalid query error in step 4 of 0.10beta3 install
Posted: Tue May 31, 2005 9:57 am
by Ted
Interesting catch. I'll look into it.
Re: Invalid query error in step 4 of 0.10beta3 install
Posted: Tue May 31, 2005 9:59 am
by 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.