NpgsqlHelper.cs bug?

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

Please do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.

This forum is for discussing mojoPortal development

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

You can monitor commits to the repository from this page. We also recommend developers to subscribe to email notifications in the developer forum as occasionally important things are announced.

Before posting questions here you might want to review the developer documentation.

Do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.
This thread is closed to new posts. You must sign in to post in the forums.
10/15/2009 12:51:54 PM
Gravatar
Total Posts 37

NpgsqlHelper.cs bug?

I found something what might be a bug. While trying to go to admins account settings using link "My account". Trace below:

 

Thanks,

Przemek

 

--------------------------------

 

BŁĄD: 42601: błąd składni w lub blisko "]"

 

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: Npgsql.NpgsqlException: BŁĄD: 42601: błąd składni w lub blisko "]"

 

Source Error:

 

 

Line 893: if( mustCloseConnection )

Line 894: connection.Close();

Line 895: throw;

Line 896: }

Line 897: }

 

Source File: c:\work\mojoPortal\mojoPortal.Data.pgsql\NpgsqlHelper.cs Line: 895

 

Stack Trace:

 

 

[NpgsqlException (0x80004005): BŁĄD: 42601: błąd składni w lub blisko "]"]

Npgsql.<ProcessBackendResponses_Ver_3>d__a.MoveNext() in C:\projects\Npgsql2\src\Npgsql\NpgsqlState.cs:831

Npgsql.ForwardsOnlyDataReader.GetNextResponseObject() in C:\projects\Npgsql2\src\Npgsql\NpgsqlDataReader.cs:1118

Npgsql.ForwardsOnlyDataReader.GetNextRowDescription() in C:\projects\Npgsql2\src\Npgsql\NpgsqlDataReader.cs:1136

Npgsql.ForwardsOnlyDataReader.NextResult() in C:\projects\Npgsql2\src\Npgsql\NpgsqlDataReader.cs:1314

Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError) in C:\projects\Npgsql2\src\Npgsql\NpgsqlDataReader.cs:985

Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) in C:\projects\Npgsql2\src\Npgsql\NpgsqlCommand.cs:572

Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb) in C:\projects\Npgsql2\src\Npgsql\NpgsqlCommand.cs:550

mojoPortal.Data.NpgsqlHelper.ExecuteReader(NpgsqlConnection connection, NpgsqlTransaction transaction, CommandType commandType, String commandText, NpgsqlParameter[] commandParameters, NpgsqlConnectionOwnership connectionOwnership) in c:\work\mojoPortal\mojoPortal.Data.pgsql\NpgsqlHelper.cs:895

mojoPortal.Data.NpgsqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, NpgsqlParameter[] commandParameters) in c:\work\mojoPortal\mojoPortal.Data.pgsql\NpgsqlHelper.cs:946

mojoPortal.Data.DBLetterSubscription.GetByUser(Guid siteGuid, Guid userGuid) in c:\work\mojoPortal\mojoPortal.Data.pgsql\DBLetterSubscription.cs:431

mojoPortal.Business.SubscriberRepository.GetListByUser(Guid siteGuid, Guid userGuid) in c:\work\mojoPortal\mojoPortal.Business\ELetter\SubscriberRepository.cs:201

mojoPortal.Web.ELetterUI.SubscriberPreferencesControl.GetSubscriptions() in c:\work\mojoPortal\Web\Controls\SubscriberPreferencesControl.ascx.cs:285

mojoPortal.Web.ELetterUI.SubscriberPreferencesControl.LoadSettings() in c:\work\mojoPortal\Web\Controls\SubscriberPreferencesControl.ascx.cs:275

mojoPortal.Web.ELetterUI.SubscriberPreferencesControl.Page_Load(Object sender, EventArgs e) in c:\work\mojoPortal\Web\Controls\SubscriberPreferencesControl.ascx.cs:43

System.Web.UI.Control.OnLoad(EventArgs e) +99

System.Web.UI.Control.LoadRecursive() +50

System.Web.UI.Control.LoadRecursive() +141

System.Web.UI.Control.LoadRecursive() +141

System.Web.UI.Control.LoadRecursive() +141

System.Web.UI.Control.LoadRecursive() +141

System.Web.UI.Control.LoadRecursive() +141

System.Web.UI.Control.LoadRecursive() +141

System.Web.UI.Control.LoadRecursive() +141

System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627

 

-------------------------

10/19/2009 9:47:58 AM
Gravatar
Total Posts 18439

Re: NpgsqlHelper.cs bug?

If you do svn  update and rebuild, visit /Setup.aspx, this should be fixed now.

Thanks,

Joe

10/19/2009 11:54:38 AM
Gravatar
Total Posts 37

Re: NpgsqlHelper.cs bug?

I updated from svn and rebuild the whole solution.

Still having the same problem.

 

Przemek

10/19/2009 11:58:01 AM
Gravatar
Total Posts 37

Re: NpgsqlHelper.cs bug?

Maybe this might be a problem?

 

"SELECT ls.*, u.email AS useremail, COALESCE(u.name, ls.emai]) AS name FROM\tmp_lettersubscribe ls LEFT OUTER JOIN mp_users u ON u.userguid = ls.userguid WHERE ls.siteguid = '2b09c235-66ff-4b62-b923-285e0e02728e'::char(36) AND ls.userguid = '4da64127-e525-4613-a873-5e7dd1fd105d'::char(36) ;"

 

Przemek

10/19/2009 2:20:15 PM
Gravatar
Total Posts 18439

Re: NpgsqlHelper.cs bug?

My bad, this typo was in several places and I missed one spot when fixing it. If you do svn update and rebuild again this one should be fixed.

Thanks,

Joe

You must sign in to post in the forums. This thread is closed to new posts.