MySQL Forums
Forum List  »  InnoDB

Error 139 from storage engine
Posted by: sirajudeen j
Date: January 10, 2013 03:51AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Error 139 from storage engine
2053
January 10, 2013 03:51AM
874
January 11, 2013 08:16AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.