Error when publishing scroller Joomla 3.2

  • Sheeko
    Inactive member
  • Topic Author
  • Member
  • Member
More
10 years 4 months ago #35069 by Sheeko
Hi!
Installed the scroller on a fresh installation of joomla 3.2 a when I publish it I get this error on the page;

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ) ORDER BY a.created DESC LIMIT 0,5' at line 9 SQL=SELECT a.*, cc.title as ctitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug FROM s1gh4_content AS a INNER JOIN s1gh4_categories AS cc ON cc.id = a.catid LEFT JOIN s1gh4_content_frontpage AS f ON f.content_id = a.id WHERE ( a.state = '1' AND a.checked_out = '0' ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= NOW() ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= NOW() ) AND f.content_id IS NULL AND ( a.id IN () ) ORDER BY a.created DESC LIMIT 0,5

Help will be appreciated

Please Log in to join the conversation.

More
10 years 4 months ago #35077 by ivan.milic
Did you set any category ID in module parameter "Content Pages IDs"

Please Log in to join the conversation.

  • Sheeko
    Inactive member
  • Topic Author
  • Member
  • Member
More
10 years 4 months ago - 10 years 4 months ago #35081 by Sheeko
No I left it blank. But I figured in was giving the error because I had not selected a category now it showing normally. But the Tile that I put in " Annoucements" has a white back ground and the scroller is not scrolling the text in fact it blank.
Last edit: 10 years 4 months ago by Sheeko.

Please Log in to join the conversation.

More
10 years 4 months ago #35088 by ivan.milic
Send link so we could check

Please Log in to join the conversation.

  • Sheeko
    Inactive member
  • Topic Author
  • Member
  • Member
More
10 years 4 months ago #35122 by Sheeko
Thanks! I figured out and it's working now. actually it doesn't scroll till the article is saved and closed.

But I need your help in make the "Title" in Bold Font just like the "read more" is in bold font. But I couldn't find an option for that. Will appreciate you help.

Thanks.

Please Log in to join the conversation.

More
10 years 4 months ago #35134 by ivan.milic
Place this in your template css file:

#highlights_scroll .contentheading a{
font-weight:bold;
}

Please Log in to join the conversation.

Time to create page: 0.283 seconds
Powered by Kunena Forum