Looks like a lot to do :-P

Thanks plg for the answer. I'll see what I can do.

plg wrote:

I have a script for virtualization. I've used it on my own gallery and I've used it on Piwigo.com accounts that were importing an existing database.

Sounds interesting. ^^

Would it be possible to have it (with a little instruction)?

plg wrote:

Hi Sugar888,

    Another option is to have text file with "old_path new_path" and then you perform an SQL query to update all your images.path but you would also have to care about images.storage_category_id :-/

Hi plg, please can you tell me how to use the text file to update all images.path?
I want to move one subcategory one level up and keep all information (mainly image.date_available - because I don't want mark pictures as recent ones).
Thank you, Pavel

pab wrote:

Hi plg, please can you tell me how to use the text file to update all images.path?
I want to move one subcategory one level up and keep all information (mainly image.date_available - because I don't want mark pictures as recent ones).

If you just want to move a physical category without turning it into a virtual category, I suggest :

1) move the directory on your filesystem
2) know the category numeric id and the new parent category id
3) perform the following SQL query (replace the <variable> with the right values:

update piwigo_categories set id_uppercat = <new parent category id> where id = <category id>;

for example :

update piwigo_categories set id_uppercat = 123 where id = 234;

4) go to [Administration > Tools > Maintenance] and perform an Update categories information and then a Update images information

Of course, backup your database before any such operation.