浏览:3592007-11-16 16:20   来自麒麟.NET      :

同城园友--北京,在翻页的时候出现错误

URL:http://space.cnblogs.com/city/beijing/members?page=2

Server Error in '/' Application.

Invalid column name 'AddDate'.
The cursor was not declared.
sp_cursorfetch: The cursor identifier value provided (0) is not valid.
sp_cursorclose: The cursor identifier value provided (0) is not valid.

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: Invalid column name 'AddDate'.
The cursor was not declared.
sp_cursorfetch: The cursor identifier value provided (0) is not valid.
sp_cursorclose: The cursor identifier value provided (0) is not valid.

Source Error:

The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:

1. Add a "Debug=true" directive at the top of the file that generated the error. Example:

  <%@ Page Language="C#" Debug="true" %>

or:

2) Add the following section to the configuration file of your application:

<configuration>
   <system.web>
       <compilation debug="true"/>
   </system.web>
</configuration>

Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.

Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario.

Stack Trace:

[SqlException (0x80131904): Invalid column name 'AddDate'.
The cursor was not declared.
sp_cursorfetch: The cursor identifier value provided (0) is not valid.
sp_cursorclose: The cursor identifier value provided (0) is not valid.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +862234
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +739110
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1956
   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) +903
   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
   Framework.Data.AdoHelper.ExecuteDataset(IDbCommand command) +149
   Framework.Data.AdoHelper.ExecuteDataset(IDbConnection connection, CommandType commandType, String commandText, IDataParameter[] commandParameters) +79
   Framework.Data.AdoHelper.ExecuteDataset(String connectionString, CommandType commandType, String commandText, IDataParameter[] commandParameters) +74
   Framework.Data.SqlHelper.ExecuteDataset(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +33
   ASP.pageClass.Page_Load(Object src, EventArgs e) +737
   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.832; ASP.NET Version:2.0.50727.832

楼主
  6个月前   dudu      :
谢谢你发现该问题,现在好了。
回复  1楼 回到顶楼 
  6个月前   坚持信念      :
顶,我昨天晚上发了这个帖子,title都是一样的
可惜死都发不出去~~~

回复  2楼 回到顶楼 
  5个月前   麒麟.NET      :
翻页还是有点问题:
http://space.cnblogs.com/city/beijing/

http://space.cnblogs.com/city/beijing/members?page=1
的内容不一样……

http://space.cnblogs.com/city/beijing/

http://space.cnblogs.com/city/beijing/members?page=2
有一部分是重复的

这样导致的结果就是:我无论如何在“北京”里,都找不到我自己……
回复  3楼 回到顶楼 
  5个月前   dudu      :
@坚持信念
发的时候出现什么现象?
回复  4楼 回到顶楼 
  5个月前   dudu      :
@麒麟.NET
现在好了。
回复  5楼 回到顶楼 
  5个月前   麒麟.NET      :
@dudu
我突然发现我设置的城市不见了……
同城园友那个页面将来是想放个地图吧?在右下角点城市,就变成了每个城市的园友,在哪里设置我的城市?
回复  6楼 回到顶楼 
  5个月前   dudu      :
@麒麟.NET
现在可以设置了。
回复  7楼 回到顶楼 

你还不是小组成员,加入小组以后才能发布新主题!
> 返回“问题反馈”


其他话题

1 8142