Troubleshooting: Database tables have not been initialized

From XTENTO Support Wiki
Jump to: navigation, search

If you see this error message the database tables could not be created. The setup scripts simply didn't get executed. This sometimes happens with Magento, and is a rare race condition that happens rarely ever, but it happens. It's not a bug in our extension.

Before applying any of the fixes, check your app/etc/local.xml file and see if the following line is there: <skip_process_modules_updates>true</skip_process_modules_updates> If yes, this is the cause of update scripts not running, but we cannot provide any advise - if you remove this line, any updates of modules you installed before will be ran. (See here for more information)

There are two possible solutions to fix this.

Solution 1: DISABLE ALL CACHES IN MAGENTO. Copy the file /app/code/local/Xtento/MODULENAME/sql/resource_reset.php into the root directory of Magento. Then open the URL http://www.urltoyourstore.com/pathtostore/resource_reset.php in your store. Delete the script resource_reset.php again, enable and refresh the cache, make sure the compiler is disabled and log into the Magento backend again.

Alternative solution: Log into a database administration tool like phpMyAdmin and open the core_resource table. Make a backup of this table. Look for an entry saying xtento_MODULENAME (replace with the module name you're trying to install) and delete the entry. Then refresh the cache, make sure the compiler is disabled and log into the Magento backend again.

The error message should be gone now.

If you're still experiencing the same error after following the above instructions please contact us. You will have to run the install scripts in your database manually. The queries are all located in the /app/code/local/Xtento/MODULENAME/sql/MODULENAME_setup/ folder.

Personal tools
Namespaces
Variants
Actions
General Information
Magento 2 Guides
Magento 2 Extensions
Magento 1 Guides
Magento 1 Extensions
Magento Integration Suite
Product Feed Guides
Toolbox