I found that you missed one in your previous fix (fe71d5447ade8624e5b33b2a779fbf17e30fe563) so hopefully this is the cause for the bug. As per usual, you'll have to run the SQL script (again).
UPDATE Firms INNER JOIN Investors ON Investors.firm = Firms.id AND Investors.firm_role = "ceo" SET Firms.ceo = Investors.name
UPDATE Firms INNER JOIN Investors ON Investors.firm = Firms.id AND Investors.firm_role = "coo" SET Firms.coo = Investors.name
UPDATE Firms INNER JOIN Investors ON Investors.firm = Firms.id AND Investors.firm_role = "cfo" SET Firms.cfo = Investors.name
As I looked at my firm's API object, I saw that the CEO and CFO are the exact same person. https://meme.market/api/firm/125
I found that you missed one in your previous fix (fe71d5447ade8624e5b33b2a779fbf17e30fe563) so hopefully this is the cause for the bug. As per usual, you'll have to run the SQL script (again).