GenoPro Support Forum

Home Search Tags Who's On

Welcome Guest ( Login | Register )

Error in Web site

Rate Topic

Topic View

Topic Options

Author

rdn

Posted Sunday, June 19, 2011 - Post #28592

Forum Guru

Customers
GenoPro version: 2.5.4.1
Last Login: Friday, October 18, 2013
Posts: 142, Visits: 3,822

Hello,

When attempting to look at Private Projects in the http://collaboration.genopro.com/Account.aspx web location, I received the following response:

Server Error in '/' Application.

Incorrect syntax near 'by'.

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: Incorrect syntax near 'by'.

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): Incorrect syntax near 'by'.]   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() +89   GenoProLib.Collaboration.Project.GetPrivateProject(Int32 idUser, String sort) +253[TargetInvocationException: Exception has been thrown by the target of an invocation.]   System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +0   System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +71   System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) +261   System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +29   System.Web.UI.WebControls.ObjectDataSourceView.InvokeMethod(ObjectDataSourceMethod method, Boolean disposeInstance, Object& instance) +488   System.Web.UI.WebControls.ObjectDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1247   System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +19   System.Web.UI.WebControls.DataBoundControl.PerformSelect() +142   System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +73   System.Web.UI.WebControls.GridView.DataBind() +4   System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82   System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +72   System.Web.UI.Control.EnsureChildControls() +87   System.Web.UI.Control.PreRenderRecursiveInternal() +44   System.Web.UI.Control.PreRenderRecursiveInternal() +171   System.Web.UI.Control.PreRenderRecursiveInternal() +171   System.Web.UI.Control.PreRenderRecursiveInternal() +171   System.Web.UI.Control.PreRenderRecursiveInternal() +171   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +842

Version Information: Microsoft .NET Framework Version:2.0.50727.3615; ASP.NET Version:2.0.50727.3618

Danny

turnbull

Posted Friday, March 6, 2015 - Post #34726

Forum Member

Customers
GenoPro version: 3.0.1.4
Last Login: Wednesday, April 22, 2020
Posts: 30, Visits: 265

I have the same error message. Do we have a solution to this? While I am IT savy, I do not have developer skills!

GenoPro Administrator - Gamma User - Important Contributor

genome

Posted Sunday, April 5, 2015 - Post #34878

Legendary Master

Administrators
Customers
Important Contributors
FamilyTrees.GenoPro.com
GenoPro version: 3.1.0.1
Last Login: 9 hours ago
Posts: 3,337, Visits: 25,588

I suspect that both 'Private Projects' and 'Public Projects' were part of the GenoPro 'Collaboration' version
that was under development some while back but never generally released and now abandoned/mothballed.
Perhaps JC can remove these links from the page to avoid confusion and this error.

I assume you were attempting to manage your familytrees publications on the GenoPro server.
To do this, instead of clicking the 'Private Projects' and 'Public Projects' links, scroll down the page to
'Online Publications' and click 'view/hide'. Details of your familytrees publications will be displayed.

'lego audio video erro ergo disco' or "I read, I listen, I watch, I make mistakes, therefore I learn"

Edited: Sunday, April 5, 2015 by genome

Reading This Topic

GenoPro Support Forum

Error in Web site

Server Error in '/' Application.

Incorrect syntax near 'by'.

Similar Topics

Reading This Topic