Postgre Current Issues

This is the place to report bugs and get support. When posting in this forum, please always provide as much detail as possible.

Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum, do not report it as a bug.

This is the place to report bugs and get support

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.
Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum.
This thread is closed to new posts. You must sign in to post in the forums.
1/3/2011 12:21:20 PM
bob
Gravatar
Total Posts 126
YAF developer

Postgre Current Issues

1.In mojoportal-2-3-5-8-b-pgsql-net40-deploymentfiles

2011-01-02 18:04:49,007 ERROR mojoPortal.Web.mojoBasePage - x.x.x.x-ru-RU - /ImageGallery/BulkUpload.aspx?pageid=3&mid=14
Npgsql.NpgsqlException:
value too long for type character varying(100)
Severity: ERROR
Code: 22001
at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
at Npgsql.ForwardsOnlyDataReader.GetNextRow(Boolean clearPending)
at Npgsql.ForwardsOnlyDataReader.Read()
at Npgsql.NpgsqlCommand.ExecuteScalar()
at mojoPortal.Data.NpgsqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, NpgsqlParameter[] commandParameters)
at mojoPortal.Data.DBGallery.AddGalleryImage(Guid itemGuid, Guid moduleGuid, Int32 moduleId, Int32 displayOrder, String caption, String description, String metaDataXml, String imageFile, String webImageFile, String thumbnailFile, DateTime uploadDate, String uploadUser, Guid userGuid)
at mojoPortal.Business.GalleryImage.Create()
at mojoPortal.Business.GalleryImage.Save()
at mojoPortal.Features.UI.ImageGallery.GalleryHelper.ProcessImage(GalleryImage galleryImage, String filePath, Color backgroundColor)
at mojoPortal.Web.GalleryUI.BulkUploadPage.btnUpload_Click(Object sender, EventArgs e)
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
2011-01-02 18:04:49,038 ERROR mojoPortal.Web.Global - 95.165.53.76-ru-RU - /ImageGallery/BulkUpload.aspx?pageid=3&mid=14
Npgsql.NpgsqlException:
value too long for type character varying(100)
Severity: ERROR

 

2.Noticed that the e-commerce is not added. It's a pity. 

1/4/2011 7:52:53 AM
Gravatar
Total Posts 18439

Re: Postgre Current Issues

Hi Bob,

Can you tell me when you uploaded images do the images have really long file names?

Do you get the same error uploading a single image instead of bulk upload?

Eventually we will implement a data layer for pgsql for WebStore but not until it is a mature feature. It still needs a lot of work as a feature and supporting more databases right now will just slow down progress.

Best,

Joe

1/4/2011 11:30:47 AM
bob
Gravatar
Total Posts 126
YAF developer

Re: Postgre Current Issues

Joe, I don't think they were really long and it was a bulk upload. with Silverlight on

As to  e-commerce, I understand it. Currently it moves slow.

Currently I'm much more concerned about forum integration into MojoPortal.  I think that I'll find time to sync postgre data layer after that? but I still need to fix some localization issues. Currently, I'm testing postgre things as I like the DB and still don't lose hope to use it. I've already installed MP and waiting for a domain release. The installation was like a walk - 30 minutes on a new hosting in Full Trust. yes

Thanks again for good job!

1/4/2011 12:56:52 PM
Gravatar
Total Posts 18439

Re: Postgre Current Issues

Hi Bob,

I just tried the bulk upload in the Image Gallery using pgsql here and it worked as expected so it makes me think there was something specific about the files might be a factor. The error message sounds like it possibly had a value longer than 100 chars for the file name which would be an unusually long file name.

Best,

Joe

3/11/2011 5:36:25 AM
bob
Gravatar
Total Posts 126
YAF developer

Re: Postgre Current Issues

 

An Error Occurred:ERROR: 42804: column "includeinchildsitemap" is of type boolean but expression is of type character varying
Source:Npgsql
Stack Trace at Npgsql.NpgsqlState.d__a.MoveNext() in C:\projects\Npgsql2\src\Npgsql\NpgsqlState.cs:line 839 at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject() in C:\projects\Npgsql2\src\Npgsql\NpgsqlDataReader.cs:line 1163 at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription() in C:\projects\Npgsql2\src\Npgsql\NpgsqlDataReader.cs:line 1181 at Npgsql.ForwardsOnlyDataReader.NextResult() in C:\projects\Npgsql2\src\Npgsql\NpgsqlDataReader.cs:line 1367 at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError) in C:\projects\Npgsql2\src\Npgsql\NpgsqlDataReader.cs:line 1030 at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) in C:\projects\Npgsql2\src\Npgsql\NpgsqlCommand.cs:line 611 at Npgsql.NpgsqlCommand.ExecuteScalar() in C:\projects\Npgsql2\src\Npgsql\NpgsqlCommand.cs:line 712 at mojoPortal.Data.NpgsqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, NpgsqlParameter[] commandParameters) in C:\Users\Vladimir\Projects\mojoportal-1003\mojoportal_aa215d8abf02\mojoPortal.Data.pgsql\NpgsqlHelper.cs:line 143 at mojoPortal.Data.DBPageSettings.Create(Int32 siteId, Int32 parentId, String pageName, String pageTitle, String skin, Int32 pageOrder, String authorizedRoles, String editRoles, String draftEditRoles, String createChildPageRoles, String createChildDraftRoles, Boolean requireSsl, Boolean allowBrowserCache, Boolean showBreadcrumbs, Boolean showChildPageBreadcrumbs, String pageKeyWords, String pageDescription, String pageEncoding, String additionalMetaTags, Boolean useUrl, String url, Boolean openInNewWindow, Boolean showChildPageMenu, Boolean hideMainMenu, Boolean includeInMenu, String menuImage, String changeFrequency, String siteMapPriority, Guid pageGuid, Guid parentGuid, Boolean hideAfterLogin, Guid siteGuid, String compiledMeta, DateTime compiledMetaUtc, Boolean includeInSiteMap, Boolean isClickable, Boolean showHomeCrumb, Boolean isPending, String canonicalOverride, Boolean includeInSearchMap, Boolean enableComments, Boolean includeInChildSiteMap, Guid pubTeamId, String bodyCssClass, String menuCssClass) in C:\Users\Vladimir\Projects\mojoportal-1003\mojoportal_aa215d8abf02\mojoPortal.Data.pgsql\dbPageSettings.cs:line 378 at mojoPortal.Business.PageSettings.Create() in C:\Users\Vladimir\Projects\mojoportal-1003\mojoportal_aa215d8abf02\mojoPortal.Business\PageSettings.cs:line 618 at mojoPortal.Business.PageSettings.Save() in C:\Users\Vladimir\Projects\mojoportal-1003\mojoportal_aa215d8abf02\mojoPortal.Business\PageSettings.cs:line 782 at mojoPortal.Web.mojoSetup.CreatePage(SiteSettings siteSettings, ContentPage contentPage, PageSettings parentPage) in C:\Users\Vladimir\Projects\mojoportal-1003\mojoportal_aa215d8abf02\Web\Components\mojoSetup.cs:line 997 at mojoPortal.Web.mojoSetup.SetupDefaultContentPages(SiteSettings siteSettings) in C:\Users\Vladimir\Projects\mojoportal-1003\mojoportal_aa215d8abf02\Web\Components\mojoSetup.cs:line 940 at mojoPortal.Web.UI.Pages.SetupHome.RunSetup() in C:\Users\Vladimir\Projects\mojoportal-1003\mojoportal_aa215d8abf02\Web\Setup\Default.aspx.cs:line 213 at mojoPortal.Web.UI.Pages.SetupHome.Page_Load(Object sender, EventArgs e) in C:\Users\Vladimir\Projects\mojoportal-1003\mojoportal_aa215d8abf02\Web\Setup\Default.aspx.cs:line 87 at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Getting this in

mojoportal_aa215d8abf02 while doing test clean install

It seems that parameter order is incorrect.

 

3/11/2011 5:52:47 AM
Gravatar
Total Posts 18439

Re: Postgre Current Issues

Thanks Bob!

Can you pull the latest changes, it should be fixed now.

Best,

Joe

9/18/2011 7:23:34 PM
bob
Gravatar
Total Posts 126
YAF developer

Re: Postgre Current Issues

I'm sure that there is a bug in postgre data layer. When I make a clean install (9.0.1) it reports me about a missing relation as I remember modulesettings. It continues to run though and the exception is ignored. When I tried to add a new site it thrown a exception related to a select query on the same table. It seems that the problem is related to the time I  update my portal - every time I'm forced to install database from my local computer  as it stands still before coming to scripts execution.  I don't experience the issues with MS SQL Server.

9/19/2011 8:47:48 AM
Gravatar
Total Posts 18439

Re: Postgre Current Issues

Hi Bob,

I just tried a clean database with pgsql and got no errors during setup nor when creating a new site. My pgsql database is version 8.3 running on opensuse.

Best,

Joe

9/20/2011 3:04:54 AM
bob
Gravatar
Total Posts 126
YAF developer

Re: Postgre Current Issues

It seems like a connector error as we use different connectors. At least trace shows some very weird exception. It simply ignores a table. MP code looks OK.

 

1/18/2012 8:54:39 AM
bob
Gravatar
Total Posts 126
YAF developer

Re: Postgre Current Issues

Changeset 3619

[NpgsqlException (0x80004005): ERROR: 42703: column bic.category does not exist] Npgsql.<ProcessBackendResponses_Ver_3>d__a.MoveNext() +502 Npgsql.ForwardsOnlyDataReader.GetNextResponseObject() +519 Npgsql.ForwardsOnlyDataReader.GetNextRowDescription() +77 Npgsql.ForwardsOnlyDataReader.NextResult() +67 Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable'1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError) +119 Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) +285 Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb) +185 mojoPortal.Data.NpgsqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, NpgsqlParameter[] commandParameters) +349 mojoPortal.Data.DBBlog.GetCategoriesForPage(Int32 moduleId, DateTime beginDate, DateTime currentTime, Int32 pageNumber, Int32 pageSize) +1282 mojoPortal.Business.Blog.GetPageDataSet(Int32 moduleId, DateTime beginDate, Int32 pageNumber, Int32 pageSize, Int32& totalPages) +396 mojoPortal.Web.BlogUI.PostList.BindBlogs() +174

1/18/2012 9:13:39 AM
Gravatar
Total Posts 18439

Re: Postgre Current Issues

Hi Bob,

Thanks for the bug report. However, those changes only exist currently in joedev branch. No-one should be working from my development branch. I have not pushed these changes to the default branch yet because I haven't tested all my changes yet and because I haven't finished editing database scripts.

So the result will be that when I make more changes to an upgrade script before I merge it to default, then you will be missing those changes because you already ran the upgrade script and it won't run again. Once I merge changes to default then I don't edit the upgrade scripts anymore and have to make a new version incremented upgrade script to make more database changes.

When I feel my changes are stable and when I have finished editing upgrade script(s) then i will merge it to default branch. Everyone else working from the repository should be using the default branch not my development sandbox branch.

Best,

Joe

1/18/2012 8:46:34 PM
bob
Gravatar
Total Posts 126
YAF developer

Re: Postgre Current Issues

Hi, Joe.

It's my bad, as I didn't look at the branch name while updated my demo portal. It's not a problem I'll make a hack.

Thanks for the reply, bob.

 

9/19/2012 5:47:33 AM
bob
Gravatar
Total Posts 126
YAF developer

Re: Postgre Current Issues

 r.4760

In 2.3.9.1.config tinyint istead of boolean here

"moderationstatus" boolean NOT NULL,

9/19/2012 7:17:52 AM
Gravatar
Total Posts 18439

Re: Postgre Current Issues

Hi Bob,

The script has tinyint already and tinyint is the correct data type for this field.

Best,

Joe

9/19/2012 9:40:20 AM
bob
Gravatar
Total Posts 126
YAF developer

Re: Postgre Current Issues

Hi, Joe.

I don't think that Postgre has tinyint typeДразнюсь I've got an exception. I didn't look into code, maybe it should be a different data type then boolean.

Best, bob.

9/19/2012 2:39:42 PM
bob
Gravatar
Total Posts 126
YAF developer

Re: Postgre Current Issues

Update: the column should be smallint.

9/19/2012 3:15:21 PM
Gravatar
Total Posts 18439

Re: Postgre Current Issues

Thanks Bob! This is now fixed in the source code repository.

Best,

Joe

10/30/2012 5:18:45 AM
bob
Gravatar
Total Posts 126
YAF developer

Re: Postgre Current Issues

2 typos in postgre 2.3.9.3 mojoportal-core sql script  - vchar instead of varchar. 

10/30/2012 10:13:47 AM
Gravatar
Total Posts 18439

Re: Postgre Current Issues

Thanks Bob! I've fixed this in the source code repository and updated the pgsql packages for 2.3.9.3

Best,

Joe

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