Aug 21

Written by: host
Mon, 21 Aug 2006 16:39:09 GMT

For two days I've spent a lot of time trying to figure out why the original Members page of this site was messed up so badly by the use of the User Account module. After installing it and some initial good working, I couldn't get access to any of the other modules on the page anymore.

Basically it turned out to be a great example of ICT trouble shooting i.e. "waste a lot of time" over something that's solved in the end in a few seconds! (frustrating and most fullfilling in the end).

Day 1.

To start with the time wasting, have a look at this query spaghetti (in the end to no resolve!), don't try to figure it out and then I'll explain:

select * from dbo_modules order by moduledefid
select * from dbo_modulesettings

select * from dbo_desktopmodules
useraccount = 33

select * from dbo_modules where moduleid = 406
select * from dbo_moduledefinitions where moduledefid = 75
select * from dbo_desktopmodules where desktopmoduleid = 33
-- select * from dbo_modulesettings where moduleid = 406

select * from dbo_tabs
where tabid = 59
and taborder = 27

--
select * from dbo_tabpermission
where tabid = 59

select * from dbo_permission

select * from dbo_roles

-- modules on members tab
select * from dbo_modules where moduleid in(
select moduleid from dbo_tabmodules where tabid= 59)

select * from dbo_tabmodulesettings
where tabmoduleid in 
(select tabmoduleid from dbo_tabmodules where tabid= 59)

select * from dbo_tabmodules -- where moduleid = 406
where tabid= 59

update dbo_tabmodules
set tabid = 59
where moduleid = 407

......... [short break untill blog 2. tomorrow]......

Day 2.:

So what you were looking at was a rather random search in SQL for the right tabs and modules tables to trace down the User Account module I placed on the Members page from the modules menu.

The funny thing was that no matter what update or deletion the User Account module wouldnt dissapear from the Members page. Worse, the other 4 modules weren't there anymore unless one would log off and visit the page as an unregistered user: behold, they're still there.

When logged on you'd see the User Account module, have the option to edit the account of the logged on user. But no options to edit the module itself or delete it from the page.

Next an extensive search followed... clicking the username link at the top of the page, try Admin and Host options, Useraccount settings, Security roles.

Most satifying was a test to recreate the Members tab (new page Memberz) and copy/ move the invisible modules over to the new Memberz page, then delete the current Members page and get rid of the User Account module! Brilliant plan, learned a lot about the options to copy modules accross from one page to the other, but did it solve the issue.....? yeah sure...:)

Then for some nonlogical reason I decided to have a look at the Admin - Site Settings options. Having in mind a previous experience with the use of setting fixed splash pages, entry pages and user pages. Might this be the lucky link to succes!?

Advanced settings -  Page management - Userpage.

This one I set to the B..#$%$#$-ly Members page and tried to acces the page for the xthd time. Right on! A great moment of ICT bliss! Bubbles, sparkles... the invisible came back into sight: all modules still there and the User Accounts module editable all the way like it should be, deletable and all.

Well as a bit of a nerd yourself, you'll probable understand this need to share  a glorious moment like this. Meanwhile I'll be working on the next one and keep you up to date. As for your self, feel free to share your DNN and otherwise existential experiences throught the FWS Forums for one!

---

...by the way, here's a brand new Fws banner:



.... more on this one nex time.

Copyright ©2006 SuperUser Account

Tags: