Hi marco ,

Sorry for late reply to this,

May i know how to reproduce this error in your site? Because I've tried to login in your site without hitting any error. Please advise.

I tried to register a new account and I had that mistake at the end of the account registration

We encountered this error too with the latest version of EasySocial. It seems as though there are some SQL calls in the /administrator/components/com_easysocial/models/privacy.php file that are hardcoded to use the jos prefix for the table names in some of the queries. This can be corrected by replacing the "jos_" prefix with "#__" prefix where appropriate in that file.

Hi Alex,

Thanks for sharing.

Hi Marco,

Here I have attached to you a file, please download it and put it in your site here: .../administrator/components/com_easysocial/models/privacy.php

Please give this a try and see if this resolves your issue.
Thanks.

sorry but I speak Italian and translate into English, I did not understand if the change was made, or should I do it myself. translating I can not understand

Hi marco,

I've checked in your this file JoomlaFOlder/administrator/components/com_easysocial/models/privacy.php , it seems like you already modified as my colleague mentioned that fix in above post thread, can you give it a try?

I have not touched the file, I have not made any changes, ok now I try to make a new recording to see if it still gives me error

I tried again a recording and I always make the same mistake

Error 1146

(Table 'cromaplu_croma.jos_social_privacy' doesn't exist SQL=INSERT INTO `mhd_social_privacy_items` (`privacy_id`, `user_id`, `uid`, `type`, `value`) SELECT `d`.`id` AS `privacy_id`, '463' AS `user_id`, `a`.`id` AS `uid`, `d`.`type`, `d`.`value` FROM `mhd_social_fields` AS `a` LEFT JOIN `mhd_social_fields_steps` AS `b` ON `b`.`id` = `a`.`step_id` LEFT JOIN `mhd_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 `mhd_social_privacy_items` AS `e` WHERE `e`.`type` = 'field' AND `e`.`user_id` = '463'))



Prova a visitare una delle seguenti pagine



Home Page

Hello Marco,

Okay, looks like this is definitely a bug! Someone hardcoded the table name to use "jos" rather than the db prefix specified in Joomla Can you download the attached file and upload it into /administrator/components/com_easysocial/models/ and see if you are hitting similar issues?

it seems that it all worked out with the update of the component

Hello Marco,

It seems like your issue has been resolved now. The fix is already included in our new release just now