Error Show K2 Articles in the Menu.

Rate this topic: Evaluations: 1, 1.00 on the average.Evaluations: 1, 1.00 on the average.Evaluations: 1, 1.00 on the average.Evaluations: 1, 1.00 on the average.Evaluations: 1, 1.00 on the average.Evaluations: 1, 1.00 on the average.1.00 out of 6 based on 1 vote(s)
GK User
Sun Aug 21, 2016 5:41 pm
Reply with quote
Report this post
Hello, I find an error to display K2 Articles in the menu. I configured module NSP GK5 as Data Sources K2 Articles and K2 Items with ID number of my K2 Articles, in this case error is " Error: no articles to display " and if in the K2 Items insert my K2 Item Name (for example BORSE) error is 1054 " Unknown column 'BORSE' in 'where clause' SQL=SELECT c.id AS CID FROM #__k2_categories AS c LEFT JOIN #__k2_items AS content ON c.id = content.catid WHERE 1=1 AND ( content.id = BORSE) AND c.published = 1 ".
How can I to resolve it ?
Thanks.
User avatar
Junior Boarder

teitbite
Thu Aug 25, 2016 11:44 am
Reply with quote
Report this post
Hi

Please do not use article name, a field for K2 articles supposed to have only ID's.
Get back to when You see "Error: no articles to display" and copy module configuration here.
User avatar
Moderator

GK User
Sat Aug 27, 2016 2:29 pm
Reply with quote
Report this post
1.png
3.png
Hello, this is module configuration and K2 items settings too:
User avatar
Junior Boarder

GK User
Sat Aug 27, 2016 2:51 pm
Reply with quote
Report this post
and this is modul configuration and K2 configuration.
User avatar
Junior Boarder

teitbite
Mon Aug 29, 2016 1:38 pm
Reply with quote
Report this post
Hi

I can see the problem. You have selected only one article with id 330, but in option "First news number" You have selected '1', in database numerics are done from 0, so basically You asking module to not show first news, which gives nothing to show at all. Change "First news number" to '0'.
User avatar
Moderator

GK User
Wed Aug 31, 2016 9:14 pm
Reply with quote
Report this post
teitbite wrote:Hi

I can see the problem. You have selected only one article with id 330, but in option "First news number" You have selected '1', in database numerics are done from 0, so basically You asking module to not show first news, which gives nothing to show at all. Change "First news number" to '0'.

I have solved problem. Thanks. :)
User avatar
Junior Boarder

teitbite
Sun Sep 04, 2016 11:42 am
Reply with quote
Report this post
Hi
Glad I could help.
---
If You were satisfied with our support please let other users know on Twitter: http://twitter.com/gavickpro or Facebook: http://www.facebook.com/gavickpro
User avatar
Moderator


cron