Using SQLite Expert you can do the following:
C:\ProgramData\Zylab\ZyTIMERService
Create a new database ' zytimerservice.db3'
Go to the database properties and change the encoding from 'utf-8' to 'utf-16le', Hit the 'apply' button.
Execute following script:
CREATE TABLE indexes (ID character(38) primary key collate nocase,_IndexPath ntext,_IndexName ntext,_IndexTitle ntext,_LastUpdateYear ntext,_LastUpdateMonth ntext,_LastUpdateDay ntext,_LastUpdateHour ntext,_LastUpdateMinute ntext,_LastUpdateSecond ntext,_NextUpdateYear ntext,_NextUpdateMonth ntext,_NextUpdateDay ntext,_NextUpdateHour ntext,_NextUpdateMinute ntext,_UpdateFreq ntext,_UpdateUnit ntext,_Automatic ntext,_Add ntext,_Quick_build ntext,_Update ntext,_Optimize ntext,_Extract ntext,_WPerrors ntext,_DbfState ntext,_IndexType ntext);
CREATE INDEX ix__IndexName ON indexes (_IndexName);
attach database 'C:\ProgramData\Zylab\ZyTIMERService\badZyTIMERService.db3' as bad;
insert into indexes select ID,_IndexPath,_IndexName,_IndexTitle,'','','','','','','','','','','',_UpdateFreq,_UpdateUnit,_Automatic,_Add,_Quick_build,_Update,_Optimize,_Extract,'','',_IndexType from bad.indexes
Comments
0 comments
Article is closed for comments.