Server Error in lansweeper Application problem

[petr22]

Hello, we upgraded previous 4.0 beta version to version from 15. April, upgrade proceed well, except computer description page - when we try to open page of any computer (by typing hostname or selecting from domain object list)
we only get this error:

Server Error in '/lansweeper' Application.
--------------------------------------------------------------------------------

Runtime Error
Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.

Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".


<!-- Web.Config Configuration File -->

<configuration>
<system.web>
<customErrors mode="Off"/>
</system.web>
</configuration>


Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.


<!-- Web.Config Configuration File -->

<configuration>
<system.web>
<customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/>
</system.web>
</configuration>


We checked this forum and we found there is a version from 16. April, fixing problems with installing to D drive (we have Lansweeper on D drive) and we upgraded only website (website directory was deleted first). After upgrade we have same error ad before. Is there a solution for it, please ? We dont tried to reinstall SQL database.

[Hemoco]

Please try running this sql script:

ALTER PROCEDURE [dbo].[web40getWOL](@comp int)
AS SELECT DISTINCT Description, IPAddress, MACaddress
FROM          dbo.tblNetwork
WHERE      (Computername = @comp) AND (MACaddress IS NOT NULL) AND (MACaddress <> '') AND (IPEnabled = 1)

[petr22]

Yes, main page is working, it look like everything is normal except it not possible to open informations about any computer.

There is debug message, it look like there is a problem with SQL database:

Server Error in '/lansweeper' Application.
--------------------------------------------------------------------------------

Column 'ipaddress' does not belong to table theTable.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentException: Column 'ipaddress' does not belong to table theTable.

Source Error:


Line 439: <% For Each myrow In dswol.DefaultView.Table.Rows%>
Line 440: <tr >
Line 441: <td ><a href="javascript:runApp(<%=Lansweeper.general.getwol(dswolconfig.FieldValue("wolcommand", nothing),myrow("macaddress"),dswolconfig.FieldValue("wolremovepoint", nothing),actionpath,myrow("ipaddress"))%>,'true');" class="clicklink"><%=myrow("description")%></a>&nbsp; <span class="lg"><%=myrow("macaddress")%></span></td>
Line 442: </tr>
Line 443: <%tel = tel + 1%>


Source File: D:\lansweeper40\website\it-compdetail.aspx Line: 441

Stack Trace:


[ArgumentException: Column 'ipaddress' does not belong to table theTable.]
System.Data.DataRow.GetDataColumn(String columnName) +1773557
System.Data.DataRow.get_Item(String columnName) +13
ASP.it_compdetail_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) in D:\lansweeper40\website\it-compdetail.aspx:441
System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +256
System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +19
System.Web.UI.Page.Render(HtmlTextWriter writer) +29
System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +27
System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +99
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +25
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1266




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.3053; ASP.NET Version:2.0.50727.3053

[Hemoco]

Are you able to see the main webpage?

In the web config could you set debug to "true" to see a better error description.