3 moves and three sets of folders

  • Ok,
    AlanP57 this is going to be all manual probably. I’ve had to move our website from an ip address to a temp wp folder now to root folder as I’ve transitioned our non-profit website from a horrible host over to another host. Each time MLP has become more and more confused. I’ve got for example three sets of folders of each of my original “static” image folders and planned on having the authors use the standard Media upload to go into uploads/year/month. But for my “static” images for example I have an uploads/media/artwork/homepage and uploads/media/artwork/ensemblepage etc for the pictures I used to make up all home and landing pages. Now each of those folders shows up three times with three different post id’s and each folder contains some of the same pictures, others contain pictures uploaded probably after a move and the third folder contains the last set uploaded.

    1. I see a database entry set XX_mgmlp+folders with post_id,folder_id using primary key post_id

    Then I have the array set under “INERT INTO ‘XX_mgmlp_folders( ‘post_id’….etc)
    With about 250 entries

    2. I’m looking at the “post” tables and seeing the

    links of posts corresponding to the folder tree, If I delete ALL of the posts listed in the mgmlp_folder array then the mgmlp_folders() table itself. Is this safe to do? Or do you cross-link your plugin somewhere else that I haven’t traced yet?

    3. Right now the functionality of MLP is highly degraded – my admin’s can’t upload as the files as they just “disappear” after upload, and using the MLP reset database plugin and reactivating doesn’t work as expected as it just re-creates the messed up folder structure again. However if I FTP a file into the folder they are trying to upload – the MLP does “SYNC” the file into the “working” folder and then it can be used… I haven’t figured out how to determine the working folder – but if I had to guess it’s the latest post dated folder in the list that isn’t necessarily in chronological order in the database. Maybe if I was smarted at SQL I could query by date the folder list and match the posts up – but If I could do that I’d use SQL to fix this problem anyway. Right now I plan on just editing the SQL export and then re-upload.

    4. If my last sentence is a bad idea …. let me know.

    5. Your plugin is 3.1 or 3.0.1 – the latest and WP is at it’s latest as well. Was hoping the jump to 3.0 would magically fix my problem.

    Thanks in advance,
    E2C2Monkeyboy

    https://www.ads-software.com/plugins/media-library-plus/

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author AlanP57

    (@alanp57)

    “using the MLP reset database plugin and reactivating doesn’t work as expected as it just re-creates the messed up folder structure again” that means your database still contains incorrect attachment URLs. You will have to insure that all your URLs point to the correct locations.

    Thread Starter e2c2monkeyboy

    (@e2c2monkeyboy)

    Luckily I’ve read a lot of word press books lately and I got what you said. So much for “Better Search and Replace” plugin – it did allow migration but it failed miserably at fixing URL’s… I’m wondering if it just cheated in the esoteric rewrite rules area…. Now I’m in trouble. This is going to be a brute force (and painful) cleanup of the database – or can you give me pointers on how to automate this?

    I’m really surprised our site still works looking at the guts of our database.

    For a concrete example: I see one photo (handled by MLP)
    https://www.xxxxxxx.org/test1/reloaded/wp-content/uploads/Staff/JacksonLai300x380.jpg’, 0, ‘attachment’, ‘image/jpeg’, 0),

    that photo is in the wp_posts table (looking at the SQL dump)

    but it must also be under with a different post ID since it is working on the live website. Having moved it from xx.xx.xx.xx/reloaded -> xxxxxx.org/test1/reloaded -> then to xxxxxx.org/reloaded and now to the root directory as I moved domains and hosts – what a mess.

    https://www.xxxxxxx.org/wp-content/uploads/Staff/JacksonLai300x380.jpg’, 0, ‘attachment’, ‘image/jpeg’, 0), is what it’s probably supposed to look like and MLP probably is finding the 3 different URL moves right?

    ALSO!?

    The MLP plug is allowing to navigate the libraries even with duplicate folders but the YELLOW link in include from MLP folders isn’t active in the editor anymore – did this get removed in 3.0 or is the plugin also broken by this database near corruption? (trust me – I’ve uninstalled MLP and re-installed twice now trying that hail Mary.)

    P.S. Is MLP self contained in the mgmlp_folders table and the ‘post_id’, ‘folder_id’ links in the wp_posts table? In other words – safe to delete the posts AND the same id’s listed in the mgmlp_folders table?

    thanks in advance,
    e2c2monkeyboy

    Thread Starter e2c2monkeyboy

    (@e2c2monkeyboy)

    OK,
    AlanP57 here are three posts, with three folders containing 6 folders who also have their duplicates. Each with three different URL’s. The first one is correct. The second two are incorrect. Can I simply delete the other two posts (#2 and #3 manually from the database) and their associated duplicate folder posts without issue?

    #1 -> correct URL ===== (2197, 1, ‘2016-06-01 02:41:32’, ‘2016-06-01 02:41:32’, ”, ‘Artwork’, ”, ‘publish’, ‘closed’, ‘closed’, ”, ‘Artwork’, ”, ”, ‘0000-00-00 00:00:00’, ‘0000-00-00 00:00:00’, ”, 0, ‘https://www.xxxxx.org/wp-content/uploads/Artwork’, 0, ‘mgmlp_media_folder’, ”, 0),

    #2 -> first testing URL during domain transfer

    (2136, 1, ‘2016-06-01 02:41:32’, ‘2016-06-01 02:41:32’, ”, ‘Artwork’, ”, ‘publish’, ‘closed’, ‘closed’, ”, ‘Artwork’, ”, ”, ‘0000-00-00 00:00:00’, ‘0000-00-00 00:00:00’, ”, 0, ‘https://www.xxxxx.org/test1/reloaded/wp-content/uploads/Artwork’, 0, ‘mgmlp_media_folder’, ”, 0),

    #3 -> second move while maintaining moved “old” website on same server.

    (2105, 1, ‘2016-06-01 02:41:32’, ‘2016-06-01 02:41:32’, ”, ‘Artwork’, ”, ‘publish’, ‘closed’, ‘closed’, ”, ‘Artwork’, ”, ”, ‘0000-00-00 00:00:00’, ‘0000-00-00 00:00:00’, ”, 0, ‘https://www.xxxxx.org/reloaded/wp-content/uploads/Artwork’, 0, ‘mgmlp_media_folder’, ”, 0),

    Regards,
    e2c2monkeyboy

    Plugin Author AlanP57

    (@alanp57)

    Yes, since these are duplicate folders.

    Thread Starter e2c2monkeyboy

    (@e2c2monkeyboy)

    lol, ok Alan – I’ll try can keep this post shorter. But the yellow “add media” thing? where can I look to see what and why it isn’t showing up?

    Plugin Author AlanP57

    (@alanp57)

    The ability view MLP from the post or page edit page, navigate its folders and insert images into post of pages in only available in Media Library Plus Pro. But you can still use the Media Library to insert images into your posts or pages. You can find out more about MLPP here: https://maxgalleria.com/downloads/media-library-plus-pro/

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘3 moves and three sets of folders’ is closed to new replies.