Corrupted database tables
-
WordPress database error: [Incorrect information in file: ‘./baza/ahc_browsers.frm’]
ALTER TABLEahc_browsersADDsite_idINT(11) NOT NULL DEFAULT '1';WordPress database error: [Incorrect information in file: ‘./baza/ahc_settings.frm’]
ALTER TABLEahc_settingsADDsite_idINT(11) NOT NULL DEFAULT '1';WordPress database error: [Incorrect information in file: ‘./baza/ahc_settings.frm’]
ALTER TABLEahc_settingsCHANGEset_idset_idINT(10) UNSIGNED NOT NULL AUTO_INCREMENTWordPress database error: [Incorrect information in file: ‘./baza/ahc_browsers.frm’]
ALTER TABLEahc_browsersCHANGEbsr_idbsr_idINT(3) UNSIGNED NOT NULL AUTO_INCREMENTWordPress database error: [Incorrect information in file: ‘./baza/ahc_settings.frm’]
SELECT set_hits_days, set_ajax_check, set_ips, set_google_map FROM ahc_settings where site_id=1WordPress database error: [Incorrect information in file: ‘./baza/ahc_settings.frm’]
insert ignore intoahc_settings( set_hits_days, set_ajax_check, set_ips, set_google_map,site_id) values (14, 15, null, 'today_visitors',1)WordPress database error: [Incorrect information in file: ‘./baza/ahc_browsers.frm’]
ALTER TABLEahc_browsersADDsite_idINT(11) NOT NULL DEFAULT '1';WordPress database error: [Incorrect information in file: ‘./baza/ahc_settings.frm’]
ALTER TABLEahc_settingsADDsite_idINT(11) NOT NULL DEFAULT '1';WordPress database error: [Incorrect information in file: ‘./baza/ahc_settings.frm’]
ALTER TABLEahc_settingsCHANGEset_idset_idINT(10) UNSIGNED NOT NULL AUTO_INCREMENTWordPress database error: [Incorrect information in file: ‘./baza/ahc_browsers.frm’]
ALTER TABLEahc_browsersCHANGEbsr_idbsr_idINT(3) UNSIGNED NOT NULL AUTO_INCREMENTShowing rows 0 - 0 (1 total, Query took 0.0000 seconds.)
Your SQL query has been executed successfully. (Query took 0.0001 seconds.)
Your SQL query has been executed successfully. (Query took 0.0004 seconds.)
Your SQL query has been executed successfully. (Query took 0.0003 seconds.)
Your SQL query has been executed successfully. (Query took 0.0001 seconds.)
Your SQL query has been executed successfully. (Query took 0.0000 seconds.)
SELECT VERSION();
SHOW VARIABLES LIKE 'datadir';
SHOW TABLE STATUS FROM baza LIKE 'ahc_settings';
SHOW TABLE STATUS FROM baza LIKE 'ahc_browsers';
CHECK TABLE baza.ahc_settings;
CHECK TABLE baza.ahc_browsers;
10.3.39-MariaDB
datadir /var/lib/mysql/
ahc_settings NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Incorrect information in file: './baza/ahc_setting… NULL NULL
ahc_browsers NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Incorrect information in file: './baza/ahc_browser… NULL NULL
baza.ahc_settings check Error Incorrect information in file: './baza/ahc_setting…
baza.ahc_settings check error Corrupt
baza.ahc_browsers check Error Incorrect information in file: './baza/ahc_browser…
baza.ahc_browsers check error CorruptSHOW CREATE TABLE baza.ahc_settings;
#1033 - Incorrect information in file: './baza/ahc_settings.frm'SHOW CREATE TABLE baza.ahc_browsers;
#1033 - Incorrect information in file: './baza/ahc_browsers.frm'There are .frm, .ibd, .MYD and .MYI files for both settings and browsers.
.frm is 2026-05-22, all the rest are 2025-08-24.filesays both .frm are empty, .ibd are both data, .MYD on settings is data, on browsers, it’s empty, and both .MYI are MySQL MyISAM index file ver 1, 1 key parts, 0 unique key parts, 1 keys, 1 records, 0 elevated recordsAny ideas on the cause? Is there a recovery path? If not, is it safe to delete the tables so the plugin recreates them?
You must be logged in to reply to this topic.