Announcement

#1 2012-07-09 12:22:33

geoffschultz
Member
Marlborough, MA, USA
2012-07-01
148

How to arrange album tree structure in 2.4?

I have created a series of albums such as "2012 Cruising", "2011 Cruising" etc and each of these parent albums has many child albums.  Now I want to create a master parent album titled "Cruising" and place each of the 2012/2011/etc albums under it.  I can't figure out how to do this in 2.4

-- Geoff

Offline

 

#2 2012-07-09 12:48:48

mistic100
Former Piwigo Team
Lyon (FR)
2008-09-27
3271

Re: How to arrange album tree structure in 2.4?

Album->Manage->Move
you can select multiple albums with Ctrl+click

Offline

 

#3 2012-07-09 12:52:06

geoffschultz
Member
Marlborough, MA, USA
2012-07-01
148

Re: How to arrange album tree structure in 2.4?

mistic100 wrote:

Album->Manage->Move
you can select multiple albums with Ctrl+click

None of the albums show up on the virtual album list.

-- Geoff

Last edited by geoffschultz (2012-07-09 12:52:33)

Offline

 

#4 2012-07-09 12:58:07

mistic100
Former Piwigo Team
Lyon (FR)
2008-09-27
3271

Re: How to arrange album tree structure in 2.4?

well, do you use physical albums only ?

if so I don't remind if there is a proper way to move a folder without loosing comments/rates/etc

Offline

 

#5 2012-07-09 13:05:34

geoffschultz
Member
Marlborough, MA, USA
2012-07-01
148

Re: How to arrange album tree structure in 2.4?

mistic100 wrote:

well, do you use physical albums only ?

if so I don't remind if there is a proper way to move a folder without loosing comments/rates/etc

As I just found out in the "How to completely delete an album" thread, I am using Physical albums.  I had no idea about the limitations of using them.  I'm using them because I need to import hundreds of albums and the only practical way to do that was via FTP.

I have no comments, ratings as of yet as I'm not making this public until I'm ready to switch over.

Now, short of my writing an SQL script to modify the _images table with the correct structure, how would you suggest that I do this?

-- Geoff

Offline

 

#6 2012-07-09 13:09:13

mistic100
Former Piwigo Team
Lyon (FR)
2008-09-27
3271

Re: How to arrange album tree structure in 2.4?

ok if there is no info to keep, just move albums in the filesystem (through FTP) and do a global sync

Offline

 

#7 2012-07-09 13:13:08

flop25
Piwigo Team
2006-07-06
6918

Re: How to arrange album tree structure in 2.4?

mistic100 wrote:

ok if there is no info to keep, just move albums in the filesystem (through FTP) and do a global sync

exacty
and I would like to add, if you want to put these albums virtual, there is [extension by plg] Virtualize (not tested in 2.4)


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#8 2012-07-09 13:20:04

geoffschultz
Member
Marlborough, MA, USA
2012-07-01
148

Re: How to arrange album tree structure in 2.4?

mistic100 wrote:

ok if there is no info to keep, just move albums in the filesystem (through FTP) and do a global sync

I have titles and thumbnails defined for hundreds of albums.  Will I lose these? 

-- Geoff

Offline

 

#9 2012-07-09 13:21:20

flop25
Piwigo Team
2006-07-06
6918

Re: How to arrange album tree structure in 2.4?

geoffschultz wrote:

mistic100 wrote:

ok if there is no info to keep, just move albums in the filesystem (through FTP) and do a global sync

I have titles and thumbnails defined for hundreds of albums.  Will I lose these? 

-- Geoff

if you manually changed that, i'm afraid the answer is yes


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#10 2012-07-09 13:23:03

geoffschultz
Member
Marlborough, MA, USA
2012-07-01
148

Re: How to arrange album tree structure in 2.4?

flop25 wrote:

mistic100 wrote:

ok if there is no info to keep, just move albums in the filesystem (through FTP) and do a global sync

exacty
and I would like to add, if you want to put these albums virtual, there is [extension by plg] Virtualize (not tested in 2.4)

How do I install an extension that isn't tested for the version that I'm on?  I only see plugins that appear to be tested for 2.4?

-- Geoff

Offline

 

#11 2012-07-09 13:26:19

flop25
Piwigo Team
2006-07-06
6918

Re: How to arrange album tree structure in 2.4?

if want to test :
[extension by plg] Virtualize there is a big orange Download button ; then put in /plugins


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#12 2012-07-12 13:02:13

geoffschultz
Member
Marlborough, MA, USA
2012-07-01
148

Re: How to arrange album tree structure in 2.4?

I manually installed Virtualize and ran it (which was very scary, but I had backups of everything) and it failed with the following error:

Code:

Warning:  [mysql error 1054] Unknown column 'has_high' in 'field list'

SELECT
    path AS oldpath,
    date_available,
    has_high,
    tn_ext,
    id
  FROM piwigo_images
  WHERE path NOT LIKE './upload/%'
; in /usr/www/users/gschultz/GeoffSchultz/photos/include/dblayer/functions_mysql.inc.php on line 770


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/www/users/gschultz/GeoffSchultz/photos/include/dblayer/functions_mysql.inc.php on line 153

Warning: Cannot modify header information - headers already sent by (output started at /usr/www/users/gschultz/GeoffSchultz/photos/include/dblayer/functions_mysql.inc.php:769) in /usr/www/users/gschultz/GeoffSchultz/photos/include/page_header.php on line 105

I don't think that it made it far enough to modify anything as all of my images appear to be there and are still located in ./galleries/

-- Geoff

Offline

 

#13 2012-07-12 14:00:59

flop25
Piwigo Team
2006-07-06
6918

Re: How to arrange album tree structure in 2.4?

Yes that's normal... I didn't know how the plugin works, but now I can tell you it will need a serious update : many database entries disappeared in 2.4


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#14 2012-07-12 17:20:29

geoffschultz
Member
Marlborough, MA, USA
2012-07-01
148

Re: How to arrange album tree structure in 2.4?

Last week I added about 200 albums and 3200 images.  These covered about 9 years of sailing and the albums were associated with top level albums titled like "2012 Cruising", etc.  I added one year at a time via FTP and synchronized them.

Since then I've been organizing sub-albums and sorting, selecting thumbnails, creating more descriptive names and providing descriptions. 

Today I made a backup of the database before attempting the Virtualize.  When that didn't work, I restored the database just to make sure that nothing got corrupted.

I then noted that I was missing 2 sub-albums from 2007 and FTPed the directories/images to the .galleries/2007_Cruising directory & ran a sync.  To my surprise it said that it was going to add all of the images and albums to the database!  I actually let it do that and it duplicated all of the files/albums.  It created duplicate "20xx Cruising" top level albums and added the "new" photos under them.

What's going on?  I've restored the database back to what it was prior to the Sync, but that doesn't solve my problem.  The directory structure of ./galleries seems to be fine.  I have many more albums that I need to add.  How am I going to do this?

-- Geoff

Last edited by geoffschultz (2012-07-12 17:24:27)

Offline

 

#15 2012-07-12 17:41:25

flop25
Piwigo Team
2006-07-06
6918

Re: How to arrange album tree structure in 2.4?

O_O wow ! how unlucky you are !

Could you create another thread please ? thx
go back to your backup first


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

Board footer

Powered by FluxBB

github twitter facebook google+ newsletter Donate Piwigo.org © 2002-2019 · Contact