XF 2.0 Update query not affecting everyone

Lukas W.

Well-known member
Does someone know why the below query works for some people but not for all? I've run it on both, my test and live installation without any trouble and everything works fine, but people are reporting that their databases haven't been affected by this query at all.

Code:
$this->db()->update('xf_connected_account_provider', ['provider_id' => 'kl_amazon'], "provider_id = 'amazon'");
        $this->db()->update('xf_connected_account_provider', ['provider_id' => 'kl_battlenet'], "provider_id = 'battlenet'");
        $this->db()->update('xf_connected_account_provider', ['provider_id' => 'kl_deviantart'], "provider_id = 'deviantart'");
        $this->db()->update('xf_connected_account_provider', ['provider_id' => 'kl_discord'], "provider_id = 'discord'");
        $this->db()->update('xf_connected_account_provider', ['provider_id' => 'kl_dropbox'], "provider_id = 'dropbox'");
        $this->db()->update('xf_connected_account_provider', ['provider_id' => 'kl_instagram'], "provider_id = 'instagram'");
        $this->db()->update('xf_connected_account_provider', ['provider_id' => 'kl_pinterest'], "provider_id = 'pinterest'");
        $this->db()->update('xf_connected_account_provider', ['provider_id' => 'kl_reddit'], "provider_id = 'reddit'");
        $this->db()->update('xf_connected_account_provider', ['provider_id' => 'kl_twitch'], "provider_id = 'twitch'");
 
Top Bottom