mysql 有很多找不到表的报错

xhf_5

Table 'crscell.crs_quick_reportstate' doesn't exist  这个表是什么作用版本Office Anywhere 2016版 白金完美版，MySQL 5.6.29 标准版



[2020-03-17 15:30:59]
错误#1146: Table 'crscell.crs_quick_reportstate' doesn't exist
SQL语句: select * from crscell.crs_quick_reportstate where find_in_set(repid, '996,1006,1008,1018,1019,1020,1027,1028,1029,1030,1031,1032,1033,1034,1039,1045,1046,1047,1048,1049,1057,1061,1066,1101,1102,1115,1148,1149,1153,1154,1156,1158,1166,1167,1169,1221,1222,1223,1224,1225,1226,1227,1228,1229,1230,1231,1232,1233,1234,1235,1240,1241,1242,1243,1244,1245,1246,1247,1248,1249,1251,1262,1263,1264,1265,1266,1267,1268,1269,1270,1271,1272,1273,1274,') and
                (writer='admin' or find_in_set(writer, '')) and finished'Y' order by repid, writetime desc, stateid desc
文件：/portal/personal/count.php?OUTPUT=1&MODULE_ID_STR=email%2Cnews%2Cnotify%2Cworkflow%2Ccalendar%2Cvote%2Cdiary%2Cattendance%2Cbbs%2Creportshop%2Cmeeting%2Cvehicle%2Cbook%2Casset%2Csource%2Coffice_product%2Cattendance%2Cnotify%2C


[2019-09-17 10:27:51]
错误#1146: Table 'crscell.crs_quick_reportstate' doesn't exist
SQL语句: select * from crscell.crs_quick_reportstate where find_in_set(repid, '996,1006,1008,1018,1019,1020,1027,1028,1029,1030,1031,1032,1033,1034,1039,1045,1046,1047,1048,1049,1057,1061,1066,1101,1102,1115,1148,1149,1153,1154,1156,1158,1166,1167,1169,1221,1222,1223,1224,1225,1226,1227,1228,1229,1230,1231,1232,1233,1234,1235,1240,1241,1242,1243,1244,1245,1246,1247,1248,1249,1251,1262,1263,1264,1265,1266,1267,1268,1269,1270,1271,1272,1273,1274,') and
                (writer='admin' or find_in_set(writer, '')) and finished'Y' order by repid, writetime desc, stateid desc
文件：/portal/personal/count.php?OUTPUT=1&MODULE_ID_STR=email%2Cnews%2Cnotify%2Cworkflow%2Ccalendar%2Cvote%2Cdiary%2Cattendance%2Cbbs%2Creportshop%2Cmeeting%2Cvehicle%2Cbook%2Casset%2Csource%2Coffice_product%2Cattendance%2Cnotify%2C


[2019-07-25 07:36:22]
错误#1146: Table 'crscell.crs_quick_reportstate' doesn't exist
SQL语句: select * from crscell.crs_quick_reportstate where find_in_set(repid, '996,1006,1008,1018,1019,1020,1027,1028,1029,1030,1031,1032,1033,1034,1039,1045,1046,1047,1048,1049,1057,1061,1066,1101,1102,1115,1148,1149,1153,1154,1156,1158,1166,1167,1169,1221,1222,1223,1224,1225,1226,1227,1228,1229,1230,1231,1232,1233,1234,1235,1240,1241,1242,1243,1244,1245,1246,1247,1248,1249,1251,1262,1263,1264,1265,1266,1267,1268,1269,1270,1271,1272,1273,1274,') and
                (writer='admin' or find_in_set(writer, '')) and finished'Y' order by repid, writetime desc, stateid desc
文件：/portal/personal/count.php?OUTPUT=1&MODULE_ID_STR=email%2Cnews%2Cnotify%2Cworkflow%2Ccalendar%2Cvote%2Cdiary%2Cattendance%2Cbbs%2Creportshop%2Cmeeting%2Cvehicle%2Cbook%2Casset%2Csource%2Coffice_product%2Cattendance%2Cnotify%2C

通达李芯

您好！该报错是指crscell库中缺少crs_quick_reportstate表。您可以到备份数据中找一下有没有这个表，有的话可以在服务控制中心使用数据库恢复工具进行恢复，如果恢复时有报错，可以把MYOA\data5\crscell下的crs_quick_reportstate文件剪切出来再尝试恢复。如果没有备份数据的话，可以找一台测试机安装2016版本的OA把这个表导出来进行恢复。操作之前需备份data5数据！

万达广场

通达李芯 发表于 2020-3-17 18:02
您好！该报错是指crscell库中缺少crs_quick_reportstate表。您可以到备份数据中找一下有没有这个表，有的话 ...

我的别的表也是这个报错，用你你的方法，不行，恢复不了。

通达李芯

万达广场 发表于 2020-3-18 17:01
我的别的表也是这个报错，用你你的方法，不行，恢复不了。

您要是恢复有问题的话，可以留一下您的QQ，帮您看一下。