Magento Installer Error

I am trying to install magento in media temple hosting account.While installing i am getting the error

Error in file: "app/code/core/Mage/Dataflow/sql/dataflow_setup/mysql4-upgrade-0.7.3-0.7.4.php" - SQLSTATE[42S02]: Base table or view not found: 1146 Table 'db128510_main.dataflow_batch' doesn't exist

Trace:
#0 /app/code/core/Mage/Core/Model/Resource/Setup.php(390): Mage::exception('Mage_Core', 'Error in file: ...')
#1 /app/code/core/Mage/Core/Model/Resource/Setup.php(289): Mage_Core_Model_Resource_Setup->_modifyResourceDb('upgrade', '0.7.3', '0.7.4')
#2 /app/code/core/Mage/Core/Model/Resource/Setup.php(233): Mage_Core_Model_Resource_Setup->_upgradeResourceDb('0.7.3', '0.7.4')
#3 /app/code/core/Mage/Core/Model/Resource/Setup.php(161): Mage_Core_Model_Resource_Setup->applyUpdates()
#4 /app/code/core/Mage/Core/Model/App.php(399): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 /app/code/core/Mage/Core/Model/App.php(329): Mage_Core_Model_App->_initModules()
#6 /app/Mage.php(627): Mage_Core_Model_App->run(Array)
开发者_如何学C#7 /index.php(80): Mage::run('', 'store')
#8 {main}

If i manually create the table and reinstall,installer outputs another table doesn't exists.I also ran magento system requirement checking script and found no issue.Its fresh install and not any upgrades.Any pointers?

---

I've had similar issues while trying to upgrade magento versions. Please try adding the following line to the top of that setup script:

$this->getConnection()->disallowDdlCache();

Also I don't think it matters much, but for good measure try to clear the DDL cache too:

$this->getConnection()->resetDdlCache();

It's a long shot, but it may work in your case.

Edit in response to your comment:

Magento caches DDL statements under the covers. Which means it will be able to execute some SQL statements a little bit faster. But sometimes this causes problems during updates. I think it has something to do with foreign keys and invalidated cache data.