Illuminate Database table missing after 7.9 update

[agentblack]

Hoping for faster support here since main ticketing support is taking forever.  Prior to upgrading to 7.9, we were able to run feedback score reports and be able to see our open support tickets, however since the 7.9 upgrade, we now get 

 

0 /var/www/html/vendor/illuminate/database/Connection.php(333): PDO->prepare('select count(*)...')
1 /var/www/html/vendor/illuminate/database/Connection.php(706): Illuminate\Database\Connection->Illuminate\Database{closure}(Object(Illuminate\Database\MySqlConnection), 'select count(*)...', Array)
2 /var/www/html/vendor/illuminate/database/Connection.php(669): Illuminate\Database\Connection->runQueryCallback('select count(*)...', Array, Object(Closure))
3 /var/www/html/vendor/illuminate/database/Connection.php(342): Illuminate\Database\Connection->run('select count(*)...', Array, Object(Closure))
4 /var/www/html/vendor/illuminate/database/Query/Builder.php(1583): Illuminate\Database\Connection->select('select count(*)...', Array, true)
5 /var/www/html/vendor/illuminate/database/Query/Builder.php(1569): Illuminate\Database\Query\Builder->runSelect()
6 /var/www/html/vendor/illuminate/database/Query/Builder.php(1974): Illuminate\Database\Query\Builder->get(Array)
7 /var/www/html/vendor/illuminate/database/Query/Builder.php(1894): Illuminate\Database\Query\Builder->aggregate('count', Array)
8 /var/www/html/modules/addons/ticketsd/hooks.php(0): Illuminate\Database\Query\Builder->count()
9 /var/www/html/includes/hookfunctions.php(0): WHMCS\Utility\SafeInclude::{closure}(Array)
10 /var/www/html/vendor/whmcs/whmcs-foundation/lib/Admin.php(0): run_hook('AdminAreaPage', Array)
11 /var/www/html/vendor/whmcs/whmcs-foundation/lib/Admin.php(0): WHMCS\Admin->output()
12 /var/www/html/portal/supporttickets.php(0): WHMCS\Admin->display()
13
Next Illuminate\Database\QueryException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'whmcs.mod_ticketsd' doesn't exist (SQL: select count(*) as aggregate from mod_ticketsd where usertype = client and tid = 960 and depid = 1) in /var/www/html/vendor/illuminate/database/Connection.php:713
Stack trace:

0 /var/www/html/vendor/illuminate/database/Connection.php(669): Illuminate\Database\Connection->runQueryCallback('select count(*)...', Array, Object(Closure))
1 /var/www/html/vendor/illuminate/database/Connection.php(342): Illuminate\Database\Connection->run('select count(*)...', Array, Object(Closure))
2 /var/www/html/vendor/illuminate/database/Query/Builder.php(1583): Illuminate\Database\Connection->select('select count(*)...', Array, true)
3 /var/www/html/vendor/illuminate/database/Query/Builder.php(1569): Illuminate\Database\Query\Builder->runSelect()
4 /var/www/html/vendor/illuminate/database/Query/Builder.php(1974): Illuminate\Database\Query\Builder->get(Array)
5 /var/www/html/vendor/illuminate/database/Query/Builder.php(1894): Illuminate\Database\Query\Builder->aggregate('count', Array)
6 /var/www/html/modules/addons/ticketsd/hooks.php(0): Illuminate\Database\Query\Builder->count()
7 /var/www/html/includes/hookfunctions.php(0): WHMCS\Utility\SafeInclude::{closure}(Array)
8 /var/www/html/vendor/whmcs/whmcs-foundation/lib/Admin.php(0): run_hook('AdminAreaPage', Array)
9 /var/www/html/vendor/whmcs/whmcs-foundation/lib/Admin.php(0): WHMCS\Admin->output()
10 /var/www/html/portal/supporttickets.php(0): WHMCS\Admin->display()

Ticket support is trying to tell us that this is a third party modification and that the 7.9 update doesn't bother those, however we downloaded 7.8.3 from WHMCS site and wouldn't ya know, /vendor/illuminate/ is included with that download.  So this isn't a third party mod that we installed however WHMCS is saying it is.  In checking our database backup done before the upgrade.  I have also gone back to early December and November database backups and this table doesn't exist there either.

 

Anyone have ideas?

Thanks.

[bear]

Illuminate is just creating the DB connection. WHMCS is trying to say it's not finding the table being asked for. I've seen hooks and addons calling Illuminate, so it's conceivable some reporting module or template you're using was supposed to have created it?

I notice: /modules/addons/ticketsd/hooks.php in that quote of yours. 
That's where I'd start looking, since it's likely what's triggering this. 

Edited January 12, 2020 by bear

[agentblack]

Thanks bear.

[Evolve Web Hosting]

Are you using this module by chance? https://marketplace.whmcs.com/product/1466

[zomex]

The table being referenced is not part of WHMCS itself (mod_ticketsd). As suggested above it does appear that it could be related to a 3rd party addon.

I just found your post on WHT and can see that WHMCS confirmed this.  Your best option is to contact the developer of the module and ask them to provide support for WHMCS V7.9.

[agentblack]

Thanks everyone for the comments. Evolve, no we aren't however we found the zombie module that was the cause of the issue.  We were using ticket secure data module in the past but opted to discontinue its usage for operational reasons. We thought we had removed all of the files from the system however we found that it hadn't been completely removed.  It took two days and a thread on WHT before we were finally able to get pointed in the right direction.

[Roberto76]

hello, i've got the same issue with the registrar modules.

 

/public_html/modules/registrars/realtimeregister/app/Services/ContactService.php(59): Illuminate\Database\Eloquent\Builder->value('handle')
#9 /home/keepinho/public_html/modules/registrars/realtimeregister/app/Hooks/AdminClient.php(57): Realtimeregister\Services\ContactService::getContactMapping(239, 0)
#10 /home/keepinho/public_html/includes/hookfunctions.php(0): Realtimeregister\Hooks\AdminClient::fields(Array)
#11 /home/keepinho/public_html/admin/clientsprofile.php(0): run_hook('AdminClientProf...', Array)