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
Remember me
Register New Account
If you are old Gavick user, click HERE for steps to retrieve your account.