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
User avatar
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.
User avatar
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
User avatar
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.
User avatar
Moderator

GK User
Thu Jun 30, 2016 4:07 pm
OK, access sent.
Ciao
User avatar
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.
User avatar
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
User avatar
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.
User avatar
Moderator


cron