Hi guys, I've asked this in the other forums, so forgive me if I seem redundant, but I have a major problem.  After moving the user accounts page from the admin menu to it's own menu for site admins, the login and register links in the skin do nothing.  I researched and tried resetting the skin to the default.  Still the same issue.  I've tried removing all cookies in the cache.  Still nothing.  I've restarted the application.  Notta.  I looked at the portals table, and the logintabid is set to null.  Both areas can be accessed by directly going to http://louangel.com/Home/tabid/140/...fault.aspx and http://louangel.com/Home/tabid/140/...ault.aspx, so I know it's still all there.  Something must be wrong with the database since I've done this move.  Would moving the page back to the admin menu fix this, and if so, how can this be accomplished?  It did me no good to move the user accounts page to it's own menu anyway, because editing the user is restricted to all but actual administrators anyway.  This is only happening in the one portal, and I have 4.

Your help will be extremely appreciated.


Tony

I would try moving the page back to the admin menu by reversing the changes that you made. If that doesn't work, I'm not sure what to suggest to you.

Reversing the changes simply moves the page to it's own menu. I cannot figure out how to move it back to the admin menu. Before when I edited the settings for the page, it was set to no page as the parent page. now when doing this it simply sets the page to it's own menu. I am having other errors on the site now, as none of my xmod modules are working either, and the other sites have gone down as well. I will ask for a restore from powerDNN. I would highly recommend because of all this that user accounts not be an option for the limiting access tutorial.

Thanks
Tone

I  added a reply to this question in your other forum post, which outlines how to move it back into the admin menu:
http://www.dnncreative.com/Forum/ta....aspx#7485

I will add a note to the tutorial page stating not to apply this to the user accounts page, thanks,

I tried the Limiting Access procedure using the TABS page but it did not accomplish what I was trying to do so I tried to move the TABS page back into the Admin menu and it would not go. I cannot figure out how to move it back.

I read the note from Lee about accessing the database and moving it but I'm not that well versed with SQL Server 2005 (which is what I'm using) to move it back. Would it be possible to get a step by step outline on how to do that?

I would really appreciate your help! Thanks.

Open the tabs table in SQL Server
Look at the TabName column
find the entry 'Tabs'
You need to edit this item to match the other pages that are in the admin menu
ie. look at the parent ID - my install is 38 for the 'Site Settings' record, so also change the parentID in the 'Tabs' record to 38
(This places it back in the admin menu)

IconFile will be: icon_tabs_16px.gif

I do not see what you are talking about here. Remember, I’m not well versed in MS SQL Server. I can install the server app., create a database and connect to it. That’s about the extent of my SQL knowledge.

So.....
 

I open up MS SQL server management studio,

 

Expand databases

 

Expand the target database

 

Expand “Tables”

 

Browse to the dbo.Tabs table

 

Expand the Columns folder

 

Scroll down to and select the TabName column

 

I right click on the TabName Column and select properties. Another window opens and nothing can be changed. It doesn't show anything about ParentID anyway.

 

I right click on the TabName Column and select Modify. A windows opens and the ParentID does not have a number. It shows a “data type” of “int” and a check box, that is checked to allow “Nulls”

 

I cannot find a place where I can change/modify the ParentID number.

 

What am I doing wrong?

 

Please help.

 

Thanks!

Right click on the dbo.Tabs table name and select "Open Table."

You will then be able to look through the data in the tabke and (very carefully, and only if needed) type over the entries that you need to change.

Then, click the red "X" in the upper right corner to close the table.  At that point, you should go back to your DNN site, refresh the pages and your changes should have taken effect. 

If you aren't sure, go to the Host Settings page and restart the application.

This is a feature I would really like to provide to a segment of my clients. I am hesitant to grant full admin access to most clients as there is too much damage they can do in the site. For most of the popular functions (i.e., newsletters) there are affordable 3rd party modules that replicate the function. The only area I have not been able to replicate is the User Accounts area. Like above I tried to grant access to a limited admin role and messed everything up. Does anyone know of a good 3rd party module that would allow another role (other than admin) to access, update, edit roles, delete, etc. the User Accounts. Thanks in advance for any assistance.

Travis

I have not come across one for user accounts, let us know if you find one,

Thanks,