I currently have a error in my 1.9.3.2 store.
When a customer wants to reset their password, the Magento Report error page is displayed.
When check the report, I get the following error:
a:5:{i:0;s:156:"SQLSTATE[42S02]: Base table or view not found: 1146 Table 'customer_flowpassword' doesn't exist, query was: DESCRIBE `customer_flowpassword`";i:1;s:2832:"#0 /lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
Problem is related to the update to 1.9.3.2, where the table was not created.
Should this solve the issue?
CREATE TABLE `customer_flowpassword` (
`flowpassword_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Flow password Id',
`ip` varchar(50) NOT NULL COMMENT 'User IP',
`email` varchar(255) NOT NULL COMMENT 'Requested email for change',
`requested_date` varchar(255) NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Requested date for change',
PRIMARY KEY (`flowpassword_id`),
KEY `IDX_CUSTOMER_FLOWPASSWORD_EMAIL` (`email`),
KEY `IDX_CUSTOMER_FLOWPASSWORD_IP` (`ip`),
KEY `IDX_CUSTOMER_FLOWPASSWORD_REQUESTED_DATE` (`requested_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer flow password' AUTO_INCREMENT=9 ;
How can I solve that?
customer_flowpassword
is not available, check which module is using the table and try to run the setup script for that module