今天导入了.ＤＡＴ格式的备份到ＳＱＬ２０００,结果出问题了，求官方解救-领先建站CMS提供服务商我们专注于CMS建站产品的研发

2036 查看	7 回复

主题：[ICMS]今天导入了.ＤＡＴ格式的备份到ＳＱＬ２０００,结果出问题了，求官方解救 [收藏主题]

转到：

artedu 当前离线

760 主题	202 广播	11 粉丝

级别:六年级

用户积分:1600 分
登录次数:541 次
注册时间:2013/1/20
最后登录:2024/11/14

artedu 发表于：2014/2/19 20:06:02 | 只看该作者查看该作者主题楼主

做考试题库就用#科汛在线考试系统!

远程正常用的网站。备份到本地后导入出现问题。三个字段后台模型中都有。

Server Error in '/' Application.

         列名 'spxj' 无效。
列名 'spdx' 无效。
列名 'xueke' 无效。                   Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

         Exception Details: System.Data.SqlClient.SqlException: 列名 'spxj' 无效。
列名 'spdx' 无效。
列名 'xueke' 无效。

         Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

         Stack Trace:

[SqlException (0x80131904): 列名 'spxj' 无效。列名 'spdx' 无效。列名 'xueke' 无效。] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +857434 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735046 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838 System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +31 System.Data.SqlClient.SqlDataReader.get_MetaData() +62 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +886 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +122 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +7 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +141 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +86 Kesion.DataBase.DBHelper.ExecuteDataset(DbConnection connection, CommandType commandType, String commandText, DbParameter[] commandParameters) +139 Kesion.DataBase.DBHelper.ExecuteDataset(String connectionString, CommandType commandType, String commandText, DbParameter[] commandParameters) +95 Kesion.DataBase.DBHelper.ExecuteDataset(CommandType commandType, String commandText) +24 Kesion.SqlDAL.DataFactory.GetDataTable(String sqlstr) +52 Kesion.BLL.DataFactory.GetDataTable(String sqlstr) +38 Kesion.HtmlTags.Intermediate.Page.Run(String Param) +2261 Kesion.HtmlTags.ReplaceLabels.GetLabelContent(String Param) +1601 Kesion.HtmlTags.ReplaceLabels.ReplaceBasicLabel(String& str) +119 Kesion.HtmlTags.ReplaceLabels.ReplaceFunFunctionLabel(String& FileStr) +33 Kesion.HtmlTags.ReplaceLabels.ReplaceFunAndSQLLabel(String& FileStr) +56 Kesion.HtmlTags.ReplaceLabels.ReplaceAllLabel(String& FileStr) +32 Kesion.HtmlTags.ReplaceList.GetList() +1237 Kesion.NET.WebSite.Model_List.S0Shjxs3VY() +133 Kesion.NET.WebSite.Model_List.Page_Load(Object sender, EventArgs e) +414 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34 System.Web.UI.Control.OnLoad(EventArgs e) +99 System.Web.UI.Control.LoadRecursive() +47 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

一分钟快速开通线上知识店铺