Jump to content

Illuminate Database table missing after 7.9 update

Recommended Posts

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()
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?


Link to comment
Share on other sites

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 by bear
Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

  • 4 months later...

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)

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated