Hello and thank you in advance.
This morning I downloaded DNN 5.1 to try and install it in a virtual machine.
VM = Microsoft Windows Server 2003
SQL 2005
VIsualStudio 2005
I did the manual install, I've basically copied the files into a folder, and changed my web.config file... etc..
But when I ran the Auto install it fails at different places...
00:00:00.015 - Installing Version: 05.00.00
00:00:00.031 - Executing Script: DotNetNuke.Schema.SqlDataProvider Error! (see DotNetNuke.Schema.log for more information)
00:00:01.734 - Executing Script: DotNetNuke.Data.SqlDataProvider Error! (see DotNetNuke.Data.log for more information)
00:00:02.609 - Installing MemberRole Provider:
00:00:02.609 - Executing Script: InstallCommon
00:00:02.750 - Executing Script: InstallMembership
00:00:03.046 - Executing Script: InstallProfile
00:00:03.140 - Executing Script: InstallRoles
00:00:03.312 - Upgrading to Version: 05.01.01
00:00:03.328 - Executing Script: 05.00.01.SqlDataProvider Error! (see 05.00.01.log for more information)
00:00:03.671 - Executing Script: 05.01.00.SqlDataProvider Error! (see 05.01.00.log for more information)
00:00:05.156 - Executing Script: 05.01.01.SqlDataProvider Error! (see 05.01.01.log for more information)
00:00:05.421 - Executing Application Upgrades: 05.00.01 Success
00:00:05.437 - Executing Application Upgrades: 05.01.00 Error!
00:00:05.546 - Executing Application Upgrades: 05.01.01 Error!
00:00:05.562 - Cleaning Up Files: 05.00.01 Success
00:00:05.562 - Cleaning Up Files: 05.01.00 Success
00:00:05.562 - Cleaning Up Files: 05.01.01 Success
00:00:05.562 - Updating Config Files: 05.00.01 Success
00:00:05.562 - Updating Config Files: 05.01.00 Success
00:00:05.562 - Updating Config Files: 05.01.01 Success
00:00:05.562 - Performing General Upgrades
I then did some digging around and found the SQL scripts that were being ran, and I quickly noticed things where they would be referencing table columbs such as File.FilesID, but the column name was actually File.FilesId,(similarly I also found other things like UserName where it should have been Username.
I ran this scripts within a transaction in SQL(rollback ftw) to test them, but quite frankly this seems to be too much of a pain to go through all of these files. Does anyone have a solution for this? or could anyone maybe give me a blank DNN Database that I can just restore to play round with DNN?