#820 Menus with extra permissions (1.3.x)

[Chris Travers]

Via email

Turns out that four additional, out-of-the-box entries were also deleted when running this SQL:

delete from menu_acl where node_id in (select node_id from menu_attribute where attribute = 'menu');

(from Brian Wolf)

[Chris Travers]

mtech_test=# select * from menu_acl where node_id in (select node_id from menu_attribute where attribute = 'menu');
id | role_name | acl_type | node_id
------+----------------------------------------------+----------+---------
8262 | lsmb_mtech_test__orders_purchase_consolidate | allow | 60
8264 | lsmb_mtech_test__orders_sales_consolidate | allow | 60
8354 | public | allow | 192
(3 rows)

mtech_test=# select * from menu_node where id in (select node_id from menu_acl where node_id in (select node_id from menu_attribute where attribute = 'menu'));
id | label | parent | position
-----+-------------+--------+----------
60 | Consolidate | 50 | 5
192 | New Window | 0 | 22
(2 rows)

That new window entry seems fishy to me. The other acls are safe to delete.

[Chris Travers]

svn 5804