Loading...
 
Skip to main content

Features / Usability

Forum List Topic List

Forums » Features / Usability » Help with migrating image galleries to file gallery
 
Thread actions
Print this page
  • Print all pages

    • Help with migrating image galleries to file gallery

    Posted by Jaroosa posts: 2 Australia

    I have a wiki with over 50,000 images in image galleries (stored in directory) which I need to migrate to file gallery before I can begin upgrading to latest versions (which no longer support image galleries).

    When I click on the 'Migrate images to File Gallery' button it causes a site timeout. The script obviously cannot handle such a large task.

    I have looked and have not been able to find a way to migrate individual image galleries one by one to file galleries.

    I am using version 18.7 of tikiwiki.

    Any suggestions or advice about how I might be able to complete this task or if this task is possible with later version of tikiwiki would be greatly appreciated.

    Reads: 1046
    Posted by Jaroosa posts: 2 Australia
    Bernard Sfez / Tiki Specialist wrote:

    Mm... I'm not sure that changing the timeout value to a bigger one will help.

    I have done similar "surgical operation" for other Tiki upgrades.
    Contact me in private.


    I appreciate the reply.

    I think I found a solution. I have done this successfully on a staging site.

    This is for anyone with a similar problem.

    In phpmyadmin.

    I made a copy of the table tiki-galleries

    Then I emptied tik-galleries

    Then copied just a few rows from backup into tiki-galleries.

    Click on the 'Migrate images to File Gallery' button.

    Then empty tiki-galleries again and copy next number of rows across. Repeat until finished.

    Did some experimenting and found the max that could be moved at one time is about 1000 images. For me that mean copying about 10 rows at a time. I have 1700 galleries.

    So while this method takes some time, doing it bit by bit works.

    Looking forward to finally being able to update software after years of being slack!

    Hope this might help someone, someday.