it seems every time I upgrade WHMCS with a major update it fails!
any help would be great I don't have time to wait for Support team to take a look...
Nick
Error below:
Upgrade Your Installation
Upgrade Failed
A problem was encountered while attempting to apply the database schema updates.
The error message returned by the update process was as follows:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'filetoba_whmcs.tbltransientdata' doesn't exist (SQL: insert into `tbltransientdata` (`name`, `data`, `expires`) values (cronComplete, 1, 1444059299))
How do I get help?
First, we recommend you restore the backup you took before you began the upgrade process to get your installation back online as quickly as possible.
Then open a ticket with our support team including a copy of your upgrade log file from /install/log/. This will help them diagnose what caused the failure, and what needs to be done before attempting the upgrade process again.
I hate manual upgrade they are a huge was of time...