Periodically remove database records

General questions relating to Joomla! 3.x.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting.
Forum Post Assistant - If you are serious about wanting help, you should use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10
Locked
bjkluft
Joomla! Apprentice
Joomla! Apprentice
Posts: 25
Joined: Mon Dec 11, 2017 1:15 pm

Periodically remove database records

Post by bjkluft » Tue Nov 13, 2018 12:23 pm

Hello,

I have a question: Due to privacy regulations (in Europe) we are no longer allowed to store data from users/visitors without there consent. Joomla 3.9 takes care of this beautifully (thanks for that!), but there is one aspect that is not (yet?!) implemented. I currently store information into the database from visitors that fill out a form on our website. One of them is to request for a rent of our Scouting building. There is quite some personal information in this request and it is stored forever in the database. I would like to have an option that automatically deletes records older then x weeks/months/years etc. from a selective table in the database.
Is such feature available or do-able?

With best regards,
Jeroen
Top
SharkyKZ
Joomla! Hero
Joomla! Hero
Posts: 2909
Joined: Fri Jul 05, 2013 10:35 am
Location: Parts Unknown

Re: Periodically remove database records

Post by SharkyKZ » Tue Nov 13, 2018 1:35 pm

This can be done with a plugin. Or a Cron script, if you need more precision.
Top
User avatar
pmleconte
Joomla! Guru
Joomla! Guru
Posts: 591
Joined: Fri Mar 17, 2017 12:55 pm
Location: France

Re: Periodically remove database records

Post by pmleconte » Tue Nov 13, 2018 2:08 pm

Hi,

What form extension are you working with ?

Core Joomla contact form does not store anything in the database.

Pascal
If anything can go wrong, it will.
https://www.conseilgouz.com/en
Top
Locked

Return to “General Questions/New to Joomla! 3.x”