Support - ZKTeco Europe Knowledgebase

MySQL Error: Table is marked as crashed and should be repaired

This error is related to ZKTime Lite, ZKTime Small Business and ZKTime Enterprise software.

 

It is due to a problem related to database that brokes some tables when an unexpected closure of the software happens.

 

To repair that tables, first of all, go to Services of Windows, and stop the service from the "ExtractorService" (if you have Extractor installed in your computer).

 

After that, enter as administrator in your software. Once done, press Control+ALT+Q to enter into the SQL Manager of the software.

 

Then, launch next sentences one by one:

REPAIR TABLE CIERRE_ACUMULADORES[c]

REPAIR TABLE CIERRE[c]

REPAIR TABLE CIERRE_DESGLOSE_DIAS[c]

REPAIR TABLE CIERRE_COSTES_DIAS[c]

REPAIR TABLE CIERRE_COSTES[c]

REPAIR TABLE FICHAJES[c]

 

After this procedure, the software must be run without problems.

Was this article helpful?  yes no

Related articles

Article ID: 64
Category: Time & Attendance
Date added: 01/08/2017 14:00:01
Views: 1243
Rating (Votes): Article rated 3.7/5.0 (6)

Go back