Fix Album/Photo hierarchy..... still?

CarlMGregory

Joined: 2009-09-12
Posts: 6
Posted: Sat, 2009-09-12 21:32

I am having problems with photo's showing an odd hierarchy... so after reading several posts on here I setup and ran the rescue module. It's been 4 hours now, still not done. But, even worse, doesn't show to of made any progress. It sometimes even goes backwards in progress!

Fix Album/Photo hierarchy
111 / 8821 rows updated
** 1.5 seconds later **
84 / 8821 rows updated
** 1.5 seconds later **
210 / 8821 rows updated
** 1.5 seconds later **
101 / 8821 rows updated
** 1.5 seconds later **
177 / 8821 rows updated

So on and so forth. And you can imagine, the percentage progress bar jumps around to match that. So, is it working and I should just wait till it's done and ignore it's progress window or is something up?

Carl M. Gregory

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16503
Posted: Sat, 2009-09-12 23:01

Are you using the latest experimental code to start with:
http://codex.gallery2.org/Gallery3:Upgrading

____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
CarlMGregory

Joined: 2009-09-12
Posts: 6
Posted: Sat, 2009-09-12 23:05
[root@cmaxcc image.purehype.net]# cat update && echo ..... && ./update
#!/bin/sh
cd /home/cmaxcc/domains/image.purehype.net/

cd gallery3-contrib
git pull

cd ../public_html/gallery3/
git pull
php index.php upgrade
.....
Already up-to-date.
Already up-to-date.
Upgrade complete
 
bharat
bharat's picture

Joined: 2002-05-21
Posts: 7934
Posted: Sun, 2009-09-13 00:17

No, it's definitely not working properly :-) I'm not exactly sure what's going wrong here, but if I had to guess I'd say that you probably have some *really* big albums in your gallery. Is that the case? Roughly what's the number of photos in your largest album?
---
Problems? Check gallery3/var/logs
bugs/feature req's | upgrade to the latest code | use git | help! vote!

 
bharat
bharat's picture

Joined: 2002-05-21
Posts: 7934
Posted: Sun, 2009-09-13 00:30

I just made a change to the rescue module to add a little more headroom. Try again, it might resolve your issue.
---
Problems? Check gallery3/var/logs
bugs/feature req's | upgrade to the latest code | use git | help! vote!

 
CarlMGregory

Joined: 2009-09-12
Posts: 6
Posted: Sun, 2009-09-13 01:04

How many ... I don't know, 8821 images over many albums ...

[root@cmaxcc gallery3-contrib]# git reset --hard HEAD && git pull

HEAD is now at 067b6b5... Installer cleanup.
Updating 067b6b5..1040302

Fast forward
 modules/rescue/helpers/rescue_task.php |   12 ++++++------
 1 files changed, 6 insertions(+), 6 deletions(-)

Wonderful, finishes now and in only a few minutes.

Quote:
Success 8821 / 8821 rows updated

Still have some weird issues though, not sure if I should open another post or not .. but...
If I go to http://image.purehype.net/gallery3/index.php/Public?page=2, all the images appear as broken.
I click on one of them and get a 'Dang... Something went wrong!'

Quote:
The page you requested, Carl M Gregory/Family/3.gif/dig-gold2.jpg/Public/cube watermelon 1.png/catlikesbeer.jpg/2004/catandbeer.jpg/little_2Dperv_2Dwill_2Dgrow_2Dbig_2Dperv_2D3dd.jpg/_Images_APCLogo.jpg/man1.gif/0402.jpg/e16.jpg/workhead.jpg/worldconspiracy.jpg/howtoprin, could not be found.

Hrm, that URI is all wrong. Suppose the rescue doesn't fix that? What do you suggest for this?

Carl M. Gregory

 
CarlMGregory

Joined: 2009-09-12
Posts: 6
Posted: Sun, 2009-09-13 01:14

Also,

If I go to http://image.purehype.net/gallery3/index.php/Carl%20M%20Gregory (or http://image.purehype.net/gallery3/index.php and click on 'Carl M Gregory' album), I get a 'Dang... Something went wrong!'. In the 'tell me more' info it says

Quote:
The page you requested, Carl M Gregory, could not be found.

However, that URI doesn't look messed up like the previous post.

Carl M. Gregory

 
bharat
bharat's picture

Joined: 2002-05-21
Posts: 7934
Posted: Sun, 2009-09-13 04:01

This should be fixed in the code now, but your data might still be messed up. In mysql, try doing "update items set relative_path_cache=null, relative_url_cache=null" and then see if that fixes your album links. If that doesn't work, try editing the album name using the context menu and change the Internet Address field to not contain spaces or special characters (once you're editing that field it won't let you enter bad characters).

---
Problems? Check gallery3/var/logs
bugs/feature req's | upgrade to the latest code | use git | help! vote!

 
dvader

Joined: 2009-09-13
Posts: 8
Posted: Sun, 2009-09-13 05:07

I'm having the same problem with g2 -> g3 imports. anything with a "'" in the title ends up looking like this (Luke_#39_s photos) when it should be (Luke's photos)
then the error is So here's the error:
The page you requested, 2009/Luke_, could not be found.

 
bharat
bharat's picture

Joined: 2002-05-21
Posts: 7934
Posted: Sun, 2009-09-13 05:21

dvader, that should also be fixed with the latest code (see upgrading link below).
---
Problems? Check gallery3/var/logs
bugs/feature req's | upgrade to the latest code | use git | help! vote!

 
dvader

Joined: 2009-09-13
Posts: 8
Posted: Sun, 2009-09-13 06:39

I am a gallery n00b, so if i didn't upgrade correctly please let me know
i followed this link http://example.com/gallery3/index.php/upgrader (replaced with my site)
and it said gallery 3 was at "6" and "7" was available, so i upgraded.
removed my albums and then re-imported, it still did not appear to be fixed.
was this the correct method for upgrading?

 
bharat
bharat's picture

Joined: 2002-05-21
Posts: 7934
Posted: Sun, 2009-09-13 08:21

@dvader: you're still using beta 2. Try the latest code from Git (see the upgrading link in my sig)
---
Problems? Check gallery3/var/logs
bugs/feature req's | upgrade to the latest code | use git

 
CarlMGregory

Joined: 2009-09-12
Posts: 6
Posted: Sun, 2009-09-13 11:28

bharat,

After doing the update `g3_items` set `relative_path_cache`=null, `relative_url_cache`=null;, all is well with the first issue.
Then, changing the internet name of the album from Carl M Gregory to CarlMGregory fixed the second issue.

All appears to be working now, thanks.

Carl M. Gregory

 
CarlMGregory

Joined: 2009-09-12
Posts: 6
Posted: Sun, 2009-09-13 11:35

By the way, bharat, now that my album is back online I can properly answer you question. My largest album has 6656 items.

Carl M. Gregory

 
bharat
bharat's picture

Joined: 2002-05-21
Posts: 7934
Posted: Sun, 2009-09-13 18:00

That's a big album! With the latest tweaks, I think the rescue module can probably only deal with an album with about 9,000 photos in it. I guess we'll cross that bridge when we come to it :-)
---
Problems? Check gallery3/var/logs
bugs/feature req's | upgrade to the latest code | use git

 
dvader

Joined: 2009-09-13
Posts: 8
Posted: Mon, 2009-09-14 04:41

@bharat - just wanted to confirm the latest code did fix the problem I mentioned in my previous post.
Thanks!

 
claytonian

Joined: 2009-09-03
Posts: 8
Posted: Sat, 2009-09-26 19:38
bharat wrote:
In mysql, try doing "update items set relative_path_cache=null, relative_url_cache=null" and then see if that fixes your album links.

Incidentally, I just had this exact same problem with b3 with the rescue module not quite fixing everything. I switched to using the git version, moved my var directory into the git version, ran php index.php upgrade, logged into mysql and ran the above sql, and viola! it works.

Thanks for the tip, and excellent work on the project as a whole

(this post is mostly just to confirm what others have said, this works quite well if you run into this problem)