cancel
Showing results for 
Search instead for 
Did you mean: 

Magento 1.9 migration to other server keep showing error

Magento 1.9 migration to other server keep showing error

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

1 REPLY

Re: Magento 1.9 migration to other server keep showing error

Two questions: do you have database boudois5_boudoir1 on new server and does Magento database user have access to it?

Tanel Raja