Magento – How to run upgrade script manually (1.9.0.0 to 1.9.1.0)

ce-1.9.1.0magento-1.9upgrade

I'm currently experiencing some urgent problems with my Magento website.

I have upgraded my website from 1.9.0.0 to 1.9.1.0 and now it seems like the upgrade script (database) do not run entirely.

Table 'website.core_email_queue' doesn't exist' in /home/magento/lib/Zend/Db/Statement/Pdo.php:228

Some settings are also missing in the core_config_data tables… Is it possible to rerun the upgrade scripts manually because currently I can't find where…

Some people suggest to modify the version in core_ressources but I don't think it's the best solution. I have triend to reinstall Mage_Core_Modules and Mage_Core_Adminhtml from the downloader but it doesn't seem to work.

I also have tried to redownload the core files of Magento and override core file in my setup, but it doesn't work at all. I can't get the missing tables created.

Thanks !

Best Answer

You can solved the problem by downgrading the version number in the table core_resource, as already written.

Alternatively, you can use tools like n98-magerun to trigger all install scripts

n98-magerun.phar sys:setup:run 

It has always solved my problems.

Related Topic