你好,我(QQ:58160670)从2013增强升级到2015版时:
提示:
升级失败,详细信息请查看日志文件(D:\MYOA\logs\update)
[2016-05-12 11:16:20]
Query Succeed: delete from `OFFICE_TASK` WHERE TASK_CODE='check_sp';
[2016-05-12 11:16:20]
Query Succeed: SELECT 1 from OFFICE_TASK where TASK_CODE='office_auto'
[2016-05-12 11:16:20]
Query Succeed: INSERT INTO `OFFICE_TASK` (`TASK_TYPE`, `INTERVAL`, `EXEC_TIME`, `LAST_EXEC`, `EXEC_FLAG`, `EXEC_MSG`, `TASK_URL`, `TASK_NAME`, `TASK_DESC`, `TASK_CODE`, `USE_FLAG`, `SYS_TASK`, `EXT_DATA`) VALUES ('2', '3', '04:21:22', '0000-00-00 00:00:00', '0', '', 'OfficeAuto.exe', '检查系统更新', '根据设置对OA进行系统更新检查,可设置为自动下载安装系统更新、仅检查系统更新但不安装、关闭系统更新等。', 'office_auto', '1', '1', '')
[2016-05-12 11:16:21]
Query Succeed: ALTER TABLE `OFFICE_TASK` ADD `EXCEPTION_LOG` TINYINT UNSIGNED NOT NULL DEFAULT '0' COMMENT '执行失败是否记录异常日志(0 不记录,1 记录)';
[2016-05-12 11:16:21]
Query Succeed: update `OFFICE_TASK` set EXCEPTION_LOG=1 WHERE TASK_CODE='office_auto' or TASK_CODE like 'db_backup%';
[2016-05-12 11:16:21]
Query Succeed: CREATE TABLE IF NOT EXISTS `user_function` (
`uid` int unsigned NOT NULL COMMENT '对应user表的UID',
`user_id` varchar(20) NOT NULL DEFAULT '' COMMENT '对应user表的USER_ID',
`user_func_id_str` text NOT NULL COMMENT '用户菜单ID串',
PRIMARY KEY (`uid`),
UNIQUE KEY `user_id` (`user_id`)
) ENGINE=InnoDB COMMENT='用户完整菜单权限表';
[2016-05-12 11:16:21]
Query Succeed: SELECT UID,USER_ID,FUNC_ID_STR FROM user,user_priv WHERE user.USER_PRIV=user_priv.USER_PRIV OR find_in_set(user_priv.USER_PRIV,user.USER_PRIV_OTHER)
[2016-05-12 11:16:21]
Query Succeed: SELECT user_func_id_str FROM user_function WHERE uid='1'
[2016-05-12 11:16:21]
Query Succeed: INSERT INTO user_function(uid,user_id,user_func_id_str) VALUES ('1','admin','1,3,42,643,644,634,4,147,148,7,8,9,10,16,11,130,5,131,132,256,229,182,183,194,637,24,196,105,119,80,81,220,96,97,98,114,126,179,127,128,199,238,251,539,108,109,110,112,51,53,54,153,217,52,150,239,240,85,86,87,88,89,137,138,222,90,91,92,152,93,94,95,118,237,106,43,17,18,19,15,76,115,185,235,535,27,60,61,481,482,483,484,485,486,487,488,489,490,491,492,120,494,495,496,497,498,499,500,501,502,503,505,504,26,506,507,508,515,537,122,123,124,628,125,630,631,632,633,55,514,509,29,28,129,510,511,224,39,512,513,252,230,231,232,629,233,234,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,200,202,201,203,204,205,206,207,208,209,580,581,582,583,584,586,585,587,590,589,588,591,592,593,594,595,596,598,597,599,241,242,243,244,245,246,247,248,249,259,186,187,188,189,190,191,606,192,193,221,550,551,552,553,554,555,556,557,558,546,62,63,48,47,49,50,25,35,532,627,543,531,545,608,250,542,624,610,611,612,613,625,614,615,616,617,618,619,620,621,622,623,548,640,641,642,549,601,600,602,603,604,46,21,22,20,79,23,45,82,83,227,56,30,31,33,32,134,37,135,136,226,253,254,255,536,57,103,146,107,197,228,258,36,77,116,58,538,151,6,534,34,218,219,223,639,225,236,78,178,104,121,149,84,99,100,533,101,113,198,540,626,638,38,1001,1002,1003,1004,');
[2016-05-12 11:16:21]
Query Succeed: SELECT user_func_id_str FROM user_function WHERE uid='1'
[2016-05-12 11:16:21]
Query Succeed: UPDATE user_function SET user_func_id_str='1,3,42,643,644,634,4,147,148,7,8,9,10,16,11,130,5,131,132,256,229,182,183,194,637,24,196,105,119,80,81,220,96,97,98,114,126,179,127,128,199,238,251,539,108,109,110,112,51,53,54,153,217,52,150,239,240,85,86,87,88,89,137,138,222,90,91,92,152,93,94,95,118,237,106,43,17,18,19,15,76,115,185,235,535,27,60,61,481,482,483,484,485,486,487,488,489,490,491,492,120,494,495,496,497,498,499,500,501,502,503,505,504,26,506,507,508,515,537,122,123,124,628,125,630,631,632,633,55,514,509,29,28,129,510,511,224,39,512,513,252,230,231,232,629,233,234,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,200,202,201,203,204,205,206,207,208,209,580,581,582,583,584,586,585,587,590,589,588,591,592,593,594,595,596,598,597,599,241,242,243,244,245,246,247,248,249,259,186,187,188,189,190,191,606,192,193,221,550,551,552,553,554,555,556,557,558,546,62,63,48,47,49,50,25,35,532,627,543,531,545,608,250,542,624,610,611,612,613,625,614,615,616,617,618,619,620,621,622,623,548,640,641,642,549,601,600,602,603,604,46,21,22,20,79,23,45,82,83,227,56,30,31,33,32,134,37,135,136,226,253,254,255,536,57,103,146,107,197,228,258,36,77,116,58,538,151,6,534,34,218,219,223,639,225,236,78,178,104,121,149,84,99,100,533,101,113,198,540,626,638,38,1001,1002,1003,1004,' WHERE uid='1';
[2016-05-12 11:16:21]
Query Succeed: SELECT user_func_id_str FROM user_function WHERE uid='2'
[2016-05-12 11:16:21]
Query Succeed: INSERT INTO user_function(uid,user_id,user_func_id_str) VALUES ('2','杨桂云','1,3,42,634,4,147,148,7,8,9,10,16,11,130,5,131,132,256,229,182,194,24,196,105,119,80,81,96,97,98,126,179,199,108,112,51,53,54,52,150,85,86,87,90,91,92,152,106,43,17,18,19,15,76,115,185,235,27,60,61,120,506,507,508,122,125,55,129,234,186,187,188,189,190,193,62,63,48,47,49,50,25,1001,1002,1003,1004,46,21,22,20,79,23,45,82,83,56,33,');
[2016-05-12 11:16:21]
Query Succeed: SELECT user_func_id_str FROM user_function WHERE uid='3'
|