[SOLVED] Photos with special charator in the name got lost in B2 to B3 upgrade
|
ckgurr
Joined: 2009-11-01
Posts: 4 |
Posted: Mon, 2009-11-02 00:30
|
|
Photos loaded into 3.2 that worked now get the missing file message. So far I have found that special characters like an apostrophe or an ampersand have gotten this error. Hey wait, you're an admin! We can tell you stuff. If this stuff doesn't make any sense to you, ask for help in the Gallery forums! File: system/core/Kohana.php, line: 841 * Kohana::show_404( ) * system/core/Event.php [209]: call_user_func( Array * system/libraries/Router.php [163]: Event::run( system.404 ) * Router_Core::setup( ) * system/core/Event.php [209]: call_user_func( Array * system/core/Bootstrap.php [49]: Event::run( system.routing ) * index.php [86]: require( system/core/Bootstrap.php ) |
|
| Login or register to post comments |
Posts: 16327
I suspectit is related to:
http://sourceforge.net/apps/trac/gallery/ticket/812
Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team
Posts: 9289
Which has been fixed, make sure you've upgraded to the latest experimental code:
http://codex.gallery2.org/Gallery3:Upgrading
and follow the tips for unpacking the code to ensure you do not have any old code lying around as it will cause problems
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
Posts: 4
Thanks for your responses, but No luck, here are the steps that I followed
I downloaded gallery-gallery3-192b117.zip
unzipped it
mv gallery3 gallery3.b3
mv gallery-gallery3-192b117 gallery3
cp -R gallery3.b3/var ./gallery3/var
http://mydomain/gallery3/index.php/upgrader
Welcome to the Gallery upgrader. One click and you're done!
Module name Installed version Available version
Comments 2 2
Gallery 3 12 16
....
Your Gallery is up to date.
.
Tried to view George's_big_fish.jpg
We tried really hard, but it's broken.
Next ideas please
Posts: 9289
I'm betting the URL has a period in it. Instead of viewing the photo, edit it from the quick menu that pops up and make sure the URL (Internet Address) doesn't have any spaces, periods or other characters (the file name can contain those, but not the Internet Address)
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
Posts: 4
nivekiam
It looks like you helped me find that there are three issues.
Issue #1
All of my photos have .jpg in the internet name, and I can still look at them.
i.e. http://mydomain/gallery3/var/resizes/Family_Photos/George_family/Family_pics_March_08_-_March_09_114.jpg
but if I edit with the quick menu it will not let me modify unless I remove the ".". this makes since but is there an easy fix?
Issue #2 (original issue)
I can not view photos with other special characters like ' or &. I am guessing this is now a feature, but what about all of the photos that were uploaded with them in beta2?
Is there something the will clear it up or do I need to edit all of the files either manually (I have over 1000) or update the "relative_url_cache" and "slug" columns of the items table. (I am a DBA)
Issue #3
In trying upload a new file to see what is used to replace the .jpg in the internet name, I have found that I now get a yellow bar the says "The album 'Family_Photos' is not writable." (this is true of all my albums)
ls -l ./gallery3/var/albums/Family_Photos/
drwxr-xr-x 10 httpuser httpgroup 4096 Nov 1 16:16 ./
Thanks again for your help, I really like the gallery software.
Posts: 9289
You'd have to dig into the database for an "easy" fix. Otherwise, as you're editing them, remove the .jpg part of the Internet Address
Issue #2
Where are those characters located? The filename or the internet address?
Issue #3
Is httpuser the user the web server or PHP run as? That is the only user that has write permission to that directory.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
Posts: 4
nivekiam
Thanks loads for your help! It is all working great now.
Here is what I did to get it working.
Issue 1
-- this fixes the "Dang..." (bad internet name) error
mysql gallery3 >> /tmp/slugs.out
mysql> select title, slug, slug from items;
mysql> exit
/tmp/slugs.out looks like this:
DS12345 tab DS12345.jpg tab DS12345.jpg
John & Mary tab John_&_Mary.jpg tab John_&_Mary.jpg"
Tim's Car tab Tim's_Car.jpg tab Tim's_Car.jpg
Edit each line of /tmp/slugs.out to remove bad characters and the .jpg from the title and 1st slug(internet name) so it reads like this: (Note: do not change the 2nd slug)
update items set title = "DS12345", slug = "DS12345" where slug = "DS12345.jpg";
update items set title = "John and Mary" slug = "John_and_Mary.jpg" where slug = "John_&_Mary.jpg";
update items set title = "Tims Car", slug = "Tims_Car" where slug = "Tim's_Car.jpg";
....
mysql gallery3 < /tmp/slugs.out
Issue 2
both see issue 1 fix
Issue 3
-- this fixes the "The album 'Family_Photos' is not writable" message.
I guess when I copied the var directory it changed the ownership.
I used cp -R gallery3old/var gallery3, but should have used cp -Rp gallery3old/var gallery3
to fix things I did this:
chown -R ApacheUser gallery3/var
This really is a nice photo gallery set up, THANKS!
Posts: 9289
Great!
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here