Step 5: Creating index in content table... [failed]
Posted: Fri Jun 22, 2012 1:02 am
Undefined variable use ($db_prefix) in install/upgrades/upgrade.35.to.36.php (on line 49) is causing the index_content_by_idhier index creation to fail. (See the error in bold/red below):
Hope this helps,
fredp
To isolate the problem, I added some debugging code to upgrade.35.to.36.php to var_dump relavant values, which are included below. You can see that the table name doesn't include the cms_db_prefix() value:install/upgrades/upgrade.35.to.36.php (line 49) wrote:$sqlarray = $dbdict->CreateTableSQL(cms_db_prefix()."routes", $flds, $taboptarray);
...
$sqlarray = $dbdict->CreateIndexSQL($db_prefix.'index_content_by_idhier', $db_prefix."content", 'hierarchy');
Please let me know if you need any more details.$sqlarray = array(1) { [0]=> string(67) "ALTER TABLE content ADD INDEX index_content_by_idhier (hierarchy)" }
$return = int(1)
$db err info= array(3) { ["ErrorNo"]=> int(1146) ["ErrorMsg"]=> string(42) "Table 'beta1_111.content' doesn't exist" ["Affected_Rows"]=> int(-1) }
Hope this helps,
fredp