DNN Forums

Ask questions about your website to get help learning DNN and help resolve issues.

Upgrading 4.9.5 to 5.4.4

 23 Replies
 1 Subscribed to this topic
 33 Subscribed to this forum
Sort:
Page 2 of 3 << < 123 > >>
Author
Messages
Growing Member
Posts: 72
Growing Member
I just checked the production system and it already has a module definition for 'Languages' in the ModuleDefinitions tables before the upgrade is started. There is a DeleteDesktopModule("Languages") being called right before it calls AddModuleDefinition to add the module from scratch.
Growing Member
Posts: 72
Growing Member
OK. Deleting the modules from the ModuleDefinition table lets the script passthru. I wonder why DeleteDesktopModule is not working in my case.

Had to delete all 3 added modules:
delete from ModuleDefinitions where FriendlyName='Languages'
delete from ModuleDefinitions where FriendlyName='Skins'
delete from ModuleDefinitions where FriendlyName='Skin Designer'

Maybe I will find some time to debug that later. Now looking at the other one:
Executing Application Upgrades: 05.03.00 Error!.
Growing Member
Posts: 72
Growing Member

It seems DeleteDesktopModule should also delete the module definition. Maybe a cascaded delete failed or something.

Veteran Member
Posts: 1182
Veteran Member
MVP
MVP
You're an MVP!
Andreas,

have you installed Sebastian Leupold's Turbo Scripts by any chance? In that case you have to uninstall them first, before upgrading, and then install the approbriate version...

Happy DNNing!
Michael

Michael Tobisch
DNN★MVP

DNN Connect
Growing Member
Posts: 72
Growing Member
Posted By Michael Tobisch on 03 Oct 2019 02:26 AM
Andreas,

have you installed Sebastian Leupold's Turbo Scripts by any chance? In that case you have to uninstall them first, before upgrading, and then install the approbriate version...

Happy DNNing!
Michael

Hi Michael,

That is a good question and I should probably have mentioned it. We did our own optimization a long while ago, using the SQL server optimizer. In our installation there were some joins being performed using strings, most likely caused by 3rd party modules. That is what caused the SQL script to fail, because an index alreayd existed. I think it was actually using a text column to store an ID field of another table, like FileID:1234. We fixed it by creating an autocalculating column that produces a bigint that can be joined.

Yesterday I found this thread having the same 5.3.0 error: https://www.dnnsoftware.c...e/posts/threadpage/4

One suggestions was, to add an additional upgrade to 5.2.3. I just tried it and it works, because there was no 5.3.0 of course. However, now 5.2.1 failed dealing with languages. According to some postings in that thread, an upgrade to 5.4.4 or newer will eventually be possible.

It seems to be a stored procedure that gets called and then deleted, so it should be easier to debug it to find the cause.

Our site was using multilanguage (MLHTML, MLAdvAnnouncementModule, ...) for a long time, since 2005/2006 I think.

Andreas

 

Veteran Member
Posts: 1182
Veteran Member
MVP
MVP
You're an MVP!
Andreas,

well I don't know how big your site is, but that sounds to me that it could be a better idea to redo the site from scratch in DNN 9. I am not sure if the old Apollo MLHTML and MLAdvAnnoncement modules are still working...

Happy DNNing!
Michael

Michael Tobisch
DNN★MVP

DNN Connect
Growing Member
Posts: 72
Growing Member
Posted By Michael Tobisch on 03 Oct 2019 07:35 AM
Andreas,

well I don't know how big your site is, but that sounds to me that it could be a better idea to redo the site from scratch in DNN 9. I am not sure if the old Apollo MLHTML and MLAdvAnnoncement modules are still working...

Happy DNNing!
Michael


Hello Michael,

Yeah, am thinking about that too. But I have not given up completely yet. Still a long road ahead till 9. Redoing it would be kind of painful because of SEO.

I just realized that the step that now fails is something else:
00:00:21.930 -   Updating Config Files: 05.02.01 Error!

So I was looking at the wrong stored procedure, which correctly executed and populated the new Languages and PortalLanguages tables.

Regarding the MLAdvAnnouncement module, the plan is to either get it working, replace the 3-4 instances we have with pure HTML, kindly ask Eric for the source code or rewrite our own. Am still undecided.

Andreas

Growing Member
Posts: 72
Growing Member

Looks like Telerik. :) Isn't Telerik long gone?

The config script files are in the \install\Config folder. It seems something should get added to the web.config here.

Growing Member
Posts: 72
Growing Member
I just made those web config changes manually and then 4.9.5 -> 5.2.3 succeeded:
00:00:00.072 - Upgrading to Version: 05.02.03
00:00:00.189 - Executing Script: 05.00.00.SqlDataProvider Success
00:00:02.589 - Executing Script: 05.00.01.SqlDataProvider Success
00:00:03.364 - Executing Script: 05.01.00.SqlDataProvider Success
00:00:05.179 - Executing Script: 05.01.01.SqlDataProvider Success
00:00:05.316 - Executing Script: 05.01.02.SqlDataProvider Success
00:00:05.324 - Executing Script: 05.01.03.SqlDataProvider Success
00:00:05.354 - Executing Script: 05.01.04.SqlDataProvider Success
00:00:05.367 - Executing Script: 05.02.00.SqlDataProvider Success
00:00:06.093 - Executing Script: 05.02.01.SqlDataProvider Success
00:00:06.129 - Executing Script: 05.02.02.SqlDataProvider Success
00:00:06.138 - Executing Script: 05.02.03.SqlDataProvider Success
00:00:06.338 - Executing Application Upgrades: 05.00.00 Success
00:00:15.153 - Executing Application Upgrades: 05.00.01 Success
00:00:15.169 - Executing Application Upgrades: 05.01.00 Success
00:00:16.462 - Executing Application Upgrades: 05.01.01 Success
00:00:16.485 - Executing Application Upgrades: 05.01.02 Success
00:00:16.486 - Executing Application Upgrades: 05.01.03 Success
00:00:16.598 - Executing Application Upgrades: 05.01.04 Success
00:00:16.598 - Executing Application Upgrades: 05.02.00 Success
00:00:16.713 - Executing Application Upgrades: 05.02.01 Success
00:00:16.721 - Executing Application Upgrades: 05.02.02 Success
00:00:16.721 - Executing Application Upgrades: 05.02.03 Success
00:00:16.723 - Cleaning Up Files: 05.00.00 Success
00:00:16.787 - Cleaning Up Files: 05.00.01 Success
00:00:16.843 - Cleaning Up Files: 05.01.00 Success
00:00:17.293 - Cleaning Up Files: 05.01.01 Success
00:00:17.293 - Cleaning Up Files: 05.01.02 Success
00:00:17.293 - Cleaning Up Files: 05.01.03 Success
00:00:17.294 - Cleaning Up Files: 05.01.04 Success
00:00:17.294 - Cleaning Up Files: 05.02.00 Success
00:00:17.294 - Cleaning Up Files: 05.02.01 Success
00:00:17.294 - Cleaning Up Files: 05.02.02 Success
00:00:17.294 - Cleaning Up Files: 05.02.03 Success
00:00:17.295 - Updating Config Files: 05.00.00 Success
00:00:17.295 - Updating Config Files: 05.00.01 Success
00:00:17.296 - Updating Config Files: 05.01.00 Success
00:00:17.303 - Updating Config Files: 05.01.01 Success
00:00:17.303 - Updating Config Files: 05.01.02 Success
00:00:17.303 - Updating Config Files: 05.01.03 Success
00:00:17.303 - Updating Config Files: 05.01.04 Success
00:00:17.303 - Updating Config Files: 05.02.00 Success
00:00:17.309 - Updating Config Files: 05.02.01 Success
00:00:17.312 - Updating Config Files: 05.02.02 Success
00:00:17.312 - Updating Config Files: 05.02.03 Success
00:00:17.312 - Performing General Upgrades
00:00:17.380 - Installing Optional Modules:
00:00:17.382 - Installing Package File HTML_Community_05.02.00_Install: Success
00:00:18.121 - Installing Optional Skins:
00:00:18.121 - Installing Optional Containers:
00:00:18.121 - Installing Optional Languages:
00:00:18.121 - Installing Optional Providers:
00:00:18.121 - Installing Package File AspNetMembershipProvider_05.02.00_Install: Success
00:00:18.395 - Installing Package File CorePermissionProvider_05.01.01_Install: Success
00:00:18.450 - Installing Package File DatabaseLoggingProvider_05.01.01_Install: Success
00:00:18.547 - Installing Package File DNNMembershipProvider_05.01.03_Install: Success
00:00:18.637 - Installing Package File DNNMenuNavigationProvider_05.01.00_Install: Success
00:00:18.798 - Installing Package File DNNTreeNavigationProvider_05.01.00_Install: Success
00:00:18.928 - Installing Package File FckHtmlEditorProvider_02.00.04_Install: Success
00:00:27.784 - Installing Package File FileBasedCachingProvider_05.01.03_Install: Success
00:00:27.975 - Installing Package File FileModuleCachingProvider_05.02.01_Install: Success
00:00:28.127 - Installing Package File MemoryModuleCachingProvider_05.02.01_Install: Success
00:00:28.268 - Installing Package File SchedulingProvider_05.02.01_Install: Success
00:00:28.341 - Installing Package File SearchIndexProvider_05.01.00_Install: Success
00:00:28.440 - Installing Package File SearchProvider_05.01.01_Install: Success
00:00:28.574 - Installing Package File SolpartMenuNavigationProvider_05.01.00_Install: Success
00:00:28.751 - Installing Optional AuthSystems:
00:00:28.751 - Installing Package File LiveID_01.00.01_Install: Success
00:00:28.875 - Installing Package File OpenID_02.00.00_Install: Success
00:00:29.056 - Installing Optional Packages:
Growing Member
Posts: 72
Growing Member

OK, after then trying to go from 5.2.3 to 5.4.4 I get the same error:
00:02:02.223 -   Executing Application Upgrades: 05.03.00 Error!

Here is another thread: https://www.dnnsoftware.c...d-gterror-lt-font-gt

Page 2 of 3 << < 123 > >>

These Forums are for the discussion of the open source CMS DNN platform and ecosystem.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. If you have (suspected) security issues, please DO NOT post them in the forums but instead follow the official DNN security policy
  2. No Advertising. This includes the promotion of commercial and non-commercial products or services which are not directly related to DNN.
  3. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  4. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  5. No Flaming or Trolling.
  6. No Profanity, Racism, or Prejudice.
  7. Site Moderators have the final word on approving / removing a thread or post or comment.
  8. English language posting only, please.

Would you like to help us?

Awesome! Simply post in the forums using the link below and we'll get you started.

Get Involved