- Posts: 22
COMMUNITY FORUM
- Forum
- K2 Community Forum
- English K2 Community
- 1064 error when trying to create new k2 user page menu item
1064 error when trying to create new k2 user page menu item
- politicaldoubts
-
Topic Author
- Offline
- Junior Member
Less
More
9 years 9 months ago #145854
by politicaldoubts
1064 error when trying to create new k2 user page menu item was created 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!
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
-
- Offline
- Platinum Member
Less
More
- Posts: 529
9 years 9 months ago #145861
by Franz Wohlkönig
Replied by Franz Wohlkönig on topic 1064 error when trying to create new k2 user page menu item
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 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
-
Topic Author
- Offline
- Junior Member
Less
More
- Posts: 22
9 years 9 months ago #145963
by politicaldoubts
Replied by politicaldoubts on topic 1064 error when trying to create new k2 user page menu item
Thanks a lot!!!
Please Log in or Create an account to join the conversation.
- Krikor Boghossian
-
- Offline
- Platinum Member
Less
More
- Posts: 15920
9 years 9 months ago #145968
by Krikor Boghossian
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
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 .
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
-
Topic Author
- Offline
- Junior Member
Less
More
- Posts: 22
9 years 9 months ago #146058
by politicaldoubts
Replied by politicaldoubts on topic 1064 error when trying to create new k2 user page menu item
thanks a lot again!
Please Log in or Create an account to join the conversation.
- Krikor Boghossian
-
- Offline
- Platinum Member
Less
More
- Posts: 15920
9 years 9 months ago #146069
by Krikor Boghossian
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
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.
- Forum
- K2 Community Forum
- English K2 Community
- 1064 error when trying to create new k2 user page menu item