Hi there,
I have an urgent issue since updating to 1.3.5 earlier today.
When a user trying to register, he get the following message after the final step (2 steps):
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 'PRIVACY_ID`, `USER_ID`, `UID`, `TYPE`, `VALUE`) SELECT `D`.`ID` AS `PRIVACY_ID`,' AT LINE 1 SQL=INSERT INTO `SEJOC_SOCIAL_PRIVACY_ITEMS (`PRIVACY_ID`, `USER_ID`, `UID`, `TYPE`, `VALUE`) SELECT `D`.`ID` AS `PRIVACY_ID`, '1764' AS `USER_ID`, `A`.`ID` AS `UID`, `D`.`TYPE`, `D`.`VALUE` FROM `SEJOC_SOCIAL_FIELDS` AS `A` LEFT JOIN `SEJOC_SOCIAL_FIELDS_STEPS` AS `B` ON `B`.`ID` = `A`.`STEP_ID` LEFT JOIN `SEJOC_SOCIAL_APPS` AS `C` ON `C`.`ID` = `A`.`APP_ID` LEFT JOIN `SEJOC_SOCIAL_PRIVACY` AS `D` ON `D`.`RULE` = `C`.`ELEMENT` WHERE `D`.`TYPE` = 'FIELD' AND `B`.`TYPE` = 'PROFILES' AND `B`.`UID` = '1' AND `A`.`ID` NOT IN (SELECT `E`.`UID` FROM `SEJOC_SOCIAL_PRIVACY_ITEMS` AS `E` WHERE `E`.`TYPE` = 'FIELD' AND
I have attached the access/ftp,
Please help(!)
Many thanks,
Eldad