SQLSTATE[42S02]: Base table or view not found in extension

Question

we installed this : https://www.magentocommerce.com/magento-connect/auto-invoice-by-plumrocket-inc.html

we are facing error here

    query was: DELETE FROM plumbase_product WHERE 
`date` < '2016-05-09 00:44:00

edit

core_translate`.`string`, `core_translate`.`translate` FROM `core_translate` WHERE (store_id IN (0 , :store_id)) AND (locale = :locale) ORDER BY `store_id` ASC

' please help me to find solution

Answer 1

Given no background information/context and no code, my assumption would be:

• You've installed a custom made/third party Magento module
• This module is supposed to create the table plumbase_product
• The module would probably have a setup script to create this table
• You deployed the change
• You didn't clear your cache

Therefore, my best advice would be:

• Clear your cache
• Run all setup scripts

If you still experience this issue (your link is a valid Magento admin panel), I'd suggest you:

• Identify the setup script that creates the table
• Identify the version number of the module that that script corresponds to
• Check if there are any problem if subsequent setup scripts get run again, and if not:
• Reset your module's version number to the version before the setup script that creates the table, then repeat the suggested steps above

Answer 2

The error is not related to the "auto invoice" module https://www.magentocommerce.com/magento-connect/auto-invoice-by-plumrocket-inc.html It does not even have the sql setup scripts in its package.

=== UPDATE ===

This table is required for plumrocket_base module which comes along with the installed "auto invoice" module. It checks for Magento version, list of installed Plumrocket modules, news feed, licenses, etc. In order to reinstall it remove table plumbase_product and remove its line from core_resource table where code="base_setup"

Do not forget to flush cache after all.