[SOLVED] yet another "Need to cleanup flexicontent_items_versions"

magj
Topic Author
Offline
Senior Member

8 years 7 months ago - 8 years 7 months ago #61785 by magj

[SOLVED] yet another "Need to cleanup flexicontent_items_versions" was created by magj

Hi

I've been using Flexicontent for years and I cannot thank you enough for your great extension and support.

I have an issue with Flexicontent_items_versions table which is now hundreds of thousands of records with Gigabytes of size which is nearly 90% of my DB size.

I have searched the forum , found some topics with no CLEAR answer to this question:

Is there any "Clean Up" or something to help me have this reduced.

Thanks in advance
Best

Last edit: 8 years 7 months ago by ggppdk.

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

micker
Offline
Administrator

8 years 7 months ago #61800 by micker

Replied by micker on topic yet another "Need to cleanup flexicontent_items_versions"

you can but you will lost all version content ...
maybe simply disable versionning in global config at first

FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]

The following user(s) said Thank You: magj

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

ggppdk
Offline
Administrator

8 years 7 months ago #61808 by ggppdk

Replied by ggppdk on topic yet another "Need to cleanup flexicontent_items_versions"

Hello

1. first go to component configurations and select to keeps a small number of versions:
e.g. 5 versions

2. then empty , aka "truncate" 2 SQL tables (BOTH of them):
In mySqlAdmin or similar too execute:

Code:

TRUNCATE  TABLE  `PREFIX_flexicontent_items_versions` 
TRUNCATE  TABLE  `PREFIX_flexicontent_versions` 

in the above code replace :
PREFIX
with your db prefix

-- 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...

The following user(s) said Thank You: magj

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