SmarterTools Portal Language
 
HomeKnowledge BaseSmarterTicketHow To - IssueClass table does not exist
Information
Article ID187
Created On11/22/2005
Modified9/11/2008
Share With Others
How To - IssueClass table does not exist

Applies to: SmarterTicket 2.x                               

There are certain circumstances where MySQL will not create an essential table called IssueClass.

Here is the query you may run within MySQL's command line to enter this query into the database.

CREATE TABLE SmarterTicket_IssueClass (
    IssueClassID int NOT NULL AUTO_INCREMENT PRIMARY KEY,
    Description nvarchar(255)  NOT NULL ,
    GroupID int NULL,
    PriorityLevel int NULL
)

Important Note:  the "nvarchar" and "varchar" may need to be switched depending on if you are not using a utf-8 database