Joomla Extensions Club 20,483 posts

[max power Friend max powerJoin date: February 2011Posts: 31Downloads:0Uploads:2 Thanks: 2]

#159986

Ok, another bug I have found…

For some reason the date stamp is inaccurate on many of my imported comments. In the back-end the date is displayed correctly, however the front-end shows completely wrong results. For example, a comment will have a time stamp of 31 months ago, I will refresh the page and it will change to something like 56 months ago, refresh again and it will say 0 months ago. Whats goin on? FYI, these comments have been imported from JComments.

The comments seem to be sorted correctly, its just the time stamp that is acting up. See attached…

---

Attachments:

1. 

[nghiatd Friend nghiatdJoin date: October 2009Posts: 324Downloads:0Uploads:8 Thanks: 7 Thanked: 39 times in 37 posts]

#376353

Hello,

Please send me your error link in your web.

Best Regards.

[max power Friend max powerJoin date: February 2011Posts: 31Downloads:0Uploads:2 Thanks: 2]

#376708

Well there is no error message or error link. The problem is as I descibed above. You can notice the problem by logging into my site and going to a video page with comments.

Example Video Page…
http://halomontage.com/video/viewvideo/90/halo-3-montage/question-reality

The log-in info was sent via the Ticket System last week. Also, I am a little confused about the support here. The tickets I submitted last week are all closed, this one included. Shouldnt the tickets be closed once a problem is solved or if it is determined there is no solution?

Thanks

[nghiatd Friend nghiatdJoin date: October 2009Posts: 324Downloads:0Uploads:8 Thanks: 7 Thanked: 39 times in 37 posts]

#376767

Hello,

Sorry about my delay in the last time. I’m preparing for my wedding.
I fixed out your problem:
I opened file: components/com_jacomment/themes/default/html/comments/items.php

change code(in line 84) from

echo '<a href="#jacommentid:'.$item->id.'">'.$helper->generatTimeStamp(strtotime($item->date)).'</a>';

to

echo '<a href="#jacommentid:'.$item->id.'">'.$helper->generatTimeStamp($item->date).'</a>';

Best Regards.

[max power Friend max powerJoin date: February 2011Posts: 31Downloads:0Uploads:2 Thanks: 2]

#376842

I am still getting pretty inaccurate results for some reason. Even after adding some test comments to the video link below. It would say 1 month right after I add the comment. I refreshed the page and all the comments then said 3 months, refreshed again and they all said 6 months.

http://halomontage.com/video/viewvideo/570/halo-3-gameplay/test

And congratulations on your wedding!

---

Attachments:

1. 

[nghiatd Friend nghiatdJoin date: October 2009Posts: 324Downloads:0Uploads:8 Thanks: 7 Thanked: 39 times in 37 posts]

#376934

Hello,

I think this bug was from JComment. There is a difference when storing date with jacomment and jcomment.

I edited some code for jcomment importing. But when I imported it again i didn’t see any comment in
http://halomontage.com/video/viewvideo/90/halo-3-montage/question-reality

Please tell me how to import jcomment into jacomment in this link.

Best Regards

[max power Friend max powerJoin date: February 2011Posts: 31Downloads:0Uploads:2 Thanks: 2]

#376995

<em>@nghiatd 221796 wrote:</em><blockquote>I edited some code for jcomment importing. But when I imported it again i didn’t see any comment in
http://halomontage.com/video/viewvideo/90/halo-3-montage/question-reality

Please tell me how to import jcomment into jacomment in this link.</blockquote>

This has been fixed

Also, not a big deal, for some reason the imported comments from JComments and HWDvideoshare do not have content titles as well. If this could be fixed as well that would be great. If its too much work, I can live without it. I also mentioned this in an earlier thread.

See below for database comparisons, I dont know if this will help or not…

Database format for JComments and HWDvideoshare…


(`id`, `parent`, `path`, `level`, `object_id`, `object_group`, `object_params`, `lang`, `userid`, `name`, `username`, `email`, `homepage`, `title`, `comment`, `ip`, `date`, `isgood`, `ispoor`, `published`, `subscribe`, `source`, `source_id`, `checked_out`, `checked_out_time`, `editor`)

(2243, 0, '0', 0, 383, 'com_hwdvideoshare_v', '', 'en-GB', 783, 'Trustin Marquez', 'AYellowSnowball', 'trustinpain@yahoo.com', '', 'RE: AYellowSnowball? Final?', 'ya, this is def not me. THat sniping is waaay to good to be me,and the sticks are waaaaay to trash for me jk guys. some great GP,you can mark this up to the game son!', '216.137.199.89', '2010-09-28 00:35:05', 1, 0, 1, 0, '', 0, 0, '0000-00-00 00:00:00', '')

Database format for JaComments and HWDvideoshare…

(`id`, `parentid`, `contentid`, `ip`, `name`, `contenttitle`, `comment`, `date`, `published`, `locked`, `ordering`, `email`, `website`, `star`, `userid`, `usertype`, `option`, `voted`, `report`, `subscription_type`, `referer`, `source`, `type`, `date_active`)

(18910, 0, 383, '216.137.199.89', 'Trustin Marquez', '', 'ya, this is def not me. THat sniping is waaay to good to be me,and the sticks are waaaaay to trash for me :) jk guys. some great GP,you can mark this up to the game son!', '0000-00-00 00:00:00', 1, 0, 0, 'trustinpain@yahoo.com', '', 0, 783, '', 'com_hwdvideoshare', 0, 0, 0, '', 'jcomments', 1, '0000-00-00 00:00:00'),

Thanks

[max power Friend max powerJoin date: February 2011Posts: 31Downloads:0Uploads:2 Thanks: 2]

#377444

<em>@nghiatd 221796 wrote:</em><blockquote>I edited some code for jcomment importing. </blockquote>

Whatever you did with the importer did not fix the problem. It imported all the dates as 0000-00-00 00:00:00. The original importer had the dates entered correctly. But something when converting the date from an actual date (Joomla back-end) to time since (Joomla front-end) is not working. The dates all show up correctly in the backend and in the database.

Also, I added a new comment via JaComment and then changed the date in the database back by two years and the same phenomenon is happening. So the imported comments are not the problem.

[nghiatd Friend nghiatdJoin date: October 2009Posts: 324Downloads:0Uploads:8 Thanks: 7 Thanked: 39 times in 37 posts]

#377649

Hello,

I think there is a problem with import system:
The “date” field of comment id of jcomment is “2010-09-28 00:35:05”.
While the “date” field of jacomment is “0000-00-00 00:00:00”.
So Jacomment can’t display correctly date of comment.
Have you changed any thing such as: change database… when click on button import from jcomment to jacomment?

Best Regards.

[Author]

Posts