| Author |
Messages |
|
Rodney Joyce
Gold Membership
Ventrian Master
Posts:478
 |
| 6/23/2009 5:45 AM |
|
Hi Scott,
I am getting a lot of these errors in my Event Viewer:
It happens for normal users too. It looks like some sort of dynamic SQL error? I am on DNN 4.9.4 and PA 1.7.37.
Thanks
ModuleId: 2381
ModuleDefId: 275
FriendlyName: My Poker Game Ads
ModuleControlSource: DesktopModules/PropertyAgentLatest/Latest.ascx
AssemblyVersion: 04.09.04
PortalID: 6
PortalName: PokerDIY
UserID: 2
UserName: host
ActiveTabID: 590
ActiveTabName: Profile
RawURL: /profile.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://www.pokerdiy.com/profile.aspx
UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.11; .NET CLR 3.0; ffco7) Gecko/2009060215 Firefox/3.0.11
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: d4f69ab6-3816-433d-a289-e70755e99930
InnerException: Incorrect syntax near 'BY'.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.OnError
StackTrace:
Message:
DotNetNuke.Services.Exceptions.ModuleLoadException: Incorrect syntax
near 'BY'. ---> System.Data.SqlClient.SqlException: Incorrect syntax
near 'BY'. at System.Data.SqlClient.SqlConnection.OnError(SqlException
exception, Boolean breakConnection) at
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection) at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior
runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream,
BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at
System.Data.SqlClient.SqlDataReader.get_MetaData() at
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString) at
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean
async) at
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String
method, DbAsyncResult result) at
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String
method) at
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
behavior, String method) at
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
behavior) at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection
connection, SqlTransaction transaction, CommandType commandType, String
commandText, SqlParameter[] commandParameters, SqlConnectionOwnership
connectionOwnership) at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String
connectionString, CommandType commandType, String commandText,
SqlParameter[] commandParameters) at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String
connectionString, String spName, Object[] parameterValues) at
Ventrian.PropertyAgent.SqlDataProvider.ListProperty(Int32 moduleID,
Int32 propertyTypeID, Int32 status, Int32 authorID, Int32 brokerID,
Boolean isActive, Boolean isPending, Boolean isExpired, Boolean
showFeaturedOnly, Int32 sortBy, Int32 sortByID, Int32 sortByIDType,
Int32 sortOrder, String customFieldIDs, String searchValues, Int32
pageNumber, Int32 pageSize, Boolean bubbleFeatured, Boolean
searchSubTypes, Int32 propertyIDForNextPrev, Double latitude, Double
longitude, DateTime startDate) at
Ventrian.PropertyAgent.PropertyController.List(Int32 moduleID, Int32
propertyTypeID, SearchStatusType status, Int32 authorID, Int32
brokerID, Boolean showFeaturedOnly, SortByType sortBy, Int32 sortByID,
SortDirectionType sortOrder, String customFieldIDs, String
searchValues, Int32 pageNumber, Int32 pageSize, Int32&
totalRecords, Boolean bubbleFeatured, Boolean searchSubTypes, Int32
propertyIDForNextPrev, Int32& typePosition, Double latitude, Double
longitude, DateTime startDate) at
Ventrian.PropertyAgent.Latest.BindLatest() at
Ventrian.PropertyAgent.Latest.Page_Load(Object sender, EventArgs e) ---
End of inner exception stack trace ---
|
|
Thanks
Rodney
Smart-Thinker & The DotNetNuke Directory
PokerDIY - Free tools and leagues for home poker players |
|
|
Scott McCulloch
Administrators
Ventrian Master
Posts:17204
|
| 6/23/2009 7:57 AM |
|
| I've seen this occasionally now - but I've been unable to replicate. Can you cause it to error? Do you allow the user to change sorting? I did find an issue with sorting on "last 7 days" etc and fixed it in 01.07.39 |
|
Scott McCulloch
Site Administrator |
|
|
Han Peper
Gold Membership
Ventrian Super Newbie
Posts:11
|
| 6/24/2009 11:59 PM |
|
| I'm getting the same error in 01.07.39, user sorting is not on. |
|
|
|
|
georgelew
Gold Membership
Ventrian Master
Posts:488
|
| 6/25/2009 12:42 AM |
|
Surprisingly I have the same long list of error log started from 24/06/2009.
I'm using 01.07.38.
"PA Latest" setting are:
Last Modified
Descending
All types
Show Related Checked
Agent Filet: None
-----------------
ModuleControlSource: DesktopModules/PropertyAgentLatest/Latest.ascx
AssemblyVersion: 04.09.02
ExceptionGUID: 29a6356e-e0e7-4875-9838-b0cfd7079972
InnerException: Incorrect syntax near 'BY'.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.OnError
StackTrace:
Message: DotNetNuke.Services.Exceptions.ModuleLoadException: Incorrect syntax near 'BY'. ---> System.Data.SqlClient.SqlException: Incorrect syntax near 'BY'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at Ventrian.PropertyAgent.SqlDataProvider.ListProperty(Int32 moduleID, Int32 propertyTypeID, Int32 status, Int32 authorID, Int32 brokerID, Boolean isActive, Boolean isPending, Boolean isExpired, Boolean showFeaturedOnly, Int32 sortBy, Int32 sortByID, Int32 sortByIDType, Int32 sortOrder, String customFieldIDs, String searchValues, Int32 pageNumber, Int32 pageSize, Boolean bubbleFeatured, Boolean searchSubTypes, Int32 propertyIDForNextPrev, Double latitude, Double longitude, DateTime startDate) at Ventrian.PropertyAgent.PropertyController.List(Int32 moduleID, Int32 propertyTypeID, SearchStatusType status, Int32 authorID, Int32 brokerID, Boolean showFeaturedOnly, SortByType sortBy, Int32 sortByID, SortDirectionType sortOrder, String customFieldIDs, String searchValues, Int32 pageNumber, Int32 pageSize, Int32& totalRecords, Boolean bubbleFeatured, Boolean searchSubTypes, Int32 propertyIDForNextPrev, Int32& typePosition, Double latitude, Double longitude, DateTime startDate) at Ventrian.PropertyAgent.Latest.BindLatest() at Ventrian.PropertyAgent.Latest.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---
Source:
Server Name:
It is shown together with another error:
AssemblyVersion: 04.09.02
PortalID: 0
PortalName: -
UserID: -1
UserName:
ActiveTabID: 77
ActiveTabName: -
RawURL: /agentType/EditProperty/PropertyID/28821.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer:
UserAgent: Mediapartners-Google
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: c64500b2-3fe5-48d6-8a00-d9035c9a3cc3
InnerException: Error loading FCK setting (Reverse HTML Encode output)
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Boolean.Parse
StackTrace:
Message: System.Exception: Error loading FCK setting (Reverse HTML Encode output) ---> System.FormatException: String was not recognized as a valid Boolean. at System.Boolean.Parse(String value) at DotNetNuke.HtmlEditor.FckHtmlEditorProvider.Fckeditor.LoadFCKCTLSettings(Boolean mAdmin) --- End of inner exception stack trace ---
Source:
Server Name: - |
|
Thanks,
George
Looking for Invite Friends Module? |
|
|
Scott McCulloch
Administrators
Ventrian Master
Posts:17204
|
| 6/25/2009 1:04 AM |
|
Can you please upgrade to the latest george.
Han Peper - can you describe how to replicate the issue? |
|
Scott McCulloch
Site Administrator |
|
|
Han Peper
Gold Membership
Ventrian Super Newbie
Posts:11
|
| 6/25/2009 1:53 AM |
|
| It is difficult to say when it happens because most of the time users visited the pages whiteout any errors and sometime there are. But I found out that when I switch between the view and edit mode from the page it always happens. |
|
|
|
|
georgelew
Gold Membership
Ventrian Master
Posts:488
|
| 6/30/2009 9:04 PM |
|
Just upgraded to latest release but still having the problem:
AssemblyVersion: 04.09.02
PortalID: 0
UserID: -1
UserName:
ActiveTabID: 36
ActiveTabName:
RawURL: /Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer:
UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.0.11) Gecko/2009060215 Firefox/3.0.11
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 194cd3c1-f0d6-48b8-a997-38ea8e5b790a
InnerException: Incorrect syntax near 'BY'.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.OnError
StackTrace:
Message: DotNetNuke.Services.Exceptions.ModuleLoadException: Incorrect syntax near 'BY'. ---> System.Data.SqlClient.SqlException: Incorrect syntax near 'BY'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at Ventrian.PropertyAgent.SqlDataProvider.ListProperty(Int32 moduleID, Int32 propertyTypeID, Int32 status, Int32 authorID, Int32 brokerID, Boolean isActive, Boolean isPending, Boolean isExpired, Boolean showFeaturedOnly, Int32 sortBy, Int32 sortByID, Int32 sortByIDType, Int32 sortOrder, String customFieldIDs, String searchValues, Int32 pageNumber, Int32 pageSize, Boolean bubbleFeatured, Boolean searchSubTypes, Int32 propertyIDForNextPrev, Double latitude, Double longitude, DateTime startDate) at Ventrian.PropertyAgent.PropertyController.List(Int32 moduleID, Int32 propertyTypeID, SearchStatusType status, Int32 authorID, Int32 brokerID, Boolean showFeaturedOnly, SortByType sortBy, Int32 sortByID, SortDirectionType sortOrder, String customFieldIDs, String searchValues, Int32 pageNumber, Int32 pageSize, Int32& totalRecords, Boolean bubbleFeatured, Boolean searchSubTypes, Int32 propertyIDForNextPrev, Int32& typePosition, Double latitude, Double longitude, DateTime startDate) at Ventrian.PropertyAgent.Latest.BindLatest() at Ventrian.PropertyAgent.Latest.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---
Source: |
|
Thanks,
George
Looking for Invite Friends Module? |
|
|
Scott McCulloch
Administrators
Ventrian Master
Posts:17204
|
| 7/01/2009 7:53 AM |
|
Just a note on this thread, I really need help in "reproducing" the error.
If you keep posting the exception trace, I need to know, can you produce the error on demand? In most cases, it's no. So it's really difficult to debug the issue.
From the post above, it looks like it's when you switch out of view/edit. Can you reproduce george? |
|
Scott McCulloch
Site Administrator |
|
|
georgelew
Gold Membership
Ventrian Master
Posts:488
|
| 7/01/2009 7:26 PM |
|
It seems like I cannot let the "Sort by" uncheck even with Allow user sorting uncheck.
The problem stop once I change check either one of the option in "sort by" |
|
Thanks,
George
Looking for Invite Friends Module? |
|
|
Scott McCulloch
Administrators
Ventrian Master
Posts:17204
|
| 7/02/2009 6:42 AM |
|
I don't know what you mean by "Sort By" uncheck? Can you explain in detail how you reproduce.
I cannot reproduce, I setup a latest properties instance and switched between edit/view and couldn't reproduce the error. |
|
Scott McCulloch
Site Administrator |
|
|
georgelew
Gold Membership
Ventrian Master
Posts:488
|
| 7/02/2009 7:32 PM |
|
| The error disappear when I tick the boxes in the Sorting Options in PA Latest Setting. |
|
Thanks,
George
Looking for Invite Friends Module? |
|
|
Scott McCulloch
Administrators
Ventrian Master
Posts:17204
|
| 7/02/2009 7:39 PM |
|
| Oh i see, so you had sorting turned on, but no checkbox's ticked for what fields to sort on. |
|
Scott McCulloch
Site Administrator |
|
|
Rodney Joyce
Gold Membership
Ventrian Master
Posts:478
|
| 7/15/2009 12:33 AM |
|
Posted By Scott McCulloch on 6/23/2009 7:57 AM
Can you cause it to error? Do you allow the user to change sorting?
Ok, I have a user that it happens on consistiently:
http://www.pokerdiy.com/andy-bradshaw.aspx
On the left, where it says "'Games' did not load
correctly..." is the PropertyAgent showing poker games. The user cannot sort or do any filtering. It happens to logged in and logged out users.
Interestingly, if I view this profile when logged in as Admin it works fine. This user has no properties/poker games.
The module is in a DNNStuff Aggregator. Let me know if you want me to run some SQL scripts or anything Scott.
|
|
Thanks
Rodney
Smart-Thinker & The DotNetNuke Directory
PokerDIY - Free tools and leagues for home poker players |
|
|
Scott McCulloch
Administrators
Ventrian Master
Posts:17204
|
| 7/15/2009 7:48 AM |
|
| Do you have custom sorting turned on? And do you have fields checked to sort on? |
|
Scott McCulloch
Site Administrator |
|
|
Rodney Joyce
Gold Membership
Ventrian Master
Posts:478
|
| 7/15/2009 3:11 PM |
|
Hi Scott,
Here are my settings:
 |
|
Thanks
Rodney
Smart-Thinker & The DotNetNuke Directory
PokerDIY - Free tools and leagues for home poker players |
|
|
Scott McCulloch
Administrators
Ventrian Master
Posts:17204
|
| 7/15/2009 6:29 PM |
|
| Okay - that should give me a start - thanks Rodney. |
|
Scott McCulloch
Site Administrator |
|
|
georgelew
Gold Membership
Ventrian Master
Posts:488
|
| 9/18/2009 2:56 AM |
|
Just upgraded to 5.1.2 with latest pa. It shows the same errors.
It happen in all of my PA Latest Modules. I've changed all of the setting to default by still getting the same.
|
|
Thanks,
George
Looking for Invite Friends Module? |
|
|
|