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:2367
  • 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

  • Posts:2367
  • 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:2367
  • isupport
  • Moderator
  • OFFLINE
  • Karma: 0
  • Page:
  • 1
Time to create page: 1.03 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.