Hi,
Using SuiteCRM 8.4 today trying to update to 8.4.1
Recently we tried to install a module from Sangoma to connect the PBX to the CRM but their module has an issue and can’t install (issue with SQL statements).
I went to module loader and removed the module, however it seems like there’s a query somewhere stuck:
Wed Oct 4 12:12:49 2023 [63340][1][FATAL] Error creating table: sng_callhistory: Query Failed: /* Table : sng_callhistory */
/* MISSING TABLE: sng_callhistory */
CREATE TABLE sng_callhistory (`id` char(36) NOT NULL ,`name` varchar(255) NULL ,`date_entered` datetime NULL ,`date_modified` datetime NULL ,`modified_user_id` char(36) NULL ,`created_by` char(36) NULL ,`description` text NULL ,`deleted` bool DEFAULT '0' NULL ,`assigned_user_id` char(36) NULL ,`uniqueid` varchar(255) NULL ,`linkedid` varchar(255) NULL ,`datetime` datetime NULL ,`direction` varchar(255) NULL ,`status` varchar(255) NULL ,`src` varchar(255) NULL ,`dest` varchar(255) NULL ,`duration` varchar(255) NULL ,`recording` varchar(255) NULL ,`recording_location` varchar(255) NULL , PRIMARY KEY (id), KEY idx_sng_callhistory_tmst_id (team_set_id)) CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
: MySQL error 1072: Key column 'team_set_id' doesn't exist in table
Now what happens is I can’t run Quick Repair nor finalize the 8.4.1 upgrade because it always breaks with this error.
How can I remove this query from the queue considering I’ve deleted the module? Thank you.