Hello Jason,

When you delete a field, the data is not deleted but it would be an orphan record

Hello Mark,

Then the data are in Phpmyadmin?

Yes, these data are still stored in #__social_fields_data

Mark as I delete this?

Sorry, but I don't get you here but no, don't delete the table If you delete this table, all other custom fields would lose it's values.

Mark wrote:

When you delete a field, the data is not deleted but it would be an orphan record

So when you delete a custom field, it's records associated are not removed? So for example if I create a custom field called "Years of Joomla Experience", a few members fill it out, and later I decide to remove the custom field altogether, your saying those few records will still exist?

Hello Josh,

Looking at the codes, yeah it looks like it's left there as an orphan record in case you need to back up in the future or when we add in the export tool (whichever comes first )

Makes sense. In the future it would be nice to have a way to remove the orphan records or remove the field data when deleting the custom field. It is nice however that right now the data can be saved in case of a future import/export.

Hello Josh,

Yep, you are right. Perhaps a new maintenance script is necessary if you want to remove all orphan records

That would do it. Also perhaps a way to re-associate those records with a custom field. Perhaps that aspect is left up to the importing/exporting idea.

Hi Josh,

Thanks for the heads up and your suggestion. We will see what is the best approach to address this matter
Thanks again and have a nice day

I have sensitive data that I deleted, I deleted those fields, but do not want who are not in the tables, a hacker could get

Yo tengo datos sensibles que he borrado, he eliminado esos campos, pero no quiero que esten en las tablas tampoco, un hacker podria conseguirlos

Hello Jasonargo,

Try the below sql form your phpmyadmin to remove the fields data from your database which does not associated with any fields.

delete from `jos_social_fields_data` 

where `type` = 'user' 

and `field_id` not in ( select `id` from `jos_social_fields` );

Replace jos_ with your own Joomla table prefix. Also, please do a backup of your database first before execute the above sql statement.

Hope this help and have a nice day

Error: #1046 - No database selected

Hello Jason,

You need to first select your database first on the left (If you are using phpmyadmin)

There are three databases, which is?

Hello Jason,

I really have no idea which database are you using for your site You should know it better than me haha

To figure out which database you are using check your configuration.php file in the root section of Joomla. It can be found at yoursite/configuration.php but can only be seen via a ftp. Once you open it, look for "public $db" (without the quotes). You will see the equal sign next to the name of your database.

Thanks for sharing Josh