Response Time
24 — 48 hours
Hi. I got an error in Easysocial's frontend as:
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 'OR `A`.`ID` NOT IN (SELECT `CATEGORY_ID` FROM `BLUE_SOCIAL_CLUSTERS_CATEGORIES_A' AT LINE 1 SQL=SELECT DISTINCT `A`.* FROM `BLUE_SOCIAL_CLUSTERS_CATEGORIES` AS `A` LEFT JOIN `BLUE_SOCIAL_CLUSTERS_CATEGORIES_ACCESS` AS `B` ON `A`.`ID` = `B`.`CATEGORY_ID` WHERE `A`.`TYPE` = 'EVENT' AND `A`.`STATE` = '1' AND (`B`.`PROILE_ID` = OR `A`.`ID` NOT IN (SELECT `CATEGORY_ID` FROM `BLUE_SOCIAL_CLUSTERS_CATEGORIES_ACCESS`)) ORDER BY `A`.`ORDERING`
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 'OR `A`.`ID` NOT IN (SELECT `CATEGORY_ID` FROM `BLUE_SOCIAL_CLUSTERS_CATEGORIES_A' AT LINE 1 SQL=SELECT DISTINCT `A`.* FROM `BLUE_SOCIAL_CLUSTERS_CATEGORIES` AS `A` LEFT JOIN `BLUE_SOCIAL_CLUSTERS_CATEGORIES_ACCESS` AS `B` ON `A`.`ID` = `B`.`CATEGORY_ID` WHERE `A`.`TYPE` = 'EVENT' AND `A`.`STATE` = '1' AND (`B`.`PROILE_ID` = OR `A`.`ID` NOT IN (SELECT `CATEGORY_ID` FROM `BLUE_SOCIAL_CLUSTERS_CATEGORIES_ACCESS`)) ORDER BY `A`.`ORDERING`
1 Replies
The replies under this section are restricted to logged in users or users with an active subscription with us
