点击进入知科官方网站
查看: 1356  |  回复: 1
 
 
jinjianlong
积分:320
注册时间:2012-10-29
最后登录:2014-11-17
发送短消息
发表于 2012-10-30 07:11
页面地址:www.150060.cn

问题描述:升级后列名 'sorting' 无效
首页打不开了 后台可以进
 
 

“/”应用程序中的服务器错误。

列名 'sorting' 无效。

说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。

异常详细信息: System.Data.SqlClient.SqlException: 列名 'sorting' 无效。

源错误:

行 38:                                     <div class="s1">
行 39:                                         <ul>
行 40:                                             <%=ZK.getInfoList1(9, "6", 40, "", "order by sorting desc,time desc,id desc", false, false, "", "<div class=\"red\" style=\"height:216px\">No data!</div>", "_blank",true)%></ul>
行 41:                                     </div>
行 42:                                 </div>

源文件: d:\freehost\jinjianlong201\web\index\4\index.aspx    行: 40

堆栈跟踪:

[SqlException (0x80131904): 列名 'sorting' 无效。]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1950890
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846875
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
   System.Data.SqlClient.SqlDataReader.get_MetaData() +83
   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) +954
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) +70
   WMshow.Show_mssql(CommandType cmdType, String cmdText, SqlParameter[] cmdParms) +131
   WMshow.Show(String strSQL) +74
   ZK.getInfoList1(Int32 num, String classid, Int32 len, String where, String orderby, Boolean ifShowClassName, Boolean ifShowThumbnailIco, String FirstLink, String NoDataTip, String target, Boolean StaticUrl) +2298
   ASP.index_4_index_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) in d:\freehost\jinjianlong201\web\index\4\index.aspx:40
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +256
   System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +19
   System.Web.UI.Page.Render(HtmlTextWriter writer) +29
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +27
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +99
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +25
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1266


版本信息: Microsoft .NET Framework 版本:2.0.50727.3634; ASP.NET 版本:2.0.50727.3634


截图说明:
 
 
Official服务
积分:16745
注册时间:2012-01-02
最后登录:2015-09-24
发送短消息
回复于 2012-10-30 09:14
1楼
因为升级后没初始化,按这个升级帖操作 http://city.zkcms.com/bbs/983.aspx
回复帖子