SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento2.captcha_log' doesn't exist

[dase_m]

Hi,

Need help understanding this error message:

Exception #0 (Magento\Framework\DB\Adapter\TableNotFoundException): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento2.captcha_log' doesn't exist.

I get this error everytime when I go to the Url checkout/cart/.

Runnning Magento 2.3.6

Dase

Thanks in advance for your help.

[Sanjay Jethva]

Hello @dase_m 

Please check if 'captcha_log' named table is present in the database or not. It seems as if this table is not yet created.

You can create this table using the below SQL query:

CREATE TABLE `captcha_log` (
     `type` varchar(32) NOT NULL COMMENT 'Type',
     `value` varchar(255) NOT NULL COMMENT 'Value',
     `count` int(10) NOT NULL DEFAULT '0' COMMENT 'Count',
     `updated_at` timestamp NULL DEFAULT NULL COMMENT ' Update Time',
     PRIMARY KEY (`type`, `value`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Count Login Attempts';

And if you may have added table prefix, then the name of the table will be "magento2.captcha_log".

I hope it helps.