发布服务器测试之后,发现新增送货,送货数量传到订单详情字段的送货数量时,有点错误,然后我获取服务器的数据之后,在数据表直接修改了订单详情的送货数量,再覆盖发送是发现报错。
但是重新换一个地址发送就可以,如果想覆盖原来的应用,该如何处理?
感谢各路大神指导。
2024-08-07 11:37:18.679 [EROR] - [027] - [cc3c2258-778b-4859-976e-9119e3d4d3f8] - [yw.v1.1] - [Server2] - Sql execute exception:
2024-08-07 11:37:18.679 [EROR] - [027] - [cc3c2258-778b-4859-976e-9119e3d4d3f8] - [yw.v1.1] - [Server2] - {
"SqliteErrorCode": 11,
"SqliteExtendedErrorCode": 11,
"IsTransient": false,
"SqlState": null,
"BatchCommand": null,
"ErrorCode": -2147467259,
"Message": "SQLite Error 11: 'database disk image is malformed'.",
"Data": {
"$type": "System.Collections.ListDictionaryInternal, System.Private.CoreLib"
},
"InnerException": null,
"HelpLink": null,
"Source": "Microsoft.Data.Sqlite",
"HResult": -2147467259,
"StackTrace": " at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
at Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements(Stopwatch timer)+MoveNext()
at Microsoft.Data.Sqlite.SqliteCommand.GetStatements(Stopwatch timer)+MoveNext()
at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader()
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
at GrapeCity.Forguncy.DataBaseApi.AdoNetExtensions.<>c__DisplayClass6_0.<ForguncyExecuteNonQuery>b__0()
at GrapeCity.Forguncy.DataBaseApi.AdoNetExtensions.Process[T](DbCommand command, Func`1 processFunc, List`1 logs, String method)
at GrapeCity.Forguncy.DataBaseApi.AdoNetExtensions.ForguncyExecuteNonQuery(DbCommand command, List`1 logs)
at SqliteWrapper.Sqlite.SetWalJournalModelAndLegacyAlterTable()"
}
CurrentMethodName: ExecuteNonQueryCommand
2024-08-07 11:37:18.679 [EROR] - [027] - [cc3c2258-778b-4859-976e-9119e3d4d3f8] - [yw.v1.1] - [Server2] - Sql statement:
2024-08-07 11:37:18.679 [EROR] - [027] - [cc3c2258-778b-4859-976e-9119e3d4d3f8] - [yw.v1.1] - [Server2] - PRAGMA journal_mode = WALRAGMA legacy_alter_table = true
2024-08-07 11:37:18.683 [WARN] - [027] - [cc3c2258-778b-4859-976e-9119e3d4d3f8] - [yw.v1.1] - [Server2] - {
"ClassName": "System.Reflection.TargetInvocationException",
"Message": "Exception has been thrown by the target of an invocation.",
"Data": {
"$type": "System.Collections.ListDictionaryInternal, System.Private.CoreLib",
"App Name": "ZI2Y54J1ASDH1SNNCOASHS1JB1QDFK5M",
"App Version": "10.0.3.0",
"Timestamp of the exe": "65310000",
"Assembly Name": "Microsoft.Data.Sqlite",
"Version of faulting assembly": "6.0.1423.6205",
"Timestamp of faulting module": "d5cd4277",
"MethodDef": "169",
"IL Offset of faulting instruction": "6d",
"Exception Type": "Microsoft.Data.Sqlite.Sqlite",
"NIL": ""
},
"InnerException": {
"$type": "Microsoft.Data.Sqlite.SqliteException, Microsoft.Data.Sqlite",
"SqliteErrorCode": 11,
"SqliteExtendedErrorCode": 11,
"IsTransient": false,
"SqlState": null,
"BatchCommand": null,
"ErrorCode": -2147467259,
"Message": "SQLite Error 11: 'database disk image is malformed'.",
"Data": {
"$type": "System.Collections.ListDictionaryInternal, System.Private.CoreLib",
"App Name": "ZI2Y54J1ASDH1SNNCOASHS1JB1QDFK5M",
"App Version": "10.0.3.0",
"Timestamp of the exe": "65310000",
"Assembly Name": "Microsoft.Data.Sqlite",
"Version of faulting assembly": "6.0.1423.6205",
"Timestamp of faulting module": "d5cd4277",
"MethodDef": "169",
"IL Offset of faulting instruction": "6d",
"Exception Type": "Microsoft.Data.Sqlite.Sqlite",
"NIL": ""
},
"InnerException": null,
"HelpLink": null,
"Source": "Microsoft.Data.Sqlite",
"HResult": -2147467259,
"StackTrace": " at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
at Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements(Stopwatch timer)+MoveNext()
at Microsoft.Data.Sqlite.SqliteCommand.GetStatements(Stopwatch timer)+MoveNext()
at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader()
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
at GrapeCity.Forguncy.DataBaseApi.AdoNetExtensions.<>c__DisplayClass6_0.<ForguncyExecuteNonQuery>b__0()
at GrapeCity.Forguncy.DataBaseApi.AdoNetExtensions.Process[T](DbCommand command, Func`1 processFunc, List`1 logs, String method)
at GrapeCity.Forguncy.DataBaseApi.AdoNetExtensions.ForguncyExecuteNonQuery(DbCommand command, List`1 logs)
at SqliteWrapper.Sqlite.SetWalJournalModelAndLegacyAlterTable()
at SqliteWrapper.Sqlite..ctor(String connectionStr)"
},
"HelpURL": null,
"StackTraceString": " at System.RuntimeMethodHandle.InvokeMethod(Object target, Span`1& arguments, Signature sig, Boolean constructor, Boolean wrapExceptions)
at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at ForguncyDataAccess.DataBaseWrapperFactory.CreateInstance(String dataBaseType, String connectionStr, List`1 logs)
at Forguncy.DataSourceBase.get_DataBaseWrapper()
at Forguncy.DataSourceBase.GetDataTableSchema(String tableName, String tableSchema)
at ForguncyDataAccess.DataAccess.GetDataTableSchema(String connectionStr, String dbType, String tableName, String schema)
at ForguncyDataAccess.DataAccess.GetDataTableSchema(String tableName)
at ForguncyDataAccess.TableEditStatusManager.EnsureStatusColumns(IDataAccess dataAccess, String tableName)
at Forguncy.Server2.ForguncyServerDataAccess.HandlingSpecialColumnQueryInfosAsync(QueryInfo queryInfo, String tableName)
at Forguncy.Server2.ForguncyServerDataAccess.PrepareForSelectingAsync(List`1 columnBindingInfos, ISqlCondition selectCondition, OrderBySqlCondition orderByCondition, String tableName)
at ForguncyDataAccess.DataAccess.SelectAsync(List`1 columnBindingInfos, ISqlCondition selectCondition, TopSqlConditionBase topCondition, String tableName, OrderBySqlCondition orderByCondition, OffsetSqlCondition offsetCondition, Boolean useGroupBy)
at Forguncy.Server2.ForguncyServerDataAccess.SelectAsync(List`1 columnBindingInfos, ISqlCondition selectCondition, TopSqlConditionBase topCondition, String tableName, OrderBySqlCondition orderByCondition, OffsetSqlCondition offsetCondition, Boolean useGroupBy)
at ForguncyDataAccess.DataAccess.GetDetailDataTableAsync(List`1 columnBindingInfos, ISqlCondition sqlCondition, TopSqlConditionBase topCondition, OrderBySqlCondition orderByCondition, List`1 primaryKeys, OffsetSqlCondition offsetCondition, Boolean distinct, Boolean ensureOrderBy)
at ForguncyDataAccess.DataAccess.GetDataTableAsync(List`1 columnBindingInfos, ISqlCondition sqlCondition, TopSqlConditionBase topCondition, List`1 primaryKeys, OrderBySqlCondition orderByCondition, OffsetSqlCondition offsetCondition, Boolean distinct, Boolean ensureOrderBy)
at Forguncy.Server2.ForguncyServerDataAccess.GetDataTableAsync(List`1 columnBindingInfos, ISqlCondition sqlCondition, TopSqlConditionBase topCondition, List`1 primaryKeys, OrderBySqlCondition orderByCondition, OffsetSqlCondition offsetCondition, Boolean distinct, Boolean ensureOrderBy)
at Forguncy.Server2.Controllers.HomeController.GetComboValueAndTextsAsync(GetComboValueAndTextsParam param)",
"RemoteStackTraceString": null,
"RemoteStackIndex": 0,
"ExceptionMethod": null,
"HResult": -2146232828,
"Source": "System.Private.CoreLib",
"WatsonBuckets": null
}
|