Joomla Templates Club 406,261 posts

[segamarius Friend segamariusJoin date: September 2011Posts: 1Downloads:0Uploads:0]

#168432

JA News Frontpage – mod_janews_fp – don’t load (show) k2 items on frontpage.

In Content Source i chose k2 an in Select K2 categories i chose a category, but in slideshow i dont see k2 items.

When i chose Joomla Content i see the itmes.

[khoand Friend khoandJoin date: February 2011Posts: 4500Downloads:0Uploads:179 Thanks: 169 Thanked: 1166 times in 1060 posts]

#412099

Hi,
Could you give me username + password of backend and a link to your website?

[nccg Friend nccgJoin date: October 2009Posts: 2Downloads:0Uploads:0]

#412770

please post soluion to this as i have the same issue and its main reason why we using teline IV

[khoand Friend khoandJoin date: February 2011Posts: 4500Downloads:0Uploads:179 Thanks: 169 Thanked: 1166 times in 1060 posts]

#412868

I have reported the bug to development team. You view: http://pm.joomlart.com/browse/JAECMODJANEWSFP-45

[balgev Friend balgevJoin date: May 2011Posts: 52Downloads:4Uploads:0 Thanks: 4 Thanked: 1 times in 1 posts]

#412891

have the same problem… please give us a solution

[khoand Friend khoandJoin date: February 2011Posts: 4500Downloads:0Uploads:179 Thanks: 169 Thanked: 1166 times in 1060 posts]

#413118

Wait, please. Our development team will fix it

[nccg Friend nccgJoin date: October 2009Posts: 2Downloads:0Uploads:0]

#413763

Hey Guys, for those who need the quick fix here it is, basically the module is setup to only display k2 items wich are set to featured… to disable this and make it just show all go to line 55 of /modules/ja_news_fp/helpers/adapter/k2.php and remove the part of the sql statement that says AND i.featured=1 below is the full statement in original form followed by the edited version:

Orig (starts at Line 43):

$query = 'SELECT i.*, g.name AS groupname, c.name AS category, c.alias AS categoryalias, v.name AS author, w.name AS moderator, u.name AS editor
FROM #__k2_items AS i
LEFT JOIN #__k2_categories AS c
ON c.id = i.catid
LEFT JOIN #__groups AS g
ON g.id = i.access
LEFT JOIN #__users AS u
ON u.id = i.checked_out
LEFT JOIN #__users AS v
ON v.id = i.created_by
LEFT JOIN #__users AS w
ON w.id = i.modified_by
WHERE i.trash=0
AND i.featured=1 ';

Replacement code:

$query = 'SELECT i.*, g.name AS groupname, c.name AS category, c.alias AS categoryalias, v.name AS author, w.name AS moderator, u.name AS editor
FROM #__k2_items AS i
LEFT JOIN #__k2_categories AS c
ON c.id = i.catid
LEFT JOIN #__groups AS g
ON g.id = i.access
LEFT JOIN #__users AS u
ON u.id = i.checked_out
LEFT JOIN #__users AS v
ON v.id = i.created_by
LEFT JOIN #__users AS w
ON w.id = i.modified_by
WHERE i.trash=0 ';

you will notice the only difference is at the end of the sql statemtn the AND i.featured=1 is removed… alternatively u could change the 1 to 0 but this would result in items u have set to published not being displayed.

I hope this is helpful

[ashbys Friend ashbysJoin date: September 2011Posts: 1Downloads:2Uploads:0]

#413778

Hey Guys, for those who need the quick fix here it is, basically the module is setup to only display k2 items wich are set to featured… to disable this and make it just show all go to line 55 of /modules/ja_news_fp/helpers/adapter/k2.php and remove the part of the sql statement that says AND i.featured=1 below is the full statement in original form followed by the edited version:

Orig (starts at Line 43):

$query = 'SELECT i.*, g.name AS groupname, c.name AS category, c.alias AS categoryalias, v.name AS author, w.name AS moderator, u.name AS editor
FROM #__k2_items AS i
LEFT JOIN #__k2_categories AS c
ON c.id = i.catid
LEFT JOIN #__groups AS g
ON g.id = i.access
LEFT JOIN #__users AS u
ON u.id = i.checked_out
LEFT JOIN #__users AS v
ON v.id = i.created_by
LEFT JOIN #__users AS w
ON w.id = i.modified_by
WHERE i.trash=0
AND i.featured=1 ';

Replacement code:

$query = 'SELECT i.*, g.name AS groupname, c.name AS category, c.alias AS categoryalias, v.name AS author, w.name AS moderator, u.name AS editor
FROM #__k2_items AS i
LEFT JOIN #__k2_categories AS c
ON c.id = i.catid
LEFT JOIN #__groups AS g
ON g.id = i.access
LEFT JOIN #__users AS u
ON u.id = i.checked_out
LEFT JOIN #__users AS v
ON v.id = i.created_by
LEFT JOIN #__users AS w
ON w.id = i.modified_by
WHERE i.trash=0 ';

you will notice the only difference is at the end of the sql statemtn the AND i.featured=1 is removed… alternatively u could change the 1 to 0 but this would result in items u have set to published not being displayed.

I hope this is helpful

[Author]

Posts