StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>The source of the error was the new DNN (community version) install didn't have all the data it needed in the "Permission" Table.</p> <p>When I looked at the new permissions table, I saw that it was missing all row that had an ID greater than 7. To fix this error, we need to import the missing permission rows.</p> <p>Two ways to fix this, (but do both before you try to do the import).</p> <p><strong>Option 1:</strong> </p> <p>If you have access to a source of the exported site's database, you can run SQL command to import the rows you need. </p> <p>New Database: DNN-NEW-DB Source Database: DNN-SOURCE-DB</p> <pre><code> INSERT INTO [DNN-NEW-DB].[dbo].[Permission] SELECT [PermissionCode] ,[ModuleDefID] ,[PermissionKey] ,[PermissionName] ,[ViewOrder] ,[CreatedByUserID] ,[CreatedOnDate],[LastModifiedByUserID],[LastModifiedOnDate] FROM [DNN-SOURCE-DB].[dbo].[Permission] WHERE[DNN-SOURCE-DB].[dbo].[Permission].[PermissionID] > 7 ORDER BY permissionid </code></pre> <p>-- </p> <p><strong>Option 2:</strong> </p> <p>Is to manually import the missing records. I'm not sure if I got everything you need, let me know if I missed something:</p> <pre><code>INSERT INTO Permission (PermissionCode, ModuleDefID, PermissionKey, PermissionName, ViewOrder) VALUES ('SYSTEM_FOLDER', -1, 'DELETE', 'Can Delete', 9999); INSERT INTO Permission (PermissionCode, ModuleDefID, PermissionKey, PermissionName, ViewOrder) VALUES ('SYSTEM_FOLDER', -1, 'ADD', 'Add', 9999); INSERT INTO Permission (PermissionCode, ModuleDefID, PermissionKey, PermissionName, ViewOrder) VALUES ('SYSTEM_FOLDER', -1, 'COPY', 'Copy', 9999); INSERT INTO Permission (PermissionCode, ModuleDefID, PermissionKey, PermissionName, ViewOrder) VALUES ('SYSTEM_FOLDER', -1, 'MANAGE', 'Manage', 9999); INSERT INTO Permission (PermissionCode, ModuleDefID, PermissionKey, PermissionName, ViewOrder) VALUES ('SYSTEM_TAB', -1, 'CONTENT', 'Content', 9999); INSERT INTO Permission (PermissionCode, ModuleDefID, PermissionKey, PermissionName, ViewOrder) VALUES ('SYSTEM_TAB', -1, 'ADD', 'Add', 9999); INSERT INTO Permission (PermissionCode, ModuleDefID, PermissionKey, PermissionName, ViewOrder) VALUES ('SYSTEM_TAB', -1, 'COPY', 'Copy', 9999); INSERT INTO Permission (PermissionCode, ModuleDefID, PermissionKey, PermissionName, ViewOrder) VALUES ('SYSTEM_TAB', -1, 'DELETE', 'Delete', 9999); INSERT INTO Permission (PermissionCode, ModuleDefID, PermissionKey, PermissionName, ViewOrder) VALUES ('SYSTEM_TAB', -1, 'EXPORT', 'Export', 9999); INSERT INTO Permission (PermissionCode, ModuleDefID, PermissionKey, PermissionName, ViewOrder) VALUES ('SYSTEM_TAB', -1, 'IMPORT', 'Import', 9999); INSERT INTO Permission (PermissionCode, ModuleDefID, PermissionKey, PermissionName, ViewOrder) VALUES ('SYSTEM_TAB', -1, 'MANAGE', 'Manage', 9999); INSERT INTO Permission (PermissionCode, ModuleDefID, PermissionKey, PermissionName, ViewOrder) VALUES ('SYSTEM_TAB', -1, 'Navigate', 'Navigate', 9999); </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload