Solved Migrated from J1.5 to 2.5 and timestamps are off.

I've recently been trying to migrate [More so, reconstruct] my website from Joomla 1.5.x to 2.5 seeing as it's no longer supported. So far the migration has gone smoothly though I noticed that the timestamps on posts were an hour or so off from the old site. I also noticed that the "Posted x minutes ago" was going down instead of up and that posts that had been read were still being marked as new.

The mostly-migrated site: test.theorangeblock.org/index.php/forum

The Joomla 1.5 live site: www.theorangeblock.org/forum/recent.html

Any help is most appreciated, thank you.

Database collation check: The collation of your table fields are correct

Legacy mode: Disabled | Joomla! SEF: Enabled | Joomla! SEF rewrite: Disabled | FTP layer: Disabled |

This message contains confidential information

htaccess: Missing | PHP environment: Max execution time: 50000 seconds | Max execution memory: 90M | Max file upload: 40M

Kunena menu details:

Warning: Spoiler!

ID	Name	Menutype	Link	Path
128	Forum	mainmenu	Itemid=119	kunena-2013-05-11
119	Forum	kunenamenu	view=home&defaultmenu=121	forum
120	Index	kunenamenu	view=category&layout=list	forum/index
121	Recent Topics	kunenamenu	view=topics&mode=replies	forum/recent
122	New Topic	kunenamenu	view=topic&layout=create	forum/newtopic
123	No Replies	kunenamenu	view=topics&mode=noreplies	forum/noreplies
124	My Topics	kunenamenu	view=topics&layout=user&mode=default	forum/mylatest
125	Profile	kunenamenu	view=user	forum/profile
126	Help	kunenamenu	view=misc	forum/help
127	Search	kunenamenu	view=search	forum/search

Joomla default template details : rhuk_milkyway | author: Lucas W | version: 1.0.0 | creationdate: 2011-12-28

Kunena default template details : Blue Eagle 2.0 | author: Kunena Team | version: 2.0.4 | creationdate: 2013-01-18

Kunena version detailed: Kunena 2.0.4 | 2013-01-18 [ Pharmacopoeia ]
| Kunena detailed configuration:

Warning: Spoiler!

Kunena config settings:
board_offline	0
enablerss	0
threads_per_page	20
messages_per_page	20
messages_per_page_search	15
showhistory	1
historylimit	6
shownew	1
disemoticons	0
template	blue_eagle
showannouncement	1
avataroncat	1
catimagepath	category_images/
showchildcaticon	1
rtewidth	450
rteheight	300
enableforumjump	0
reportmsg	1
username	1
askemail	1
showemail	1
showuserstats	1
showkarma	1
useredit	1
useredittime	0
useredittimegrace	600
editmarkup	1
allowsubscriptions	1
subscriptionschecked	0
allowfavorites	1
maxsubject	50
maxsig	600
regonly	0
pubwrite	0
floodprotection	0
mailmod	-1
mailadmin	-1
captcha	1
mailfull	1
allowavatarupload	1
allowavatargallery	1
avatarquality	100
avatarsize	2048
imageheight	800
imagewidth	800
imagesize	10000
filetypes	zip,txt,doc,gz,tgz,mp3
filesize	10000
showranking	1
rankimages	1
userlist_rows	30
userlist_online	1
userlist_avatar	0
userlist_name	0
userlist_posts	1
userlist_karma	1
userlist_email	0
userlist_usertype	0
userlist_joindate	0
userlist_lastvisitdate	0
userlist_userhits	0
latestcategory	0
showstats	1
showwhoisonline	1
showgenstats	1
showpopuserstats	1
popusercount	5
showpopsubjectstats	1
popsubjectcount	5
usernamechange	0
showspoilertag	1
showvideotag	1
showebaytag	0
trimlongurls	0
trimlongurlsfront	40
trimlongurlsback	20
autoembedyoutube	1
autoembedebay	1
ebaylanguagecode	en-us
sessiontimeout	1800
highlightcode	0
rss_type	topic
rss_timelimit	month
rss_limit	100
rss_included_categories
rss_excluded_categories
rss_specification	rss2.0
rss_allow_html	1
rss_author_format	name
rss_author_in_title	1
rss_word_count	0
rss_old_titles	1
rss_cache	900
defaultpage	categories
default_sort	asc
sef	1
sefutf8	0
showimgforguest	1
showfileforguest	1
pollnboptions	20
pollallowvoteone	1
pollenabled	1
poppollscount	5
showpoppollstats	1
polltimebtvotes	00:15:00
pollnbvotesbyuser	100
pollresultsuserslist	1
maxpersotext	50
ordering_system	mesid
post_dateformat	ago
post_dateformat_hover	datetime
hide_ip	0
imagetypes	jpg,jpeg,gif,png
checkmimetypes	1
imagemimetypes	image/jpeg,image/jpg,image/gif,image/png
imagequality	50
thumbheight	32
thumbwidth	32
hideuserprofileinfo	put_empty
boxghostmessage	0
userdeletetmessage	1
latestcategory_in	1
topicicons	1
debug	0
catsautosubscribed	0
showbannedreason	1
version_check	1
showthankyou	1
showpopthankyoustats	1
popthankscount	5
mod_see_deleted	1
bbcode_img_secure	text
listcat_show_moderators	1
lightbox	1
show_list_time	720
show_session_type	0
show_session_starttime	0
userlist_allowed	1
userlist_count_users	1
enable_threaded_layouts	0
category_subscriptions	post
topic_subscriptions	every
pubprofile	0
thankyou_max	10
email_recipient_count	0
email_recipient_privacy	bcc
captcha_post_limit	0
keywords	0
userkeywords	0
image_upload	everybody
file_upload	registered
topic_layout	flat
time_to_create_page	1
show_imgfiles_manage_profile	1
hold_newusers_posts	0
hold_guest_posts	0
attachment_limit	8
pickup_category	1
article_display	intro
send_emails	1
fallback_english	1
cache	0
cache_time	60
iptracking	1
rss_feedburner_url
enablepdf	0
jmambot	0
annmodid	62
changename	0
userlist_username	1
rules_infb	1
help_infb	0
onlineusers	1

| Kunena integration settings:

Warning: Spoiler!

Kunena - AlphaUserPoints Disabled
Kunena - Community Builder Disabled
Kunena - Gravatar Disabled
Kunena - JomSocial Disabled
Kunena - Joomla Enabled: access=1 login=1
Kunena - Kunena Enabled: avatar=1 profile=1
Kunena - UddeIM Disabled

| Joomla! detailed language files installed:

Warning: Spoiler!

Joomla! languages installed:
en-GB	English (United Kingdom)

Third-party components: None

Third-party SEF components: None

Plugins: None

Modules: Kunena Login 2.0.4

Most likely this is a timezone (daylight saving) thing.

I notice that this topic was started 7½ hours ago (there have been no replies) but this topic has been viewed 12,000 times! This represents roughly one page view ever 2 seconds. :huh: It's curious that this topic should be this "active" but that no-one has actually posted anything in reply. Maybe someone is polling the page every couple of seconds to see if the topic had received some attention? It would be nice if someone might offer some insight as to why this may be occurring.

As far as your second question about "posted x minutes ago" was going down instead of going up, that's a different subject (although it may be related to the whole server timezone offset thing) and I do not really follow the drift of the question. When I looked at your forum - the recent topics view - the topics were arranged in descending chronology as you would normally expect. Perhaps I have misunderstood the question?

I can see what you mean, I checked and my thread has 40k views. I have no idea how that happened as I've only ever looked at this thread ~5 times.

I've checked both versions and the server timezone on the 1.5 and 2.5 are set to UTC yet the 2.5 versions are ~2 hour off.

Compare this to this .

On the third point, I think that problem is only on the test account I was using, it would show the top 2 topics as having new posts even after reading them but the problem is not there on another test account, so it's a non-issue.

Thanks again for your time

Lucas W wrote: Compare this to this .

I realise that the URL links point, in the first instance, to a "test" site and, in the second.instance, to a "not-a-test" site, but I don't see the issue with the particular examples you gave as an in illustration on the problem.

Can you clarify a matter for us, please? In your original post, you wrote that the timestamps on the posts in the migrated site were "an hour or so off from the old site". Can we aim for a little more specificity, please? Timestamping is an absolute. When a forum post is written into the database, the data is "stamped" with the actual UTC date/time it was written. When Kunena displays the post, the timestamp is displayed either in the date/time format according to the locale of the user viewing the topic - by default, this is the time zone of the server, but logged-in users can change their profile settings to something other than the default - or as a "relative time" - relative to "now" in relation to the current server time - depending on how you set things up.

The question therefore is, did the timestamp change or did the display change? Moreover, by what amount did the the timestamp or display change: one hour; one hour into the future or into the past? I am asking these questions because I want to nail down the amount by which the time has been adjusted - because "thereabouts" is a little vague - because I think this is a daylight savings thing.

J! 1.5 had no concept of daylight savings. Automatic adjustment of time displays, based on whether daylight savings occurs in the site's location, was first introduced in J! 1.6 (although, from recollection, it didn't work too well in the early stages :lol:) and that's why I think this is the contributing factor in your case. So, another question is whether you were logged-in when you looked at the two sites because, on the J! 2.5 site, your user profile will take into account DST.

But, if we are talking about the actual timestamp (the data in the database) having been modified during the J! 1.5 to J! 2.5 migration that's an entirely different thing and I have no advice about that (because that issue has nothing to do with daylight savings or with Kunena for that matter).

So, can we get a bit more clarification from you about the issue, please?

On further examination of the examples posted by Lucas, the displayed date and times for msg #48227 are:

• Original site: 29-June-2013 16:41
• Migrated/test site: 29-June-2013 20:41

So we are not talking about one hour, we're talking about 6 hours. Can we see the screenshots of your Joomla Global Configuration settings for both sites, please?

Anything specific? If you're after the Time Zone setting they're both set to UTC.

Lucas W wrote: Anything specific? If you're after the Time Zone setting they're both set to UTC.

Good. That's what I wanted to know. Can you now tell us what is the timezone offset of the account you are using to view the problem site, please, and can you also tell us if daylignt savings is currently in effect where you live?

Like sozzled said, the reason is probably in daylight saving, which doesn't exist in Joomla 1.5, but is automatically applied to Joomla 2.5+.

There are two options: either you can ignore the off-by-one hour, or you can make SQL to update all dates which occured during daylight saving.

The issue also applies to all other content in your site, not just Kunena.

Sorry I've been a bit, and thanks for the continued help.

It's not currently Daylight saving where I live and both Joomlas are set to UTC/GMT and my user account is set to use the server's setting.

Daylight savings is currently in use at GMT (London time). Were you aware of that?

In SQL terms, times are always stored based on UTC. Joomla subsequently uses the server's local time offset from UTC to convert those times when they are displayed. If you are using GMT as the local server time then you should also be aware that (currently) GMT = UTC + 1 hour.