[Bug] 绝区零绳网月报获取失败

[PIut02]

Checklist

• My issue was not mentioned by others, and it is not a duplicate issue.

Description

获取1月明细时报错，总览数据获取成功，但缺少具体日期的数据，12月和2月无报错。

Reproduction Steps

点击绳网月报-1月-获取明细

Expected Behavior

No response

Screenshots

Starward Version

0.13.6

Windows Version

Windows 11 24H2

Log

Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 19: 'UNIQUE constraint failed: InterKnotReportDetailItem.Uid, InterKnotReportDetailItem.Id'.
   at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32, sqlite3)
   at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior)
   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
   at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command) in /_/Dapper/SqlMapper.cs:line 638
   at Dapper.SqlMapper.Execute(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType) in /_/Dapper/SqlMapper.cs:line 527
   at Starward.Services.GameRecordService.GetInterKnotReportDetailAsync(GameRecordRole role, String month, String type) in D:\a\Starward\Starward\src\Starward\Services\GameRecordService.cs:line 885
   at Starward.Pages.HoyolabToolbox.InterKnotMonthlyReportPage.GetDataDetailsAsync(String month) in D:\a\Starward\Starward\src\Starward\Pages\HoyolabToolbox\InterKnotMonthlyReportPage.xaml.cs:line 199

Additional Context

No response

[Scighost]

等几天再试一次

[PIut02]

到今天为止仍然报错

[Scighost]

不知道什么原因数据id冲突了，只能把最近三个月的数据删除了再次尝试。

把 @Uid 替换成你的账号uid，在数据库文件 StarwardDatabase.db 中执行，在2025年2月底前完成操作。

DELETE FROM InterKnotReportDetailItem WHERE Uid = @Uid AND DataMonth IN ('202412', '202501', '202502');

[PIut02]

删除成功后重新获取数据1月数据仍然提示与之前相同的报错，2月和12月正常