How to clean up FileBird database and settings to do a fresh installation

Hi there,

Thanks for reaching out.

Please try clean up like this:

First, you need remove all the relationships from term (created by FileBird) with attachment (post_ID) by using this sql you will see all relationships and delete all record

SELECT * 
FROM   wp_term_relationships 
WHERE  wp_term_relationships.term_taxonomy_id IN (SELECT 
       wp_term_taxonomy.term_taxonomy_id 
                                                  FROM   wp_term_taxonomy 
                                                  WHERE 
              wp_term_taxonomy.taxonomy = 'nt_wmc_folder') 

please change your prefix, in our database prefix is _wp

Secondly, remove all meta created by FileBird, to get that use this sql:

SELECT * 
FROM   wp_termmeta 
WHERE  wp_termmeta.meta_id IN (SELECT wp_terms.term_id 
                               FROM   wp_terms 
                                      JOIN wp_term_taxonomy 
                                        ON wp_terms.term_id = 
                                           wp_term_taxonomy.term_id 
                                           AND wp_term_taxonomy.taxonomy = 
                                               'nt_wmc_folder') 

Meta keys are ‘folder_position’ and ‘folder_type’

Finally, remove term first

select * from wp_terms JOIN wp_term_taxonomy on wp_terms.term_id = wp_term_taxonomy.term_id and wp_term_taxonomy.taxonomy = 'nt_wmc_folder'

after that remove the records (term_taxonomy):
select * from wp_term_taxonomy WHERE taxonomy = 'nt_wmc_folder'

Let me know if this helps.

Thanks,
Kelly

• This reply was modified 4 years, 9 months ago by Ninja Team.
• This reply was modified 4 years, 9 months ago by Ninja Team.

Thanks very much, it works.
Now I’m recreating my folder structure.

Glad to hear that.
Cheers!

Kelly

Hello –?I have also lost all my folders (for the second time).
We are nearing the end of a project for our client and they have literally thousands of images in their image library which we were using FileBird Pro to clean up and keep tidy.

I’m afraid I don’t understand the fix above and it sounds like we will have to recreate our folders? This will take forever – is there a way to retrieve what has been lost? What is causing this and why does it keep happening?

Hello,

You’re already a Pro user, please submit a private ticket at https://ninja.ticksy.com/ and our support team will help you check it.

Kind regards,
Kelly