LS doesnt work after Upgrade to 3.1

[dffe]

I have been running LS 3.0 and have upgraded to 3.1 today, but after the upgrade doesnt the Website work any more... any ideas? There isnt any information on it and I get an JS error when I try to search....

[Hemoco]

You have probably deleted this line:
<add key="MM_CONNECTION_DATABASETYPE_Lansweeper" value="SQLServer" />

Should be below the line with "MM_CONNECTION_STRING_Lansweeper"

[dffe]

Lansweeper wrote:
You have probably deleted this line:
<add key="MM_CONNECTION_DATABASETYPE_Lansweeper" value="SQLServer" />

Should be below the line with "MM_CONNECTION_STRING_Lansweeper"

There is a reason why you rock and I dont 🙂 It fixed the issue with a blank page, now I just get a JS error (Attached)

[dffe]

dffe wrote:

Lansweeper wrote:
You have probably deleted this line:
<add key="MM_CONNECTION_DATABASETYPE_Lansweeper" value="SQLServer" />

Should be below the line with "MM_CONNECTION_STRING_Lansweeper"

There is a reason why you rock and I dont 🙂 It fixed the issue with a blank page, now I just get a JS error (Attached)

¨

Get fixed when I removed the Debug=true

[Hemoco]

dffe wrote:
I fixed the issue with a blank page, now I just get a JS error (Attached)

Set the debug back to false in your web.config and it will be gone.

[Hemoco]

Could you upload you web.config file please (with the password masked)

[Hemoco]

Open the web.config and set debug=false to "true"
Open the file state.aspx and set debug=false to "true"

now surf to state.aspx.

You should see the error description now.

[dffe]

Lansweeper wrote:
Open the web.config and set debug=false to "true"
Open the file state.aspx and set debug=false to "true"

now surf to state.aspx.

You should see the error description now.

Have done that and now do I get:

System.Exception: This page has a MM:DataSet, MM:Insert, MM:Update or MM:Delete tag with a null or empty value for the DatabaseType attribute. 

Often, such values come from application settings in the web.config file. That file might be missing from the server executing this page. Or, it might be missing the particular add key tags for the database connection this page uses. If you are using Dreamweaver, look for the web.config file in the local root folder of your Dreamweaver site. Once you find this file, you can either:
Put this file onto the server that is executing this page.
Copy the add key tags from the web.config in the local root folder of your Dreamweaver site and paste them into the web.config file in the server that is executing this page.

at DreamweaverCtrls.DataSet.DoInit()

and my web.config looks like this: (Datasource/user ID and Password have been replaced by xxxxxx)

<configuration>
	<appSettings>
		<add key="MM_CONNECTION_HANDLER_Lansweeper" value="sqlserver.htm" />
		<add key="MM_CONNECTION_STRING_Lansweeper" value="Persist Security Info=False;Data Source=xxxxxx\sqlexpress;Initial Catalog=Lansweeper;User ID=xxxxxx;Password=xxxxxx" />
		<add key="MM_CONNECTION_SCHEMA_Lansweeper" value="" />
		<add key="MM_CONNECTION_CATALOG_Lansweeper" value="" />
		<add key="dateformat" value="dd/MM/yyyy" />		
	</appSettings>
	   <system.web>
       <compilation debug="true" strict="false" explicit="true">
         <assemblies>
           <add assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
           <add assembly="System.Design, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
           <add assembly="System.Web.Extensions.Design, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
           <add assembly="System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
         </assemblies>
       </compilation>
       <httpHandlers>
         <remove verb="*" path="*.asmx"/>
         <add verb="*" path="*.asmx" type="System.Web.Script.Services.ScriptHandlerFactory"  validate="false"/>
         <add verb="*" path="*_AppService.axd" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
         <add verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" validate="false"/>
       </httpHandlers>
       <httpModules>
         <add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
       </httpModules>
   </system.web>
</configuration>

[Hemoco]

CHeck your web.config file if it's pointing to the correct database/user/password

[dffe]

Lansweeper wrote:
CHeck your web.config file if it's pointing to the correct database/user/password

I have been replacing it with the MM_CONNECTION_STRING_Lansweeper from the old web.config