This error came up when i try to open a new k2 user page after upgrade to 3.4.3.
The old k2 user page and everything else seems ok.


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, 5' at line 1 SQL=SELECT i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams FROM j25_k2_items as i RIGHT JOIN j25_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-14 12:29:23' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2015-07-14 12:29:23' ) AND i.created_by=0 AND i.created_by_alias='' AND c.id IN() ORDER BY i.id DESC LIMIT 0, 5

Hi,

i had same Issue and solved by appending some Categories in the Menu Item > Options > Filter categories.

I dont know why this sometimes happens, because in the most Menu Items it works. It happened only in Menue Items, i batched to another Menu. So i think it have something to do with moving or like in your case making a new Menu Item.

Regards

Hello, which versions of K2 where you using?

Franz Wohlkönig wrote: Hi,

i had same Issue and solved by appending some Categories in the Menu Item > Options > Filter categories.

I dont know why this sometimes happens, because in the most Menu Items it works. It happened only in Menue Items, i batched to another Menu. So i think it have something to do with moving or like in your case making a new Menu Item.

Regards

Yes,Franz thank you very much.
When i filter categories in user page menu item,everything is ok.The problem is that i have to filter all categories,to show all articles per user.
When i don't filter any category 1064 error came up.

Dear Krikor, i have v.2.6.9

@iatriko

if you a hurry a Workaround: apply the id-Numbers of your needed Categories in phpMyAdmin. So you make one time a Text with the id-Numbers and copy them.

Regards

Thank you for your feedback guys,
We will look into it and correct it in the dev version.

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 .

Thanks to everyone who reported the issue.