Joomla 3..3.3
K2 2.6.8
K2/Jomsocial integration.

Whenever I create an author alias the article displays in the category view but not in item view. If I click the article title I get a 1046 error message. If I remove the author alias the individual article displays just fine.

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 'AND field_id=4' at line 1 SQL=SELECT id, user_id,

field_id, value FROM sdc_community_fields_values WHERE user_id= AND

field_id=4

I need author alias feature.

Tell me how to solve this problem?

This error is raised from Jomsocial.
The sdc_community_fields_values table is theirs.
Make sure to address this issue to the JomSocial developers and to use the latest version ot that extension.