Need help with recover of missing albums.

[Ken.]

My album's list was getting rather long so I thought that assigning some of them to a parent category would be a good thing, trouble is when they were moved into the category they disappeared. The category that they were moved to is the default "Member Galleries".

Is there a way to cause them to show in the Member Galleries, or failing that to move them back to their original position?
... I can tell that at least one of the albums is still there somewhere because images from the album show in my "Recent Pictures" list.

[SMFHacks]

Pictures are not meant to be moved to the member galleries placeholder. That category just holds the list of member galleries.   I see the bug with moving a picture and will get the member galleries option removed.

Here is a database query that you could use.
First step find what category the members gallery is. This gets you the ID_CAT

Code: [Select]

SELECT ID_CAT FROM smf_gallery_cat WHERE title = 'Member Galleries';

Next step is to figure out which user's category you wish to move to
Example
http://www.ourfamilyforum.org/FamilyForum/index.php?action=gallery;su=user;cat=1;u=57
This user is Jake and user category ID of 1
Remember this user's category will be used laster

To move all pictures to his category
Make a backup first of the gallery_pic table then run

Code: [Select]

UPDATE smf_gallery_pic  SET USER_ID_CAT = USERSCATIDHERE, ID_CAT = 0  WHERE  ID_CAT = ID_CAT_HEREFROMFIRSTQUERY


[Ken.]

Thanks for the reply Hacks.

The ID_CAT list of the albums that were moved (6 albums) was pulled using the query that you posted and that went OK, but I'm not 100% sure on how to write the update query.

In this example are the values set correctly to move the album back to the regular Gallery section if the ID_CAT number is 5?

Code: [Select]

UPDATE smf_gallery_pic  SET USER_ID_CAT = 5, ID_CAT = 0  WHERE  ID_CAT = ID_CAT_5

[SMFHacks]

Your example would move the pictures to the user gallery category that is number 5

If you want to move it to a normal gallery

Code: [Select]

UPDATE smf_gallery_pic  ID_CAT =MainGalleryCategoryIDHERE  WHERE  ID_CAT = 5
Where 5 is the category id of the "Member Galleries" category

Replace MainGalleryCategoryIDHERE with the ID of the Main category to move the pictures to.

[Ken.]

So if there is an album category called "Member Pics" with the ID of '3' the command would be as below?
http://www.ourfamilyforum.org/FamilyForum/index.php?action=gallery;cat=3

Code: [Select]

UPDATE smf_gallery_pic  ID_CAT =3  WHERE  ID_CAT = 5

[SMFHacks]

One small change

Code: [Select]

UPDATE smf_gallery_pic SET  ID_CAT =3  WHERE  ID_CAT = 5


[Ken.]

I'm still doing something incorrectly.

The query is moving the pictures, but not the album itself.
Will I need to create a new album to place the recovered pictures in?

[Ken.]

Got it. 

It was not a big deal after I started to understand the queries a little better and started to do things in the correct order.

Thanks for the help... Ken.

[SMFHacks]

Glad you got it working. I keep the DB structure pretty simple to allow moving of items around pretty easily and getting the information that is needed.