Upgrade from 6.0.2 to 6.1 Upgrade Failed :Base table or view not found

[filetobackup]

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...

[Heaven]

Just run the following code on phpmyadmin and try to install again:

 

DROP TABLE IF EXISTS `tbltransientdata`;

 

CREATE TABLE `tbltransientdata` (

 

`id` int(10) NOT NULL AUTO_INCREMENT,

 

`name` varchar(1024) NOT NULL,

 

`data` text NOT NULL,

 

`expires` int(10) NOT NULL,

 

PRIMARY KEY (`id`),

 

KEY `name` (`name`(255))

 

) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;