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?


Share this post

Link to post
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

Share this post

Link to post
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.

Share this post

Link to post
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.

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.


Important Information

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