-
Type:
Bug
-
Status: Closed
-
Priority:
Critical
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: Platform
-
Labels:None
-
Environment:Stage
-
Module:BenAdmin - EDS
-
Reported by:Harbinger
-
Item State:Production Complete - Closed
-
Issue Importance:Must Have
Getting server error on saving site branding configuration for word like Yoke's
ErrorID : 0
ErrorSource : ControllerAppTier.Save->WORKTERRAControllerAppTier.Save->WORKTERRACommon.Save=>WORKTERRACommon.SaveSiteBrandingOtherConfiguration
ErrorMessage: Incorrect syntax near 's'.
Unclosed quotation mark after the character string ', TotalCostAndCreditonSummary1 = ', TotalCostAndCreditonSummary2 = ', TotalCostAndCreditonSummary3 = ', DisplayHSAPaycheckValues = 0, DatetimeStamp=Getdate() , UserID =1 Delete from BenefitType_EmployerCostSettings Where CostSettingsCategoryId IN (1,2,3,4)'.
StackTrace: at WORKTERRA.Shared.WORKTERRAControllerAppTier.Save(WORKTERRAControllerWebTierEntity objWORKTERRAControllerWebTierEntity)
Got during one of demo set up of http://www.yokesfreshmarkets.com/
Hi Satya,
Yes we can implement this.
Due to short bandwidth, cant assign this task today.Will assign to Chaitali tomorrow.
CC:Swapnil Pandhare
Thanks,
Sheetal Bodhale
Sheetal Bodhale (Inactive)
added a comment - Hi Satya ,
Yes we can implement this.
Due to short bandwidth, cant assign this task today.Will assign to Chaitali tomorrow.
CC: Swapnil Pandhare
Thanks,
Sheetal Bodhale Hi Rakesh Roy
As per discussion with Satya
Validation is to be implemented for :
1)Copyright Text.
2)Copyright Text in Spanish.
3)Copyright Text in French.
4)Spending Credit Label.
5)Total Costs & Credit On Summary.
6)Total Costs & Credit On Summary(Spanish).
7)Total Costs & Credit On Summary(French).
As per discussion with Rakesh Roy
1)Characters not allowed are ; ' – xp_
2)Validation error message to be shown ->Special characters like ; ' – xp_ are not allowed.
Development is in progress on this and will update you on this by tomorrow.
CC:Swapnil Pandhare Sheetal Bodhale
Thanks,
Chaitali
Concern:
Getting server error on saving site branding configuration for word like Yoke's
Cause:
Characters like ' cause SQL Query to form wrongly so system throws Server Error.
Correction:
We have now provided validation for special characters ; ' – xp_.
Risk Mitigation:
Now user will be prevented from entering special characters like ; ' – xp_ and system will not throw server error.
Files affected:
SiteBrandingOtherConfiguration.cshtml
Working fine--Refer attached image
working fine on stage as well.
Hi Sheetal,
Can we please have this validation check implemented?
Thanks & Regards,
Satya Prakash