Windows

Please copy-paste the whole error output from the error log, run and paste the output of

SHOW CREATE TABLE promotions;

SHOW INDEX IN promotions;

and attach your cnf file(s).

CREATE TABLE `promotions` (
`code` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`libelle` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`fam_client` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
`fam_article` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
`codeart` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
`codeclient` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
`remise` double NOT NULL DEFAULT 0,
`debut` date NOT NULL DEFAULT '0000-00-00',
`fin` date NOT NULL DEFAULT '0000-00-00',
`bloquer` enum('Non','Oui') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Non',
`qte` double NOT NULL DEFAULT 100000000000,
`vendu` double NOT NULL DEFAULT 0,
`prix` double NOT NULL DEFAULT 0,
`codebar` varchar(39) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`demande_confirmation` tinyint(1) NOT NULL DEFAULT 0,
`active` tinyint(1) GENERATED ALWAYS AS (if(curdate() between `debut` and `fin` and `bloquer` = 'Non' and (`vendu` < `qte` or `qte` = 0),1,0)) VIRTUAL,
PRIMARY KEY (`code`),
KEY `codebar` (`codebar`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

Thanks. The request for your cnf/ini files still applies.

i have send you my.ini file

cirtasoft,

Thank you.
Has it been happening regularly?
Does the table get updated frequently? To your knowledge, do crashes anyhow correlate with table updates?
You've specified 10.2.9 also as an affected version, I assume it has happened there at least once (both occurrences in the log are from 10.2.6). Could you please also attach the log from 10.2.9 crash, and in general, as many examples as possible – it can help us to find similarities.
If you have a minidump from any of the crashes, please send it as well. To generate minidumps upon a crash, please add core-file option to the server config file.

the problem is in this two versions.

but is only i use with select * from table in DBGrid
and use other DB Query to read value