avatar  


Recently viewed tickets

Log out

SQL Server collation

Jitbit Helpdesk requires case insensitive server collation. If your server is case sensitive, then you can simply override this for Jitbit's database only. Whenever I attempt to edit an automation rule, I get this error below:

Please run this SQL query against your database to resolve the issue:

ALTER DATABASE JitbitHelpdesk
COLLATE SQL_Latin1_General_CP1_CI_AS
An example of an error you might get with wrong collation: 

Exception:
System.Data.SqlClient.SqlException (0x80131904): Must declare the scalar variable "@ruleID".
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
Creation date: 11/26/2021 5:13 PM (Vlad)      Updated: 11/26/2021 6:08 PM (Alex)
Files   
image001[1].png
37.2 KB
OriginalEmail[10].eml
136.4 KB
OriginalEmail[2].eml
146.3 KB
OriginalEmail[3].eml
149.2 KB
OriginalEmail[4].eml
108.3 KB
OriginalEmail[5].eml
159.1 KB
OriginalEmail[6].eml
210.8 KB
OriginalEmail[7].eml
189.1 KB
OriginalEmail[8].eml
189.7 KB
OriginalEmail[9].eml
188 KB
Solving problems with on-premise version of Jitbit Helpdesk ticketing system