cleaning old versions of an article

Hello

In the parameters I keep 10 versions (default values)of each articles.

There are numerous articles now in the site.

Is it possible to clean old versions of an article for at least articles which are more than 1 month old.

thank you for advices

best regards

Michel

Hello

there is option to select versions kept e.g. 20, 10, 5 there is no option to do it according to time,

-- you may want to set it to keep 5

and then empty the ALL versions (yes this is will delete all version):
truncate dbprefix_flexicontent_versions
truncate dbprefix_flexicontent_item_versions

and then login/logout, visit FLEXIcontent backend and you will be asked to create/add current item versions

NOTE: to make versioning more meaningful/useful,

we think
- to create 1 new item version per login session (thus you you login and even if you save the item multiple times, only 1 new version is created, all subsequent saves go to this version),
- the above together with an option to create a new version on-demand only, aka when you save you are given an option to manually add more than 1 version during current login session

thank you

I have changed the number of version to 5
but I dont find where to do :

and then empty the ALL versions (yes this is will delete all version):
truncate dbprefix_flexicontent_versions
truncate dbprefix_flexicontent_item_versions

Do I need to go directly to PHPMYADMIN ? I prefer ask you before doing wrong things

thank you for advices

best regards

Michel

Hello

yes, in phpmyadmin,

please truncate correct tables as mentioned above

- maybe we should add this as a task in items manager,

just the versioning tables do not effect frontend/backend site (because they are only used in item form and in backend dashboard)

They only effect performance:
- slightly the item form
- little the first visit in FLEXIcontent backend (only the first screen after login to backend)

and eat some DB space

Thank you very much.

I agree with you to add a task in item manager.
I'm always a little bit afraid when obliged to update datas directly in PHPMAYADMIN.

The treatment has been successfull.

After this operation, the data base has lost 33% of his initial size (I have done an optimization before and after truncating the files).

best regards

Michel

We can also reset it back to Version #1 - by adding the last line:

Reset Joomla Article Hits to zero: