cleaning old versions of an article

More
10 years 7 months ago #45443 by rottenberg
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

Please Log in or Create an account to join the conversation.

More
10 years 7 months ago #45447 by ggppdk
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


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

More
10 years 7 months ago #45453 by rottenberg
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

Please Log in or Create an account to join the conversation.

More
10 years 7 months ago #45455 by ggppdk
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


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

More
10 years 7 months ago #45465 by rottenberg
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

Please Log in or Create an account to join the conversation.

More
3 weeks 1 day ago #85628 by iamrobert
We can also reset it back to Version #1 - by adding the last line:
Code:
TRUNCATE TABLE `PREFIX_flexicontent_items_versions`; TRUNCATE TABLE `PREFIX_flexicontent_versions`; UPDATE `PREFIX_content` SET `version` = 1;

Reset Joomla Article Hits to zero:
Code:
UPDATE `PREFIX_content` SET `hits` = 0;
 

Please Log in or Create an account to join the conversation.

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.304 seconds
Save
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Essential
These cookies are needed to make the website work correctly. You can not disable them.
Display
Accept
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline