I created custom product attributes in custom module. when Add new product is clicked it shows this error message.
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento2_dev.catalog_product_entity_integer' doesn't exist
Magento – SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘magento2.catalog_product_entity_integer’ doesn’t exist
magento2
Related Solutions
In order to resolve this issue,you need to create flat table catalog_category_flat_store_1.
disable magento Catalog Flat for Category from Admin>Stores>Configuration>Catalog>Catalog>StoreFront>Use Flat Catalog Category make it NO
Then Flush magento Cache by php bin/magento cache:flush
Then you should drop table catalog_category_flat_store_1, if it is exists in db by drop table catalog_category_flat_store_1
Next enable Catalog Flat for Category by Use Flat Catalog Category make it yes
Final,you need to indexing from magento cli : php bin/magento indexer:reindex
Table is missing. Run in sql console below sql query. After run sql query run php bin/magento indexer:reindex
CREATE TABLE `design_config_grid_flat` (
`entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
`store_website_id` int(11) DEFAULT NULL COMMENT 'Store_website_id',
`store_group_id` int(11) DEFAULT NULL COMMENT 'Store_group_id',
`store_id` int(11) DEFAULT NULL COMMENT 'Store_id',
`theme_theme_id` varchar(255) DEFAULT NULL COMMENT 'Theme_theme_id',
PRIMARY KEY (`entity_id`),
KEY `DESIGN_CONFIG_GRID_FLAT_STORE_WEBSITE_ID` (`store_website_id`),
KEY `DESIGN_CONFIG_GRID_FLAT_STORE_GROUP_ID` (`store_group_id`),
KEY `DESIGN_CONFIG_GRID_FLAT_STORE_ID` (`store_id`),
FULLTEXT KEY `DESIGN_CONFIG_GRID_FLAT_THEME_THEME_ID` (`theme_theme_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='design_config_grid_flat';
Best Answer
It seems that you have set
integeras thebackend_typeortypeproperty of your attribute. This is not possible. Normally you would usevarchar, if you want to store numbers, useintordecimalif you want to store prices or weight.You can find the types mentioned in the table
eav_attribute.UPDATE
While you are totally correct that you prefer class constants over strings, imho this does not apply here.
\Magento\Framework\DB\Ddl\Table::TYPE_INTEGERshould be used when you create or modify columns of a database table. This is not the case, though, when you create a product attribute. This does not change any table structure, but only adds a new row toeav_attributeandcatalog_eav_attribute.If you look, for example, into
\Magento\Catalog\Setup\CategorySetup, you will find that even here thetypeattribute is written as the string "int". So, I guess it's totally fine if you do it like this in your own module.