Rank: Newbie
Joined: 7/9/2010(UTC)
Posts: 2
Location: Seattle, WA
|
Fixed it. It does appear that when my sdf database previously got corrupted and then subsequently repaired that a table was dropped. I dumped the tables from my repaired manictime sdf file: Code:Activity
ActivityUpdatedDate
ComputerUsage
ComputerUsageType
ComputerUsageUpdatedDate
DatabaseVersion
DayDurationStatisticsCacheItem
DeletedActivity
DocumentGroup
GroupCategory
GroupStatistics
GroupStatisticsCacheItem
GroupStatisticsGroup
Process
Sequence
Statistics
StatisticsCache
Tag
TagGroup
TagGroupTag
Timeline
TimeTag
TimeTagUpdatedDate
TopStatistics I then renamed that file and re-opened ManicTime so it created a new default ManicTime.sdf. Dumping the tables from that I saw that the new sdf database had the table StatisticsGroup which had been dropped in my version. I scripted the creation of that table based on the one in the default database via: Code:CREATE TABLE [StatisticsGroup] (
[StatisticsGroupId] int NOT NULL ,
[Name] nvarchar(100) NOT NULL ,
[DisplayOrder] int NOT NULL ,
[StatisticsGroupType] int NOT NULL ,
[GraphType] int ,
[GroupBy] int NOT NULL ,
[UpdatedUtcTime] datetime NOT NULL ,
[TimelineId] int );
ALTER TABLE [StatisticsGroup] ADD CONSTRAINT [PK_StatisticsGroupId] PRIMARY KEY ([StatisticsGroupId]); And then adding the default data rows: Code:INSERT INTO "StatisticsGroup" ("StatisticsGroupId","Name","DisplayOrder","StatisticsGroupType","GraphType","GroupBy","UpdatedUtcTime","TimelineId")
VALUES (1,'',1,3,NULL,0,'7/12/2010 8:27:23 PM',NULL);
INSERT INTO "StatisticsGroup" ("StatisticsGroupId","Name","DisplayOrder","StatisticsGroupType","GraphType","GroupBy","UpdatedUtcTime","TimelineId")
VALUES (2,'',2,2,3,0,'7/12/2010 8:27:23 PM',2);
INSERT INTO "StatisticsGroup" ("StatisticsGroupId","Name","DisplayOrder","StatisticsGroupType","GraphType","GroupBy","UpdatedUtcTime","TimelineId")
VALUES (3,'',3,2,3,0,'7/12/2010 8:27:23 PM',3);
INSERT INTO "StatisticsGroup" ("StatisticsGroupId","Name","DisplayOrder","StatisticsGroupType","GraphType","GroupBy","UpdatedUtcTime","TimelineId")
VALUES (4,'',4,2,3,0,'7/12/2010 8:27:23 PM',1);
INSERT INTO "StatisticsGroup" ("StatisticsGroupId","Name","DisplayOrder","StatisticsGroupType","GraphType","GroupBy","UpdatedUtcTime","TimelineId")
VALUES (5,'',5,2,3,0,'7/12/2010 8:27:23 PM',4);
INSERT INTO "StatisticsGroup" ("StatisticsGroupId","Name","DisplayOrder","StatisticsGroupType","GraphType","GroupBy","UpdatedUtcTime","TimelineId")
VALUES (6,'',6,1,1,1,'7/12/2010 8:27:23 PM',NULL); And then ran those scripts against my original sdf file (renamed back to Manictime.sdf) to add that table+contents back. Now when I click on the Statistics tab in ManicTime I get the old familiar tabs and functionality. Hooray for ManicTime using SQL CE. =)
|
