Cant View Support Ticket in Admin Area

[sibuk]

Since updating to version 7.8.3 and updating my PHP 7.2 I am now getting this error when trying to view support tickets in admin area.

any had this problem?

 

Oops!

Something went wrong and we couldn't process your request.

Please go back to the previous page and try again.

If the problem persists, please contact us.

« Back to Homepage

For additional assistance, please reference the WHMCS TroubleShooting Guide »

InvalidArgumentException: Data missing in /home/public_html/clients/vendor/nesbot/carbon/src/Carbon/Carbon.php:425
Stack trace:
#0 /home/smartnetvps/public_html/clients/admin/supporttickets.php(0): Carbon\Carbon::createFromFormat('Y-m-d H:i:s', NULL)
#1 {main}

[sibuk]

And can I add, I can still view tickets that were created before upgrading to whmcs 7.8.3

Any tickets that were created after the upgrade gets the above error 

[WHMCS John]

Hi @sibuk,

This error can occur if columns are missing from ticket-related tables

• tblticketnotes

• tblticketreplies

• tbltickets

 

The 7.8.2 update creates an attachments_removed column in those tables, so creating them manually should resolve the error:
 

alter table `tbltickets` add `attachments_removed` tinyint(1) NOT NULL DEFAULT '0' AFTER `attachment`

alter table `tblticketreplies` add `attachments_removed` tinyint(1) NOT NULL DEFAULT '0' AFTER `attachment`

alter table `tblticketnotes` add `attachments_removed` tinyint(1) NOT NULL DEFAULT '0' AFTER `attachments`

I'd also recommend checking the other database updates have been applied., these are located at /resources/sql