Hi,

I've just updated my dnn test server 4.8.0 to 4.8.1 but somewhere it did went wrong.

I've first have made a backup of my file system and the db. After that i've overwrite the files with the update zip. I've checked the web.config but they the sql connections was the same (i don't know how, but i think this cause the problem).

So i thought i try it, a nice message came with updating 4.8.0 database version to 4.8.1 after that i could login.

i check the db and only had system tabels left nothing else, witch is very strang because the update did see the db version and after that everything is gone. The data that is lost isn't the problem i only what to know what i did wrong so i don't make the mistake again.

Sorry i don't kwow what a ObjectQualifier is?

I've tried a few minutes to update at home this time it works :). Here i have a win 2003 server with sql server 2000 at work is a 2003 server with sql server 2000 and sql server 2005, the database is also running under sql 2000.

No i notice something strange at home in the web.config.

Here the difference in the web.config backup and the new one.

The backup web.config

  <connectionStrings>
    <!-- Connection String for SQL Server 2005 Express -->
    <add name="SiteSqlServer"
        connectionString="Data Source=(local);Initial Catalog=DotNetNuke;Integrated Security=True"
        providerName="System.Data.SqlClient" />
    <!-- Connection String for SQL Server 2000/2005
    <add
      name="SiteSqlServer"
      connectionString="Server=(local);Database=DotNetNuke;uid=;pwd=;"
      providerName="System.Data.SqlClient" />
   -->
  </connectionStrings>

the new web.config

    <connectionStrings>
        <!-- Connection String for SQL Server 2005 Express -->
        <add name="SiteSqlServer"
          connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;"
          providerName="System.Data.SqlClient" />
        <!-- Connection String for SQL Server 2000/2005
    <add
      name="SiteSqlServer"
      connectionString="Server=(local);Database=DotNetNuke;uid=;pwd=;"
      providerName="System.Data.SqlClient" />
   -->
    </connectionStrings>
   

At work i´ve only seen that the part of the 2000/2005 connection string was the same, now i see that at home with no 2005 server it still uses the connection string from 2005 express. Tomorrow i will check at work of this is also the problem there.

Anyone a clue how this is possible because for me this is pretty confusing.
Thanx for the help