Loading...
 
Features / Usability

Features / Usability


Help with migrating image galleries to file gallery

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.

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.


Upcoming Events

1)  25 Jun 2024 16:00 GMT-0000
Data umbrella : Build Your First Database Web App with (open source) Tiki Trackers
2)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
4)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5) 
Tiki birthday
6)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
8)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting