I have migrated all magento files and database on other server but it keep showing me error message.
Error message:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'boudois5_boudoir1.tag' doesn't exist, query was: SELECT `tag_summary`.`popularity`, `tag`.* FROM `tag_summary`
INNER JOIN `tag` ON tag.tag_id = tag_summary.tag_id AND tag.status = 1 WHERE (tag_summary.store_id = '1') AND (tag_summary.products > 0) ORDER BY `popularity` DESC LIMIT 20
Website is : http://goo.gl/gqzVuc
I have created new table by sql query but still showing me same error...
This was my sql query and it was successful
CREATE TABLE IF NOT EXISTS `boudois5_boudoir1.tag` (
`tag_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Tag Id',
`store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
`customers` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Customers',
`products` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Products',
`uses` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Uses',
`historical_uses` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Historical Uses',
`popularity` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Popularity',
`base_popularity` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Base Popularity',
PRIMARY KEY (`tag_id`,`store_id`),
KEY `IDX_TAG_SUMMARY_STORE_ID` (`store_id`),
KEY `IDX_TAG_SUMMARY_TAG_ID` (`tag_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='boudois5 boudoir1.tag';
Help me out to fix it
Thanks
