adam/Piwigo
1
0 Fork 0
mirror of https://github.com/Piwigo/Piwigo.git synced 2026-10-30 21:52:00 +01:00
Code Issues 657 Packages Projects Releases Wiki Activity

[albums] [Enhancement] Possibility to physically move/change pictures from a category to an other #99

New Issue
Open
opened 2026-10-04 23:43:23 +02:00 by adam · 1 comment
adam commented 2026-10-04 23:43:23 +02:00
Owner
Copy link
Copy source

Reported by Bozz974 on 25 Aug 2009 14:25

Version: 2.0.3

I sometimes experienced this problem:
I sarted to populate a category with some pictures. But after a while, I realised that my pictures can be organized differently:
not in the right category, or must be inside a subcategory.

I did not find an easy way to administrate such a moving. It would be nice to have such an admin feature.

Steps to reproduce: Exemple:
[current]
cat_macro

  • pic_macro_flower_001.jpg
  • pic_macro_flower_002.jpg
  • pic_macro_butterfly_001.jpg
  • pic_macro_Syrphe_001.jpg

[whish]
cat_macro
|_cat_macro_flowers
- pic_macro_flower_001.jpg
- pic_macro_flower_002.jpg
|_cat_macro_insects
- pic_macro_butterfly_001.jpg
- pic_macro_Syrphe_001.jpg

Additional information: The aim is to keep all hit counters, comments, tags, titles, descriptions, date_available, etc...
in order to not disturb the history, or sorting.
The old pictures, even moved should still be an old one, and should not appears as a new added picture in the system (in other words, I would not like them to be among the "recent_pictures")

Piwigo Bugtracker #1143

**Reported by Bozz974 on 25 Aug 2009 14:25** **Version:** 2.0.3 I sometimes experienced this problem: I sarted to populate a category with some pictures. But after a while, I realised that my pictures can be organized differently: not in the right category, or must be inside a subcategory. I did not find an easy way to administrate such a moving. It would be nice to have such an admin feature. **Steps to reproduce:** Exemple: [current] cat_macro - pic_macro_flower_001.jpg - pic_macro_flower_002.jpg - pic_macro_butterfly_001.jpg - pic_macro_Syrphe_001.jpg [whish] cat_macro |_cat_macro_flowers - pic_macro_flower_001.jpg - pic_macro_flower_002.jpg |_cat_macro_insects - pic_macro_butterfly_001.jpg - pic_macro_Syrphe_001.jpg **Additional information:** The aim is to keep all hit counters, comments, tags, titles, descriptions, date_available, etc... in order to not disturb the history, or sorting. The old pictures, even moved should still be an old one, and should not appears as a new added picture in the system (in other words, I would not like them to be among the &quot;recent_pictures&quot;) [Piwigo Bugtracker #1143](http://piwigo.org/bugs/view.php?id=1143) <!-- github-sync-id:97225806 -->
adam commented 2026-10-04 23:43:24 +02:00
Author
Owner
Copy link
Copy source

Comment posted by Bozz974 on 26 Aug 2009 07:56

What I do today when I need to do so:

  • copy all the pictures I want to move into the new categories.
  • write down (on a paper, in a file on my computer) which old element_id/image_id corresponds to new element_id.
  • edit my database and alter manually the tables:
    _comments: replace the old id by the id (for each moved pictures)
    _images: copy paste from old to new: date_available, name, comment, author, hit, date_metadata_update, average_rate
    _image_tag: replace the old id by the new id
    _rate: replace the old id by the new id
  • Then I remove physically the files from the old category.
  • Then I perform a sync with pwg to clean the database with old references.

It takes me some times to do so.
I also may miss some steps...

**Comment posted by Bozz974 on 26 Aug 2009 07:56** What I do today when I need to do so: - copy all the pictures I want to move into the new categories. - write down (on a paper, in a file on my computer) which old element_id/image_id corresponds to new element_id. - edit my database and alter manually the tables: _comments: replace the old id by the id (for each moved pictures) _images: copy paste from old to new: date_available, name, comment, author, hit, date_metadata_update, average_rate _image_tag: replace the old id by the new id _rate: replace the old id by the new id - Then I remove physically the files from the old category. - Then I perform a sync with pwg to clean the database with old references. It takes me some times to do so. I also may miss some steps... <!-- github-comment-id:124891795 -->
Sign in to join this conversation.
No Branch/Tag Specified
Labels
No items
No labels
Milestone
No items
No Milestone
Projects
Clear projects
No projects
Assignees
Clear assignees
adam (Adam Wojcieszonek)
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: adam/Piwigo#99