- How-to's
- Miscellaneous
- Email issues
- On-premise version issues
- Integrations and migrating from other apps
- Errors and solutions
- FAQ
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)
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 |