| 主题 : 无法设置权限 请帮忙解决一下 |
级别: 举人
 |
1# 发表于:2021-11-26 11:08:46 IP:59.62.*.*
|
||||
|---|---|---|---|---|---|
级别: 举人
|
3# 发表于:2021-11-29 09:38:57 IP:59.62.*.*
该帖子已被屏蔽，仅版主可见
|
||
|---|---|---|---|
级别: 总版主
 |
4# 发表于:2021-11-29 10:45:35 IP:111.200.*.*
|
||
|---|---|---|---|
级别: 举人
|
5# 发表于:2021-11-29 10:47:42 IP:59.62.*.*
回复第4楼
好的 我试试 |
||
|---|---|---|---|
级别: 举人
|
6# 发表于:2021-11-29 10:50:08 IP:59.62.*.*
回复第4楼
所有的sql语句都要执行一次吗 |
||
|---|---|---|---|
级别: 举人
|
7# 发表于:2021-11-29 11:23:13 IP:59.62.*.*
#清理错误的组织id
update jc_sys_data_perm set org_id =null where role_id is not null or user_id is not null; 受影响的行: 0 时间: 0.027s [SQL] delete FROM jc_sys_data_perm WHERE data_type IN ( 2, 3 ) AND data_id IN ( SELECT channel_id FROM jc_channel WHERE deleted_flag = 1 ); 受影响的行: 0 时间: 0.016s [SQL] delete FROM jc_sys_data_perm WHERE data_type IN ( 2, 3 ) AND data_id not IN ( SELECT channel_id FROM jc_channel ); 受影响的行: 36 时间: 0.024s [SQL] delete FROM jc_sys_data_perm where org_id in ( SELECT id FROM jc_sys_org WHERE deleted_flag = 1 ); 受影响的行: 42 时间: 0.015s [SQL] delete FROM jc_sys_data_perm where org_id not in ( SELECT id FROM jc_sys_org ); 受影响的行: 0 时间: 0.012s [SQL] delete FROM jc_sys_data_perm where role_id in ( SELECT id FROM jc_sys_role WHERE deleted_flag = 1 ); 受影响的行: 0 时间: 0.013s [SQL] delete FROM jc_sys_data_perm where role_id not in ( SELECT id FROM jc_sys_role ); 受影响的行: 0 时间: 0.011s [SQL] delete FROM jc_sys_data_perm where role_id in ( SELECT id FROM jc_sys_role WHERE deleted_flag = 1 ); 受影响的行: 0 时间: 0.012s [SQL] delete FROM jc_sys_data_perm where user_id not in ( SELECT id FROM jc_sys_user ); 受影响的行: 0 时间: 0.014s [SQL] delete FROM jc_sys_data_perm where user_id in ( SELECT id FROM jc_sys_user WHERE deleted_flag = 1 ); 受影响的行: 621 时间: 0.024s [SQL] delete FROM jc_sys_data_perm where user_id not in ( SELECT id FROM jc_sys_user ); 受影响的行: 0 时间: 0.011s [SQL] delete FROM jc_sys_perm_cfg where org_id in ( SELECT id FROM jc_sys_org WHERE deleted_flag = 1 ); 受影响的行: 2 时间: 0.013s [SQL] delete FROM jc_sys_perm_cfg where org_id not in ( SELECT id FROM jc_sys_org ); 受影响的行: 4 时间: 0.013s [SQL] delete FROM jc_sys_perm_cfg where role_id in ( SELECT id FROM jc_sys_role WHERE deleted_flag = 1 ); 受影响的行: 0 时间: 0.010s [SQL] delete FROM jc_sys_perm_cfg where role_id not in ( SELECT id FROM jc_sys_role ); 受影响的行: 5 时间: 0.012s [SQL] delete FROM jc_sys_perm_cfg where user_id not in ( SELECT id FROM jc_sys_user ); 受影响的行: 0 时间: 0.010s [SQL] delete FROM jc_sys_perm_cfg where user_id in ( SELECT id FROM jc_sys_user WHERE deleted_flag = 1 ); 受影响的行: 3 时间: 0.012s [SQL] #清理错误栏目 update jc_channel set deleted_flag =1 where site_id in(select id from jc_site where is_delete =1); 受影响的行: 0 时间: 0.010s [SQL] delete FROM jc_sys_data_perm where data_type in(2,3) and data_id in ( SELECT channel_id FROM jc_channel where deleted_flag =1 ); 受影响的行: 0 时间: 0.012s [SQL] delete FROM jc_sys_data_perm where data_type=1 and data_id in ( SELECT id FROM jc_site where deleted_flag =1 ); 受影响的行: 0 时间: 0.012s [SQL] delete from jc_tr_menu_api where menu_management_id not in(select id from jc_sys_menu); 受影响的行: 0 时间: 0.012s [SQL] delete from jc_tr_menu_api where api_body_information_id not in(select id from jc_sys_api); 受影响的行: 0 时间: 0.011s [SQL] delete from jc_tr_org_menu where menu_id not in(select id from jc_sys_menu); 受影响的行: 0 时间: 0.010s [SQL] delete from jc_tr_role_menu where menu_id not in(select id from jc_sys_menu); 受影响的行: 0 时间: 0.011s [SQL] delete from jc_tr_user_menu where menu_id not in(select id from jc_sys_menu); 受影响的行: 0 时间: 0.011s |
||
|---|---|---|---|
级别: 举人
|
8# 发表于:2021-11-29 11:29:24 IP:59.62.*.*
回复第4楼
已经全执行了 但是权限还是看不到栏目 
|
||
|---|---|---|---|
级别: 举人
|
9# 发表于:2021-11-29 11:31:46 IP:59.62.*.*
回复第4楼
数据库地址我也可以给你 |
||
|---|---|---|---|