as a side note, I have to add that all the html content I tried to add are actually listed when I use Content Management to visualize them, and I can also edit them, but they are not displayed in the pages at the end.

Also the pre-existent Welcome content has never been displayed in the Home page.

Hi Joe,
sorry for being a pain in the neck...

I read chris_at's discover about PublishBegin in post http://www.mojoportal.com/ForumThreadView.aspx?thread=999&pageid=5&ItemID=2 and decided to investigate more on this issue.
It's a really bugging one because the panes in PageLayout.aspx are not update and thus the user starts filling the db with ghost items.

My understanding is that the panes are not updated because the newly created features have a "publish begin" attribute which still has to come.
This looks a lot like a timezone issue.

That's why I did not see the Welcome content: you created it on the 14th, I installed it the very same day, but due to the timezone difference the UTC BeginDate still had to come.
This morning I was of course able to see it.

After some trial and error experimentation, I found out that the "publish begin" field reported in the "Admin Menu > Content Manager > Publishing for.." page is a UTC time; being I in Italy I have a +2 time offset (GMT+1 + 1DST) and cannot see the new content after I edited; playing with the date value I come to the 2 hours threashold.

About the hour displayed in the page "Admin Menu > Content Manager > Publishing for..", I'm not sure what the expected behaviour of the server is,
should it show an UTC date (as it does now)?
should it show the time of the timezone of the server?
should it show the time of the timezone of the admin user?
probably the last one should be the best option.

anyway this is a minor issue; the worst is the PageLayout.aspx not getting updated.

What is not clear to me is how the BeginDate is set in the first place.
Is it 1.5h before the creation date?
When I create a html container, no new row is written in the mp_htmlcontent table, just one in mp_modules; in this case the indicated "Publish begin" datum seems to be 1/2h before row creation (not utc, but the header doesn't show up in the page).

hope this helps.

btw:
You said you were unable to reproduce the bug, did you try installing from scratch a MojoPortal site with italian local, browser language _and pc timezone_?

Federico

Hi all

I so have this problem.I start to debug for find this bug.

A.Samarian

Hi,

Further to above (unable to add page content), I have found the source of the bug (at least in MySQL). Line 7060 of dbPortal.cs (as of 2.2.3.6) should be:

arParams[4].Value = DateTime.UtcNow.AddMinutes(-30);

NOT

arParams[4].Value = DateTime.Now.AddMinutes(-30);

As you later compare against UTC (as you should) in getting the modules.

I hope this helps, and sorry I'm not experienced enoughh yet to submit this bug/correction directly.

Thanks again for a great product,

Allister

By the way, this bug was fixed some time ago, but it reappeared recently. About a month ago, I downloaded the trunk version, installed it, and the prefilled content was missing!

May I humbly suggest that it would be cool to move all date-time management functionality into a separate class..

ulu

Hi Joe!

I've experienced same issues till found out my timezone was -4 instead of +3. By the way new two minor bugs were discovered in ContentManager (version 2.2.7.5 MSSQL).

The first one appears when content is already published and publication date is extracted from database and it is not adjusted from UTC to user's timezone. But when the user just saves publication settings this date is adjusted back to UTC as if it was user's local time. For me it works like substract 3 hours every time I save publication. But once someone has negative timezone offset acting this manner, the publication date will be increased by offset hours. So publication start date can even be in future for newly created content. The other side of the problem is publication end date which may be critical in some applications. And it is changed in the same manner.

The second bug: PageGuid of published content does not correspond to PageID in the mp_PageModules table. It seems like it is PageGuid of the first page of portal.

Regards,

Misha

Hi Joe,

But there is an error with ContentManager. Let me point it out.

Suppose we create new content. Next, add it to some page with begin time 10 a.m. We see time is adjusted to utc in the publishing table when we press "save". A little bit confusing, but ok. Next, open the publishing record we just added and see the begin time is not 10a.m. It's 7 a.m. for me (UTC+3).

Exactly the same thing happens with end date.

Let's look into the code.

Dates in the grid are placed in the dpBeginDate and dpEndDate date picker controls. dpBeginDate is bound to PublishBeginDate column using GetBeginDate(Eval("PublishBeginDate")). GetBeginDate looks like this
protected String GetBeginDate(Object o)
{
if((o == null)||(o.ToString() == String.Empty))
{
return DateTime.UtcNow.AddHours(timeOffset).ToString();
}

return o.ToString();

}
This function adjusts time only for empty value. This happens when content has not been published yet.
dpEndDate is bound to PublishEndDate using Bind("PublishEndDate").
When RowUpdating event occurs, DatePickers simply take their values from dpBeginDate and dpEndDate.
Are date adjusted before binding occurs? I’ve traced calls down to SQL. The answer is: no.

The fix is straightforward. But I’m not sure wether DateTime.Parse works ok if some cultures are mixed. But culture combinations are not supposed to happen, do they?

ContentManager.aspx.cs starting from line 268:
protected String GetBeginDate(Object o)
{
DateTime dt;
if ((o == null) || (o.ToString() == String.Empty))
dt = DateTime.UtcNow;
else dt = DateTime.Parse(o.ToString());

return ((DateTime)dt).AddHours(timeOffset).ToString();
}

protected String GetEndDate(Object o)
{
if ((o == null) || (o.ToString() == String.Empty))
return o.ToString();
return DateTime.Parse((string)o).AddHours(timeOffset).ToString();
}

ContentManager.aspx starting from line 65:
<asp:TemplateField HeaderText="">
<ItemTemplate>
<%# GetBeginDate(Eval("PublishBeginDate"))%>
</ItemTemplate>
<EditItemTemplate>
<mp:DatePickerControl id="dpBeginDate" runat="server" Text='<%# GetBeginDate(Eval("PublishBeginDate")) %>' ShowTime="True"></mp:DatePickerControl>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="">
<ItemTemplate>
<%# GetEndDate(Eval("PublishEndDate"))%>
</ItemTemplate>
<EditItemTemplate>
<mp:DatePickerControl id="dpEndDate" runat="server" Text='<%# GetEndDate(Eval("PublishEndDate")) %>' ShowTime="True"></mp:DatePickerControl>
</EditItemTemplate>
</asp:TemplateField>

Hope this helps mojoportal become little better. :)
Sincerely,
Misha