By John Candido on Thursday, 19 March 2015
Posted in General Issues
Replies 3
Likes 0
Views 767
Votes 0
An 1146 error occurs when registering from the home page or the ES "Community" page. It does register the person (login is ok. ) but gives this scary error as follows:


1146
Table 'world_jcw3.jos_social_privacy' doesn't exist SQL=INSERT INTO `ckfw3_social_privacy_items` (`privacy_id`, `user_id`, `uid`, `type`, `value`) SELECT `d`.`id` AS `privacy_id`, '310' AS `user_id`, `a`.`id` AS `uid`, `d`.`type`, `d`.`value` FROM `ckfw3_social_fields` AS `a` LEFT JOIN `ckfw3_social_fields_steps` AS `b` ON `b`.`id` = `a`.`step_id` LEFT JOIN `ckfw3_social_apps` AS `c` ON `c`.`id` = `a`.`app_id` LEFT JOIN (select pi.`id`, pi.type, pi.rule, ifnull(pim.`value`, pi.value) as `value` from jos_social_privacy as pi left join jos_social_privacy_map as pim on pi.`id` = pim.`privacy_id` and pim.`utype` = 'profiles' and pim.`uid` = '1' where pi.`type` = 'field') 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 `ckfw3_social_privacy_items` AS `e` WHERE `e`.`type` = 'field' AND `e`.`user_id` = '310')
It appears the page you were looking for doesn't exist. Sorry about that.
Hello John,

I am really sorry for the inconveniences caused. This issue seems like we have used some "hardcoded" database prefix. A quick fix is for you to download the attached file and upload it into /administrator/components/com_easysocial/models/

We will be releasing another version shortly which addresses this.
·
Thursday, 19 March 2015 10:18
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks
I did see that solution in the forums but since I just updated ES yesterday to the latest version and already had the privacy.php file present, I didn't think it applied -but it did and it fixed it.
·
Thursday, 19 March 2015 11:03
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi John,

You're welcome. Thanks and have a nice day ahead.
·
Thursday, 19 March 2015 12:07
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post