Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

How to solve Reindexing problem in magento Use three step in magento database (mysql) and Solve Re-indexing Problem
 
mukeshpti
Jr. Member
 
Total Posts:  1
Joined:  2013-08-29
 

How to solve Reindexing problem in magento
Use three step in magento database (mysql) and Solve Re-indexing Problem

// First step Start ///////

DROP TABLE IF EXISTS `index_process_event`;
DROP TABLE IF EXISTS `index_event`;
DROP TABLE IF EXISTS `index_process`;

//first step Complete///////

// Second step Start /////

CREATE TABLE `index_event` (
`event_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`type` VARCHAR(64) NOT NULL,
`entity` VARCHAR(64) NOT NULL,
`entity_pk` BIGINT(20) DEFAULT NULL,
`created_at` DATETIME NOT NULL,
`old_data` MEDIUMTEXT,
`new_data` MEDIUMTEXT,
PRIMARY KEY (`event_id`),
UNIQUE KEY `IDX_UNIQUE_EVENT` (`type`,`entity`,`entity_pk`)
) ENGINE=INNODB DEFAULT CHARSET=utf8;

CREATE TABLE `index_process` (
`process_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`indexer_code` VARCHAR(32) NOT NULL,
`status` ENUM(’pending’,’working’,’require_reindex’) NOT NULL DEFAULT ‘pending’,
`started_at` DATETIME DEFAULT NULL,
`ended_at` DATETIME DEFAULT NULL,
`mode` ENUM(’real_time’,’manual’) NOT NULL DEFAULT ‘real_time’,
PRIMARY KEY (`process_id`),
UNIQUE KEY `IDX_CODE` (`indexer_code`)
) ENGINE=INNODB DEFAULT CHARSET=utf8;

///second step complete//////////////////

// Third step complete complete //////

INSERT INTO `index_process`(`process_id`,`indexer_code`,`status`,`started_at`,`ended_at`,`mode`) VALUES (1,’catalog_product_attribute’,’pending’,’2010-02-13 00:00:00’,’2010-02-13 00:00:00’,’real_time’),(2,’catalog_product_price’,’pending’,’2010-02-13 00:00:00’,’2010-02-13 00:00:00’,’real_time’),(3,’catalog_url’,’pending’,’2010-02-13 19:12:15’,’2010-02-13 19:12:15’,’real_time’),(4,’catalog_product_flat’,’pending’,’2010-02-13 00:00:00’,’2010-02-13 00:00:00’,’real_time’),(5,’catalog_category_flat’,’pending’,’2010-02-13 00:00:00’,’2010-02-13 00:00:00’,’real_time’),(6,’catalog_category_product’,’pending’,’2010-02-13 00:00:00’,’2010-02-13 00:00:00’,’real_time’),(7,’catalogsearch_fulltext’,’pending’,’2010-02-13 00:00:00’,’2010-02-13 00:00:00’,’real_time’),(8,’cataloginventory_stock’,’pending’,’2010-02-13 00:00:00’,’2010-02-13 00:00:00’,’real_time’);

CREATE TABLE `index_process_event` (
`process_id` INT(10) UNSIGNED NOT NULL,
`event_id` BIGINT(20) UNSIGNED NOT NULL,
`status` ENUM(’new’,’working’,’done’,’error’) NOT NULL DEFAULT ‘new’,
PRIMARY KEY (`process_id`,`event_id`),
KEY `FK_INDEX_EVNT_PROCESS` (`event_id`),
CONSTRAINT `FK_INDEX_EVNT_PROCESS` FOREIGN KEY (`event_id`) REFERENCES `index_event` (`event_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_INDEX_PROCESS_EVENT` FOREIGN KEY (`process_id`) REFERENCES `index_process` (`process_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=INNODB DEFAULT CHARSET=utf8;

///Third step complete complete //////////////////

 
Magento Community Magento Community
Magento Community
Magento Community
 
MukeshSaini
Member
 
Avatar
Total Posts:  33
Joined:  2011-06-26
jaipur
 

How to solve Reindexing problem in magento
Use three step in magento database (mysql) and Solve Re-indexing Problem

More Info :-

http://mukeshbagri.blogspot.in/2013/06/how-to-slove-reindexing-problem-in.html

// First step Start ///////

DROP TABLE IF EXISTS `index_process_event`; 
DROP TABLE IF EXISTS `index_event`; 
DROP TABLE IF EXISTS `index_process`;

//first step Complete///////

// Second step Start /////

CREATE TABLE `index_event` ( 
`
event_idBIGINT(20UNSIGNED NOT NULL AUTO_INCREMENT
`
typeVARCHAR(64NOT NULL
`
entityVARCHAR(64NOT NULL
`
entity_pkBIGINT(20) DEFAULT NULL
`
created_atDATETIME NOT NULL
`
old_dataMEDIUMTEXT
`
new_dataMEDIUMTEXT
PRIMARY KEY (`event_id`), 
UNIQUE KEY `IDX_UNIQUE_EVENT` (`type`,`entity`,`entity_pk`) 
ENGINE=INNODB DEFAULT CHARSET=utf8;

CREATE TABLE `index_process` ( 
`
process_idINT(10UNSIGNED NOT NULL AUTO_INCREMENT
`
indexer_codeVARCHAR(32NOT NULL
`
statusENUM(’pending’,’working’,’require_reindex’NOT NULL DEFAULT â€˜pending’
`
started_atDATETIME DEFAULT NULL
`
ended_atDATETIME DEFAULT NULL
`
modeENUM(’real_time’,’manual’NOT NULL DEFAULT â€˜real_time’
PRIMARY KEY (`process_id`), 
UNIQUE KEY `IDX_CODE` (`indexer_code`) 
ENGINE=INNODB DEFAULT CHARSET=utf8;

///second step complete//////////////////

// Third step complete complete //////

INSERT INTO `index_process`(`process_id`,`indexer_code`,`status`,`started_at`,`ended_at`,`mode`) VALUES (1,’catalog_product_attribute’,’pending’,’2010-02-13 00:00:00’,’2010-02-13 00:00:00’,’real_time’),(2,’catalog_product_price’,’pending’,’2010-02-13 00:00:00’,’2010-02-13 00:00:00’,’real_time’),(3,’catalog_url’,’pending’,’2010-02-13 19:12:15’,’2010-02-13 19:12:15’,’real_time’),(4,’catalog_product_flat’,’pending’,’2010-02-13 00:00:00’,’2010-02-13 00:00:00’,’real_time’),(5,’catalog_category_flat’,’pending’,’2010-02-13 00:00:00’,’2010-02-13 00:00:00’,’real_time’),(6,’catalog_category_product’,’pending’,’2010-02-13 00:00:00’,’2010-02-13 00:00:00’,’real_time’),(7,’catalogsearch_fulltext’,’pending’,’2010-02-13 00:00:00’,’2010-02-13 00:00:00’,’real_time’),(8,’cataloginventory_stock’,’pending’,’2010-02-13 00:00:00’,’2010-02-13 00:00:00’,’real_time’);

CREATE TABLE `index_process_event` ( 
`
process_idINT(10UNSIGNED NOT NULL
`
event_idBIGINT(20UNSIGNED NOT NULL
`
statusENUM(’new’,’working’,’done’,’error’NOT NULL DEFAULT â€˜new’
PRIMARY KEY (`process_id`,`event_id`), 
KEY `FK_INDEX_EVNT_PROCESS` (`event_id`), 
CONSTRAINT `FK_INDEX_EVNT_PROCESSFOREIGN KEY (`event_id`) REFERENCES `index_event` (`event_id`) ON DELETE CASCADE ON UPDATE CASCADE
CONSTRAINT `FK_INDEX_PROCESS_EVENTFOREIGN KEY (`process_id`) REFERENCES `index_process` (`process_id`) ON DELETE CASCADE ON UPDATE CASCADE 
ENGINE=INNODB DEFAULT CHARSET=utf8;
///Third step complete complete //////////////////

http://mukeshbagri.blogspot.in/2013/06/how-to-slove-reindexing-problem-in.html

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top