Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length

JoomlaTune Support Forum    JComments component    Integration with third-party extensions    Topic: JComments w/ Past Events in Eventlist
Pages: [1]   Go Down
  Print  
Author Topic: JComments w/ Past Events in Eventlist  (Read 5450 times)
0 Members and 1 Guest are viewing this topic.
itgl72
Newbie
*

Karma: 0
Offline Offline

Posts: 20


« on: July 09, 2009, 19:00:06 »

I just noticed that one of the events in my eventlist component had all the latest comments that were listed on JCOMMENTS LATEST on my front page.

The problem was, that the latest comments being displayed were for an event that had expired  a few days ago and was now in the archive. The title of the event was no longer listed next to the bullet but the first few words of the comment and who wrote it was listed.

Obviously this looked terrible so I removed it from the website... For now?

How can we work with this problem? Is there a way for the jcomments to still show the latest comments of an event properly even i it went to the archive state in eventlist?

Logged
smart
Administrator
Hero Member
*****

Karma: 160
Offline Offline

Gender: Male
Posts: 2559



WWW
« Reply #1 on: July 09, 2009, 20:03:59 »

Try to replace in /components/com_jcomments/plugins/com_eventlist.plugin.php line:

Code: (php)
$db->setQuery( 'SELECT title FROM #__eventlist_events WHERE published = 1 AND id = ' . $id );
with
Code: (php)
$db->setQuery( 'SELECT title FROM #__eventlist_events WHERE id = ' . $id );
Logged

If you use JComments, please post a rating and a review at the Joomla! Extensions Directory
itgl72
Newbie
*

Karma: 0
Offline Offline

Posts: 20


« Reply #2 on: July 09, 2009, 23:18:59 »

This seems to have done the trick. Thank you.    Huh Roll Eyes Tongue
Logged
luisraposo
Newbie
*

Karma: 0
Offline Offline

Posts: 5


« Reply #3 on: July 29, 2009, 19:11:30 »

hello there,
I spent a lot of time figuring this one out, to come to the same conclusion (only now I saw this post  Sad)

The plugin should not add the published criteria to the search, if it's called, then return what's asked, no questions about, that should be performed by the calling method...

This principle is applied to every other functions then getObjectTitle, it makes no sense to prevent only the title from displaying..

I believe the published criteria should be removed from the official release of this plugin.

regards,
luis raposo
« Last Edit: July 29, 2009, 19:15:19 by luisraposo » Logged
itgl72
Newbie
*

Karma: 0
Offline Offline

Posts: 20


« Reply #4 on: July 30, 2009, 19:41:49 »

Thanks for the help on this thread before. It did work and I'm  happy with the solution.

However I have a different but similiar problem with jcomments latest and community builder with eventslist. if you will please have a look over at the thread Jcomments TAB in Community Builder not showing EVENTLIST Comments
Logged
smart
Administrator
Hero Member
*****

Karma: 160
Offline Offline

Gender: Male
Posts: 2559



WWW
« Reply #5 on: August 27, 2009, 18:07:09 »

The plugin should not add the published criteria to the search, if it's called, then return what's asked, no questions about, that should be performed by the calling method...
yes, you are right!

I believe the published criteria should be removed from the official release of this plugin.
yes in next version it will be fixed...
Logged

If you use JComments, please post a rating and a review at the Joomla! Extensions Directory
Pages: [1]   Go Up
  Print  
JoomlaTune Support Forum    JComments component    Integration with third-party extensions    Topic: JComments w/ Past Events in Eventlist
 
Jump to: