- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Got a site updated all the way from 1.4 to 1.6 then 1.7 but going to 1.9.2 I get an error when logging into admin - the crucial part is:
sales_bestsellers_aggregated_yearly' doesn't exist
...and indeed the table does not exist in the database. Any ideas?
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Please find below the create table syntax for that table. I'd be concerned that there would be other tables missing though - so I would recommend running your database through the Magento database repair tool available at:
http://www.magentocommerce.com/download
CREATE TABLE `sales_bestsellers_aggregated_yearly` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Id', `period` date DEFAULT NULL COMMENT 'Period', `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store Id', `product_id` int(10) unsigned DEFAULT NULL COMMENT 'Product Id', `product_name` varchar(255) DEFAULT NULL COMMENT 'Product Name', `product_price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Product Price', `qty_ordered` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Qty Ordered', `rating_pos` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Rating Pos', PRIMARY KEY (`id`), UNIQUE KEY `UNQ_SALES_BESTSELLERS_AGGRED_YEARLY_PERIOD_STORE_ID_PRD_ID` (`period`,`store_id`,`product_id`), KEY `IDX_SALES_BESTSELLERS_AGGREGATED_YEARLY_STORE_ID` (`store_id`), KEY `IDX_SALES_BESTSELLERS_AGGREGATED_YEARLY_PRODUCT_ID` (`product_id`), CONSTRAINT `FK_SALES_BESTSELLERS_AGGRED_YEARLY_PRD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `FK_SALES_BESTSELLERS_AGGRED_YEARLY_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='Sales Bestsellers Aggregated Yearly';
Magento Certified Developer Plus | www.iwebsolutions.co.uk | Magento Small Business Partner
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Please find below the create table syntax for that table. I'd be concerned that there would be other tables missing though - so I would recommend running your database through the Magento database repair tool available at:
http://www.magentocommerce.com/download
CREATE TABLE `sales_bestsellers_aggregated_yearly` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Id', `period` date DEFAULT NULL COMMENT 'Period', `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store Id', `product_id` int(10) unsigned DEFAULT NULL COMMENT 'Product Id', `product_name` varchar(255) DEFAULT NULL COMMENT 'Product Name', `product_price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Product Price', `qty_ordered` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Qty Ordered', `rating_pos` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Rating Pos', PRIMARY KEY (`id`), UNIQUE KEY `UNQ_SALES_BESTSELLERS_AGGRED_YEARLY_PERIOD_STORE_ID_PRD_ID` (`period`,`store_id`,`product_id`), KEY `IDX_SALES_BESTSELLERS_AGGREGATED_YEARLY_STORE_ID` (`store_id`), KEY `IDX_SALES_BESTSELLERS_AGGREGATED_YEARLY_PRODUCT_ID` (`product_id`), CONSTRAINT `FK_SALES_BESTSELLERS_AGGRED_YEARLY_PRD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `FK_SALES_BESTSELLERS_AGGRED_YEARLY_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='Sales Bestsellers Aggregated Yearly';
Magento Certified Developer Plus | www.iwebsolutions.co.uk | Magento Small Business Partner
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Last Stage of upgrade to 1.9.2
Thank you - that solved my problem. I have many others but that one was really giving me a headache!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Last Stage of upgrade to 1.9.2
Hi,
Please use Magento's Database repair tool to repair database. You can download from https://www.magentocommerce.com/download.
This will help you to repair other missing fields and tables.
Opal Infotech,
Skype : professionalseo
www.webmasterindia.com
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Last Stage of upgrade to 1.9.2
I normaly upgrade to 1.8 then to 1.9.
Also at the 1.8 stage you need to remove google checkout.
See this for more:
http://sherodesigns.com/magento-how-to-safely-upgrade-from-1-7-to-1-9/
Regards
Jeff