| Author |
 Topic  |
|
|
MKO
Poland
2 Posts |
 Posted - 03/05/2015 : 02:04:16
|
HI
I use version ReportPortal 4.0, Build 188, Dec 26, 2014
In Administration\User I have error like below. In SQL statement is bad field name AppuserLogId, instead of AppUserLogId.
I temporary correct this by addding computed field "AppuserLogId as AppUserLogId", so this error is not critical and may by corrected in next version RP.
Server Error in '/ReportPortal' Application.
Invalid column name 'AppuserLogId'.
Invalid column name 'AppuserLogId'.; SQL: select l.AppuserLogId, l.LogDate, l.EditAction, u.FirstName, u.LastName from AppUserLog l inner join AppUser u on u.UserId = l.EditUserId Where l.UserId = '0' ORDER BY l.AppuserLogId
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.Exception: Invalid column name 'AppuserLogId'.
Invalid column name 'AppuserLogId'.; SQL: select l.AppuserLogId, l.LogDate, l.EditAction, u.FirstName, u.LastName from AppUserLog l inner join AppUser u on u.UserId = l.EditUserId Where l.UserId = '0' ORDER BY l.AppuserLogId
Source Error:
Line 368: ()
Line 369:
Line 370: [ \/]
Line 371:
Line 372:
Source File: C:\inetpub\wwwroot\reportportal_188\admin\userContent.aspx Line: 370
Stack Trace:
[Exception: Invalid column name 'AppuserLogId'.
Invalid column name 'AppuserLogId'.; SQL: select l.AppuserLogId, l.LogDate, l.EditAction, u.FirstName, u.LastName from AppUserLog l inner join AppUser u on u.UserId = l.EditUserId Where l.UserId = '0' ORDER BY l.AppuserLogId]
ReportPortal.Helper.GetDataReader(String sSql) +811
ReportPortal.userContent.GetHistorySelect() +404
ASP.admin_usercontent_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) in C:\inetpub\wwwroot\reportportal_188\admin\userContent.aspx:370
System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +115
System.Web.UI.Page.Render(HtmlTextWriter writer) +38
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4240
Version Information: Microsoft .NET Framework Version:2.0.50727.5420; ASP.NET Version:2.0.50727.5474 |
|
|
admin
1637 Posts |
Posted - 03/05/2015 : 02:25:17
|
Fix for .net 2.0 version of ReportPortal:
1. Download and unzip: http://www.reportportal.com/download/rp_188_AppUserLogId.zip
2. Backup old file to an external folder and copy the unzipped file to: "C:\inetpub\wwwroot\ReportPortal(_188)\bin\ReportPortal.dll"
Alternatively, you can change the collation of ReportPortal database to case insensitive like
ALTER DATABASE ReportPortal COLLATE Latin1_General_CI_AS |
 |
|
| |
Topic |
|
|
|
Report Portal
Bad field name in SQL statement
