- Posts: 48
- Thank you received: 0
Error when publishing scroller Joomla 3.2
-
Sheeko
Inactive member - Topic Author
- Member
Less
More
11 years 2 weeks ago #35069
by Sheeko
Error when publishing scroller Joomla 3.2 was created 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
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.
-
ivan.milic
Support Staff - Moderator
Less
More
- Posts: 14116
- Thank you received: 1639
11 years 2 weeks ago #35077
by ivan.milic
Replied by ivan.milic on topic Error when publishing scroller Joomla 3.2
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
Less
More
- Posts: 48
- Thank you received: 0
11 years 2 weeks ago - 11 years 2 weeks ago #35081
by Sheeko
Replied by Sheeko on topic Error when publishing scroller Joomla 3.2
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: 11 years 2 weeks ago by Sheeko.
Please Log in to join the conversation.
-
ivan.milic
Support Staff - Moderator
Less
More
- Posts: 14116
- Thank you received: 1639
11 years 2 weeks ago #35088
by ivan.milic
Replied by ivan.milic on topic Error when publishing scroller Joomla 3.2
Send link so we could check
Please Log in to join the conversation.
-
Sheeko
Inactive member - Topic Author
- Member
Less
More
- Posts: 48
- Thank you received: 0
11 years 2 weeks ago #35122
by Sheeko
Replied by Sheeko on topic Error when publishing scroller Joomla 3.2
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.
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.
-
ivan.milic
Support Staff - Moderator
Less
More
- Posts: 14116
- Thank you received: 1639
11 years 2 weeks ago #35134
by ivan.milic
Replied by ivan.milic on topic Error when publishing scroller Joomla 3.2
Place this in your template css file:
#highlights_scroll .contentheading a{
font-weight:bold;
}
#highlights_scroll .contentheading a{
font-weight:bold;
}
Please Log in to join the conversation.
Time to create page: 0.166 seconds