clean jos_flexicontent_items_versions

micker
Topic Author
Offline
Administrator

14 years 11 months ago #8867 by micker

clean jos_flexicontent_items_versions was created by micker

hello i desactived to versionning in my flexicontent
but
this table

Code:

jos_flexicontent_items_versions

is too big (2.5MO)
ist's possible to clean this ?
Thanks

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]

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

micker
Topic Author
Offline
Administrator

14 years 11 months ago #8949 by micker

Replied by micker on topic clean jos_flexicontent_items_versions

hello nobody ?

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

vlester
Offline
Premium Member

13 years 9 months ago #18643 by vlester

Replied by vlester on topic clean jos_flexicontent_items_versions

Hello Micker,

Did you find an answer to that question ?
I don't need versionning on my website but I forgot to disable it at the beginning and now my database is full because of the huge size of the jos_flexicontent_items_versions table.
I don't understand how the versionning works. If I clean the table, will I loose the current version of my contents ? Or is it safe in the jos_content table ?

Thanks

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

ggppdk
Offline
Administrator

13 years 9 months ago #18647 by ggppdk

Replied by ggppdk on topic clean jos_flexicontent_items_versions

Do not delete the tables. You can empty the tables:
jos_flexicontent_versions
and
jos_flexicontent_items_versions

by executing (e.g. in phpmyadmin):

TRUNCATE TABLE `jos_flexicontent_versions`
TRUNCATE TABLE `jos_flexicontent_items_versions`

PLEASE TRUNCATE --BOTH-- tables not just one of them otherwise you will have problems with enabling versioning later.

Regards

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