search

siteserver / cms

SS CMS 基于 .NET Core，能够以最低的成本、最少的人力投入在最短的时间内架设一个功能齐全、性能优异、规模庞大并易于维护的网站平台。
https://sscms.com
GNU Affero General Public License v3.0
3.68k stars 1.21k forks source link

5.0升级6.0 用命令行时执行数据库恢复是出现以下错误log怎么解决 #666

Open snailzhang opened 6 years ago

snailzhang commented 6 years ago

{"dateTime":"2018-05-23 16:18:15","detail":"tableName siteserver_AdministratorsInRoles, fileName 1.json","message":"',' 附近有语法错误。","stackTrace":" 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)\r\n 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)\r\n 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)\r\n 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)\r\n 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n 在 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n 在 System.Data.SqlClient.SqlCommand.ExecuteNonQuery()\r\n 在 SiteServer.CMS.Data.DbHelper.ExecuteNonQuery(IDbCommand command) 位置 C:\projects\cms\SiteServer.CMS\Data\DbHelper.cs:行号 738\r\n 在 SiteServer.CMS.Data.DbHelper.ExecuteNonQuery(IDbConnection connection, String commandText, IDataParameter[] commandParameters) 位置 C:\projects\cms\SiteServer.CMS\Data\DbHelper.cs:行号 954\r\n 在 SiteServer.CMS.Data.DbHelper.ExecuteNonQuery(String connectionString, String commandText, IDataParameter[] commandParameters) 位置 C:\projects\cms\SiteServer.CMS\Data\DbHelper.cs:行号 795\r\n 在 SiteServer.CMS.Provider.DatabaseDao.InsertRows(String tableName, String columnNames, List1 valuesList, List1 parameterList) 位置 C:\projects\cms\SiteServer.CMS\Provider\DatabaseDao.cs:行号 1746\r\n 在 SiteServer.CMS.Provider.DatabaseDao.InsertMultiple(String tableName, IEnumerable1 items, List1 tableColumns) 位置 C:\projects\cms\SiteServer.CMS\Provider\DatabaseDao.cs:行号 1728\r\n 在 SiteServer.Cli.Commands.RestoreManager.Execute(String[] args)"}

{"dateTime":"2018-05-23 16:18:15","detail":"tableName siteserver_ErrorLog, fileName 1.json","message":"',' 附近有语法错误。","stackTrace":" 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)\r\n 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)\r\n 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)\r\n 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)\r\n 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n 在 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n 在 System.Data.SqlClient.SqlCommand.ExecuteNonQuery()\r\n 在 SiteServer.CMS.Data.DbHelper.ExecuteNonQuery(IDbCommand command) 位置 C:\projects\cms\SiteServer.CMS\Data\DbHelper.cs:行号 738\r\n 在 SiteServer.CMS.Data.DbHelper.ExecuteNonQuery(IDbConnection connection, String commandText, IDataParameter[] commandParameters) 位置 C:\projects\cms\SiteServer.CMS\Data\DbHelper.cs:行号 954\r\n 在 SiteServer.CMS.Data.DbHelper.ExecuteNonQuery(String connectionString, String commandText, IDataParameter[] commandParameters) 位置 C:\projects\cms\SiteServer.CMS\Data\DbHelper.cs:行号 795\r\n 在 SiteServer.CMS.Provider.DatabaseDao.InsertRows(String tableName, String columnNames, List1 valuesList, List1 parameterList) 位置 C:\projects\cms\SiteServer.CMS\Provider\DatabaseDao.cs:行号 1746\r\n 在 SiteServer.CMS.Provider.DatabaseDao.InsertMultiple(String tableName, IEnumerable1 items, List1 tableColumns) 位置 C:\projects\cms\SiteServer.CMS\Provider\DatabaseDao.cs:行号 1728\r\n 在 SiteServer.Cli.Commands.RestoreManager.Execute(String[] args)"}

{"dateTime":"2018-05-23 16:18:15","detail":"tableName siteserver_Log, fileName 1.json","message":"',' 附近有语法错误。","stackTrace":" 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)\r\n 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)\r\n 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)\r\n 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)\r\n 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n 在 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n 在 System.Data.SqlClient.SqlCommand.ExecuteNonQuery()\r\n 在 SiteServer.CMS.Data.DbHelper.ExecuteNonQuery(IDbCommand command) 位置 C:\projects\cms\SiteServer.CMS\Data\DbHelper.cs:行号 738\r\n 在 SiteServer.CMS.Data.DbHelper.ExecuteNonQuery(IDbConnection connection, String commandText, IDataParameter[] commandParameters) 位置 C:\projects\cms\SiteServer.CMS\Data\DbHelper.cs:行号 954\r\n 在 SiteServer.CMS.Data.DbHelper.ExecuteNonQuery(String connectionString, String commandText, IDataParameter[] commandParameters) 位置 C:\projects\cms\SiteServer.CMS\Data\DbHelper.cs:行号 795\r\n 在 SiteServer.CMS.Provider.DatabaseDao.InsertRows(String tableName, String columnNames, List1 valuesList, List1 parameterList) 位置 C:\projects\cms\SiteServer.CMS\Provider\DatabaseDao.cs:行号 1746\r\n 在 SiteServer.CMS.Provider.DatabaseDao.InsertMultiple(String tableName, IEnumerable1 items, List1 tableColumns) 位置 C:\projects\cms\SiteServer.CMS\Provider\DatabaseDao.cs:行号 1728\r\n 在 SiteServer.Cli.Commands.RestoreManager.Execute(String[] args)"}

{"dateTime":"2018-05-23 16:18:15","detail":"tableName siteserver_Role, fileName 1.json","message":"',' 附近有语法错误。","stackTrace":" 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)\r\n 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)\r\n 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)\r\n 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)\r\n 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n 在 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n 在 System.Data.SqlClient.SqlCommand.ExecuteNonQuery()\r\n 在 SiteServer.CMS.Data.DbHelper.ExecuteNonQuery(IDbCommand command) 位置 C:\projects\cms\SiteServer.CMS\Data\DbHelper.cs:行号 738\r\n 在 SiteServer.CMS.Data.DbHelper.ExecuteNonQuery(IDbConnection connection, String commandText, IDataParameter[] commandParameters) 位置 C:\projects\cms\SiteServer.CMS\Data\DbHelper.cs:行号 954\r\n 在 SiteServer.CMS.Data.DbHelper.ExecuteNonQuery(String connectionString, String commandText, IDataParameter[] commandParameters) 位置 C:\projects\cms\SiteServer.CMS\Data\DbHelper.cs:行号 795\r\n 在 SiteServer.CMS.Provider.DatabaseDao.InsertRows(String tableName, String columnNames, List1 valuesList, List1 parameterList) 位置 C:\projects\cms\SiteServer.CMS\Provider\DatabaseDao.cs:行号 1746\r\n 在 SiteServer.CMS.Provider.DatabaseDao.InsertMultiple(String tableName, IEnumerable1 items, List1 tableColumns) 位置 C:\projects\cms\SiteServer.CMS\Provider\DatabaseDao.cs:行号 1728\r\n 在 SiteServer.Cli.Commands.RestoreManager.Execute(String[] args)"}

{"dateTime":"2018-05-23 16:18:15","detail":"tableName siteserver_Table, fileName 1.json","message":"',' 附近有语法错误。","stackTrace":" 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)\r\n 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)\r\n 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)\r\n 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)\r\n 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n 在 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n 在 System.Data.SqlClient.SqlCommand.ExecuteNonQuery()\r\n 在 SiteServer.CMS.Data.DbHelper.ExecuteNonQuery(IDbCommand command) 位置 C:\projects\cms\SiteServer.CMS\Data\DbHelper.cs:行号 738\r\n 在 SiteServer.CMS.Data.DbHelper.ExecuteNonQuery(IDbConnection connection, String commandText, IDataParameter[] commandParameters) 位置 C:\projects\cms\SiteServer.CMS\Data\DbHelper.cs:行号 954\r\n 在 SiteServer.CMS.Data.DbHelper.ExecuteNonQuery(String connectionString, String commandText, IDataParameter[] commandParameters) 位置 C:\projects\cms\SiteServer.CMS\Data\DbHelper.cs:行号 795\r\n 在 SiteServer.CMS.Provider.DatabaseDao.InsertRows(String tableName, String columnNames, List1 valuesList, List1 parameterList) 位置 C:\projects\cms\SiteServer.CMS\Provider\DatabaseDao.cs:行号 1746\r\n 在 SiteServer.CMS.Provider.DatabaseDao.InsertMultiple(String tableName, IEnumerable1 items, List1 tableColumns) 位置 C:\projects\cms\SiteServer.CMS\Provider\DatabaseDao.cs:行号 1728\r\n 在 SiteServer.Cli.Commands.RestoreManager.Execute(String[] args)"}

{"dateTime":"2018-05-23 16:18:15","detail":"tableName siteserver_TableMetadata, fileName 1.json","message":"',' 附近有语法错误。","stackTrace":" 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)\r\n 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)\r\n 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)\r\n 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)\r\n 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n 在 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n 在 System.Data.SqlClient.SqlCommand.ExecuteNonQuery()\r\n 在 SiteServer.CMS.Data.DbHelper.ExecuteNonQuery(IDbCommand command) 位置 C:\projects\cms\SiteServer.CMS\Data\DbHelper.cs:行号 738\r\n 在 SiteServer.CMS.Data.DbHelper.ExecuteNonQuery(IDbConnection connection, String commandText, IDataParameter[] commandParameters) 位置 C:\projects\cms\SiteServer.CMS\Data\DbHelper.cs:行号 954\r\n 在 SiteServer.CMS.Data.DbHelper.ExecuteNonQuery(String connectionString, String commandText, IDataParameter[] commandParameters) 位置 C:\projects\cms\SiteServer.CMS\Data\DbHelper.cs:行号 795\r\n 在 SiteServer.CMS.Provider.DatabaseDao.InsertRows(String tableName, String columnNames, List1 valuesList, List1 parameterList) 位置 C:\projects\cms\SiteServer.CMS\Provider\DatabaseDao.cs:行号 1746\r\n 在 SiteServer.CMS.Provider.DatabaseDao.InsertMultiple(String tableName, IEnumerable1 items, List1 tableColumns) 位置 C:\projects\cms\SiteServer.CMS\Provider\DatabaseDao.cs:行号 1728\r\n 在 SiteServer.Cli.Commands.RestoreManager.Execute(String[] args)"}

{"dateTime":"2018-05-23 16:18:16","detail":"tableName siteserver_SiteLog, fileName 1.json","message":"',' 附近有语法错误。","stackTrace":" 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)\r\n 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)\r\n 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)\r\n 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)\r\n 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n 在 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n 在 System.Data.SqlClient.SqlCommand.ExecuteNonQuery()\r\n 在 SiteServer.CMS.Data.DbHelper.ExecuteNonQuery(IDbCommand command) 位置 C:\projects\cms\SiteServer.CMS\Data\DbHelper.cs:行号 738\r\n 在 SiteServer.CMS.Data.DbHelper.ExecuteNonQuery(IDbConnection connection, String commandText, IDataParameter[] commandParameters) 位置 C:\projects\cms\SiteServer.CMS\Data\DbHelper.cs:行号 954\r\n 在 SiteServer.CMS.Data.DbHelper.ExecuteNonQuery(String connectionString, String commandText, IDataParameter[] commandParameters) 位置 C:\projects\cms\SiteServer.CMS\Data\DbHelper.cs:行号 795\r\n 在 SiteServer.CMS.Provider.DatabaseDao.InsertRows(String tableName, String columnNames, List1 valuesList, List1 parameterList) 位置 C:\projects\cms\SiteServer.CMS\Provider\DatabaseDao.cs:行号 1746\r\n 在 SiteServer.CMS.Provider.DatabaseDao.InsertMultiple(String tableName, IEnumerable1 items, List1 tableColumns) 位置 C:\projects\cms\SiteServer.CMS\Provider\DatabaseDao.cs:行号 1728\r\n 在 SiteServer.Cli.Commands.RestoreManager.Execute(String[] args)"}

{"dateTime":"2018-05-23 16:18:17","detail":"tableName siteserver_Channel, fileName 1.json","message":"',' 附近有语法错误。","stackTrace":" 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)\r\n 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)\r\n 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)\r\n 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)\r\n 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n 在 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n 在 System.Data.SqlClient.SqlCommand.ExecuteNonQuery()\r\n 在 SiteServer.CMS.Data.DbHelper.ExecuteNonQuery(IDbCommand command) 位置 C:\projects\cms\SiteServer.CMS\Data\DbHelper.cs:行号 738\r\n 在 SiteServer.CMS.Data.DbHelper.ExecuteNonQuery(IDbConnection connection, String commandText, IDataParameter[] commandParameters) 位置 C:\projects\cms\SiteServer.CMS\Data\DbHelper.cs:行号 954\r\n 在 SiteServer.CMS.Data.DbHelper.ExecuteNonQuery(String connectionString, String commandText, IDataParameter[] commandParameters) 位置 C:\projects\cms\SiteServer.CMS\Data\DbHelper.cs:行号 795\r\n 在 SiteServer.CMS.Provider.DatabaseDao.InsertRows(String tableName, String columnNames, List1 valuesList, List1 parameterList) 位置 C:\projects\cms\SiteServer.CMS\Provider\DatabaseDao.cs:行号 1746\r\n 在 SiteServer.CMS.Provider.DatabaseDao.InsertMultiple(String tableName, IEnumerable1 items, List1 tableColumns) 位置 C:\projects\cms\SiteServer.CMS\Provider\DatabaseDao.cs:行号 1720\r\n 在 SiteServer.Cli.Commands.RestoreManager.Execute(String[] args)"}

{"dateTime":"2018-05-23 16:18:17","detail":"tableName siteserver_Template, fileName 1.json","message":"',' 附近有语法错误。","stackTrace":" 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)\r\n 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)\r\n 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)\r\n 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)\r\n 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n 在 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n 在 System.Data.SqlClient.SqlCommand.ExecuteNonQuery()\r\n 在 SiteServer.CMS.Data.DbHelper.ExecuteNonQuery(IDbCommand command) 位置 C:\projects\cms\SiteServer.CMS\Data\DbHelper.cs:行号 738\r\n 在 SiteServer.CMS.Data.DbHelper.ExecuteNonQuery(IDbConnection connection, String commandText, IDataParameter[] commandParameters) 位置 C:\projects\cms\SiteServer.CMS\Data\DbHelper.cs:行号 954\r\n 在 SiteServer.CMS.Data.DbHelper.ExecuteNonQuery(String connectionString, String commandText, IDataParameter[] commandParameters) 位置 C:\projects\cms\SiteServer.CMS\Data\DbHelper.cs:行号 795\r\n 在 SiteServer.CMS.Provider.DatabaseDao.InsertRows(String tableName, String columnNames, List1 valuesList, List1 parameterList) 位置 C:\projects\cms\SiteServer.CMS\Provider\DatabaseDao.cs:行号 1746\r\n 在 SiteServer.CMS.Provider.DatabaseDao.InsertMultiple(String tableName, IEnumerable1 items, List1 tableColumns) 位置 C:\projects\cms\SiteServer.CMS\Provider\DatabaseDao.cs:行号 1728\r\n 在 SiteServer.Cli.Commands.RestoreManager.Execute(String[] args)"}

{"dateTime":"2018-05-23 16:18:17","detail":"tableName siteserver_TemplateLog, fileName 1.json","message":"',' 附近有语法错误。","stackTrace":" 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)\r\n 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)\r\n 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)\r\n 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)\r\n 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n 在 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n 在 System.Data.SqlClient.SqlCommand.ExecuteNonQuery()\r\n 在 SiteServer.CMS.Data.DbHelper.ExecuteNonQuery(IDbCommand command) 位置 C:\projects\cms\SiteServer.CMS\Data\DbHelper.cs:行号 738\r\n 在 SiteServer.CMS.Data.DbHelper.ExecuteNonQuery(IDbConnection connection, String commandText, IDataParameter[] commandParameters) 位置 C:\projects\cms\SiteServer.CMS\Data\DbHelper.cs:行号 954\r\n 在 SiteServer.CMS.Data.DbHelper.ExecuteNonQuery(String connectionString, String commandText, IDataParameter[] commandParameters) 位置 C:\projects\cms\SiteServer.CMS\Data\DbHelper.cs:行号 795\r\n 在 SiteServer.CMS.Provider.DatabaseDao.InsertRows(String tableName, String columnNames, List1 valuesList, List1 parameterList) 位置 C:\projects\cms\SiteServer.CMS\Provider\DatabaseDao.cs:行号 1746\r\n 在 SiteServer.CMS.Provider.DatabaseDao.InsertMultiple(String tableName, IEnumerable1 items, List1 tableColumns) 位置 C:\projects\cms\SiteServer.CMS\Provider\DatabaseDao.cs:行号 1728\r\n 在 SiteServer.Cli.Commands.RestoreManager.Execute(String[] args)"}

starlying commented 6 years ago

可能是导入的数据库版本太低，用的是那个版本的数据库？

snailzhang commented 6 years ago

我用的系统是2008R2 64x 数据库是 sqlserver 2005

starlying commented 6 years ago

数据库版本太低~~建议用SQLSERVER 2012,或者MySQL