Category: MySQL

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 ;