Skip to main content

DotNetNuke: Customized Events Module Upgrade to Standard

Today I was able to upgrade a customized Events module of the DNN (DotNetNuke) at the request of the client. After my suggestion the client wanted to have the latest updates and also gave an okay to drop the customization and use the standard events module.

What should have been an easy upgrade quickly turned into a nightmare; a nightmare which took all evening yesterday and the early morning today.

It turns out that the install wizard does not rollbacks all the things as is; especially the ones which were checked with IF Exists or IF NOT Exists SQL.

I believe the IF (NOT) Exists scenarios should actually turn on and off boolean values so that they can be passed on as parameters to the other SQL scripts and all the way to the rollback scenario.

It was really painful to redo all things at least ten times as the error was triggering the rollback and retry will fail at missing columns or columns already exists; which were added or deleted by the previous try and were not undone by the rollback.

  1. Table
    1. Events
      1. Remove index of IX_(objectQualifier)Events_4
      2. Add column PayPalPassword
      3. Alter Column name CreatedByID to CreatedBy
    2. EventsRecurMaster
      1. Remove all Relationship keys
    3. EventsSignups
      1. Add column TimeZoneOffset
  2. DLLs
    1. Delete all Events module related dlls (the dlls are locked and can't be overwritten)
  3. DesktopModules
    1. Delete the Events sub-folders and the Events folder as well. (resource files are locked and can't be overwritten)
At the end all things went fine but making it all work was painful and not an easy route.

Hope this can be helpful to any who are in similar situation as me.

 

Comments

Popular posts from this blog

Completed UiPath - RPA Developer Advance Training

After a month of training, with late nights and weekends I have completed the UiPath RPA Developer Advance Training. The Level 1 Foundation Training pretty much covered all the basics of Desktop studio and workflows, only draw back was I started with the default foundation course which was for 2016, and all document reference links where pointing to 2016 version. I didn't understand it during the foundation training and kept switching to 2018 version document/page. Only after completing the Foundation course that I realized, I was suppose to have started with the 2018 version of Level 1 Foundation Training, but as it was optional I didn't have to retake the 2018 version, the 2016 was good enough for moving to level 2. The Level 2 Orchestrator 2018.3 Training as good. It gave good understanding of Queue's, Jobs, and schedules and I was able to complete the level two much faster then the level 1. The Level 3 UiPath Advanced Training was bit tough as it involved the a

KB 294807 - IIS Server - PHP FastCGI 500 Error 0xfffffffe

Resolved issue today of IIS Server - PHP FastCGI 500 Error 0xfffffffe by deleting "Windows Temp" folder files. We used Cygwin to customize some permissions of "Windows Temp" folder and after few hours the website stopped working. The search online was giving all kinds of different solution except what I was looking for. I was hoping the stackoverflow will have answers but even this post didn't cover the issue I was running into. https://stackoverflow.com/questions/15302080/fastcgi-500-failure Restarting the IIS didn't work, but deleting temp files cleared the issue, but now the problem is how long before the site will go down again? Hope the issue is resolved for ever, if not; I will update this post later.

QlikSense - Custom Form Login Screen

Extension of:  Custom login, logout and error forms for Qlik Sense by RPK https://developer.qlik.com/garden/5ada5a8f0c313f5c539dc7fd QlikSense - Custom Login Screen Install Node on QlikSense Server: URL: https://nodejs.org/en/ Saved at: C:\server-tools\Downloads\Node Installed at: C:\server-tools\Runtime\nodejs\ Keep default options Create Folder: C:\QlikForm Clone git Repository and keep updates private: # Open Shell/Bash/Command Prompt cd /QlikForm # Ref: https://medium.com/@bilalbayasut/github-how-to-make-a-fork-of-public-repository-private-6ee8cacaf9d3 git clone --bare https://github.com/kreta99/QS-Custom-Forms .git cd QS-Custom-Forms.git git push --mirror https://github.com/<name>/QS-Custom-Forms.git cd .. (go to parent folder) # remove other users repo clone rm -rf QS-Custom-Forms.git # clone witinc private repo git clone https://github.com/<name>/QS-Custom-Forms.git Get latest copy of login pages: # Open She