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. 

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.

Thanks again for good job!

 

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.

 

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.

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.

 r.4760

In 2.3.9.1.config tinyint istead of boolean here

"moderationstatus" boolean NOT NULL,

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.