1064 error when publishing NSPGK5

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
Mon Oct 19, 2015 12:45 pm
Reply with quote
Report this post
Hi,
when I publish News Show Pro GK5 on my website I have a 1064 error
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.published = 1' at line 12 SQL=SELECT c.id AS CID FROM iwdgi_k2_categories AS c LEFT JOIN iwdgi_k2_items AS content ON c.id = content.catid WHERE 1=1 AND ( content.id = ) AND c.published = 1

Data source is Joomla category (one published article in this category) - position tried Header and Mainbody
Any idea about the problem ?
User avatar
Gold Boarder

GK User
Mon Oct 19, 2015 3:30 pm
Reply with quote
Report this post
Please follow this steps:

0) Install new current version of NSP GK5 (re-install)
1) Open module in edit mode
2) Click Refresh button in your browser
3) Change data source to another from list
4) Change order of showing items
5) Save changes - check on front page
6) If okey, change data source back to option which you have at the beginning
User avatar
Moderator

GK User
Tue Oct 20, 2015 3:33 pm
Reply with quote
Report this post
Well done !
it works now.
Thanks !
User avatar
Gold Boarder

GK User
Sat Oct 24, 2015 9:54 am
Reply with quote
Report this post
If you have any additional questions regarding this topic, please let me know.
User avatar
Moderator

GK User
Wed Oct 28, 2015 10:04 am
Reply with quote
Report this post
Hi Cyberek
"see more" link does not display the full article
The url seems correct in the adress bar. Weird...
please, see there
http://www.scierie-granie.fr/
at top1 position, NSPGK5 is used to display news
when you click on "Plus d'info" (see more), nothing happens. It should go to to the full article, right ?
I've tried to disable SEF but the problem is still there.
Thanks
User avatar
Gold Boarder

GK User
Fri Oct 30, 2015 5:13 pm
Reply with quote
Report this post
This problem doesn't correspond to original thread's topic. Please post it as a separate thread with correct tittle.
User avatar
Moderator

GK User
Mon Nov 02, 2015 11:02 am
Reply with quote
Report this post
ok I thought it was due to the new install you told me to make on this thread
that's why I posted here.
0) Install new current version of NSP GK5 (re-install)

I make a new thread then, ok.
User avatar
Gold Boarder

GK User
Mon Nov 02, 2015 7:33 pm
Reply with quote
Report this post
Thanks :).
User avatar
Moderator


cron