sntech
July 15, 2024, 10:07am
1
On refreshing or doing anything i get “pymysql.err.OperationalError: (1712, ‘Index tabVersion is corrupted’)” error. Can any have idea about this also i tried the below commands with respect to my database table , it say “”_1bd3e0294da19198.tabVersion"" doesn’t exit in engine,
use mysql
check table db;
repair table db;
@sntech , Try below command.
REPAIR TABLE ‘tabVersion’;
if not success then create table.
CREATE TABLE `tabVersion` (
`name` varchar(140) NOT NULL,
`creation` datetime(6) DEFAULT NULL,
`modified` datetime(6) DEFAULT NULL,
`modified_by` varchar(140) DEFAULT NULL,
`owner` varchar(140) DEFAULT NULL,
`docstatus` int(1) NOT NULL DEFAULT 0,
`parent` varchar(140) DEFAULT NULL,
`parentfield` varchar(140) DEFAULT NULL,
`parenttype` varchar(140) DEFAULT NULL,
`idx` int(8) NOT NULL DEFAULT 0,
`ref_doctype` varchar(140) DEFAULT NULL,
`docname` varchar(140) DEFAULT NULL,
`data` longtext DEFAULT NULL,
`_user_tags` text DEFAULT NULL,
`_comments` text DEFAULT NULL,
`_assign` text DEFAULT NULL,
`_liked_by` text DEFAULT NULL,
PRIMARY KEY (`name`),
KEY `modified` (`modified`),
KEY `ref_doctype_docname_index` (`ref_doctype`,`docname`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED;```