新建流程和处理流程的时候报错：
新建流程和处理流程的时候报错：数据有做个迁移到另外一台电脑上，出现了这个问题，请问怎么解决已更新到最新版的OA2017
错误#1813: Tablespace for table '`td_oa`.`flow_data_233`' exists. Please DISCARD the tablespace before IMPORT.
SQL语句:create table if not exists flow_data_233 (
`id` int(10) not null auto_increment,
`run_id` int(10) not null default '0',
`run_name` varchar(200) not null default '',
`begin_user` varchar(20) not null default '',
`begin_time` datetime null,
`flow_auto_num` int(11) not null default '0',
`flow_auto_num_year` int(11) not null default '0',
`flow_auto_num_month` int(11) not null default '0', `data_105` text not null default '', `data_107` text not null default '', `data_106` text not null default '', `data_108` text not null default '', `data_102` text not null default '', `data_112` text not null default '', `data_113` text not null default '', `data_114` text not null default '', `data_115` text not null default '', `data_117` text not null default '', `data_118` text not null default '', primary key(id),
unique key(run_id) );
文件：/general/workflow/new/edit.php?FLOW_ID=233&AUTO_NEW=1
错误#1813: Tablespace for table '`td_oa`.`flow_data_233`' exists. Please DISCARD the tablespace before IMPORT.
SQL语句:create table if not exists flow_data_233 (
`id` int(10) not null auto_increment,
`run_id` int(10) not null default '0',
`run_name` varchar(200) not null default '',
`begin_user` varchar(20) not null default '',
`begin_time` datetime null,
`flow_auto_num` int(11) not null default '0',
`flow_auto_num_year` int(11) not null default '0',
`flow_auto_num_month` int(11) not null default '0', `data_105` text not null default '', `data_107` text not null default '', `data_106` text not null default '', `data_108` text not null default '', `data_102` text not null default '', `data_112` text not null default '', `data_113` text not null default '', `data_114` text not null default '', `data_115` text not null default '', `data_117` text not null default '', `data_118` text not null default '', primary key(id),
unique key(run_id) );
文件：/general/workflow/new/edit.php?FLOW_ID=233&AUTO_NEW=1
错误#1813: Tablespace for table '`td_oa`.`flow_data_249`' exists. Please DISCARD the tablespace before IMPORT.
SQL语句:create table if not exists flow_data_249 (
`id` int(10) not null auto_increment,
`run_id` int(10) not null default '0',
`run_name` varchar(200) not null default '',
`begin_user` varchar(20) not null default '',
`begin_time` datetime null,
`flow_auto_num` int(11) not null default '0',
`flow_auto_num_year` int(11) not null default '0',
`flow_auto_num_month` int(11) not null default '0', `data_53` text not null default '', `data_57` text not null default '', `data_54` text not null default '', `data_55` text not null default '', `data_56` text not null default '', `data_49` text not null default '', `data_58` text not null default '', `data_59` text not null default '', `data_60` text not null default '', `data_61` text not null default '', `data_62` text not null default '', `data_63` text not null default '', primary key(id),
unique key(run_id) );
文件：/general/workflow/new/edit.php?FLOW_ID=249&AUTO_NEW=1
错误#1146: Table 'td_oa.flow_data_249' doesn't exist
SQL语句:select * from flow_data_249 where run_id='33235' limit 1
文件：/general/workflow/list/input_form/?actionType=handle&MENU_FLAG=&RUN_ID=33235&PRCS_KEY_ID=121900&FLOW_ID=249&PRCS_ID=1&FLOW_PRCS=1
错误#1146: Table 'td_oa.flow_data_249' doesn't exist
SQL语句: select * from FLOW_DATA_249 where RUN_ID='33235'
文件：/general/workflow/list/input_form/work_handle.php?actionType=handle&menu_flag=&run_id=33235&prcs_key_id=121900&flow_id=249&prcs_id=1&flow_prcs=1&AUTO_NEW=0&getdata_search=&=
您好，根据报错日志显示，td_oa库下缺少flow_data_233表，建议可安装一下数据库管理工具看下是否存在该表，如不存在的话，建议单独从热备份数据中恢复一下此表。 查询数据库有该表：flow_data_233。数据库我是恢复原来的数据，恢复是正常的，有其他原因吗
您好，检查一下OA安装目录下的myoa/data5下的td_oa库下的flow_data_233是否有两个，后缀是frm和idb，如存在一个文件，建议把data5做好备份，手动把flow_data_233表剪切到桌面，通过热备份数据单独恢复下。
页:
[1]