fixing existing blank galleries for a new client

Just picked up a new client. They have a couple of Galleries that are displaying blank pages. Not sure which version they were created in, but the config file contains the following lines, so I assume it's an older version:

* Gallery - a web based photo album viewer and editor
* Copyright (C) 2000-2006 Bharat Mediratta

I've installed Version 3 on my local server. None of the table names in the new install match any of the table names in the existing db.

Attached is a screen shot showing side by side web directories of my new local install and that on the web server.

Is there a way to confirm whether the existing galleries were created with Gallery?

thanks,
david

Web server platform

Operating System CentOS release 5.4 (Final)
Kernel Version 2.6.18-164.11.1.el5PAE
Apache Version 2.2.3
MySQL Version 5.0.77
PERL Path /usr/bin/perl
PERL Version 5.8.8
PHP Path /usr/bin/php
PHP Version 5.3.14
PHP53 Path /opt/php53/bin/php
PHP53 Version 5.3.14
Ruby Path /usr/local/bin/ruby
Ruby Version 1.8.7
DB Server 209.200.244.80

thanks.

I'll download that locally and begin troubleshooting

david

One of the two galleries is back online after running the upgrade. But ... of the 15 existing albums, only two are displaying the photos. Looking at one of the 'blank' albums, the images are located on the server at the location indicated by admin / edit photo.

As an example:

missing image
album name = Congressional Prostate Cancer Task Force Briefing
image path = /Prostate_Cancer_Task_Force_Briefing/print Ahaghotu IMG_7583 sml.jpg

viewable image
album name = Women Against Prostate Cancer Annual Meeting 2008
image path = /wapc1208/498smlcrop.jpg

Thinking that the white spaces in the file name might be causing a problem, on the server I renamed print Ahaghotu IMG_7583 sml.jpg to print-Ahaghotu-IMG_7583-sml.jpg, but when inputing the new name into the admin interface, the following error message occurred:

--------------------------------------------------------------------------------
Error Detail -
Error (ERROR_BAD_PATH)
in modules/core/classes/GalleryDataItem.class at line 339 (GalleryCoreApi::error)
in modules/core/ItemEditItem.inc at line 218 (GalleryDataItem::rename)
in modules/core/ItemEdit.inc at line 84 (ItemEditItem::handleRequest)
in main.php at line 250 (ItemEditController::handleRequest)
in main.php at line 104
in main.php at line 88
System Information
Gallery version 2.3.2
PHP version 5.3.14 cgi-fcgi
Webserver Apache/2.2.3 (CentOS)
Database mysqli 5.1.62-rel13.3
Toolkits Gd
Operating system Linux sho.lunariffic.com 2.6.18-164.11.1.el5PAE #1 SMP Wed Jan 20 08:16:13 EST 2010 i686
Browser Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_2) AppleWebKit/536.26.17 (KHTML, like Gecko) Version/6.0.2 Safari/536.26.17
--------------------------------------------------------------------------------

Do I need to re-add each of the missing photos to get them to display?

david

From the 1st message white spaces are not a problem.
Do you have rewrite enabled on that gallery?
if so, try resetting your rewrite rules.

2nd message

Gallery is trying to copy the temp file to its final destination and receiving an error likely due to filesystem permissions
FAQ: How can I fix the filesystem permissions of the Gallery storage folder?

-s
________________________________
All New jQuery Minislideshow for G2/G3

	    if (!$platform->copy($inputFileName, $newFileName)) {
		return GalleryCoreApi::error(ERROR_PLATFORM_FAILURE);
	    }

		if (!$platform->rename($currentPath, $newPath)) {
		    $error = GalleryCoreApi::error(ERROR_BAD_PATH);
		}

Ok, both are related to filesystem permissions.

Permissions need to be set recursively
chmod -R 0777 /home/mensh0/public_html/photos/conferences/g2data_ab3234as/

where -R is recursive

-s
________________________________
All New jQuery Minislideshow for G2/G3

Just went to Site Admin / Maintenance / Rebuild all thumbnails/resizes and received the following:

Debug output for failed items:

file_exists(/home/mensh0/public_html/photos/conferences/g2data_ab3234as/cache/entity/1/0/1002.inc)
file_exists(/home/mensh0/public_html/photos/conferences/g2data_ab3234as/cache/derivative/1/0/1002.dat)
file_exists(/home/mensh0/public_html/photos/conferences/g2data_ab3234as/cache/entity/1/0/1000.inc)
getParameter lock.system for core plugin
fopen(/home/mensh0/public_html/photos/conferences/g2data_ab3234as/locks/1002,
wb+, 0)
flock(Resource id #107, 6, )

(mysqli): SELECT eG_id, eG_entityType FROM eventsGal_Entity WHERE eG_id IN
(1002)

(mysqli): SELECT eventsGal_Schema.eG_info FROM eventsGal_PluginMap,
eventsGal_Schema
WHERE eventsGal_PluginMap.eG_pluginId =
eventsGal_Schema.eG_pluginId
AND eventsGal_Schema.eG_type = 'entity' AND
eventsGal_PluginMap.eG_active = 1

(mysqli): SELECT eventsGal_DerivativeImage.eG_width,
eventsGal_DerivativeImage.eG_height,
eventsGal_Derivative.eG_derivativeSourceId,
eventsGal_Derivative.eG_derivativeOperations,
eventsGal_Derivative.eG_derivativeOrder,
eventsGal_Derivative.eG_derivativeSize,
eventsGal_Derivative.eG_derivativeType, eventsGal_Derivative.eG_mimeType,
eventsGal_Derivative.eG_postFilterOperations,
eventsGal_Derivative.eG_isBroken, eventsGal_ChildEntity.eG_parentId,
eventsGal_Entity.eG_id, eventsGal_Entity.eG_creationTimestamp,
eventsGal_Entity.eG_isLinkable, eventsGal_Entity.eG_linkId,
eventsGal_Entity.eG_modificationTimestamp,
eventsGal_Entity.eG_serialNumber, eventsGal_Entity.eG_entityType,
eventsGal_Entity.eG_onLoadHandlers FROM eventsGal_DerivativeImage,
eventsGal_Derivative, eventsGal_ChildEntity, eventsGal_Entity WHERE
eventsGal_DerivativeImage.eG_id IN (1002) AND
eventsGal_Derivative.eG_id=eventsGal_DerivativeImage.eG_id AND
eventsGal_ChildEntity.eG_id=eventsGal_DerivativeImage.eG_id AND
eventsGal_Entity.eG_id=eventsGal_DerivativeImage.eG_id
------------

the entire message was 83,000+ lines.

The note added to the main System Maintenance window states:
"Ensure data files for all derivatives (thumbnails, etc) have been built and rebuild broken ones.
Last Run Details:

Checked 534 items
448 items failed"

please advise.

david

all set!

there are two Gallery installs on this site, each with multiple albums. The config file for the one I was working on was pointing to the wrong location. Adjusted that, re-ran the system maintenance / rebuild thumbnails and all is fine.

on to the second blank gallery

david

blank pages usually mean php errors check your server's error logs
and make sure your config is pointing to the correct paths, DB etc.

-s
________________________________
All New jQuery Minislideshow for G2/G3

Am still at a complete loss as to how to get the second gallery functioning.

Browsing to main.php = blank page.

But browsing to /upgrade/ allows me to successfully run the upgrade, but when complete, I'm redirected once again to a blank page. The upgrade is reading the config.php and accepting the password and successfully backing up the db.

Both galleries are writing to the same db, but into different tables.

Both config files have identical db + usr + password information AND each have the correct table names and prefixes. If I alter the db / usr/ pwd in the config for the 'blank' gallery, then ERROR is displayed instead of a blank page. That indicates to me that the path is correct.

I've been using Mac Safari 6.0.2 and Firefox 19.0 on this task. Just noticed that Chrome 25 reports ...

--------------
Server error
The website encountered an error while retrieving http://www.menshealthnetwork.org/photos/conferences/main.php. It may be down for maintenance or configured incorrectly.
Here are some suggestions:
Reload this webpage later.
HTTP Error 500 (Internal Server Error): An unexpected condition was encountered while the server was attempting to fulfill the request.
--------------

Any and all ideas greatly appreciated.

david

Here is the specific error message:

-------------------
Configuration Error: Missing Theme

Missing Theme

This album is configured to use the matrix theme, but it is either inactive, not installed, or incompatible. To fix this problem you can either login and then choose a new theme for this album or login as a site administrator and then install or activate this theme.
-------------------

After logging in, I'm directed to the upgrade page, thus finding myself in the same loop.

I've downloaded the db via phpmyadmin. It appears the matrix is the active theme:

--------
INSERT INTO `confgallery_PluginMap` (`g_pluginType`, `g_pluginId`, `g_active`) VALUES
('theme', 'matrix', 1),
------------

However the db also contains a couple of hundreds lines typical of this:

-------
INSERT INTO `eventsGal_EventLogMap` (`eG_id`, `eG_userId`, `eG_type`, `eG_summary`, `eG_details`, `eG_location`, `eG_client`, `eG_timestamp`, `eG_referer`) VALUES
(1, 6, 'Image Error', 'Unable to build image', 'Error (ERROR_TOOLKIT_FAILURE, ERROR_PLATFORM_FAILURE)<b>in</b> modules/gd/classes/GdFunctionality.class <b>at line</b> 213 (GalleryCoreApi::error) \n<b>in</b> modules/gd/classes/GdFunctionality.class <b>at line</b> 258 (GdFunctionality::checkResource) \n<b>in</b> modules/gd/classes/GdToolkit.class <b>at line</b> 468 (GdFunctionality::imageCreateFromJpeg) \n<b>in</b> modules/gd/classes/GdToolkit.class <b>at line</b> 136 (GdToolkit::_getImageResource) \n<b>in</b> modules/core/classes/GalleryDerivative.class <b>at line</b> 452 (GdToolkit::performOperation) \n<b>in</b> modules/core/classes/GalleryDerivative.class <b>at line</b> 274 (GalleryDerivative::_rebuildCache) \n<b>in</b> modules/core/classes/GalleryDerivativeImage.class <b>at line</b> 153 (GalleryDerivative::rebuildCache) \n<b>in</b> modules/core/classes/helpers/GalleryDerivativeHelper_advanced.class <b>at line</b> 844 (GalleryDerivativeImage::rebuildCache) \n<b>in</b> modules/core/classes/GalleryCoreApi.class <b>at line</b> 997 (GalleryDerivativeHelper_advanced::rebuildCache) \n<b>in</b> modules/core/classes/helpers/GalleryDerivativeHelper_simple.class <b>at line</b> 50 (GalleryCoreApi::rebuildDerivativeCache) \n<b>in</b> modules/core/classes/GalleryCoreApi.class <b>at line</b> 984 (GalleryDerivativeHelper_simple::rebuildCacheIfNotCurrent) \n<b>in</b> modules/core/classes/BuildDerivativesTask.class <b>at line</b> 113 (GalleryCoreApi::rebuildDerivativeCacheIfNotCurrent) \n<b>in</b> modules/core/AdminMaintenance.inc <b>at line</b> 128 (BuildDerivativesTask::run) \n<b>in</b> ??? <b>at line</b> 0 (AdminMaintenanceController::runTask) \n<b>in</b> modules/core/classes/GalleryTemplateAdapter.class <b>at line</b> 1089\n<b>in</b> /home/mensh0/public_html/photos/conferences/g2data_ab3234as/smarty/templates_c/%%1030693542/matrix/%%3A^3A8^3A818B59%%theme.tpl.php <b>at line</b> 75 (GalleryTemplateAdapter::trailer) \n<b>in</b> lib/smarty/Smarty.class.php <b>at line</b> 1255\n<b>in</b> modules/core/classes/GallerySmarty.class <b>at line</b> 61 (Smarty::fetch) \n<b>in</b> modules/core/classes/GalleryTemplate.class <b>at line</b> 241 (GallerySmarty::fetch) \n<b>in</b> main.php <b>at line</b> 506 (GalleryTemplate::display) \n<b>in</b> main.php <b>at line</b> 104\n<b>in</b> main.php <b>at line</b> 88\n\nRequest variables: Array\n(\n [controller] => core.AdminMaintenance\n [form] => Array\n (\n [action] => Array\n (\n [runTask] => 1\n )\n\n )\n\n [taskId] => BuildDerivativesTask\n [authToken] => c040255c0c72\n)\n', 'http://www.menshealthnetwork.org/photos/events/main.php?g2_controller=core.AdminMaintenance&g2_form%5Baction%5D%5BrunTask%5D=1&g2_taskId=BuildDerivativesTask&g2_authToken=c040255c0c72', '67.248.251.75', 1362505183, 'http://www.menshealthnetwork.org/photos/events/main.php?g2_view=core.SiteAdmin&amp;g2_subView=core.AdminMaintenance'),
---------

Every record in the above table contains an error message.

attached is a screen shot showing what I found the directory for the Conference gallery. it appears that a number of files were missing. Those files are now in place after running the upgrade. Not sure if that makes a difference.

thanks!

Done. Error message gone, but blank page returns

david

am trying to gain access. Host did this overnight:

I have added the following line to the public_html/php.ini file in order to enable error reporting output to browser:
display_errors = On
This means that all server side errors will be printed to browser further which should help in troubleshooting any coding or configuration errors.

Is it possible to make an adjustment directly to the db via phpmyadmin to activate a different theme?

I almost mentioned that earlier. suphp does not allow you to execute files in the public space that have the wrong permissions.
If you have shell access execute these commands in your gallery's root directory

find . -type f -print0 | xargs -0 chmod 0644
find . -type d -print0 | xargs -0 chmod 0755
chmod -R 0777 /home/mensh0/public_html/photos/conferences/g2data_ab3234as

-s
________________________________
All New jQuery Minislideshow for G2/G3