thumbnails are not being created

not sure what's going on, but the thumbnails for images aren't being created and the standard image isn't being created. however, you can directly access the photo.

here's the link to the album where you can see the broken thumbnail:
http://gallery.andrewshemo.com/miscellaneous-photos/beer

link to the photo within the album:
http://gallery.andrewshemo.com/miscellaneous-photos/beer/P1050581

direct link:
http://gallery.andrewshemo.com/var/albums/miscellaneous-photos/beer/P1050581.JPG?m=1297574650

the back end maintenance says I have 1 out of date photo and I run it, and it shows 0 images have been updated. (see attachments).

I tried switching from grey dragon to the default theme but it didn't change anything. also, I'm running on 3.0.1 that's a few days old.

all previous images except for the specific 1 I mentioned were uploaded days, week or months ago.

I've attached my logs from the past 2 days. the file was upload on 2/12, but I'm not sure exactly at what time.

I was using IM and then switched it to GM, but that didn't help.

no dice.

I went into the album where the broken thumbnail/image is and went up to album options>rebuild items and checked all of the options in the module and ran it.

ok, I tried running the option to rebuild both the thumbnail and the resizes. there is 5 photos within the album where the broken image is and it only fixed 4/5 images as seen in the attachment I've provided.

also, this happens to all photos. you can see the latest photo (broken photo) I added in the gallery root:
http://gallery.andrewshemo.com/

I've attached the log.

I deleted it and then re-added it. still showing the broken image.

I've attached my log from today.

I can provide an admin log in account if that's easier.

sent you a PM with the log in credentials.

the photo exceeds the 1mb limit on the attachment, so here's the direct URL to it:
http://gallery.andrewshemo.com/var/albums/miscellaneous-photos/beer/P1050581.JPG?m=1297715263

Got your PM.
I changed your theme to the default wind and added a very small image and was unsuccessful.
I added your image just fine.
I chaged your image toolkit to IM and still get a no thumb or resize.
I noticed a modification to the wind theme, some arrows. So i suggest you install a new G3 with a new DB or DB table prefix in a new directory to see if you can get it to work that way first.
Images worked before, so it is either a host change or your a change you made.

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team

ok, I did some testing..

I created a new database and installed a clean version of gallery 3 to test to see if it works on a default install, and it does.

so the problem I'm having with my live gallery is either something in my database or something in the files. how can I move my current gallery structure (i.e., photos, albums, gallery hits, comments, etc.) over to the clean install?

pointed the new install at the old DB in /var/database.php (I didn't see anything in /application/config/config.php to edit for the db).

here's the test site:
http://andrewshemo.com/test/gallery/index.php/

as you can see, it has my old albums and such, and also has a few other photos on the main page (which can't be seen because it's not generating thumbnails), however, it is displaying the intermediate photo just fine:
http://andrewshemo.com/test/gallery/index.php/P1050581

it doesn't build any thumbnails, but it does show the intermediate photo as I wrote in my previous post:

as you can see, it has my old albums and such, and also has a few other photos on the main page (which can't be seen because it's not generating thumbnails), however, it is displaying the intermediate photo just fine:
http://andrewshemo.com/test/gallery/index.php/P1050581

yes, except it's still not generating thumbnails. it is however generating the intermediate image:
http://andrewshemo.com/test/gallery/index.php/P1050581

but if you look on http://andrewshemo.com/test/gallery/index.php, you'll see that the image link is there, but no actual image.

a test install with a fresh DB works 100%

the test install pointing at the old database adds the image but it doesn't generate the thumbnail. however, it does generate the intermediate photo while the old database wasn't generating thumbnails nor intermediate images.

lastly, the fix gallery task ran but didn't fix the issue.

Shemo725, glad to find this post as I am having the same problem. Ever since I migrated all my G2 photos/users over no thumbnails or intermediate pics are being created. I also ran the "fix gallery" function in the maintenance menu to no avail.

I'm running 3.0.1 now, but had the same problem with 3.0.

Maybe Bharat has a clue, I'll ask.

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team

any update to this?

the maintenance page says I have 8 photos that need to be rebuilt. upon running the rebuild tool, none of them actually get rebuilt as you can see in the attachment.

I don't see the image file in: gallery3/var/resizes/miscellaneous-photos/beer/ I'm also not seeing it anywhere else in the /resizes folder as I have that same file uploaded in a few different places.

the photo is in the /beer album itself if you browse to it on the site:
http://gallery.andrewshemo.com/miscellaneous-photos/beer/P1050581

if you go to the main beer album and move your mouse around on the page, you can see that the actual file is there, but you can't see it because the thumbnail isn't being generated.

not sure if this is what you wanted, but I searched the terms "4621" in phpmyadmin and it pulled up something from the items table. I'm not really good with mysql so if that's not right, let me know. here's what the table shows:

-- phpMyAdmin SQL Dump
-- version 3.3.8.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 26, 2011 at 07:50 PM
-- Server version: 5.1.47
-- PHP Version: 5.2.9

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `uglycars_asgallery`
--

-- --------------------------------------------------------

--
-- Table structure for table `items`
--

CREATE TABLE IF NOT EXISTS `items` (
  `id` int(9) NOT NULL AUTO_INCREMENT,
  `album_cover_item_id` int(9) DEFAULT NULL,
  `captured` int(9) DEFAULT NULL,
  `created` int(9) DEFAULT NULL,
  `description` text,
  `height` int(9) DEFAULT NULL,
  `left_ptr` int(9) NOT NULL,
  `level` int(9) NOT NULL,
  `mime_type` varchar(64) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `owner_id` int(9) DEFAULT NULL,
  `parent_id` int(9) NOT NULL,
  `rand_key` decimal(11,10) DEFAULT NULL,
  `relative_path_cache` varchar(255) DEFAULT NULL,
  `relative_url_cache` varchar(255) DEFAULT NULL,
  `resize_dirty` tinyint(1) DEFAULT '1',
  `resize_height` int(9) DEFAULT NULL,
  `resize_width` int(9) DEFAULT NULL,
  `right_ptr` int(9) NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `sort_column` varchar(64) DEFAULT NULL,
  `sort_order` char(4) DEFAULT 'ASC',
  `thumb_dirty` tinyint(1) DEFAULT '1',
  `thumb_height` int(9) DEFAULT NULL,
  `thumb_width` int(9) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `type` varchar(32) NOT NULL,
  `updated` int(9) DEFAULT NULL,
  `view_count` int(9) DEFAULT '0',
  `weight` int(9) NOT NULL DEFAULT '0',
  `width` int(9) DEFAULT NULL,
  `view_1` binary(1) DEFAULT '0',
  `view_2` binary(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `parent_id` (`parent_id`),
  KEY `type` (`type`),
  KEY `random` (`rand_key`),
  KEY `weight` (`weight`),
  KEY `left_ptr` (`left_ptr`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4630 ;

--
-- Dumping data for table `items`
--

INSERT INTO `items` (`id`, `album_cover_item_id`, `captured`, `created`, `description`, `height`, `left_ptr`, `level`, `mime_type`, `name`, `owner_id`, `parent_id`, `rand_key`, `relative_path_cache`, `relative_url_cache`, `resize_dirty`, `resize_height`, `resize_width`, `right_ptr`, `slug`, `sort_column`, `sort_order`, `thumb_dirty`, `thumb_height`, `thumb_width`, `title`, `type`, `updated`, `view_count`, `weight`, `width`, `view_1`, `view_2`) VALUES
(4621, NULL, 1297576072, 1297715262, NULL, 2304, 1648, 4, 'image/jpeg', 'P1050581.JPG', 2, 3619, 0.4674450000, 'miscellaneous-photos/beer/P1050581.JPG', 'miscellaneous-photos/beer/P1050581', 1, NULL, NULL, 1649, 'P1050581', 'created', 'ASC', 1, NULL, NULL, 'P1050581', 'photo', 1297715263, 9, 4280, 3072, '1', '1');

it doesn't appear as if it helped...

I uploaded a new photo and it's still not generating a thumbnail or an intermediate photo:
http://gallery.andrewshemo.com/test

but direct access to the photo works:
http://gallery.andrewshemo.com/var/albums/test.jpg?m=1298847910

I've tried new installs and such. I don't want to lose my album structure or any of the meta data, however.

bharat, any ideas with the data I provided for you?

ok, I installed the file where you mentioned it to be installed in the other thread and also tried adding a photo.

attached is my most recent log. I hope that's what you wanted.

I see this in your logs:

2011-03-14 13:08:09 -07:00 --- error: Database_Exception [ 44 ]: #1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IS NULL' at line 3 [ SELECT COUNT(*) AS `records_found`
FROM `items`
WHERE (`items`.`view_1` = '1') AND `parent_id` = NULL AND  IS NULL ]

That indicates some database corruption. I'd like to investigate, but I have limited time. Can you send me a dump of your database so that I can poke at it and see what I can figure out? Also tell me which album you were trying to add photos to. Perhaps I can improve the fix gallery task to undo this corruption.
---
Problems? Check gallery3/var/logs
file a bug/feature ticket | upgrade to the latest code! | hacking G3? join us on IRC!

I completely redid the gallery on a new database. unfortunately I don't have any logs of the old database.