1064 error
By John Candido on Monday, 17 November 2014
Posted in Technical Issues
Likes 0
Views 1.1K
Votes 0
Error:
1064You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OR `a`.`id` NOT IN (SELECT `category_id` FROM `ckfw3_social_clusters_categories_' at line 1 SQL=SELECT DISTINCT `a`.* FROM `ckfw3_social_clusters_categories` AS `a` LEFT JOIN `ckfw3_social_clusters_categories_access` AS `b` ON `a`.`id` = `b`.`category_id` WHERE `a`.`type` = 'event' AND `a`.`state` = '1' AND (`b`.`profile_id` = OR `a`.`id` NOT IN (SELECT `category_id` FROM `ckfw3_social_clusters_categories_access`))
It appears the page you were looking for doesn't exist. Sorry about that
-----------------------
I installed some new users using Nordmograph sample profiles but now cannot access the EasySocial (COMMUNITY) main page without this error.
Hi,

It seems like the tool that you are using is not assigning a proper profile for users.

Do check this at backend -> EasySocial -> Users and you can see that the users are not assigned with a profile. Do assign users to a profile.
Jason Rey
·
Monday, 17 November 2014 12:23
·
0 Likes
·
0 Votes
·
0 Comments
·
Thank you -that worked.

I do have one other small problem with approving comments in Komento.
In Komento >> Comments, when I select an unpublished comment and click on Publish, I get never-ending moving black bars but if you leave the page and then come back, the comment does show being published.
John Candido
·
Monday, 17 November 2014 21:14
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello John,

Can you recheck the access for both backend and FTP because I can't access them. Please advise.
Nik Faris
·
Tuesday, 18 November 2014 11:25
·
0 Likes
·
0 Votes
·
0 Comments
·
ok, try this...
John Candido
·
Tuesday, 18 November 2014 21:18
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello John,

Sorry for the late reply. I've tried to replicate the issue in your site but it seems to work just fine: http://screen.stackideas.com/2014-11-19_1118.swf . Did I missed anything? Please advise.
Nik Faris
·
Wednesday, 19 November 2014 11:20
·
0 Likes
·
0 Votes
·
0 Comments
·
1) Still a problem. Please go to Komento>>Comments and see the post "This is a test post to check on a few things." If you click on the status button "Publish Item", little black bars moving up and down continue forever without turning to Published with the check mark. If you leave the page and then come back, it says published and the check mark shows.

2. I just updated to the latest EasySocial version and once again the little blue help ( ?) circles do not work. This also happened the last three times I updated EasySocial. Why does this happen and how to fix it?
John Candido
·
Wednesday, 19 November 2014 22:00
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello John,

I've fixed it for you both the issues. Please have a look.
Nik Faris
·
Thursday, 20 November 2014 12:37
·
0 Likes
·
0 Votes
·
0 Comments
·
Thank you.
John Candido
·
Saturday, 22 November 2014 11:20
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks for updating John, glad that your issues are resolved now
Mark
·
Saturday, 22 November 2014 16:31
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post