No Articles Showing

Discussion about free Joomla news rotator/ticker with multiple effects like scrolling, fading and several data sources supported.
Rate this topic: Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.
GK User
Mon Apr 13, 2009 6:25 pm
Joomla!1.5, FireFox,http://www.terrablack.com, News Highlighter GK1
Hi, I installed the News Highlighter (I was having too many problems with News Show)but now the Highlighter isn't working. I can see the Interface buttons & text, but NO scrolling articles/text. What am I doing wrong?

thanks much for any help.
User avatar
Fresh Boarder

GK User
Mon Apr 13, 2009 7:17 pm
terrablack wrote:
Joomla!1.5, FireFox,http://www.terrablack.com, News Highlighter GK1
Hi, I installed the News Highlighter (I was having too many problems with News Show)but now the Highlighter isn't working. I can see the Interface buttons & text, but NO scrolling articles/text. What am I doing wrong?

thanks much for any help.


I fixed this, I needed to "Disable" the "Showing Only Front Page Articles" and now it works.
User avatar
Fresh Boarder

GK User
Fri Apr 24, 2009 10:09 am
I still am unable to get anything to show.

I really wanted to create a full category of articles which appear ONLY in the ticker...but I can't get anything to work, at all... :(
User avatar
Fresh Boarder

GK User
Fri Apr 24, 2009 10:12 am
Inside the module parameters
User avatar
Senior Boarder

GK User
Thu Jun 11, 2009 2:52 pm
Saludos, tuve el mismo problema el problema esta en la sentencia sql.
Para resolverlo hice lo siguiente.
1. ir a la carpeta de modulos y luego accesar en modulesmod_gk_news_highlightergk_classes
2. buscar el archivo joomla.news.class.php
3. Buscar la sentencia SQL q aparece en la funcion getNewsStandardMode
4. sustituir esto
// creating SQL query
$query_news = '
SELECT DISTINCT
cats.title AS cat,
'.((($config['username'] != 2) ? 'users.'.(($config['username'] == 1) ? 'username':'name') : 'content.created_by_alias')) .' AS author,
cats.section AS SID,
content.title AS title,
content.introtext AS text,
content.created AS date,
content.publish_up AS date_publish,
content.images AS images,
content.id as IID,
CASE WHEN CHAR_LENGTH(content.alias)
THEN CONCAT_WS(":", content.id, content.alias)
ELSE content.id END as ID,
CASE WHEN CHAR_LENGTH(cats.alias)
THEN CONCAT_WS(":", cats.id, cats.alias)
ELSE cats.id END as CID
FROM
#__content AS content
LEFT JOIN
#__categories AS categories
ON categories.id = content.catid

LEFT JOIN
#__sections AS sections
ON sections.id = content.sectionid
LEFT JOIN
#__menu AS menu
ON menu.componentid = content.id
LEFT JOIN
#__users AS users
ON users.id = content.created_by
LEFT JOIN
#__content_frontpage AS frontpage
ON content.id = frontpage.content_id
LEFT JOIN
#__categories AS cats
ON content.catid = cats.id
WHERE
content.state = 1'.((!$noauth && $config['unauthorized'] == 0) ? '
AND categories.access <= ' .(int) $aid . '
AND content.access <= '.(int) $aid : '').'
AND categories.published = 1
AND ( content.publish_up = '.$db->Quote($nullDate).'
OR content.publish_up <= '.$db->Quote($now).' )
AND ( content.publish_down = '.$db->Quote($nullDate).'
OR content.publish_down >= '.$db->Quote($now).' )
AND ( '.$sql_where.' )
'.$frontpage_con.'
ORDER BY
'.$order_options.'
LIMIT
'.$config['startposition'].','.($amount + (int)$config['startposition']).';
';
4. Por esto.
// creating SQL query
$query_news = '
SELECT DISTINCT
cats.title AS cat,
'.((($config['username'] != 2) ? 'users.'.(($config['username'] == 1) ? 'username':'name') : 'content.created_by_alias')) .' AS author,
cats.section AS SID,
content.title AS title,
content.introtext AS text,
content.created AS date,
content.publish_up AS date_publish,
content.images AS images,
content.id as IID,
CASE WHEN CHAR_LENGTH(content.alias)
THEN CONCAT_WS(":", content.id, content.alias)
ELSE content.id END as ID,
CASE WHEN CHAR_LENGTH(cats.alias)
THEN CONCAT_WS(":", cats.id, cats.alias)
ELSE cats.id END as CID
FROM
#__content AS content
LEFT JOIN
#__categories AS categories
ON categories.id = content.catid

LEFT JOIN
#__sections AS sections
ON sections.id = content.sectionid
LEFT JOIN
#__menu AS menu
ON menu.componentid = content.id
LEFT JOIN
#__users AS users
ON users.id = content.created_by
LEFT JOIN
#__content_frontpage AS frontpage
ON content.id = frontpage.content_id
LEFT JOIN
#__categories AS cats
ON content.catid = cats.id
WHERE
content.state = 1'.((!$noauth && $config['unauthorized'] == 0) ? '
AND categories.access <= ' .(int) $aid . '
AND content.access <= '.(int) $aid : '').'
AND categories.published = 1

AND ( '.$sql_where.' )

ORDER BY
'.$order_options.'
LIMIT
'.$config['startposition'].','.($amount + (int)$config['startposition']).';
';
5. Salvar y ya funciona bien, quiero contar q yo lo utilizo para mostrar articulos solamente por ids.

Espero te sirva.
User avatar
Fresh Boarder

GK User
Tue Jun 23, 2009 8:31 am
In English please
User avatar
Fresh Boarder


cron