select id from lh_issuetypes where name = 'Bug' Sorry, but you need to put the default values for Bug/Enhancement in the lh_issuetypes table! select id from lh_issuetypes where name = 'Enhancement' Sorry, but you need to put the default values for Bug/Enhancement in the lh_issuetypes table! update lh_issues set issuetypeidfk = '#bugid#' where isbug = 1 update lh_issues set issuetypeidfk = '#enhid#' where isbug = 0