UPDATES PayPlans 5.0.8 Released! Joomla 5.x and PHP 8.x compatible now!

Helpdesk

Your Time
Our Time
Response Time
24 — 48 hours
We strive to provide the fastest ever response possible. However, we are not super beings.

Allow at least 24 — 48 hours
  Support is online
Our support specialists is available now. We will attend to you as soon as we can.
  Support is online

Users can't register since updating to ES 1.3.5

Eldad Caspi · ·
3:20 AM Wednesday, 24 September 2014
None
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
The replies under this section are restricted to logged in users or users with an active subscription with us