DNN Forums

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

Upgrading 4.9.5 to 5.4.4

Sort:
You are not authorized to post a reply.
Page 2 of 3 << < 123 > >>





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





      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





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






        Veteran Member





          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

          dnnWerk Austria
          DNN Connect





          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





              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

              dnnWerk Austria
              DNN Connect





              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





                  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





                    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





                      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

                      You are not authorized to post a reply.
                      Page 2 of 3 << < 123 > >>

                      These Forums are dedicated to the discussion of DNN Platform.

                      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