Table rebuild required. Please do "ALTER TABLE `rorynews_com.ins_banner_count` FORCE" or dump/reload to fix it! select count(*) from ins_banner_count where banner_uid='228' and count_ip='18.225.149.32' and wdate='20240420'