ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Bad field name in SQL statement

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Message:

* HTML is ON
* Forum Code is OFF
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
MKO 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
1   L A T E S T    R E P L I E S    (Newest First)
admin 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

ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page