This is the 3rd or 4th of these missing column issues I've had in the last few months. It seems that somewhere along the line an upgrade went sideways.. This is the error I got today when trying to update domain pricing:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'grace_period' in 'field list' (SQL: update `tbldomainpricing` set `dnsmanagement` = 0, `emailforwarding` = 0, `idprotection` = 1, `eppcode` = 1, `grace_period` = -1, `grace_period_fee` = 0.00, `redemption_grace_period` = -1, `redemption_grace_period_fee` = 0.00, `updated_at` = 2018-11-26 11:02:06 where `id` = 1)
In all previous cases adding the column was a quick easy fix, and each time I got the exact SQL statement needed or the data-type/info so I could manually add it in PHPMyAdmin from the experts here, so looking forward to more expert help.
TIA !

Ok, after some coffee i added the column, but now i get this error, which tells me something went wrong/was missed at some point during one of the upgrades:
Base table or view not found: 1146 Table 'whmcs.tblmarketing_consent' doesn't exist

Duh.. thank you.
Can anyone else confirm the name the column? In my error it's shown as "marketingemailsopin" but in @brian! 's post its shown as marketing_emails_opt_in ..
Would i just create the name that the error indicates it's looking for?

I guess i dont know how to add a table in PHPMyadmin (although i've done it many times in the past) .. if anyone could post the SQL for this, that would be much helpful.
BTW - the board/community appears to be borked today so hopefully this posts..

Just checked and it's not there, this is very similar to an issue I had upgrading 7.5.2->7.6 which also had missing entries:
So now i'm sure that adding that column will fix it - but I need the syntax.. If @string isnt around I'll contact support.

I got this error today (below, and edited for brevity) when trying to add a new customer. It created/added the customer but i'm guessing it was just this one record that didnt get added.. I'm hoping this table just needs to be added into the database or something easy like that?
PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'marketingemailsoptin' in 'field list' in /home/vendor/illuminate/database/Connection.php:462
WHMCS\User\Client->marketingEmailOptOut('71.x.x.210', false)
Next Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'marketingemailsoptin' in 'field list' (SQL: update `tblclients` set `updated_at` = 2018-09-04 16:25:26, `marketingemailsoptin` = 0 where `id` = 104) in /home/