Custom provisioning module is not processing when we hit suspend or unsuspend

[TysonPM]

For the way we need our site to operate, when a service gets suspended we need it to update a database entry which our back end server then accesses. The issue comes when I hit the button, it just spins but does not do anything and nothing appears in the logs about it. This is what I am currently using to attempt this

Quote

function vanguard_SuspendAccount(array $params)
{
    $mysqli = new mysqli("localhost", "USERNAME", "PASSWORD", "DATABASE");
    mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
    $mysqli->set_charset("utf8mb4");
    
    try {
        
        $stmt = $mysqli->prepare("UPDATE apps SET status = ? WHERE service_id = ?");
        $stmt->bind_param("ii", "1", $params['serviceid']);
        $stmt->execute();
        $stmt->close();
        
    } catch (Exception $e) {
        // Record the error in WHMCS's module log.
        logModuleCall(
            'vanguard',
            __FUNCTION__,
            $params,
            $e->getMessage(),
            $e->getTraceAsString()
        );

        return $e->getMessage();
    }

    return 'success';
}

Any suggestions as to why this isn't working would be great!

 

Thank you!