Hi All,
My upgrade to DotNetNuke 4.9.0 didn't complete automatically as it should have done.
Prior to upgrade I did all the usual, backed up DB, DNN install folder and created an app_offline.htm file to take the application offline.
I was previously using DotNetNuke 4.8.4. I downloaded the upgrade package and extracted it to a folder on my local machine. I then uploaded the contents of this package over the top of my DotNetNuke installation on my web host.
I then removed app_offline.htm and connected to my DNN site. I have AutoUpgrade switched on in the web.config file and so I was greeted by the DotNetNuke upgrade screen, which listed four lines before stating Upgrade Complete. I thought that the output of this screen seemed too small for a DotNetNuke upgrade and there was no mention of SqlDataProvider at any time.
I clicked on the "Continue to your portal" link, which took me back to the Upgrade page telling me that my database was at 4.8.4 whilst the binaries were at 4.9.0. I was stuck in an infinite loop of visiting the upgrade page. It appears that no changes were made to the database - including adding 4.9.0 to the Versions table.
I manually added 4.9.0 to the Versions table and then my site appeared as normal.
I wondered if there were any database changes that should be applied for version 4.9.0 and so I checked Providers\DataProviders\SqlDataProvider\04.09.00.SqlDataProvider in the upgrade package. Indeed there is a bit of SQL in there that makes various changes to the database.
As a test I decided to check if the FileExtensions entry in the HostSettings table started with 'template,' - it didn't. So I did a find/replace on the dbo/object qualifier and then ran the script manually against the database.
Are there any other database changes that need to be applied for the transition between 4.8.4 and 4.9.0 ?
Does anybody have any idea why this upgrade would have failed like this?
I have performed several upgrades on this particular site in the past and I've never encountered any problems.
Thanks in advance for any assistance I receive with this matter.
Regards,
Adam