We are transitioning over to a new forum platform. Please post new issues there. Existing threads will be dealt with here unless you choose to move them over. Visit the new forum

Forum

Thread tagged as: Problem, Runway

Role Privilege Duplicates

Well here's a new one (for me, anyway):

runway1

runway2

Drew, this is the same site that was having db problems a year ago, which you corrected with some MySQL command wizardry. The site seems to be working great aside from this.

Diagnostics report

HEALTH CHECK

Perch Runway is up to date
PHP 5.6.24 is up to date
MySQL 5.5.54-cll is up to date
Image processing available
SUMMARY INFORMATION

Perch Runway: 2.8.34, PHP: 5.6.24, MySQL: mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $, with PDO
Server OS: Linux, litespeed
Installed apps: content (2.8.34), assets (2.8.34), categories (2.8.34), perch_blog (5.0), perch_forms (1.8.3), collection_2 (2.8.34), collection_3 (2.8.34), collection_1 (2.8.34), perch_members (1.4)
App runtimes: <?php $apps_list = array( 'content', 'categories', 'perch_members', 'perch_blog', 'perch_forms' );
PERCH_LOGINPATH: /easton-admin
PERCH_PATH: /home/eastonevents/public_html/easton-admin
PERCH_CORE: /home/eastonevents/public_html/easton-admin/core
PERCH_RESFILEPATH: /home/eastonevents/public_html/easton-admin/resources
Image manipulation: GD
PHP limits: Max upload 64M, Max POST 64M, Memory: 128M, Total max file upload: 64M
F1: 6a33f95eca3667f9e0c39bf5ca2980fe
Resource folder writeable: Yes
HTTP_HOST: eastonevents.com
DOCUMENT_ROOT: /home/eastonevents/public_html
REQUEST_URI: /easton-admin/core/settings/diagnostics/
SCRIPT_NAME: /easton-admin/core/settings/diagnostics/index.php
Shane Lenzen

Shane Lenzen 18 points

  • 2 years ago
Drew McLellan

Drew McLellan 2637 points
Perch Support

I've seen this once or twice before, but I'm not quite sure why it occurs.

Are you comfortable deleting the duplicates in the database?

Yes, if you think there's no risk to the rest of the site's data or future updates.

Drew McLellan

Drew McLellan 2637 points
Perch Support

No, that should be fine.

Hey Drew, just now getting around to this. I see the duplicate privKeys in the db but I'm not sure which rows to delete. Can you take a look? Here are the tables in CSV:

privID,privKey,privTitle,privOrder
1,perch.login,"Log in",1
2,perch.settings,"Change settings",2
3,perch.users.manage,"Manage users",3
4,perch.updatenotices,"View update notices",4
5,content.regions.delete,"Delete regions",1
6,content.regions.options,"Edit region options",2
7,content.pages.edit,"Edit page details",1
8,content.pages.reorder,"Reorder pages",2
9,content.pages.create,"Add new pages",3
10,content.pages.configure,"Configure page settings",5
11,content.pages.delete,"Delete pages",4
12,content.templates.delete,"Delete master pages",6
13,content.navgroups.configure,"Configure navigation groups",7
14,content.navgroups.create,"Create navigation groups",8
15,content.navgroups.delete,"Delete navigation groups",9
16,content.pages.create.toplevel,"Add new top-level pages",3
17,content.pages.delete.own,"Delete pages they created themselves",4
18,content.templates.configure,"Configure master pages",6
19,content.pages.attributes,"Edit page titles and attributes",6
20,assets.create,"Upload assets",1
21,perch_members,"Manage members",1
22,perch_blog,"Access the blog",1
23,perch_blog.post.create,"Create posts",1
24,perch_blog.post.delete,"Delete posts",1
25,perch_blog.post.publish,"Publish posts",1
26,perch_blog.comments.moderate,"Moderate comments",1
27,perch_blog.comments.enable,"Enable comments on a post",1
28,perch_blog.categories.manage,"Manage categories",1
29,perch_blog.import,"Import data",1
30,perch_blog.authors.manage,"Manage authors",1
31,perch_blog.sections.manage,"Manage sections",1
32,perch_forms,"Access forms",1
33,perch_forms.configure,"Configure forms",1
34,perch_forms.delete,"Delete forms",1
35,assets.create,"Upload assets",1
36,categories.create,"Create new categories",1
37,categories.delete,"Delete categories",2
38,categories.manage,"Manage categories",3
39,categories.sets.create,"Create category sets",4
40,categories.sets.delete,"Delete category sets",5
41,content.navgroups.configure,"Configure navigation groups",7
42,content.navgroups.create,"Create navigation groups",8
43,content.navgroups.delete,"Delete navigation groups",9
44,content.pages.create.toplevel,"Add new top-level pages",3
45,content.pages.delete.own,"Delete pages they created themselves",4
46,content.templates.configure,"Configure master pages",6
47,content.pages.republish,"Republish pages",12
48,content.pages.attributes,"Edit page titles and attributes",6
49,assets.create,"Upload assets",1
50,categories.create,"Create new categories",1
51,categories.delete,"Delete categories",2
52,categories.manage,"Manage categories",3
53,categories.sets.create,"Create category sets",4
54,categories.sets.delete,"Delete category sets",5
55,content.navgroups.configure,"Configure navigation groups",7
56,content.navgroups.create,"Create navigation groups",8
57,content.navgroups.delete,"Delete navigation groups",9
58,content.pages.create.toplevel,"Add new top-level pages",3
59,content.pages.delete.own,"Delete pages they created themselves",4
60,content.templates.configure,"Configure master pages",6
61,content.pages.republish,"Republish pages",12
62,content.pages.attributes,"Edit page titles and attributes",6
63,content.navgroups.configure,"Configure navigation groups",7
64,content.navgroups.create,"Create navigation groups",8
65,content.navgroups.delete,"Delete navigation groups",9
66,content.pages.create.toplevel,"Add new top-level pages",3
67,content.pages.delete.own,"Delete pages they created themselves",4
68,content.templates.configure,"Configure master pages",6
69,content.pages.republish,"Republish pages",12
70,content.pages.attributes,"Edit page titles and attributes",6
71,assets.create,"Upload assets",1
72,categories.create,"Create new categories",1
73,categories.delete,"Delete categories",2
74,categories.manage,"Manage categories",3
75,categories.sets.create,"Create category sets",4
76,categories.sets.delete,"Delete category sets",5
77,content.navgroups.configure,"Configure navigation groups",7
78,content.navgroups.create,"Create navigation groups",8
79,content.navgroups.delete,"Delete navigation groups",9
80,content.pages.create.toplevel,"Add new top-level pages",3
81,content.pages.delete.own,"Delete pages they created themselves",4
82,content.templates.configure,"Configure master pages",6
83,content.pages.republish,"Republish pages",12
84,content.pages.attributes,"Edit page titles and attributes",6
85,assets.create,"Upload assets",1
86,assets.manage,"Manage assets",2
87,categories.create,"Create new categories",1
88,categories.delete,"Delete categories",2
89,categories.manage,"Manage categories",3
90,categories.sets.create,"Create category sets",4
91,categories.sets.delete,"Delete category sets",5
92,content.regions.revert,"Roll back regions",3
93,perch_blog.blogs.manage,"Manage blogs",1
94,content.regions.revert,"Roll back regions",3
95,content.navgroups.configure,"Configure navigation groups",7
96,content.navgroups.create,"Create navigation groups",8
97,content.navgroups.delete,"Delete navigation groups",9
98,content.pages.create.toplevel,"Add new top-level pages",3
99,content.pages.delete.own,"Delete pages they created themselves",4
100,content.templates.configure,"Configure master pages",6
101,content.pages.republish,"Republish pages",12
102,content.pages.attributes,"Edit page titles and attributes",6
103,assets.create,"Upload assets",1
104,assets.manage,"Manage assets",2
105,categories.create,"Create new categories",1
106,categories.delete,"Delete categories",2
107,categories.manage,"Manage categories",3
108,categories.sets.create,"Create category sets",4
109,categories.sets.delete,"Delete category sets",5
110,content.regions.revert,"Roll back regions",3
111,content.navgroups.configure,"Configure navigation groups",7
112,content.navgroups.create,"Create navigation groups",8
113,content.navgroups.delete,"Delete navigation groups",9
114,content.pages.create.toplevel,"Add new top-level pages",3
115,content.pages.delete.own,"Delete pages they created themselves",4
116,content.templates.configure,"Configure master pages",6
117,content.pages.republish,"Republish pages",12
118,content.pages.attributes,"Edit page titles and attributes",6
119,assets.create,"Upload assets",1
120,assets.manage,"Manage assets",2
121,categories.create,"Create new categories",1
122,categories.delete,"Delete categories",2
123,categories.manage,"Manage categories",3
124,categories.sets.create,"Create category sets",4
125,categories.sets.delete,"Delete category sets",5
126,content.regions.revert,"Roll back regions",3
127,content.navgroups.configure,"Configure navigation groups",7
128,content.navgroups.create,"Create navigation groups",8
129,content.navgroups.delete,"Delete navigation groups",9
130,content.pages.create.toplevel,"Add new top-level pages",3
131,content.pages.delete.own,"Delete pages they created themselves",4
132,content.templates.configure,"Configure master pages",6
133,content.pages.republish,"Republish pages",12
134,content.pages.attributes,"Edit page titles and attributes",6
135,assets.create,"Upload assets",1
136,assets.manage,"Manage assets",2
137,categories.create,"Create new categories",1
138,categories.delete,"Delete categories",2
139,categories.manage,"Manage categories",3
140,categories.sets.create,"Create category sets",4
141,categories.sets.delete,"Delete category sets",5
142,content.regions.revert,"Roll back regions",3
143,content.navgroups.configure,"Configure navigation groups",7
144,content.navgroups.create,"Create navigation groups",8
145,content.navgroups.delete,"Delete navigation groups",9
146,content.pages.create.toplevel,"Add new top-level pages",3
147,content.pages.delete.own,"Delete pages they created themselves",4
148,content.templates.configure,"Configure master pages",6
149,content.pages.republish,"Republish pages",12
150,content.pages.attributes,"Edit page titles and attributes",6
151,assets.create,"Upload assets",1
152,assets.manage,"Manage assets",2
153,categories.create,"Create new categories",1
154,categories.delete,"Delete categories",2
155,categories.manage,"Manage categories",3
156,categories.sets.create,"Create category sets",4
157,categories.sets.delete,"Delete category sets",5
158,content.navgroups.configure,"Configure navigation groups",7
159,content.navgroups.create,"Create navigation groups",8
160,content.navgroups.delete,"Delete navigation groups",9
161,content.pages.create.toplevel,"Add new top-level pages",3
162,content.pages.delete.own,"Delete pages they created themselves",4
163,content.templates.configure,"Configure master pages",6
164,content.pages.republish,"Republish pages",12
165,content.pages.attributes,"Edit page titles and attributes",6
166,assets.create,"Upload assets",1
167,assets.manage,"Manage assets",2
168,categories.create,"Create new categories",1
169,categories.delete,"Delete categories",2
170,categories.manage,"Manage categories",3
171,categories.sets.create,"Create category sets",4
172,categories.sets.delete,"Delete category sets",5
173,content.regions.revert,"Roll back regions",3
Drew McLellan

Drew McLellan 2637 points
Perch Support

Just any that are duplicates.

That seems to have done the trick. Thanks!