Guides & Tutorials7.1 Update TroubleshootingA blank admin dashboard after update

A blank admin dashboard after update

If none of the admin dashboard widgets are loading following an upgrade to version 7.1, the problem most likely lies in the database schema.

1. tbltransientdata table missing

Review your WHMCS MySQL database (using a tool such as phpmyadmin) and look for a table called tbltransientdata.

If the table does not exist, create it now by executing the following MySQL command:

CREATE TABLE `tbltransientdata` (
  `id` int(10) NOT NULL,
  `name` varchar(1024) COLLATE utf8_unicode_ci NOT NULL,
  `data` text COLLATE utf8_unicode_ci NOT NULL,
  `expires` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

2. Invalid data type in tbladminlog table

If the tbltransientdata table is present and correct in your database, the next thing to check is the structure of the tbladminlog table. It should look like:

+---------------+----------+------+-----+---------------------+----------------+
| Field         | Type     | Null | Key | Default             | Extra          |
+---------------+----------+------+-----+---------------------+----------------+
| id            | int(10)  | NO   | PRI | NULL                | auto_increment |
| adminusername | text     | NO   |     | NULL                |                |
| logintime     | datetime | NO   |     | 0000-00-00 00:00:00 |                |
| logouttime    | datetime | NO   | MUL | 0000-00-00 00:00:00 |                |
| ipaddress     | text     | NO   |     | NULL                |                |
| sessionid     | text     | NO   |     | NULL                |                |
| lastvisit     | datetime | NO   |     | 0000-00-00 00:00:00 |                |
+---------------+----------+------+-----+---------------------+----------------+

Any discrepancies, such as the logintime, logouttime or lastvisit fields having a text data type instead of a datetime data type could cause this problem.

Correcting the table schema to match the above will resolve the matter.