Keyword

1064 error when trying to create new k2 user page menu item

  • politicaldoubts
  • politicaldoubts's Avatar Topic Author
  • Offline
  • Junior Member
More
8 years 9 months ago #145854 by politicaldoubts
Hallo to everyone!

Recently i had a new problem on my site. When i tried to create a new menu item connected to a user page (blog) i got 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 DESC LIMIT 0, 10' at line 1 SQL=SELECT i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams FROM fmzl8_k2_items as i RIGHT JOIN fmzl8_k2_categories AS 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 <= '2015-07-19 21:50:48' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2015-07-19 21:50:48' ) AND i.created_by=461 AND i.created_by_alias='' AND c.id IN() ORDER BY i.id DESC LIMIT 0, 10

What i shall do?

My site is running on Joomla! 3.4.3 and k2 v2.6.9

Thanks for your time!

Please Log in or Create an account to join the conversation.

  • Franz Wohlkönig
  • Franz Wohlkönig's Avatar
  • Offline
  • Platinum Member
More
8 years 9 months ago #145861 by Franz Wohlkönig
Hi,

please take a look: www.joomlaworks.net/forum/k2-en/42176-1064-error-in-k2-user-page

Looks like Devs will work on it.

Regards

Please Log in or Create an account to join the conversation.

  • politicaldoubts
  • politicaldoubts's Avatar Topic Author
  • Offline
  • Junior Member
More
8 years 9 months ago #145963 by politicaldoubts
Thanks a lot!!!

Please Log in or Create an account to join the conversation.

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
8 years 9 months ago #145968 by Krikor Boghossian
Replied by Krikor Boghossian on topic 1064 error when trying to create new k2 user page menu item
Thank you all for reporting this issue.
The issue has been resolved with this commit: github.com/joomlaworks/k2/commit/d3617d1c6c4602b1328bc5de82bb253e1002e5fa .

Apply the fix or install the development version from getk2.org/assets/get .

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.

  • politicaldoubts
  • politicaldoubts's Avatar Topic Author
  • Offline
  • Junior Member
More
8 years 9 months ago #146058 by politicaldoubts
thanks a lot again!

Please Log in or Create an account to join the conversation.

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
8 years 9 months ago #146069 by Krikor Boghossian
Replied by Krikor Boghossian on topic 1064 error when trying to create new k2 user page menu item
You 're welcome :)

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.


Powered by Kunena Forum