Category: Date and Time

Using recent 1.10 (end of november'07):
today December 8th 2007 I've set a new event at a calendar:
http://intercanvis.net/tiki-calendar.php?todate=1197068400

If you view this calendar as anonymous you see the correct date in both places:
# Focus: Dissabte 08/Desembre/2007 (08/12/07, Saturday)
# Cel (current and focus) date: 12/08

However, if you login as plain registered user, this same url:
http://intercanvis.net/tiki-calendar.php?todate=1197068400

...it takes you to: "Focus: Friday 07/December/2007" (user abel, for instance), which is wrong: it should be 08/Desembre/2007

And if you login as user with admin rights (user Xavi) , the same url shows:
# Focus: Dissabte 08/Desembre/2007 (08/12/07, Saturday)
# __BUT Cel (current and focus) date shows__: 12/07,
+ which is wrong: it should be 08/Desembre/2007
+ (if you click at teh event view, the date is set right: 08/12/07)
-----
Further Update:
This is kind of weird: I had prefference for new users as "site default", and site language was either English or Catalan, amnong the few allowed languages for users.
I checked language of user "abel", and it had "Arabic" (which was not among the pre-selected as available for users).

I changed default language for all users as Catalan, and ensure the only Catalan, Spanish, English and French were allowed. Then, again, tried viewing this date:
http://intercanvis.net/tiki-calendar.php?todate=1197068400

with user "usuari", which has language selected to English: date in calendar is shown fine.
# Focus: Dissabte 08/Desembre/2007 (08/12/07, Saturday)
# Cel (current and focus) date: 12/08

However, if I login as user "abel" (with Catalan interface), weird change in date shown is produced:
# Focus: Dissabte 08/Desembre/2007 (08/12/07, Saturday)
# Cel (current and focus) date: 12/07 __1 day less than it should__

I can enable an account there for any admin who want to track/hunt this bug, if needed.

Adding an event to the calendar adds 3 or 5 hours depending if user is at local or UTF time.

Bug reproduced on Tikiwiki.org

Bug is present with or without jscalendar.

{draw name=CalendarTimeBug}

Contributors

Example: I've created a created including two date fields, Date Started and Date Closed.

Both are date and time data type, with options d,2008,,blank

I've also created a wiki page and added a tracker new item form with PluginTracker, configured to display only Date Started. When saving the new item, the visible field (Date Started) inserts a blank as expected (from the values in the controls), but the hidden field (Date Closed) inserts today's date. If Date Closed is made visible, it starts defaulting to blank as well. So hidden fields appear to be behaving as if option 'empty' rather than option 'blank', or not picking up the option at all.

Showing a comment to a blog entry that has been posted the same day, only the time when the comment was posted is displayed. We use the German translation of TikiWiki, but the English "at" in "at 12:34" is display, not the German "um".
After having a look into the code, it seems the translation function is not called in lib/smarty_tiki/tiki_short_datetime.php

Steps to reproduce:

1. Goto http://tikiwiki.org/TikiFeatures and click on an upcoming event.

2. click on the calendar tab. choose monthly view.

3. now navigate backwards or forwards with the "Week" navigation buttons.

3. If the currently selected cell is prior to today's date the dates display correctly. If the currently selected cell is after today the entire month view displays incorrect dates.

Trackers are great in Tiki, it provides a way to build quick and easy register solutions.
When used in any context related to monitoring, it would be nice to have a way to associate a record with one or more events in time. For instance you would like to receive an email at the time the issue related to the task should be controlled and/or be resolved.

Thinking on it as a feature, the following could be considered in the solution:
*It could exist more than one "timer" in the tracker record,
*It should be added like any other tracker field to the record definition,
*It could have different ways to alert: email, rss, ... (maybe only one choice when instance),
*It could have rules, like auto disable when the record is closed (or other condition),
*It could be (as an option) reprogrammed,

and also
*Maybe a user wants to know about all his/her pending "timers".
*Maybe timer implementation could be independent objects that are linked to (special fields in) tracker records (or other objects), so global management is possible.

I guess that a good part of above functionality is already in Tiki in some form.

Normally, we want banners from 0h00 to 23h59 and this works well.

However, on banner edit, 3 hours are added (depends on server).

This is a new problem introduced by a fix a few months ago. Tiki 1.10 has much better handling of timezones.

Workaround: On each edit, make sure to change back to 0h00 to 23h59



{img src=show_image.php?id=31}

When you publish a blog post using an upcoming publish date, post appears right away in last_blog_posts module even if the publish date is stll in the future.

After updating tikiwiki3.3 to 4.1, the following fails to load
/tiki-admin_categories.php
/tiki-admin_polls.php and
/tiki-wiki_rss.php?ver=2

I checked memory and execution time therefore the problem due to this is ruled out. Problem must be somewhere which I could not figure out.

Time does not show correctly while date is perfect. It needs me to set time of publication of articles manually.

The module since your last visit does not work properly.

On my part I reinstalled it several times but errors persists.

There is currently no sanity check

According to the Calendar Module docs, "For the blogs system any weblog will only display posts with dates equal or lower than the date selected in the calendar." But this doesn't seem to work. There is no change in the blog posts displayed even when a date prior to one or more blog posts is clicked.

Using the same 1.10svn from March 29th 2008 on two sites on the same hosting.

If "Time zone" setting at "Admin > login > default values" was set as default: "Detect Browser time zone if possible and site deafult if not" (or something similar) in the first tiki site, but unset on the second tiki site, then dates in site 1 are shown in tiki-calendar.php month view with a label which is wrong: it shows date -1 day. Site two shows the right date.

I.e.: today Wednesday April 2nd, on site one would say 04/01 (on the wednesday column, which is the correct one), and on site two, it would say: 04/02 (also on the wednesday column, the correct one).

When viewing the event at item view, then the date is shown correctly on both sites.

Once I set "site default" as default seting for new users on site one, dates were shown ok.

I'm afraid that previously registered users on tiki site 1 will have the wrong setting and thus, I will have to change their setting manually....

I would suggest that, if somebody else can confirm this bug, the default setting onp tiki.sql and 1.9_to_1,0.sql would be "site default" and not "browser based thingy....

Sometimes, first day of the week is Sunday, even if you set that to be Monday on Calendar settings.

This bug shows up for us (catalan interface, time zone "Europe Madrid (UTC+1)" when we have in tiki-admin.php?page=general, at preferecnes syntax:
"1.10 - $prefs.feature_foobar..."

When we swich this parameter to
"1.9 - $feature_foobar"

then fist day of the week in calendar is Monday, as expected

((RoadMap)) shows "Fatal error: Call to undefined method TikiDate::getDate() in /home/tiki/public_html/lib/wiki-plugins/wikiplugin_countdown.php on line 60". This happens when using the COUNTDOWN plugin on PHP 5.1 and later due to a missing definition of getDate() in the lib/tikidate-php5.php TikiDate. The old TikiDate (lib/tikidate-pear-date.php) declared that function (via inheritance).

This was introduced in r14129 and widely exposed in r20047 on lib/tikidate.php.

Hi,

Because of partial translations of pages, I use French or English GUI translated and sometimes Spanish, Italian or German.
Because I Have defined complementary of elements of GUI dictionary, it is not so evident to take care the whole time with which language you are working and more the associated date format.

It is the reason, while, after, some errors in input dates in a wrong format that I do believe that the current format to input a date should be always repeated into display tpl or input title (displayed).

This is a long and progressive but useful job in my opinion.

Each time I can do it, I do.

When editing a new article, the publish date at the bottom defaults to 2000. The month and day are not consistent, but it's always 2000.

I've checked the code. It's using these variables.
{CODE()}
$publishDate = date("U");
$cur_time = getdate();
$expireDate = mktime ($cur_time["hours"], $cur_time["minutes"], 0, $cur_time["mon"], $cur_time["mday"]+365, $cur_time["year"]);
$dc = &$tikilib->get_date_converter($user);
{CODE}
I'm running 1.9.1.

Any ideas?

Can be duplicated on tikiwiki.org

start and end time in tiki-calendar.php (add or edit mode) takes the GMT time, even if the current user is in local time.

This is not such a problem when adding an event because the user is expected to choose the time.

However, when someone edits an existing event, the start & end times are reverted back to GMT. When the user saves the event, the time is several hours off.

--

Related:
Also affects tiki-edit_article.php, tiki-edit_submission.php and tiki-view_tracker.php (when submitting a tracker)

To duplicate the bug, you must be in a different timezone than your server.

So if I change the format of short date, I can see right away the formatted result with the current time.

This was done in later versions of 1.9.11 but not in 2.0

Should be in new magic admin panel

In groups of people you often have the problem to find day/time when all the people have time to meet.

Especially if they are not in the same room.
And even if they are present its difficult to talk about all the pro and cons when is the best time.


http://www.doodle.com/
Is offering an easy solution. Everybody marks the spots when he has time. Doodle comes up with a proposal, when is the best time to meet. No discussions, every vote has the same weight, non-party and you can always reproduce how the decission was formed.

Can we integrate something like this? Especially because the Tiki direction goes more in decision making.
That feature would fit perfectly in.

In groups of people you often have the problem to find day/time when all the people have time to meet.

Especially if they are not in the same room.
And even if they are present its difficult to talk about all the pro and cons when is the best time.


http://www.doodle.com/
Is offering an easy solution. Everybody marks the spots when he has time. Doodle comes up with a proposal, when is the best time to meet. No discussions, every vote has the same weight, non-party and you can always reproduce how the decission was formed.

Can we integrate something like this? Especially because the Tiki direction goes more in decision making.
That feature would fit perfectly in.

The calendar in TW6.7 does not render correctly in IE8. It shows two months worth of dates instead of the expected single month when in month view. Week view and day view render correctly in IE8, though.

Also, amazingly, the same install of TW6.7 shows the dates of the month of March when viewed with IE8 and April (the current month) when viewed in IE9 and other major standards compliant browsers.

Activating the PlugIn FullCalendar for the display of calendar items does not show event information as expected when using the 24h display mode.
It seems that FullCalendar is not aware of the setting (12h/24h) and shows the time as AM/PM anyway.

The module upcoming_events does not indicate whether an all-day event lasts longer than one day. Such an event is only listed once on its first day. If the end date of events, that don't last all day is not displayed (parameter showEnd=y), an event lasting multiple days is indistinguishable from an event lasting only a few minutes.

Features Classification

Contributors

This manual time / date selection (code below) should be optional off

__Sorry, code plugin doesn't work so below looks weird...__

{CODE()}
<input type="text" name="start_freeform" value="{$start_freeform}">
<a {popup text="{tr}Format: mm/dd/yyyy hh:mm<br />...}{/tr} {tr}See strtotime php function{/tr}"}><img src="img/icons/help.gif" border="0" height="16" width="16" alt='{tr}help{/tr}'></a>
{tr}or{/tr}

<input type="text" name="end_freeform" value="{$end_freeform}">
<a {popup text="{tr}Format: mm/dd/yyy hh:mm<br />...}{/tr} {tr}See strtotime php function{/tr}"}><img src="img/icons/help.gif" border="0" height="16" width="16" alt='{tr}help{/tr}'></a>
{tr}or{/tr}
{CODE}

In the type "date and time" it may be necessery to be able to have only 'year' choise instead of year, month, day and hour


::: FRENCH :::
Dans le type "date and time" nous devrions pouvoir avoir seulement année (de x à x au choix), seulement mois/année ou seulement jour/mois/année. Pour plusieurs tracker, la suppression de l'heure est nécessaire, comme lorsqu'on demande la date de naissance d'un individu !

The pop up calendar in Calendar view only shows 24hr time and there seems to be no place to set this. It does not respect the time settings in admin/General as the rest of the Calendar does. Here in AM/PM land it makes it unusable and I've had to disable it in the template.

Sorry if I've entered this wrong -I'm a user and I'm not sure I'm even supposed to put things here.

In message list and for each message.

__Background:__ I'm in the process of an overdue upgrade of two Tikis from version 2.2 to the new LTS version 6.x. Testing and adaptation of styles was done on XAMPP localhost under Windows and all worked fine. Problems began with installing on public server (Debian). Installation is done from shell (tar.gz and running setup.sh) and a fresh install works fine.

__Problem:__ When I use the existing database (no problems at database upgrading to 6.2 reported) then it also works fine for anonymous user. But as soon as I try to login as admin user, I get a long wait and then:

__Fatal error:__ Out of memory (allocated 110100480) (tried to allocate 157 bytes) in /home/hrusccbo/tikitest.hruschka.com/tiki-6.2/lib/init/initlib.php on line 185
''(Note: the line number 185 varies)''

In order to locate the error, I entered the following line in initlib:

171: print ("a:$errno, b:$errstr, c:$errfile, d:$errline");

The result is that Tiki starts displaying thousands of times, in an endless loop, until memory exhaustion:
a:2, b:DateTimeZone::__construct() [datetimezone.--construct]: Unknown or bad timezone (M), c:lib/tikidate-php5.php, d:182

From that I deduct that the error originates from line 182 of tikidate-php5.php


===Some other findings which might be useful:===

The last days I tried to enter dev.tiki.org and themes.tiki.org, but could not because the sites displayed exactly the same error. Yesterday I went to IRC chat and was advised to clear the cookies of my browser. After that it worked.

Looking at the cookies now, I found that "local_tz" (I assume that has to do with timezone) of my working tw_2.2 had the content "22%3A37%3A23", the cookie from tiki.org has now the content "UTC", but the cookies from working XAMPP/localhost and from the not working Debian 6.2 installation have both the content "M".

This fits to the origin of the error, as line 182 is "function setTZbyID" which calls "function convertMissingTimezone", where "M" is used in a switch/case statement.

But probably the bug is not really in the tikidate script, but where the cookies are set !!! (see below under "workaround")

Hope that helps to locate the bug and that it can be solved in 6.3. In the meantime I'll wait with migrating.

Thanks to all of you for your great work.
Felix
(running 3 tiki sites since 2005)

((doc:PluginCountdown)) a great idea. But showing time to the seconds is not a good default.

Wish:
Make options; Days, Days & hours, etc

Should be an option as to how to handle once time is passed.

__x days since__ or __the event has happened__

And locate time has no effect here:
http://tikiwiki.org/TikiFestNY

{QUOTE()}
Stateful? by rpg
posted on: Wed 18 of Jul, 2007 [17:48]
The idea of an aggregator --- and ideally one that could be put on a Wiki page together with other items --- sounds great. But only if it's going to be a stateful aggregator. I.e., I don't want one that will forget which items I have read when I revisit it.
{QUOTE}


A simple fix would be to somehow highlight all the RSS feed items which have a date/time which is after your last login. A bit like the "Since your last visit" module.

Seen on IRC:
{img src=images/code.png}%%% {CODE(wrap=>1)}
(10:33:47 AM) ***dthacker also wonders if there is a login-timestamp wiki syntax such as mediawiki's ~~~~ that would auto sign with user id and date/time.
{CODE}


Wiki pages are great to produce Neutral Point of View (NPOV) content. If we need to know who added what, we check the edit history.

For debates, discussions, opinions, etc, people will often use Tiki blogs, Tiki forums or comments at the bottom of wiki pages. These are more natural formats and it's clear who thinks what and who said what. Comments & forum threading make it clear who is responding to who/what.

However, in some cases, it is useful to have this type of interaction in wiki pages. The [http://doc.tikiwiki.org/Editorial+Board|TikiWiki documentation Editorial board] has monthly meetings to discuss and make decisions. Members can edit, comment and vote on motions.

The way people add their comments is not standard and if we are not careful, it can get messy. This often happens in wikis.

Some wikis use a special syntax for "signature". This would be a way to associate the name of the user and maybe the date to a specific comment. It would be nice to clearly and visually associate the user to the comment. Maybe the comment & signature are in a same box?

It would be nice also for people to be able to express support to an idea in the wiki page, with a thumbs up (+1) or a thumbs down (-1). Right now, the wiki ratings feature let's us vote only once per wiki page.

These syntaxes should be quicktags to it's easy to add. Maybe some of the less important meta data (ex.: date of comment) would be only visible on mouse-over. (and thus not in printed mode). The mouse over could also contain a link to the user's personal wiki page and some data about the user (his avatar, score, etc).


Ex.:
*click my PluginComment tool (in toolbar)
*Pre-fill text that will be mouse-overed with previously selected text
**add date & signature (with link to userpage)


Everyone: please share your ideas on this and how you have seen it implemented elsewhere.

Thanks!


Related:
{wish id=2102}

lib/smarty_tiki/modifier.duration.php and lib/smarty_tiki/modifier.duration_short.php are both using hardcoded strings for display of time units (seconds,days,etc).

Please see:
http://sourceforge.net/mailarchive/forum.php?thread_id=10026369&forum_id=12569

In tiki-browse_gallery.php, there is Sort Images by [ Name | Date | Hits | User | Size ] so robots can think these are all different pages

Already possible:
http://profiles.tikiwiki.org/time_sheet

But it would be nicer to have a click on start, click on end to count time for you.

Something integrated to track time spent on ((doc:tasks))

Will be useful for ((project Management))


http://timeclock.sourceforge.net/
http://sourceforge.net/projects/phptimetracker/



Coordination happening at ((Timesheet))

The Tiki date library does not implement the %l (lower case "L") for time.

PHP (5.3.3) ERROR (E_WARNING):
File: lib/tikidate-php5.php
Line: 174
Type: DateTime::setDate() expects parameter 2 to be long, string given

This started happening after I updated to the current subversion head and allowed the installer to upgrade the DB to UTF-8.

The symptom on the page is:

Created by admin. Last Modification: DateTime::__construct() [datetime.--construct]: Failed to parse time string (5) at position 0 (5): Unexpected character by mheller.

Webcalendar offers a setting Timezone Offset to Subtract or add hours to server time.

{draw name=timezoneoffset}

This would make things simpler for site which all events are in a common timezone.

Ex.: Showing UTC time in RSS feeds is not very useful...

Goal: to add a way to represent relevant data in a timeline.

This will most probably be done by re-using an existing library and/or service.

Let's coordinate here: ((TimeLine))

I give anonymous users read acess to forums, etc. Their timestamps are all UTC based .. seems funny to them since all users including anonymous would be in local TZ

I can set it in Mytiki, preferences but that doesn't apply until someone logs in

I found a display_timezone setting of "EST" in the twiki_preferences table that seems to be totally ignored

Further, I found code in the php files that was commented out with a note "-- Obsolete from 1.7 timezone changes". I don't know what that means


Could a feature please be added to allow the admin to set a default TZ for the site (that the user could then override in Mytwiki, preferencs)

No matter what time zone is chosen, the displayed time is always represented as Paris.
This occurs whether the site is used or the browser in order to determine the time zone.

In doing some debugging, I've noticed that the $tz variable in tikidate-php5.php always returns as "Europe/Paris".

If I set $tz = 'America/New_York' in this script, the timezone on the website does change.

For tracker items, displaying the item shows the current date and time for the fields "created" and "lastModif".

I have checked the DB values, and the proper values are stored in the database.

db values :
created : 1265627980
lastmodif : 1265627980

value : 2010-02-08, 11:19:40
Date displayed when viewing tracker item : vrijdag 12 Feb, 2010 10:16:22
(= current date / time)

when listing tracker items, the proper date is shown for all the tracker items.
The problem occurs only when viewing a tracker item.

Bugs & Wish list

Tiki Calendar is very nice for events. But what if someone updates the information about an event? Maybe I won't know (because I copy/pasted the event my pesonal calendar) and I will show up at the old (wrong) time.

Tiki's excellent watch feature should be added (with the little eye) to
# all calendars
# each calendar (id=1) (this could be nice on the filter tab)
# each individual event (when in view mode)

Ideally, for a modified event, I would receive in the email the old and the new value, like for watching trackers.


related code here:
http://tikiwiki.org/tiki-index.php?page=UserPagericks99#Calendar_Notifications