Gallery URL = http://www.photosbybailini.com/g2/main.php
Gallery version = 2.3 core 1.3.0
API = Core 7.54, Module 3.9, Theme 2.6, Embed 1.5
PHP version = 5.2.9 cgi
Webserver = Apache
Database = mysqlt 5.1.70-cll, lock.system=flock
Toolkits = Gd, ImageMagick, Exif
Acceleration = partial/3600, partial/3600
Operating system = Linux server1.photosbybailini.com 2.6.32-358.14.1.el6.x86_64 #1 SMP Tue Jul 16 23:51:20 UTC 2013 x86_64
Default theme = carbon
gettext = enabled
Locale = en_GB
Browser = Mozilla/5.0 (Macintosh; Intel Mac OS X 10_7_5) AppleWebKit/536.30.1 (KHTML, like Gecko) Version/6.0.5 Safari/536.30.1
Rows in GalleryAccessMap table = 2497
Rows in GalleryAccessSubscriberMap table = 165468
Rows in GalleryUser table = 503
Rows in GalleryItem table = 165465
Rows in GalleryAlbumItem table = 5508
Rows in GalleryCacheMap table = 2337
Hello,
Some very strange things have been happening lately.
A week or two ago, after a large upload (~2000 proofs), a customer of mine emailed to say she was viewing her proofs, then went back later and one of them was missing. Sure enough, one of her series of shots is gone. The strange thing is when I searched her name, the missing proof appeared in the search results. It just wouldn't show up as part of the album. Without wanting to waste a lot of time on it, I simply reloaded her proof and carried on.
Yesterday, after another large upload, I was told that an ENTIRE ALBUM has disappeared! Again, if I search for one of the riders whose proofs are in that album, it appears in the search results. If I click on the thumbnail it takes me to the full size proof (photo page). However, if I click on the breadcrumb to the disappearing album, I get an error that the page cannot be found.
So the items are still there, but not accessible.
I've deleted the db cache (all the caches in fact), optimized and repaired, but still doesn't show up.
I have since reloaded the proof album, so now if I search a name in the album, I get duplicate search results.
The album in question is:
http://www.photosbybailini.com/g2/v/Equine/2013/equus3dfallht_sep29/pe/o/sj/
If you want to try searching a name, you can use Kaila Orr. The results with proof numbers 290913-Vxxx are the ones of interest.
Thank you in advance for any insight you can offer.
Andrew
Posted: Thu, 2013-10-03 16:20
Posts: 8339
did you link to an album that requires login?
-s
________________________________
All New jQuery Minislideshow for G2/G3
Posts: 176
Thanks for your reply, suprsidr.
One of the first things I checked were the permissions on the parent album and set them to apply to all sub-albums. They're all set for public viewing.
It was accessible after the upload so I know it was a public album. Just disappeared after a while.
Never seen anything like this before.
Posts: 176
Also, I was logged in as admin when I was looking into it.
Could an album be hidden or kept from viewing by the admin?
Posts: 8339
Admin can see everything.
From looking in your DB if you could determine the albumId you could use an edit link and see if the permissions have been corrupted.
-s
________________________________
All New jQuery Minislideshow for G2/G3
Posts: 176
I used GR to obtain the missing album id. 409847 Yes, it still shows up in GR as an album.
Could you please explain how to use an edit link..? Never heard that term before...
Thanks!
Posts: 176
For more info, I clicked on a thumbnail from the search results that exists in the missing album and copied the debug tree.
Not sure if it means anything or not, but....
Debug Tree
7: (GalleryAlbumItem) [browse]
30: (GalleryAlbumItem) [browse]
344595: (GalleryAlbumItem) [browse]
409839: (GalleryAlbumItem) [browse]
409841: (GalleryAlbumItem) [browse]
409845: (GalleryAlbumItem) [browse]
409847: (GalleryAlbumItem) [browse]
410295: (GalleryPhotoItem) [browse]
width 399
height 600
mimeType image/jpeg
size 64927
canContainChildren 0
description
keywords Kaila Orr; Colby
ownerId 6
renderer
summary
title 290913-V132
viewedSinceTimestamp 1380650252
originationTimestamp 1380441210
pathComponent 290913-V132.jpg
parentId 409847
id 410295
creationTimestamp 1380650252
isLinkable 1
linkId
linkedEntity
modificationTimestamp 1380650253
serialNumber 2
entityType GalleryPhotoItem
onLoadHandlers
_persistentStatus Array
410296: (GalleryDerivativeImage)
Posts: 8339
gallery2/main.php?g2_view=core.ItemAdmin&g2_subView=core.ItemEdit&g2_itemId=XXXX
-s
________________________________
All New jQuery Minislideshow for G2/G3
Posts: 176
Thanks suprsidr.
I tried while logged in as admin and still came up with the "page cannot be found" error.
Not sure what that means...
Posts: 8339
http://www.photosbybailini.com/g2/main.php?g2_view=core.ItemAdmin&g2_subView=core.ItemEdit&g2_itemId=409847
-s
________________________________
All New jQuery Minislideshow for G2/G3
Posts: 176
I know I'm a complete noob, but I know enough to replace the XXXX with the id number and to make it point to my server.... LoL!
Tried your link anyway and it took me to the log in page. After logging in as admin, I still got the "page cannot be found" error.... sad.
Posts: 8339
so on the parent album try resetting permissions recursively.
if the parent album is huge and you don't want to reset all those other albums:
you could also find your item in the g2_item table and check the ownerId (admin should be 6, but you can check g2_user for your id)
-s
________________________________
All New jQuery Minislideshow for G2/G3
Posts: 8339
Lastly make sure your gallery's files and resources are still good
FAQ: How can I make sure that my installation files are all intact?
-s
________________________________
All New jQuery Minislideshow for G2/G3
Posts: 176
Thanks again, suprsidr!
I'll have another large upload on Tuesday, so will take a look at those points before then.
Posts: 176
Checked the db for the missing album. I am the owner (6).
Created a "test" album and set it as the parent id. Changed permissions recursively. Still get the same "page cannot be found" error.
So, did the integrity check. The missing files were all associated with the "fluid" theme which I'm not using, so no worries there.
The modified files however are a little more worrisome (I think.....)
modules/checkout/templates/Select.tpl
modules/rewrite/data/mod_rewrite/custom/.htaccess
modules/rewrite/data/mod_rewrite_no_options/custom/.htaccess
modules/slideshowapplet/applets/GalleryRemoteAppletMini.jar
modules/core/classes/GalleryPhotoItem.class
modules/uploadapplet/applets/GalleryRemoteAppletMini.jar
I know I altered the checkout template, but not sure what the others mean.
At this point I'd like to just delete the missing album since I've reloaded those proofs anyway. I'm more concerned with preventing this from happening again.
Thoughts...?
Posts: 176
Tried to delete the "test" album that was set as the parent for the missing album and got this gallery error:
Error (ERROR_LOCK_REQUIRED)
in modules/core/classes/GalleryFileSystemEntity.class at line 260 (GalleryCoreApi::error)
in modules/core/classes/GalleryItem.class at line 329 (GalleryFileSystemEntity::delete)
in modules/core/classes/GalleryAlbumItem.class at line 293 (GalleryItem::delete)
in modules/core/classes/helpers/GalleryEntityHelper_medium.class at line 115 (GalleryAlbumItem::delete)
in modules/core/classes/GalleryCoreApi.class at line 2377 (GalleryEntityHelper_medium::deleteEntityById)
in modules/core/classes/GalleryItem.class at line 309 (GalleryCoreApi::deleteEntityById)
in modules/core/classes/GalleryAlbumItem.class at line 293 (GalleryItem::delete)
in modules/core/classes/helpers/GalleryEntityHelper_medium.class at line 115 (GalleryAlbumItem::delete)
in modules/core/classes/GalleryCoreApi.class at line 2377 (GalleryEntityHelper_medium::deleteEntityById)
in modules/core/ItemDeleteSingle.inc at line 69 (GalleryCoreApi::deleteEntityById)
in main.php at line 250 (ItemDeleteSingleController::handleRequest)
in main.php at line 104
in main.php at line 88
Posts: 8339
You should remove the slideshowapplet altogether. it has not had an update in ~8yrs
you may have needed to update the rewrite files when you activated. you may want to download new versions and compare.
GalleryPhotoItem.class absolutely should not be altered, download a fresh copy and compare to see what is different. and I'd suggest replacing the altered.
-s
________________________________
All New jQuery Minislideshow for G2/G3
Posts: 176
Thanks suprsidr.
Deleted both slideshow applet and slideshow (just to be safe). Wasn't using them anyway.
I know my gallery2 is outdated so where can I find a fresh download of this version of GalleryPhotoItem.class?
Posts: 176
Downloaded the G2.3.2 full package.
the GalleryPhotoItem.class looked the same so I uploaded it.
Ran the integrity check and got....
modules/checkout/templates/Select.tpl
modules/rewrite/data/mod_rewrite/custom/.htaccess
modules/rewrite/data/mod_rewrite_no_options/custom/.htaccess
modules/uploadapplet/applets/GalleryRemoteAppletMini.jar
Not sure what was modified, but it seems clean now. Yes?
However, I still can't delete that confounded album. Grrr...
Posts: 176
After all this, now my gallery remote won't launch.
I get the protocol implementation error.
I know you don't like GR, but I really need it to work asap!
Can you glean anything from the previous posts that would cause GR to stop working? Was fine before.
I launch it from a .jar file on my computer. Downloaded it from the codex.
I've tried from the "add item" pane but that doesn't even try to launch! The mini applet in the "add item" results in the same protocol imp. error.
I've enabled java log and trace, but don't know where to find those files....??
Posts: 176
Here's a thought.
When I ran the installer to check for missing/modified files, I had to re-authenticate (first step, I believe). Could this be blocking GR from recognizing this computer now?
Posts: 8339
do you have the latest remote module for G2?
I have not used GR or the upload applet since I wrote the uploadify module.
-s
________________________________
All New jQuery Minislideshow for G2/G3
Posts: 176
Deleted the plugin and downloaded from the repository in Gallery.
For the one on my computer, I downloaded it from the codex so all should be up to date (or as much as an outdated app can be...).
Working on installing uploadify now.... fingers crossed.
Posts: 176
Can uploadify create new albums or do I have to create the albums first, then uploadify the proofs to them?
Posts: 8339
uploadify is an uploader only. and it works in a tab like the upload applet did.
-s
________________________________
All New jQuery Minislideshow for G2/G3
Posts: 176
That's why I really need my GR to work again. Very time consuming to create the albums individually... I make a lot of albums!
So, the Java Webstart from the GR tab sort of worked. It "installed" and opened, but then came up with the same "GR can not find any protocol implementation at the URL..."
Does that shed any new light on the problem?
It's something associated with the steps I performed to fix the "missing item" problem because it worked before.
Posts: 8339
did you mess w/ your rewrite?
Also the zip upload module allows you to upload a zip w/ directories->subdirectories->items and it will respect the entire directory structure of yoour zip, creating the necessary albums, sub-albums etc.
-s
________________________________
All New jQuery Minislideshow for G2/G3
Posts: 176
I don't think so. I uploaded a clean version of the GalleryPhotoItem.class since it was shown as "modified".
I ran the installer again and once again failed the authentication so had to upload the new login.txt file to /g2. Could GR be looking for the original login string? If so, how do I update that with the new string?
Posts: 176
Unfortunately, the uploadify app isn't working so well for me.
Uploaded most of my proofs (to the first of many albums), but not all. The ones that did upload were not in order.
So, revisiting the GR issues.
I tried again with the upload applet tab (miniGR). Still the same error, but at least I got this log. This is the bottom of the output (what I think pertains to the error):
19208|CRITI|ImageUtils|Can't find ImageMagick in the system Path. Disabling
network: Connecting http://www.photosbybailini.com:80/ with proxy=DIRECT
23120|INFO |ImageUtils|jp.enabled: true
23120|INFO |ImageUtils|jp.path: jpegtran
23120|INFO |ImageUtils|jp.ignoreErrorCode: false
23120|CRITI|ImageUtils|jpegtran path is not fully qualified, presence won't be tested until later
23188|TRACE|GalComm |Trying Java 5 and 6 proxy class (sun.plugin.net.proxy.PluginAutoProxyHandler)
23205|TRACE|GalComm |Failed instantiation java.lang.reflect.InvocationTargetException
23206|TRACE|GalComm |No proxy
23217|TRACE|GalComm |Trying protocol 2.5 for http://www.photosbybailini.com/g2/
23222|TRACE|GalComm |Sending cookie: GALLERYSID=d1ae937eda48b0a52589bfad789c2765; path=/g2/; domain=.www.photosbybailini.com
23684|ERROR|GalComm |java.net.ProtocolException: Bad Set-Cookie header: __cfduid=d0abbe129b65a45bfcc9db7b6529050431381436754985; expires=Mon, 23-Dec-2019 23:50:00 GMT; path=/; domain=.photosbybailini.com; HttpOnly
No '=' found for token starting at position 133
at HTTPClient.Cookie.parse(Cookie.java:247)
at HTTPClient.CookieModule.handleCookie(CookieModule.java:454)
at HTTPClient.CookieModule.responsePhase1Handler(CookieModule.java:403)
at HTTPClient.HTTPResponse.handleResponse(HTTPResponse.java:727)
at HTTPClient.HTTPResponse.getStatusCode(HTTPResponse.java:190)
at com.gallery.GalleryRemote.GalleryComm.tryComm(GalleryComm.java:422)
at com.gallery.GalleryRemote.GalleryComm.getCommInstance(GalleryComm.java:357)
at com.gallery.GalleryRemote.model.Gallery.getComm(Gallery.java:858)
at com.gallery.GalleryRemote.model.Album.fetchAlbumProperties(Album.java:105)
at com.gallery.GalleryRemote.GRAppletMini.startup(GRAppletMini.java:106)
at com.gallery.GalleryRemote.GalleryRemote.runGR(GalleryRemote.java:138)
at com.gallery.GalleryRemote.GRApplet$1.run(GRApplet.java:50)
23684|ERROR|Gallery |No protocol implementation found
Translation...???
Posts: 176
So, I got the proofs uploaded using uploadify. Once I figured out how to change the sorting of the albums, it was pretty slick.
Just one pet peeve, though.... When a file fails to upload (HTTP error) is there a way to keep it in the queue or to display the file names of the errors? I had a hell of a time going through the album (some of them were 5 pages) to find which files didn't load. Other than that, it was a pretty slick app! Thanks!
That being said, I'd still prefer to get my GR working again. Hoping that you can give me some direction on that...
Posts: 8339
gallery forwards all request to remote to a specific address via .htaccess(if I remember correctly)
.htacess:
RewriteCond %{REQUEST_FILENAME} gallery\_remote2\.phpmake sure that line is in your g2's .htaccess
-s
________________________________
All New jQuery Minislideshow for G2/G3
Posts: 176
Thanks suprsidr.
Already in there....
The directory, however, is g2\...remote\ not remote2. I don't know if that matters.
Also, theres this at the top of g2's .htaccess:
.htaccess
ASCII text
#<Files ~ "\.(inc|class)$">
# Deny from all
#</Files>
the rest of the file is rewriterules and conditions, so this looks out of place...
Posts: 176
I tried putting that rewrite cond in the .htaccess for the public_html directory (one step up from g2) and still got the same "no protocol implementation" error when I launched GR.
What about the HTTP Auth module? Could that be causing this problem? Is it safe to disable/delete the module?
Posts: 176
Just found this in my server's error logs from yesterday:
[Thu Oct 10 18:10:30 2013] [error] [client 141.101.99.196] File does not exist: /home/photosby/public_html/templates/Snapshot/img/6F6F6F
[Thu Oct 10 17:59:00 2013] [error] [client 108.162.216.104] File does not exist: /home/photosby/public_html/404.shtml, referer: http://www.photosbybailini.com/g2/main.php?g2_view=core.ItemAdmin&g2_subView=core.ItemAdd&g2_itemId=413982&g2_addPlugin=ItemAddUploadApplet
[Thu Oct 10 17:59:00 2013] [error] [client 108.162.216.104] File does not exist: /home/photosby/public_html/g2/com.gallery.GalleryRemote.GRAppletMini, referer: http://www.photosbybailini.com/g2/main.php?g2_view=core.ItemAdmin&g2_subView=core.ItemAdd&g2_itemId=413982&g2_addPlugin=ItemAddUploadApplet
[Thu Oct 10 17:51:17 2013] [error] [client 141.101.99.196] File does not exist: /home/photosby/public_html/404.shtml
[Thu Oct 10 17:51:17 2013] [error] [client 141.101.99.196] File does not exist: /home/photosby/public_html/templates/Snapshot/img/6F6F6F
[Thu Oct 10 17:48:39 2013] [error] [client 173.245.55.106] File does not exist: /home/photosby/public_html/500.shtml, referer: http://www.photosbybailini.com/g2/main.php?g2_view=core.SiteAdmin&g2_subView=httpauth.HttpAuthSiteAdmin
[Thu Oct 10 17:48:39 2013] [alert] [client 173.245.55.106] /home/photosby/public_html/g2/.htaccess: <Location not allowed here, referer: http://www.photosbybailini.com/g2/main.php?g2_view=core.SiteAdmin&g2_subView=httpauth.HttpAuthSiteAdmin
[Thu Oct 10 17:42:57 2013] [error] [client 173.245.55.72] File does not exist: /home/photosby/public_html/404.shtml
[Thu Oct 10 17:42:57 2013] [error] [client 173.245.55.72] File does not exist: /home/photosby/public_html/favicon.ico
[Thu Oct 10 17:40:49 2013] [error] [client 108.162.216.104] File does not exist: /home/photosby/public_html/404.shtml, referer: http://www.photosbybailini.com/g2/main.php?g2_view=core.ItemAdmin&g2_subView=core.ItemAdd&g2_itemId=413982&g2_return=%2Fg2%2Fv%2FEquine%2F2013%2Fcsha_rawfcupqual2_oct6%2Fgg%2F1st%2F
[Thu Oct 10 17:40:49 2013] [error] [client 108.162.216.104] File does not exist: /home/photosby/public_html/g2/com.gallery.GalleryRemote.GRAppletMini, referer: http://www.photosbybailini.com/g2/main.php?g2_view=core.ItemAdmin&g2_subView=core.ItemAdd&g2_itemId=413982&g2_return=%2Fg2%2Fv%2FEquine%2F2013%2Fcsha_rawfcupqual2_oct6%2Fgg%2F1st%2F
[Thu Oct 10 17:39:41 2013] [error] [client 173.245.55.106] File does not exist: /home/photosby/public_html/404.shtml, referer: http://www.photosbybailini.com/g2/main.php?g2_view=core.ItemAdmin&g2_subView=core.ItemAdd&g2_itemId=413657&g2_addPlugin=ItemAddUploadApplet
[Thu Oct 10 17:39:41 2013] [error] [client 173.245.55.106] File does not exist: /home/photosby/public_html/g2/com.gallery.GalleryRemote.GRAppletMini, referer: http://www.photosbybailini.com/g2/main.php?g2_view=core.ItemAdmin&g2_subView=core.ItemAdd&g2_itemId=413657&g2_addPlugin=ItemAddUploadApplet
[Thu Oct 10 17:35:24 2013] [error] [client 173.245.54.130] File does not exist: /home/photosby/public_html/500.shtml
[Thu Oct 10 17:35:24 2013] [alert] [client 173.245.54.130] /home/photosby/public_html/g2/.htaccess: <Location not allowed here
[Thu Oct 10 17:35:23 2013] [error] [client 108.162.216.104] File does not exist: /home/photosby/public_html/500.shtml, referer: http://www.photosbybailini.com/g2/main.php?g2_view=core.SiteAdmin&g2_subView=httpauth.HttpAuthSiteAdmin
[Thu Oct 10 17:35:23 2013] [alert] [client 108.162.216.104] /home/photosby/public_html/g2/.htaccess: <Location not allowed here, referer: http://www.photosbybailini.com/g2/main.php?g2_view=core.SiteAdmin&g2_subView=httpauth.HttpAuthSiteAdmin
I saw some things pertaining to GR in there. Not sure if it means anything...
Posts: 8339
Huh?
I would re-setup rewrite through gallery's admin interface. Something with your rewrite has runamuck.
-s
________________________________
All New jQuery Minislideshow for G2/G3
Posts: 176
I believe the rewrite was set up by the developer who changed my Gallery to display the full size proofs as flash objects. More secure than jpgs. Can't remember his name, though....
Would that be something that I could hire you to look into for me?
Posts: 8339
I was the one who pioneered the image->flash in G2 but I cannot remember back that far. ?what did I do yesterday?
-s
________________________________
All New jQuery Minislideshow for G2/G3
Posts: 176
LoL! Ah-HA! I know the feeling....
I'd still be willing to pay you for your time if you'd like to look into that.
I've attached the java console output when I tried to run the upload applet (miniGR) if that's of any use.
Posts: 176
Would uninstalling (NOT deleting!) and re-installing the rewrite module help or just lead to more problems?
Posts: 8339
rename your current .htaccess to .htaccess_old -> deactivate/uninstall(not delete) G2's rewrite module -> re-activate/re-install -> re-setup rewrite through site admin > rewrite
-s
________________________________
All New jQuery Minislideshow for G2/G3
Posts: 176
Thanks suprsidr! Step by step is just what I need!
I'm fine with all of it except the last two. I guess printing the screen of the rewrite setup before uninstalling would suffice in getting it back to how it should be..?
Also, do I have to initiate the rewrite or does it do that automagically when it's enabled?