Alter table civicrm_case_type_en_CA is not of type 'BASE TABLE'

[shaneonabike]

Hey there,

= Problem =

When enabling the CiviCase extension I seem to have run into a strange issue whereby I am getting the following error

exception" => CiviCRM_API3_Exception {#8773
-extraParams: array:6 [
"error_code" => "unknown error"
"sql" => """
\n
ALTER TABLE civicrm_case_type_en_CA\n
ADD COLUMN case_type_category INT(10) [nativecode=1347 ** 'cinema_wordpress.civicrm_case_type_en_CA' is not of type 'BASE TABLE']
"""
"tip" => "add debug=1 to your API call to have more info about the error"
"is_error" => 1
"error_message" => "DB Error: unknown error"
`
I'm not really certain why this isn't working... the table exists it would seem.

= My environment =

• English Canada enabled
• French Canada enabled
• Latest CiviCRM
• Wordpress latest

[mlutfy]

Hi Shane,

Here's a patch: #536