Error 139 from storage engine
Dear all,
I have just execute this query but it has given 139 error.Please do needful.
DROP TABLE IF EXISTS PLAN_TEXT`;
CREATE TABLE PLAN_TEXT` (
`HOTEL_ID` varchar(10) NOT NULL DEFAULT '',
`PLAN_ID` varchar(10) NOT NULL DEFAULT '',
`LANG_ID` varchar(2) NOT NULL DEFAULT '',
`TEMP_TYPE_1` varchar(3) DEFAULT NULL,
`TEMP_CHARGE` varchar(10) DEFAULT NULL,
`TEMP_TYPE_2` varchar(3) DEFAULT NULL,
`TEMP_EQUIPMENT` varchar(10) DEFAULT NULL,
`TEMP_TYPE_3` varchar(3) DEFAULT NULL,
`TEMP_MEALS` varchar(10) DEFAULT NULL,
`TEMP_TYPE_4` varchar(3) DEFAULT NULL,
`TEMP_OTHERS` varchar(10) DEFAULT NULL,
`CANCELLATION_ID` varchar(10) DEFAULT NULL,
`SMARTPHONE_USE_FLAG` tinyint(4) DEFAULT NULL,
`PLAN_MANAGE_DETAILS` text,
`PLAN_DISP_NAME` varchar(100) DEFAULT NULL,
`SMARTPHONE_PLAN_DISP_NAME` varchar(100) DEFAULT NULL,
`PLAN_SEARCH_TAB_NAME` varchar(20) DEFAULT NULL COMMENT '?????????',
`PLAN_RES_FRAME_NAME` varchar(40) DEFAULT NULL COMMENT '??\n',
`SMARTPHONE_CHARGE_TITLE` varchar(100) DEFAULT NULL,
`PLAN_CHARGE_SEARCH_TITLE` varchar(40) DEFAULT NULL COMMENT '??\n',
`PLAN_CHARGE_RESERVE_TITLE` varchar(40) DEFAULT NULL COMMENT '??\n',
`PLAN_CHARGE_EXP` varchar(400) DEFAULT NULL,
`PLAN_RESULT_TEXT` text,
`PLAN_EXPLAIN_TEXT` text,
`PLAN_EXPLAIN_ADD_TEXT` text,
`PLAN_ATTENTION_TEXT` text,
`PLAN_EXP_DIGEST_TEXT` text,
`PLAN_SMARTPHONE_EXPLAIN_TEXT` text,
`SMARTPHONE_CATCHCOPY` text,
`PLAN_DETAILS_POPUP_TEXT` varchar(400) DEFAULT NULL COMMENT '?????(????????????)',
`PLAN_ATTENTION_POPUP_TEXT` varchar(400) DEFAULT NULL COMMENT '????(????????????)',
`PLAN_PMS_RESERVE_ROUTE` varchar(40) DEFAULT NULL,
`PLAN_THX_MAIL_FLG` tinyint(4) DEFAULT '0',
`PLAN_THX_MAIL_FROM` varchar(50) DEFAULT NULL,
`PLAN_THX_MAIL_REPLYTO` varchar(50) DEFAULT NULL,
`PLAN_THX_MAIL_BCC` varchar(200) DEFAULT NULL,
`PLAN_THX_MAIL_SUBJECT` varchar(50) DEFAULT NULL,
`PLAN_THX_MAIL_PC_YES_TEXT` longtext,
`PLAN_THX_MAIL_PC_NO_TEXT` longtext,
`PLAN_THX_MAIL_FROM_NAME` varchar(255) DEFAULT NULL,
`PLAN_RES_MAIL_FROM_NAME` varchar(255) DEFAULT NULL,
`PLAN_RES_MAIL_SUBJECT` varchar(50) DEFAULT NULL,
`PLAN_RES_MAIL_TEXT` longtext,
`PLAN_THX_MAIL_KBN` tinyint(4) NOT NULL DEFAULT '0',
`PLAN_STANDBY_FLG` tinyint(4) DEFAULT '0',
`PLAN_CARD_FLG` tinyint(4) NOT NULL DEFAULT '0',
`PLAN_CARD_COMP_ID` varchar(10) DEFAULT NULL,
`PLAN_AIR_FLG` tinyint(4) DEFAULT '0',
`PLAN_RESULT_DIGEST_TEST` varchar(200) DEFAULT NULL,
`PLAN_ATTENTION_TEXT_DIGEST` text,
`PLAN_ATTENTION_TEXT_SMARTPHONE` text,
`PLAN_ATTENTION_TEXT_AIR` text,
`AIR_PDF_CONTENT` text,
`AIR_LOGIN_CONTENT` text,
`SECRET_PLAN_EXP` text,
`PLAN_IMG1_CAPTION` varchar(100) DEFAULT NULL,
`PLAN_IMG2_CAPTION` varchar(100) DEFAULT NULL,
`PLAN_IMG3_CAPTION` varchar(100) DEFAULT NULL,
`PLAN_IMG4_CAPTION` varchar(100) DEFAULT NULL,
`PLAN_IMG5_CAPTION` varchar(100) DEFAULT NULL,
`PLAN_PC_IMG1_CAPTION` varchar(150) DEFAULT NULL,
`PLAN_PC_IMG2_CAPTION` varchar(150) DEFAULT NULL,
`PLAN_PC_IMG3_CAPTION` varchar(150) DEFAULT NULL,
`PLAN_PC_IMG4_CAPTION` varchar(150) DEFAULT NULL,
`PLAN_PC_IMG5_CAPTION` varchar(150) DEFAULT NULL,
`PLAN_EQUIP_TEXT` varchar(1000) DEFAULT NULL,
`PLAN_MEAL_TEXT` varchar(1000) DEFAULT NULL,
`PLAN_OTHER_TEXT` varchar(1000) DEFAULT NULL,
`PLAN_ABOUT_CANCEL` text,
`CHARGE_DISPLAY_FLAG` tinyint(4) NOT NULL DEFAULT '1',
`RESTAURANT_MANDATORY_FLG` tinyint(4) DEFAULT NULL,
`OPTION_RESTAURANT_ID` varchar(10) DEFAULT NULL,
`RESTAURANT_DISP_PREF` varchar(2) DEFAULT NULL,
`RESTAURANT_BLOCK_CODE` varchar(10) DEFAULT NULL,
`RESTAURANT_BLOCK_CODE_PREF` varchar(2) DEFAULT NULL,
`CREATED_BY` varchar(50) NOT NULL DEFAULT '',
`CREATED_DATE` datetime DEFAULT NULL,
`MODIFIED_BY` varchar(50) NOT NULL DEFAULT '',
`MODIFIED_DATE` datetime DEFAULT NULL,
`DEL_FLG` tinyint(1) NOT NULL DEFAULT '0',
`PLAN_RES_MAIL_FROM_KBN` tinyint(4) NOT NULL DEFAULT '0',
`PLAN_RES_MAIL_FROM` varchar(50) DEFAULT NULL,
`PLAN_RES_MAIL_TO` varchar(200) DEFAULT NULL,
`PLAN_RES_MAIL_BCC` varchar(200) DEFAULT NULL,
`PLAN_RES_MAIL_FLG` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`HOTEL_ID`,`PLAN_ID`,`LANG_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
QUERY:
UPDATE PLAN_TEXT
SET PLAN_ATTENTION_TEXT_AIR=PLAN_ATTENTION_TEXT
WHERE HOTEL_ID IN('0000000010');
Regards
Siraj.j