Article order: NSPGK5 does’t work when I set “by user input"
Support forum dedicated to free and advanced Joomla content presentation module with various layout options and data sources support.
- GK User
- Fri Jun 17, 2016 11:50 am
Hi,
GK5 module does’t work when I set “by user input”.
My CMS is Joomla 3.4.8 (local) or 3.5.1(remote).
GK5 settings are:
Data source:
Joomla! articles
Articles: 190, 117, 193
News order: By user input
News sort order: Descending
Article layout:
Amount of pages with arts: 1
Amount of column: 1
Amounts of rows: 3
The page displays ONLY the article with ID 190.
Moreover, if I set only TWO articles (e.g. 190, 117), I get this page error:
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 ') AND c.extension = 'com_content' AND c.published = 1' at line 12 SQL=SELECT c.id AS CID FROM #__categories AS c LEFT JOIN #__content AS content ON c.id = content.catid WHERE 1=1 AND ( content.id = 190 OR content.id = 117 OR content.id = ) AND c.extension = 'com_content' AND c.published = 1
I did something wrong? What about?
Many thanks. Ciao, dario
GK5 module does’t work when I set “by user input”.
My CMS is Joomla 3.4.8 (local) or 3.5.1(remote).
GK5 settings are:
Data source:
Joomla! articles
Articles: 190, 117, 193
News order: By user input
News sort order: Descending
Article layout:
Amount of pages with arts: 1
Amount of column: 1
Amounts of rows: 3
The page displays ONLY the article with ID 190.
Moreover, if I set only TWO articles (e.g. 190, 117), I get this page error:
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 ') AND c.extension = 'com_content' AND c.published = 1' at line 12 SQL=SELECT c.id AS CID FROM #__categories AS c LEFT JOIN #__content AS content ON c.id = content.catid WHERE 1=1 AND ( content.id = 190 OR content.id = 117 OR content.id = ) AND c.extension = 'com_content' AND c.published = 1
I did something wrong? What about?
Many thanks. Ciao, dario
-
- Junior Boarder
- teitbite
- Mon Jun 20, 2016 9:02 pm
Hi
From Your error message it looks like this part is responsible: "117 OR content.id = ) AND" as You can see module is trying to pick up 3rd article, but no number was given. I think in ID settings there is a comma sign after the last ID. Please check it and try to remove it.
From Your error message it looks like this part is responsible: "117 OR content.id = ) AND" as You can see module is trying to pick up 3rd article, but no number was given. I think in ID settings there is a comma sign after the last ID. Please check it and try to remove it.
-
- Moderator
- GK User
- Wed Jun 22, 2016 9:05 pm
Hi,
OK for the second question, I removed a comma sign.
But what about my first question?
When I set articles order:
-Data source: Joomla! articles
-Articles: 190, 117, 193
-News order: By user input
The page displays ONLY the article with ID 190
Thanks, dario
OK for the second question, I removed a comma sign.
But what about my first question?
When I set articles order:
-Data source: Joomla! articles
-Articles: 190, 117, 193
-News order: By user input
The page displays ONLY the article with ID 190
Thanks, dario
-
- Junior Boarder
- teitbite
- Sat Jun 25, 2016 4:57 pm
Hi
I would need to check that. Please send me an access to joomla panel.
I would need to check that. Please send me an access to joomla panel.
-
- Moderator
- GK User
- Thu Jun 30, 2016 4:07 pm
OK, access sent.
Ciao
Ciao
-
- Junior Boarder
- teitbite
- Sat Jul 02, 2016 5:32 pm
Hi
I have studied the code and order by "user" must be created for a different type of source since there is no such value in regular joomla articles database, so for this source selecting this option will work as a random order. What do You want to achieve? Maybe it could be done by a different setting.
I have studied the code and order by "user" must be created for a different type of source since there is no such value in regular joomla articles database, so for this source selecting this option will work as a random order. What do You want to achieve? Maybe it could be done by a different setting.
-
- Moderator
- GK User
- Tue Jul 05, 2016 3:35 pm
Hi,
my achievement is to set EXACTLY the order from the top to the bottom of the articles I listed.
MY QUESTION
When GK5 settings are
in DATA SOURCE:
Source of articles = Joomla! articles
Articles = 190, 117, 193, 210
and
in ARTICLE LAYOUT:
Amount of pages with arts = 1
Amount of column = 1
Amounts of rows = 3
how can I get the order of the three articles displayed is:
190 THE FIRST, on the top, 117 the second, and 193 the third?
Thanks. Ciao
my achievement is to set EXACTLY the order from the top to the bottom of the articles I listed.
MY QUESTION
When GK5 settings are
in DATA SOURCE:
Source of articles = Joomla! articles
Articles = 190, 117, 193, 210
and
in ARTICLE LAYOUT:
Amount of pages with arts = 1
Amount of column = 1
Amounts of rows = 3
how can I get the order of the three articles displayed is:
190 THE FIRST, on the top, 117 the second, and 193 the third?
Thanks. Ciao
-
- Junior Boarder
- teitbite
- Fri Jul 08, 2016 1:02 pm
Hi
Articles = 190, 117, 193, 210 doesn't set the order. It's only a selection which articles should be shown.
Best way is to simply set order in articles list and than in module select it to show by order.
Articles = 190, 117, 193, 210 doesn't set the order. It's only a selection which articles should be shown.
Best way is to simply set order in articles list and than in module select it to show by order.
-
- Moderator
8 posts
• Page 1 of 1