TYPO3 Core

When doing the compare database (update as well as installing doing an fresh installation) the following error occurs:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /homepages/30/d155523077/htdocs/typo3cms/typo3_src-4.2.0RC1/t3lib/class.t3lib_db.php on line 1047

The refered script from line 1034 - 1052 shows the following code:
/** * Returns information about the character sets supported by the current DBM * This function is important not only for the Install Tool but probably for DBALs as well since they might need to look up table specific information in order to construct correct queries. In such cases this information should probably be cached for quick delivery. * * This is used by the Install Tool to convert tables tables with non-UTF8 charsets * Use in Install Tool only! * * @return array Array with Charset as key and an array of "Charset", "Description", "Default collation", "Maxlen" as values
*/
function admin_get_charsets() {
$output = array();

$columns_res = mysql_query('SHOW CHARACTER SET', $this->link);
        while ($row = mysql_fetch_assoc($columns_res)) {
            $output[$row['Charset']] = $row;
        }

return $output;
    }

After the first compare all tables are installed but the following statements are left open:
ALTER TABLE cache_hash ENGINE=InnoDB;
Current value: ENGINE=
(over all 8 statements like the one above)

Clicking on Update doesn't solve the problem. It stays unchanged.

Taking a look into the database via phpmyadmin the tables, for example the above mentioned table cach_hash, shows that the engine has been set to InnoDB.

MySQL 4.0
PHP 5.2.7

Install-Tool
2: Database Analyser
Compare

Settings in 5: All Configuration
UTF8-filesystem yes
TTFLocaleConv = utf-8
setDBinit = SET NAMES utf-8; SET CHARACTER SET utf-8;
(issue imported from #M8018)