Error when Opening new support ticket

[Ali]

Hello,
When we open new upport ticket in client area , this error is sho
Uh oh! Something went wrong ...
Our billing system encountered an temporary error .
Please try to perform last action again. If error persists let us know, we will do our best to fix it.

the ticket is opened but not redirected to related support ticket
how can I do ?

[Ali]

I found the solution
Run this query on PHPmyadmin on related database:


ALTER TABLE `hb_ticket_related_account` CHANGE COLUMN `account_id` `rel_id` INT( 10 ) UNSIGNED NOT NULL AFTER `ticket_id` ,
ADD COLUMN `type` ENUM( 'account', 'domain' ) NOT NULL DEFAULT 'account' AFTER `rel_id` ,
DROP PRIMARY KEY ,
ADD PRIMARY KEY ( `ticket_id` , `rel_id` , `type` )

[hbillclient]

Nice that you found the solution...although be wary of editing databases this way as any future updates/bug fixes might cause issues later on.

By the way have you migrated HB data from another server or so, as you seem to be getting a few issues related to databases and all.

Thanks.