Fatal error: Uncaught exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[HY000]: General error: 2006 MySQL server has gone away (SQL: select * from `tblinvoices` where `id` = 33 limit 1) (SQL: select * from `tblinvoices` where `id` = 33 limit 1)' in /home/bunnytech/public_html/control/includes/classes/WHMCS/Terminus.php:0 Stack trace: #0 [internal function]: WHMCS\Terminus->whmcsExceptionHandler(Object(Illuminate\Database\QueryException)) #1 {main} thrown in /home/bunnytech/public_html/control/includes/classes/WHMCS/Terminus.php on line 0 Fix … Continue reading Fatal error: Uncaught exception ‘Illuminate\Database\QueryException’ with message ‘SQLSTATE[HY000]: General error: 2006 MySQL server has gone away (SQL: select * from `tblinvoices` where `id` = 33 limit 1)
Category: WHMCS
WHMCS showing incorrect time than server time
Fix correct this in the configuration.php of whmcs. Open up your configuration.php (which is in your root WHMCS directory) using any text editor you are using and then at the bottom before the closing php tag add the following line: date_default_timezone_set('Pacific/Auckland');
Clients are opening support Tickets but don’t see them in my WHMCS dashboard!
Fix Make sure that when login to the client's client area, you are able to see the tickets there. If so, make sure your user is assigned to the departments. Setup -> Staff Management -> Administrator users -> your user and set what departments you want access to.
Installed whmcs via softaculous but showing page not found error
Fix This was fixed by assigning the mentioned php /usr/local/cpanel/3rdparty/php/56/bin/php /usr/local/cpanel/3rdparty/php/56/bin/php-cgi
whmcs SQL Error: Table ‘bunnytec_whmc554.tbltickettags’ doesn’t exist – Full Query: SELECT tag, COUNT(*) AS count FROM tbltickettags WHERE ticketid IN (1666) GROUP BY tag ORDER BY count DESC
Fix Please run the following MySQL query in phpMyAdmin to re-create the missing table: CREATE TABLE IF NOT EXISTS `tbltickettags` ( `id` int(10) NOT NULL AUTO_INCREMENT, `ticketid` int(10) NOT NULL, `tag` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB ;
The Linux Admin Turned Kubestronaut 