VISIT AND LIKE OUR PAGE ON FACEBOOK
TAKE A LOOK AT OUR TWEETS ON TWITTER
SUBSCRIBE TO THE JOOMFREAK RSS FEED
CHECK OUT OUR PAGE ON GOOGLE +
VISIT OUR CHANNEL ON YOUTUBE

Account Details

Change your name, email, password or permanently delete your account. Change settings

We offer several ways you can get support from our experts: Support ForumKnowledgebaseNewsletter

Your Forum Posts

No posts to display.

Welcome, Guest
Username Password: Remember me
  • Page:
  • 1

TOPIC: module

module 08 Apr 2016 11:57 #8584

hi, when I try to install the module (JF K2 Module Event Up), in another template, I get this message
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 ') ORDER BY i.id asc' at line 1 SQL=SELECT i.*,c.name AS categoryname, c.description AS categorydescription, c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams FROM #__k2_items as i RIGHT JOIN #__k2_categories c ON c.id = i.catid WHERE i.published = 1 AND i.access IN(1,1) AND i.trash = 0 AND c.published = 1 AND c.access IN(1,1) AND c.trash = 0 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2016-04-08 10:51:00' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2016-04-08 10:51:00' ) AND i.catid IN () ORDER BY i.id asc

how do I fix?
Thanks in advance

Re: module 11 Apr 2016 04:03 #8591

Did you install K2 component?

joomfreak

  • Posts:2028
  • isupport
  • Moderator
  • OFFLINE
  • Karma: 0

Re: module 11 Apr 2016 08:40 #8594

sure, i use k2

Re: module 12 Apr 2016 03:12 #8601

You have to create k2 component and extra field like attachment.
This image is hidden for guests. Please log in or register to see it.


joomfreak
The following user(s) said Thank You: info@sgonline.net

  • Posts:2028
  • isupport
  • Moderator
  • OFFLINE
  • Karma: 0

Re: module 14 Apr 2016 17:27 #8617

hi, I certainly have this same situation, I created the fields with the same logic, but it still does not work, can you help me? thank you

Re: module 15 Apr 2016 02:31 #8619

Can you please send me your website url and the super admin access via private message system?

joomfreak

  • Posts:2028
  • isupport
  • Moderator
  • OFFLINE
  • Karma: 0
  • Page:
  • 1
Time to create page: 0.67 seconds

joomfreak is not affiliated with or endorsed by the Joomla Project or Open Source Matters.
The Joomla logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.