Réduire le nombre de version des items Flexicontent ?

More
5 years 11 months ago #72821 by flodariege
Bonjour,

J'ai rencontré un gros problème lors de la mise à jour de mon site de Joomla 3.7.5 vers 3.8.6, et j'ai donc confié les clefs de mon administration à quelqu'un de plus technique que moi, qui a parfaitement - mais non sans difficultés - réussi à résoudre les problèmes.

Au final, tout fonctionne, mais le nombre de fichiers l'a quelque peu alarmé : plus de 60 000 fichiers, alors qu'il me dit qu'un Joomla neuf n'en compte que 6 000.
J'ai certes quelques 2 500 photos et autant de vignettes, mais ça ne suffit pas à expliquer ce nombre de fichiers très élevé.

Selon lui, cela viendrait de Flexicontent, mais comme il n'en est pas utilisateur, il ne peut pas m'aider sur ce volet.
Voici sa question, que je vous livre telle quelle (en espérant qu'elle vous parle plus qu'à moi) :

Est-il possible de réduire le nombre de versions des items Flexicontent ?
La base en comporte plus de 50.000 soit plus de 75 Mo de données,alors qu'il n'y a que 484 éléments dans la gestion de Flexi.


Comment dois-je procéder pour supprimer (au moins) une partie de ces 50 000 fichiers ?

Merci d'avance pour vos lumières.
Si la question n'est pas assez claire pour vous, j'essaierai d'obtenir des détails.

Bonne soirée,
Flo
--

Dare to dream, believe the unbelievable, never take no for an answer

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

More
5 years 11 months ago #72823 by ggppdk
Hello

unix.stackexchange.com/questions/4105/ho...-through-directories

Open a linux command box into your server
and go to Joomla folder:

Execute
Code:
find -maxdepth 1 -type d | while read -r dir; do printf "%s:\t" "$dir"; find "$dir" -type f | wc -l; done

then
cd somefolder
when somefolder is the folder listing the large >10,000 of files

then execute again
then CD again


-- 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
5 years 11 months ago - 5 years 11 months ago #72828 by flodariege
EN FRANCAIS :
Désolée, mais ça ne répond pas à la demande.
Sans doute ma question n'était-elle pas assez claire.

Je ne cherche PAS à faire une recherche du nombre de fichiers dans les dossiers, mais plutôt:
1) savoir pourquoi il y a autant de versions dans mon site
2) savoir comment supprimer les versions inutiles

C'est la table "#__flexicontent_items_versions" qui dépasse 75 Mo et compte plus de 50.000 lignes pour 484 éléments (publiés ou non).

Est-ce plus clair ainsi ?
Merci d'avance pour votre aide.

IN ENGLISH:
I'm sorry but this do not answer my question, which was probably not clear enough.

I DO NOT need to search the files number inside the folders, but rather:
1) know why there are so many versions / files on my website
2) know how to delete the useless ones

It is the table "#__flexicontent_items_versions" which is over 75 Mo and counts more than 50 000 lines for only 484 items (published or not).

Is that more clear this time?
Thank you for your help.

Dare to dream, believe the unbelievable, never take no for an answer
Last edit: 5 years 11 months ago by flodariege.

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

More
5 years 11 months ago - 5 years 11 months ago #72832 by ggppdk
Hello

e.g.

100 versions per item x 10 fields (core or custom) x 500 items = 50,000 rows
or
25 versions per item x 40 fields (core or custom) x 500 items = 50,000 rows

there is 1 row per field value


1. in component configuration, you can reduce the number of version to 5
2. then you can backup DB , go to you DB tool e.g. phpmyadming
and (empty / truncate) tables:
"*_flexicontent_items_versions"
"*_flexicontent_versions"

do not delete the table, only "truncate" them
FC code will (should) handle the empty version tables without any issues


-- 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...
Last edit: 5 years 11 months ago by ggppdk.

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

More
5 years 11 months ago #72835 by flodariege
Hello,

Thank you for your answer.

Regarding the component configuration, I "only" have :

versions à conserver : 10 (and turned it on 5 from now)
Nb de versions par page : 5

Regarding the number of fields (core or custom), I have 23 of them.

Which would be :
10 versions per item x 23 fields x 484 items = 111 320 rows
... but maybe only 11 132 rows ???

In fact I don't get your calculation. You wrote :
100 versions x 10 fields x 500 items = 50 000 rows (when 100*10*500 = 500 000)
25 versions x 40 fields x 500 items = 50 000 rows (when 25 * 40 * 500 = 500 000)
there is 1 row per field value ... <= I don't understand, even with this, how you get 50 000 in your calculation.


Well, anyway I'm going to try to clean my database as you told me to (whith some little help from a friend).


Have a nice day :)

Dare to dream, believe the unbelievable, never take no for an answer

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

More
5 years 11 months ago - 5 years 11 months ago #72851 by ggppdk

In fact I don't get your calculation. You wrote :


yes i made mistake it is 1 more zero , lol

thus
100 versions per item x 10 fields (core or custom) x 500 items = 500,000 rows



in your case you are correct in calculation
10 versions per item x 23 fields x 484 items = 111 320 rows

but the above is the MAX for your current on number of items
- meaning you will reach the above if you save all items at least 10 times

so if you have 50,000 rows < 111,320 rows
it looks correct

If you want to reduce the number of versions to 5 and then backup DB and then "emtpty / truncate" the 2 tables
be careful and truncate the specific tables

flexicontent_items_versions
flexicontent_versions


-- 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...
Last edit: 5 years 11 months ago by ggppdk.

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

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.305 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