cPanel usage statistics not updating

[kdhosting]

I am having an issue with the usage report for hosting packages, the usage report has not update since 16/05/2017. Manual update also does not work.

 

Bug Error:

 

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'status' in 'where clause' in /home/kdhosting/public_html/members/vendor/illuminate/database/Connection.php:333

Stack trace:

#0 /home/kdhosting/public_html/members/vendor/illuminate/database/Connection.php(333): PDO->prepare('select * from `...')

#1 /home/kdhosting/public_html/members/vendor/illuminate/database/Connection.php(706): Illuminate\Database\Connection->Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'select * from `...', Array)

#2 /home/kdhosting/public_html/members/vendor/illuminate/database/Connection.php(669): Illuminate\Database\Connection->runQueryCallback('select * from `...', Array, Object(Closure))

#3 /home/kdhosting/public_html/members/vendor/illuminate/database/Connection.php(342): Illuminate\Database\Connection->run('select * from `...', Array, Object(Closure))

#4 /home/kdhosting/public_html/members/vendor/illuminate/database/Query/Builder.php(1583): Illuminate\Database\Connection->select('select * from `...', Array, true)

#5 /home/kdhosting/public_html/members/vendor/illuminate/database/Query/Builder.php(1569): Illuminate\Database\Query\Builder->runSelect()

#6 /home/kdhosting/public_html/members/vendor/illuminate/database/Eloquent/Builder.php(624): Illuminate\Database\Query\Builder->get(Array)

#7 /home/kdhosting/public_html/members/vendor/illuminate/database/Eloquent/Builder.php(316): Illuminate\Database\Eloquent\Builder->getModels(Array)

#8 /home/kdhosting/public_html/members/modules/servers/plesk/plesk.php(0): Illuminate\Database\Eloquent\Builder->get()

#9 /home/kdhosting/public_html/members/vendor/whmcs/whmcs-foundation/lib/Module/AbstractModule.php(0): plesk_UsageUpdate(Array)

#10 /home/kdhosting/public_html/members/vendor/whmcs/whmcs-foundation/lib/Module/Server.php(0): WHMCS\Module\AbstractModule->call('UsageUpdate', Array)

#11 /home/kdhosting/public_html/members/includes/modulefunctions.php(0): WHMCS\Module\Server->call('UsageUpdate', Array)

#12 /home/kdhosting/public_html/members/modules/reports/disk_usage_summary.php(13): ServerUsageUpdate()

#13 /home/kdhosting/public_html/members/admin/reports.php(0): unknown()

#14 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'status' in 'where clause' (SQL: select * from `tblhosting` where `server` = 1 and `status` in (Active, Suspended)) in /home/kdhosting/public_html/members/vendor/illuminate/database/Connection.php:713

Stack trace:

#0 /home/kdhosting/public_html/members/vendor/illuminate/database/Connection.php(669): Illuminate\Database\Connection->runQueryCallback('select * from `...', Array, Object(Closure))

#1 /home/kdhosting/public_html/members/vendor/illuminate/database/Connection.php(342): Illuminate\Database\Connection->run('select * from `...', Array, Object(Closure))

#2 /home/kdhosting/public_html/members/vendor/illuminate/database/Query/Builder.php(1583): Illuminate\Database\Connection->select('select * from `...', Array, true)

#3 /home/kdhosting/public_html/members/vendor/illuminate/database/Query/Builder.php(1569): Illuminate\Database\Query\Builder->runSelect()

#4 /home/kdhosting/public_html/members/vendor/illuminate/database/Eloquent/Builder.php(624): Illuminate\Database\Query\Builder->get(Array)

#5 /home/kdhosting/public_html/members/vendor/illuminate/database/Eloquent/Builder.php(316): Illuminate\Database\Eloquent\Builder->getModels(Array)

#6 /home/kdhosting/public_html/members/modules/servers/plesk/plesk.php(0): Illuminate\Database\Eloquent\Builder->get()

#7 /home/kdhosting/public_html/members/vendor/whmcs/whmcs-foundation/lib/Module/AbstractModule.php(0): plesk_UsageUpdate(Array)

#8 /home/kdhosting/public_html/members/vendor/whmcs/whmcs-foundation/lib/Module/Server.php(0): WHMCS\Module\AbstractModule->call('UsageUpdate', Array)

#9 /home/kdhosting/public_html/members/includes/modulefunctions.php(0): WHMCS\Module\Server->call('UsageUpdate', Array)

#10 /home/kdhosting/public_html/members/modules/reports/disk_usage_summary.php(13): ServerUsageUpdate()

#11 /home/kdhosting/public_html/members/admin/reports.php(0): unknown()

#12 {main}

[srsbiznus]

I'm also running into the same error. This happened right after placing an order as a client. Running WHMCS 7.3. 

 

[WHMCS Application] ERROR: exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'orderid' in 'where clause'' in /home/removed/public_html/vendor/illuminate/database/Connection.php:333 Stack trace: #0 /home/removed/public_html/vendor/illuminate/database/Connection.php(333): PDO->prepare('select * from `...') #1

[WHMCS John]

Hi,

This sounds like a known issue in version 7.2.0 if the hostname and IP fields were left empty on the server configurations, but was resolved in 7.2.2.

Could you please ensure all your servers have a hostname and IP filled in under Setup > Products/Services > Servers > Edit.